Python data manipulation string to dict and then data frame

Asked Jul 18 '18 at 16:59

Active Jul 18 '18 at 17:47

Viewed 27 times

I would like to convert this string to a dictionary and then to a dataframe in Python.

string1 = "[{col1: val1,col2: val2,col3: val3,col4: val4}]"

I want the data frame like

col1 col2 col3 col4
val1 val2 val3 val4

Thank you for the feedback, here I am adding what I tried

import ast
ast.literal_eval(string1)

edited Jul 18 '18 at 17:47

asked Jul 18 '18 at 16:59

BigDataScientist

What have you tried so far? – rpanai Jul 18 '18 at 17:01
You want to evaluate the string so it becomes a dict, and then you can construct the dataframe: https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.from_dict.html – xyzjayne Jul 18 '18 at 17:01
@Chad Eytan That's not a policy of SO (apparently). Have you ever tried entering the comment: "What have you tried?" – Rob Jul 18 '18 at 17:03
I have edited my question. I thought it is a simple manipulation. – BigDataScientist Jul 18 '18 at 17:48

0 Answers0