Accessing json values

Question

I have loaded the following json this way:

url2 = "https://gbfs.capitalbikeshare.com/gbfs/en/station_status.json"
response2 = urllib2.urlopen(url2)
cabi_station_status = json.load(response2)

sample output of cabi_station_status:

{u'stations': [{u'eightd_has_available_keys': False,
   u'is_installed': 1,
   u'is_renting': 1,
   u'is_returning': 1,
   u'last_reported': 1489309320,
   u'num_bikes_available': 5,
   u'num_bikes_disabled': 0,
   u'num_docks_available': 10,
   u'num_docks_disabled': 0,
   u'station_id': u'1'},
  {u'eightd_has_available_keys': False,
   u'is_installed': 1,
   u'is_renting': 1,
   u'is_returning': 1,
   u'last_reported': 1489309256,
   u'num_bikes_available': 5,
   u'num_bikes_disabled': 0,
   u'num_docks_available': 6,
   u'num_docks_disabled': 0,
   u'station_id': u'2'}

I cannot figure out how to access the value of "num_bikes_available" of certain stations. When I try cabi_station_status["stations"]["station_id"][1]

it does not return anything. Pseudo code for my ideal output would be to get the "num_bikes"available" when "station_id" == 1. and return an integer, in this case, 5.

Afaq · Accepted Answer · 2017-03-12 15:58:17Z

1

cabi_station_status["stations"] is a list.

You should use a loop to iterate over each station and from each station get num_bikes_available.

each_station['num_bikes_available']

Your solution would look like:

for each_station in cabi_station_status["stations"]:
    if each_station['station_id'] == '1':
        return each_station['num_bikes_available']

edited Mar 12, 2017 at 15:58

answered Mar 12, 2017 at 15:52

Afaq

1,1551 gold badge13 silver badges27 bronze badges

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

Comments

Greg Eremeev · Accepted Answer · 2017-03-12 15:56:24Z

0

for station in cabi_station_status['stations']:
    if station['station_id'] == '1':
        print(station['num_bikes_available'])

answered Mar 12, 2017 at 15:56

Greg Eremeev

1,8505 gold badges25 silver badges33 bronze badges

1 Comment

CWill Over a year ago

That worked! I was so close with my attempt: 'for key in cabi_station_status(): ] if cabi_station_status.get("station_id","") == 1: print ["num_bikes_available"'

Daniel Roseman · Accepted Answer · 2017-03-12 15:54:22Z

0

cabi_station_status["stations"] is a list; you need to refer to its elements by index, not key.

cabi_station_status["stations"][0]["num_bikes_available"]

answered Mar 12, 2017 at 15:54

Daniel Roseman

602k68 gold badges911 silver badges924 bronze badges

1 Comment

CWill Over a year ago

hmm, so no way to selected num_bikes_available based off of a station_id? The index is not 1:1 for the stations, ie index 12 = station_id:14 and index 45 = station_id: 52

Collectives™ on Stack Overflow

Accessing json values

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related