How to loop through JSON data using python?

Question

I'm trying to for loop through a json data and only look at "deadline_time" key. But I don't seem to know how to do that!

Here's my code:

import json
from urllib.request import urlopen

with urlopen("https://fantasy.premierleague.com/api/bootstrap-static/") as response:
    source = response.read()

data = json.loads(source)

print(json.dumps(data, indent=2))

for item in data['events']['deadline_time']:
    print(item)

Here's what the API looks like:

    {
      "events": [
        {
          "id": 1,
          "name": "Gameweek 1",
  ------> "deadline_time": "2021-08-13T17:30:00Z",
          "average_entry_score": 69,
          "finished": true,
          "data_checked": true,
          "highest_scoring_entry": 5059647,
          "deadline_time_epoch": 1628875800,
          "deadline_time_game_offset": 0,
          "highest_score": 150,
          "is_previous": true,
          "is_current": false,
          "is_next": false,
          ...

But I end up getting this error:

  File "API2.py", line 11, in <module>
    for item in data['events']['deadline_time']:
TypeError: list indices must be integers or slices, not str

Jeremy Savage · Accepted Answer · 2021-08-24 15:56:38Z

3

You need to loop through the events not the individual deadline time.

Replace

for item in data['events']['deadline_time']:
    print(item)

With

for item in data['events']:
        print(item['deadline_time'])

answered Aug 24, 2021 at 15:56

Jeremy Savage

9045 silver badges15 bronze badges

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

Comments

Kaushal panchal · Accepted Answer · 2021-08-24 15:58:12Z

0

data['events']['deadline_time'] gives you the value of deadline_time and it's string

Replace it like this:

for item in data['events']:
    print(item['deadline_time'])

answered Aug 24, 2021 at 15:58

Kaushal panchal

4002 silver badges11 bronze badges

Comments

Subhashis Pandey · Accepted Answer · 2021-08-24 16:07:13Z

0

The right way to achieve this

for item in data['events']:
  print(item["deadline_time"])

answered Aug 24, 2021 at 16:07

Subhashis Pandey

1,5381 gold badge13 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to loop through JSON data using python?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related