Convert json to dataframe in python

Question

I have a json array f below format

[{
    'Address': 'xxx',
    'Latitude': 28. xxx,
    'Longitude': 77. xxx,
    'reached': False
}, {
    'Address': 'yyy',
    '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?

A Kareem · Answer

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')

zi guo · Answer

You can use the pd.DataFrame.from_records() method like:
pd.DataFrame.from_records(data)

Edward Weinert · Answer

Please use pd.json_normalize(data). It normalizes json structure into flat table of data:
data = [{
'Address': 'xxx',
'Latitude': 28.000,
'Longitude': 77.000,
'reached': False}, {
'Address': 'yyy',
'Latitude': 18.000,
'Longitude': 73.000,
'reached': False}]
pd.json_normalize(data)

Convert json to dataframe in python

3 Answers

Add your own answers!

Ask a Question