jakevdp / open-recipe-data Goto Github PK

Dear all

I am learning from the Data Science Handbook now on Py 3.8/3.9. Just to share some small lines of code/modification that needs to be included to read the json file properly in those Python versions.

a) pg185 In[19] needs importing of StringIO for use with pd.read_json() to avoid "ValueError: Protocol not known":

from io import StringIO

with open("recipeitems.json") as f:
  line = f.readline()
pd.read_json(StringIO(line)).shape

b) pg185 In[20] needs specification of encoding="utf8" to avoid a UnicodeDecodeError,
and as above, the use of StringIO() with pd.read_json():

with open("recipeitems.json", 'r', encoding="utf8") as f:
  data = (line.strip() for line in f)
  data_json = f'[{",".join(data)}]'

recipes = pd.read_json(StringIO(data_json))

recipes.shape