Parse Json format excel file into table

Question

I have an excel file with rows containing JSON formatted data. How do I convert it into a table format?

example:

row1[{"name":"val","age":"100"}]

Output:

+---------+-----+
|   name  | val |
+---------+-----+
|   age   | 100 |
+---------+-----+

sam · Accepted Answer · 2019-12-30 14:24:02Z

1

Hope this helps!

If you have a file with rows/records in JSON format, then you can use pandas.read_json with orient

import pandas as pd

df = pd.read_json('filename.json', orient='records')

df would be your data frame, with data in tabular format.

answered Dec 30, 2019 at 14:24

sam

1,9521 gold badge18 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1