How to extract N-level object from JSON string

Question

I want to extract wind object's data from the following JSON string:

import pandas as pd
from urllib2 import Request, urlopen
import json
from pandas.io.json import json_normalize

request=Request('...')
response_weather = urlopen(request)
w = response_weather.read()
metar = json.loads(w)
wind = pd.DataFrame(json_normalize(metar['wind']))
print wind


KeyError: 'wind'

bakkal · Accepted Answer · 2016-01-15 15:42:23Z

1

I want to extract wind object's data

Then you want you want metar['conditions']['wind']

And based on your screenshot, that key contains the following object: {direction: 60, directionIsVariable: false, speedKnots: "3.00"}

_{P.S. Since that's a single object, I'm not sure what you want to achieve by making it into a pandas.DataFrame}

answered Jan 15, 2016 at 15:42

bakkal

55.6k12 gold badges136 silver badges113 bronze badges

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

1 Comment

Klausos Klausos Over a year ago

I am appending pandas DataFrame with more readings of wind obtained from other requests

Rhuarc13 · Accepted Answer · 2016-01-15 15:37:33Z

1

To get to the wind object, you first have to get the conditions object out of metar. Once you have the conditions object, you can then pull out the wind object.

Metar doesn't have a wind child, so metar['wind'] doesn't access anything. metar['conditions'] will work, because there is a conditions child.

Hope that helps!

answered Jan 15, 2016 at 15:37

Rhuarc13

1351 silver badge9 bronze badges

Collectives™ on Stack Overflow

How to extract N-level object from JSON string

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related