Python: Parsing a single-line JSON file

Question

I'm trying to parse a large one-line JSON file and can't seem to figure it out. I've looked for resources on here and elsewhere, but most of what I see tells you to parse everything line-by-line. Since I'm working with one really long line, what's the best way to parse this with python?

Specifically, I'm looking for one particular value that's in a nested dictionary in the JSON data. The data looks like this (after running it through a formatter):

{ "type":"FeatureCollection", "features":[ { "type":"Feature", "id":"wells.529038", "geometry":null, "properties":{ "api":"4245180382" } }, { "type":"Feature", "id":"wells.481699", "geometry":null, "properties":{ "api":"4237182573" } } ] }

I want to extract all the api values, but I'm having trouble wrapping my head around how to do that given the multi-nested structure and because the file is huge and only one line. What the best approach here?

you can do: import json and then json.load(open('my_file.json')) — Saullo G. P. Castro
– Saullo G. P. Castro, Commented Oct 11, 2013 at 15:20

Co_42 · Accepted Answer · 2013-10-11 15:22:16Z

5

Use the standard library :

json_data = json.loads(your_line) # Usage exemple for feature in json_data['features']: print feature['id']

answered Oct 11, 2013 at 15:22

Co_42

1,2971 gold badge11 silver badges19 bronze badges

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

1 Comment

Ben Over a year ago

I was doing this but nesting another loop with for property in feature["properties"], but doing print property["api"] gave me an error "string indices must be integers". If I just use the one loop and do print feature["properties"]["api"] it works great though. Thanks!

Collectives™ on Stack Overflow

Python: Parsing a single-line JSON file

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related