On Sat, Feb 13, 2010 at 3:00 PM, Chris Patillo <[email protected]> wrote:
> Thanks for your response. i did some research on json.load() and I don't
> understand how you extract the data from it. How do I get just the name and
> number from the file?
The value returned from json.load() is a Python dictionary. The
structure of the dict will be the same as that of your initial data.
In your case, the value of the 'records' key is itself a list of dicts
containing names and phone numbers. To get the desired data you have
to navigate this structure using standard python.
Here is an example using your sample data. Note that I use
json.loads() because I have the data in a string, rather than a file.
import json
from pprint import pprint
json_data = '''{
"table":"contacts",
"records":[
{
"name":"John",
"phone":"555-555-4444"
},
{
"name":"Jane",
"phone":"555-555-3333"
}
]
}'''
data = json.loads(json_data)
pprint(data)
for record in data['records']:
print record['name'], record['phone']
The output of the program is
{u'records': [{u'name': u'John', u'phone': u'555-555-4444'},
{u'name': u'Jane', u'phone': u'555-555-3333'}],
u'table': u'contacts'}
John 555-555-4444
Jane 555-555-3333
Kent
PS Please Reply All to reply on list.
_______________________________________________
Tutor maillist - [email protected]
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
