storing data retrieved from REST api into variables in python

Question

So I'm trying to learn more about APIs and the different ways I can use them. Say that as of right now I have

import requests, json, pprint

r = requests.get("values from api") 

pprint.pprint(r.json())

which returns to me the following

> {'currentResultCount': '10',  
> 'results': [{'Name': 'Item_One',
>               'Price': '464086'},
>              {'Name': 'Item_Two',
>               'Price': '70874',
>                and so on.........

If I want to store all the price in an array and do some data analysis on them (like find the mean, median, and mode), what should I do?

I tried calling r[0] to see if it's functional or not, but apparantly r is an response object type, so r[0] doesn't work. This is my first time learning about API and data manipulation, any suggestions and learning tips are greatly appreciated!

sorry but I havn't really looked into what exactly json is yet, but it does seem like json will answer my question. Thanks for the tip! — user3277633
– user3277633, Commented Sep 19, 2014 at 22:15

Community · Accepted Answer · 2017-05-23 12:02:35Z

4

.json() parses JSON response under the hood and returns you a Python data structure, in your case, a regular dictionary:

data = r.json()

To get the list of prices, iterate over the results values and get the Price on every iteration:

prices = [item['Price'] for item in data['results']]

You may also cast prices to float:

prices = [float(item['Price']) for item in data['results']]

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Sep 19, 2014 at 22:12

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

1 Comment

Sarang Manjrekar Over a year ago

I am using

res = conn.getresponse()                                 data = res.read()                                 print(data.decode("utf-8"))                                 mydata = data.json()

But what I get is, RemoteDisconnected: Remote end closed connection without response What should be done ?

Nathan Basanese · Accepted Answer · 2021-06-20 18:12:23Z

1

Here r is Response type object which contains a server's response to an HTTP request. Now in your code you are using,

r = requests.get("values from api")

get method must receive a url as parameter.

You can use dir(r) to see the properties of the object. You can try some of them. If there is a json-encoded content of a response, r.json() will return it. Now json is very much similar to python dictionary. So you can use this as a dictionary, store it in a list and also manipulate the data.

edited Jun 20, 2021 at 18:12

Nathan Basanese

8,98211 gold badges41 silver badges68 bronze badges

answered Sep 19, 2014 at 22:26

salmanwahed

9,6878 gold badges37 silver badges56 bronze badges

Collectives™ on Stack Overflow

storing data retrieved from REST api into variables 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