# Convert json to dataframe in python

I have a json array f below format

[{
'Latitude': 28. xxx,
'Longitude': 77. xxx,
'reached': False
}, {
'Latitude': 18. yyy,
'Longitude': 73. yyy,
'reached': False
}]


i want to convert into dataframe. if the column name is same it should have (Address_0, Address_1 etc) and should be side by side, not below. How can i do this?

• Did you tried, what happens, what error shown? – Venkatesh Gandi May 3 '20 at 13:05

Have you tried using the pandas.read_json method? (documentation)
And it looks like your json is structured like 'records' so use
pd.read_json(_, orient='records')

• Did you change the underscore to the actual path? pd.read_json(PATH_HERE, orient='records') – A Kareem May 3 '20 at 13:29