python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - json-normalize

How do I flatten nested list from JSON object?

I've exported fitbit sleep data and got a json file with nested variables + dict. I would like to convert the json file to a csv file that will display all "regular" variables, e.g. "da...
test-img

Lea

python

json

pandas

csv

json-normalize

Votes: 0

Answers: 1

Latest Answer

Use pd.json_normalize, all nested levels are flatten and join with dots (by default): import pandas as pd import json with open('data.json') as fp: data = json.load(fp) df = pd.json_normalize...
test-img

Corralien

Partly flatten nested JSON objects stored in df column

I have a dataframe with 3 columns (INSTNR, Enhedsadresser, API_response), where the 3rd column (API_response) contains JSON objects. I would like to flatten the JSON object and store the extracted inf...
test-img

mantasbacys

python

json

pandas

typeerror

json-normalize

Votes: 0

Answers: 1

Latest Answer

Series.str.get can help you extract individual elements from a dictionary column. If API_response is a column of dictionaries formatted as your example, you can use: df['kategori'] = df['api_response'...
test-img

ozacha

Pandas json normalize why it returns NaN for repeated values

I have a dataframe where 2 columns are lists of dictionaries that I want to expand to separate columns. For example: id text agg_inds ag...
test-img

joasa

python

pandas

explode

json-normalize

Votes: 0

Answers: 2

Latest Answer

You can use ffill to replace the NaN values with the value of the previous row. For this you only have to add one line: s = (df.set_index('id') .apply(lambda x: x.apply(pd.Series).stack()) ...
test-img

JANO

Convert JSON data to pandas df - python

I know there is a few questions on SO regarding the conversion of JSON file to a pandas df but nothing is working. Specifically, the JSON requests the current days information. I'm trying to return th...
test-img

Chopin

python

json

json-normalize

Votes: 0

Answers: 1

Latest Answer

record_path is the path to the record, so you should specify the full path df = pd.json_normalize(data, record_path=['d', 'Tables', 'Data']) If you want to do without record_path, the value type of D...
test-img

Ynjxsjmh

Posts

Questions

Blogs

Jobs