Parsing a nested json and save it in csv

Question

I am parsing json using an api using json_normalize, and I have to save it in a csv file.

I have get the json and saved it in a csv but its a nested json and one key and its attributes is not saving as columns like other columns.

getting below output in weather column

[{'id': 600, 'main': 'Snow', 'description': 'light snow', 'icon': '13d'}]

code..............

import requests

import json

import pandas as pd

from pandas.io.json import json_normalize

data = requests.get("http://api.openweathermap.org/data/2.5/forecast?id=524901&APPID=94070a31e4a96500de718a66f86ca6ba").json()



vardump = json.dumps(data)

varobject = json.loads(vardump)

df = json_normalize(varobject['list'])

df.to_csv('Output3.csv')

I want the output to be as columns in same csv file.

jezrael · Accepted Answer · 2019-02-06 10:20:07Z

1

Use:

df1 = json_normalize(data['list'], 'weather')
df2 = json_normalize(data['list'])

df = df2.drop('weather', axis=1).join(df1)

answered Feb 6, 2019 at 10:20

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Parsing a nested json and save it in csv

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