need to parse JSON in Python3

Question

am new to Python and need to parse the date and '4. close' from the following JSON. Would be very grateful for pointers how to do this the pythonic way.

{'2017-01-24': {'1. open': '207.8600',
                 '2. high': '209.4000',
                 '3. low': '207.7479',
                 '4. close': '208.9700',
                 '5. adjusted close': '208.0046',
                 '6. volume': '1940125',
                 '7. dividend amount': '0.00',
                 '8. split coefficient': '1.0000'},...

Moshe · Accepted Answer · 2017-06-15 17:16:39Z

1

You can parse JSON like this:

import json
from pprint import pprint

with open('path_of_file.json') as data_file:    
    data = json.load(data_file)

pprint(data)

answered Jun 15, 2017 at 17:16

Moshe

2,6744 gold badges30 silver badges72 bronze badges

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

3 Comments

steff Over a year ago

Thanks Moshe. Thats what i figured already actually. But whats the best way to slice it in order to get the date at the beginning and the value for '4. close' so i can stick them into a CSV or a database?

steff Over a year ago

Actually so easy. Sorry to bother you guys. the output is already a Python dictionary and the date is simply the key.

Moshe Over a year ago

Yeah sorry, JSON is nearly universal as most programming languages have value key pairs

Collectives™ on Stack Overflow

need to parse JSON in Python3

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related