Explore our sites

Stack Exchange
tour help careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 2 down vote favorite

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.

share|improve this question
 
possible duplicate of Python JSON tutorial –  dnozay Jul 15 at 21:21
add comment

3 Answers

up vote 2 down vote accepted

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.

share|improve this answer
 
this worked like a charm, thank you –  fox Jul 15 at 21:21
 
I'd love to hear what is not helpful or wrong about my answer, to deserve a downvote. That way I can improve my answer! –  Martijn Pieters Jul 16 at 6:55
 
I voted it up, did somebody else downvote? –  fox Jul 18 at 4:48
add comment
up vote 0 down vote

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)
share|improve this answer
add comment
up vote 0 down vote

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.