how to read data frame having multiple json value in same columns

Question

i loaded a json file into a dataframe using pd.read_json. One of the column named Info has the data in the form of {'name': 'john', 'lname': 'buck', 'address': '101 N state'}

there are 3 other columns with normal value like id, date, post

Q - how to extract all the rows from a dataframe where lname = 'buck'

dportman · Accepted Answer · 2018-04-24 21:26:55Z

1

You can use pandas.io.json.json_normalize to flatten the Info column to separate columns in your dataframe.

from pandas.io.json import json_normalize
df_norm = json_normalize(df, 'Info', ['id', 'date', 'post'])

Then you can query the normalized dataframe as you wish:

df_norm.query("lname == 'buck'")

answered Apr 24, 2018 at 21:26

dportman

1,11910 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

how to read data frame having multiple json value in same columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related