Trying to store a GET Requests to a DataFrame in Pandas, but getting the following error

Asked Oct 23 '21 at 17:55

Active Oct 24 '21 at 07:50

Viewed 54 times

url = "https://api.defhc.com/v5/odata-v4/Hospitals?$top=500"

res = requests.get(url,headers={"Authorization": "Bearer %s" % access_token}).json()

df = pd.DataFrame(res)

Getting this error:

TypeError: Cannot interpret '<attribute 'dtype' of 'numpy.generic' objects>' as a data type

I want to be able to store the data in a DataFrame in Pandas so I can perform some analysis.

edited Oct 24 '21 at 07:50

j__carlson

1,346
3
12
20

asked Oct 23 '21 at 17:55

Eli Santibanez

Can you post what you are receiving into `res`? If it is sensitive data, post mock data, in the same format as that of the actual data. – Arvind Kumar Avinash Oct 23 '21 at 18:10
I do not think you will receive answers if you do not provide at least some mockup data. – hpchavaz Oct 23 '21 at 18:10

Trying to store a GET Requests to a DataFrame in Pandas, but getting the following error

0 Answers0