Read in JSON into array

Question

I have the following market data in JSON format:

[
 {
  "date":1405728000,
  "high":0.005,
  "low":0.00406,
  "open":0.00411473,
  "close":0.00461299,
  "volume":183.76967581,
  "quoteVolume":40579.4327267,
  "weightedAverage":0.00452864
 },
 {
  /* same structure */
 },
 ...
]

I am trying to read it in assigning 1 variable for the close price for example:

import json


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


print data[0]["close"]

But this only reads in the first value for the close objects. How to put all "close" objects in 1 array?

Sorry I am amateur with arrays, so I'd like to know how to put all price types in their separate array variable.

user1785721 · Accepted Answer · 2017-08-25 12:30:28Z

3

import json


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


print([row['close'] for row in data])

answered Aug 25, 2017 at 12:30

user1785721

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

Comments

zipa · Accepted Answer · 2017-08-25 12:28:10Z

1

Try it like this:

[item['close'] for item in data]

answered Aug 25, 2017 at 12:28

zipa

28k6 gold badges45 silver badges62 bronze badges

Comments

Abe · Accepted Answer · 2017-08-25 12:31:23Z

-1

Try this:

import json
data = json.load(open('1.json', 'r'))
print(data)
print(data[0]["close"])

If its possible, pass the absolute path for the file 1.json

answered Aug 25, 2017 at 12:31

Abe

1,41315 silver badges32 bronze badges

1 Comment

marcusshep Over a year ago

this wont print all close keys in json obj.

Collectives™ on Stack Overflow

Read in JSON into array

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related