In [14]:

    

import json
import pprint

import dateutil.parser

with open('./data/submissions.json') as fobj:
    submissions = json.loads(fobj.read())
    submission = submissions[0]

pprint.pprint(submission)


    

    




{'abstract': 'Short and sweet',
 'audience_level': 'Intermediate',
 'avatar': 'https://secure.gravatar.com/avatar/f883be8a2084ce5474530455e8ed4d87?s=500',
 'bio': "I'm sold.",
 'confirmed': False,
 'created_at': '2017-07-26T03:43:43.852Z',
 'description': 'I will have more to say when I am presenting this talk.',
 'email': 'p****@p**********.com',
 'location': 'Unknown',
 'name': 'Peter McCormick',
 'notes': 'Hi everyone!',
 'organization': 'PyNorth',
 'rating': 0.0,
 'shirt_size': "Men's S",
 'state': 'submitted',
 'tag_list': ['documentation', 'api', 'performance', 'visualization'],
 'title': "Peter's sample talk title",
 'twitter': '**********',
 'url': 'https://pycon.ca/'}

In [15]:

    

submission['created_at'] = dateutil.parser.parse(submission['created_at'])
submission['tag_list'] = ', '.join(submission['tag_list'])


    

In [16]:

    

pprint.pprint(submission)


    

    




{'abstract': 'Short and sweet',
 'audience_level': 'Intermediate',
 'avatar': 'https://secure.gravatar.com/avatar/f883be8a2084ce5474530455e8ed4d87?s=500',
 'bio': "I'm sold.",
 'confirmed': False,
 'created_at': datetime.datetime(2017, 7, 26, 3, 43, 43, 852000, tzinfo=tzutc()),
 'description': 'I will have more to say when I am presenting this talk.',
 'email': 'p****@p**********.com',
 'location': 'Unknown',
 'name': 'Peter McCormick',
 'notes': 'Hi everyone!',
 'organization': 'PyNorth',
 'rating': 0.0,
 'shirt_size': "Men's S",
 'state': 'submitted',
 'tag_list': 'documentation, api, performance, visualization',
 'title': "Peter's sample talk title",
 'twitter': '**********',
 'url': 'https://pycon.ca/'}

In [ ]: