Skip to content
Advertisement

How to convert JSON data inside a pandas column into new columns

I have this short version of ADSB json data and would like to convert it into dataFrame columns as Icao, Alt, Lat, Long, Spd, Cou…..

After Alperen told me to do this

JavaScript

I can load it into a DataFrame. However, df.acList is

[{'Id': 10537990, 'Rcvr': 1, 'HasSig': False, ...
Name: acList, dtype: object

How can I get the Icao, Alt, Lat, Long, Spd, Cou data?

JavaScript

Advertisement

Answer

If you already have your data in acList column in a pandas DataFrame, simply do:

JavaScript

Since pandas 1.0 the imports should be:

JavaScript
Advertisement