How can I access these json object in python

Question

I'm making some data visualization from movies database api and I already access the data in the normal way but when i load the json data and for loop to print it, the data that out is just the column but I need to access the object inside.

url = "https://api.themoviedb.org/3/discover/movie?api_key="+ api_key 
+"&language=en- US&sort_by=popularity.desc&include_adult=
false&include_video=false&page=1" # api url

response = urllib.request.urlopen(url)
raw_json = response.read().decode("utf-8")
data = json.loads(raw_json)

for j in data:
    print(j)

i expect the output would be

[{'popularity': 15,
  'id': 611,
  'video': False,
  'vote_count': 1403,
  'vote_average': 8.9,
  'title': 'lalalalo'},{....}]

but the actual output is

page
total_results
total_pages
results

It seems that you are iterating on the keys of a mapping. Check what j is instead of trying to print is elements. — MisterMiyagi
– MisterMiyagi, Commented Sep 9, 2019 at 4:10
Possible duplicate of Iterating over dictionaries using 'for' loops — Shadow
– Shadow, Commented Sep 9, 2019 at 4:14
if it is dictionary then loop normally gives only keys. You would have to use data.items() in for..in... to get pairs (key, value) . But first you should check print(data) and print(type(data)) — furas
– furas, Commented Sep 9, 2019 at 20:38

Matthew Gaiser · Accepted Answer · 2019-09-09 04:23:45Z

3

The results are one level down. You are looping through the metadata.

Try changing your code to

import json
import urllib.request
api_key = "your api code"

url = "https://api.themoviedb.org/3/discover/movie?api_key=" + api_key +"&language=en- US&sort_by=popularity.desc&include_adult=false&include_video=false&page=1" # api url

response = urllib.request.urlopen(url)
raw_json = response.read().decode("utf-8")
data = json.loads(raw_json)

for j in data['results']:
    print(j)

You need to change

data

to

data['results']

answered Sep 9, 2019 at 4:23

Matthew Gaiser

4,8431 gold badge23 silver badges36 bronze badges

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

1 Comment

Kateezy Mymoneygone Over a year ago

Thank you it my false that i just miss this spot thank you

Nyzex SKB · Accepted Answer · 2019-09-09 05:32:32Z

0

you can simply use requests module...

import requests
import json

your_link = " "
r = requests.get(your_link)
data = json.loads(r.content)

You shall have the json loaded up, then use your key "results" ["results"] and loop through the data you got.

answered Sep 9, 2019 at 5:32

Nyzex SKB

1565 bronze badges

Collectives™ on Stack Overflow

How can I access these json object in python

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related