Pandas read_json value_error, Type_erroe

Question

url = 'https://api.misoenergy.org/MISORTWDDataBroker/DataBrokerServices.asmx?messageType=getace&returnType=json'

pd.read_json(url)

ValueError: Expected object or value

pd.read_json(url, lines= True)

TypeError: initial_value must be str or None, not bytes

json sample:

{"MktDay":"11-19-2020","RefId":"19-Nov-2020 - Interval 14:10:00 EST","ACE":[{"instantEST":"2020-11-19 12:10:30 PM","value":"-60.95"},{"instantEST":"2020-11-19 12:11:00 PM","value":"172.85"},{"instantEST":"2020-11-19 12:11:30 PM","value":"344.70"}

The first code block works for me (python 3.9.5, pandas 1.2.0). Something else is wrong. — msanford
– msanford, Commented Aug 2, 2021 at 15:01

Jonathan Leon · Accepted Answer · 2020-11-19 20:15:45Z

1

Both of your examples worked for me.

you can try this as an option:

import requests
data = requests.get('https://api.misoenergy.org/MISORTWDDataBroker/DataBrokerServices.asmx?messageType=getace&returnType=json')
pd.read_json(data.text)

answered Nov 19, 2020 at 20:15

Jonathan Leon

5,6862 gold badges9 silver badges16 bronze badges

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

1 Comment

hp1232 Over a year ago

Thanks, that worked. not sure why for the same URL, pd.read_json wont work, but requests.get would

Collectives™ on Stack Overflow

Pandas read_json value_error, Type_erroe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related