parsing json file in python

Question

Have a file in plaintext that looks as follows:

{
   "user1":[int1, int2...intX], 
   "user2":[int1, int2...intX], 
    ... 
   "userX":[int1, int2...intX]
}

I want to be able to cycle through all users and their corresponding lists of integers; what's the best way to load and parse through this object?

Eventually I want to do something like:

for user, intlist in [FILE]:
    for item in intlist:
        [perform some function on each int]

though I'm not sure the right way to set up the IO and then leveraging the json library.

possible duplicate of Python JSON tutorial

dnozay
– dnozay

2013-07-15 21:21:14 +00:00
Commented Jul 15, 2013 at 21:21 — dnozay
– dnozay, Commented Jul 15, 2013 at 21:21

Martijn Pieters · Accepted Answer · 2013-07-15 21:11:31Z

2

Just load the file with json.load():

import json

with open('yourfile') as infile:
    for user, intlist in json.load(infile).iteritems():
        for item in intlist:

Your JSON contains a dictionary top-level object, so the above code calls .iteritems() to loop over each key-value combo in that object.

answered Jul 15, 2013 at 21:11

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

Comments

astrognocci · Accepted Answer · 2013-07-15 21:12:22Z

0

Something like this:

import json
with open('file.json', 'r') as f:
    data = json.load(f)
for user, intlist in data.items():
    for item in intlist:
        do_your_stuff(item)

answered Jul 15, 2013 at 21:12

astrognocci

1,0951 gold badge7 silver badges17 bronze badges

Comments

Conan Li · Accepted Answer · 2013-07-15 22:31:14Z

0

Aside from the above answers, you may also try the package 'simplejson' which supports a bit more python objects than the plain 'json'

answered Jul 15, 2013 at 22:31

Conan Li

5042 silver badges6 bronze badges

Collectives™ on Stack Overflow

parsing json file in python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related