In each of the dataframe, I have a row entry that looks like:

[{‘degree’: 0.1, ‘name’: ‘Colins Dental Clinic’, ‘rating’: 9, ‘level’: ‘fourth’}]

It is a direct import from read.csv of a file.

I would like to create two columns from each entry that extracts two numeric values, from above, 0.1, and 9, which are degree and rating information of a dental clinic.

I tried substring and using sep=”,” with quotes, but I am just not getting things correctly.

Any advice would be greatly appreciated!

I tried substring and using sep=”,” with quotes, but I am just not getting things correctly.