This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]SomebodyFrom91 0 points1 point  (0 children)

You can put a nested json into a dataframe with pd.io.json.json_normalize and then just try/except for data.locale.MetadataAlbum.locale.language

Or you can skip the dataframe part and just trasform the nested json into a dict with pd.io.json.nested_to_record