Extract specific data from JSON file

Question

I have this json file that is available in the link https://raw.githubusercontent.com/Cyral/Bakeoof/master/full_format_recipes.json

and I used Pandas to open the recipes JSON file.

import pandas as pd
df = pd.read_json('full_format_recipes.json', lines=True)
print(df)

and this is the output I get

  0      \
0  {'directions': ['1. Place the stock, lentils, ...   

                                               1      \
0  {'directions': ['Combine first 9 ingredients i...   

                                               2      \
0  {'directions': ['In a large heavy saucepan coo...   

                                               3      \
0  {'directions': ['Heat oil in heavy large skill...   

                                               4      \
0  {'directions': ['Preheat oven to 350°F. Lightl...   

                                               5      \
0  {'directions': ['Mix basil, mayonnaise and but...   

                                               6      \
0  {'directions': ['Cook potatoes and carrots in ...   

                                               7      \
0  {'directions': ['Stir together sugar and chili...   

                                               8      \
0  {'directions': ['Stir together soy sauce, suga...   

                                               9      ...  \
0  {'directions': ['Chop enough parsley leaves to...  ...   

                                               20120  \
0  {'directions': ['Bring all ingredients to a si...   

                                               20121  \
0  {'directions': ['1. Preheat the oven to 400°F....   

                                               20122  \
0  {'directions': ['Mix first 4 ingredients in la...   

                                               20123  \
0  {'directions': ['Stir water, sugar and juice i...   

                                               20124  \
0  {'directions': ['Wash spareribs. Remove excess...   

                                               20125  \
0  {'directions': ['Beat whites in a bowl with an...   

                                               20126  \
0  {'directions': ['Bring broth to simmer in sauc...   

                                               20127  \
0  {'directions': ['Using a sharp knife, cut a sh...   

                                               20128  \
0  {'directions': ['Heat 2 tablespoons oil in hea...   

                                               20129  
0  {'directions': ['Position rack in bottom third...  

[1 rows x 20130 columns]

I want to extract only the directions and the title for each recipe, How can I do that?

You should check the JSON content structure and use suitable parameters to read it. Obviously the file only has one line so you should not set lines=True. — guyskk
– guyskk, Commented Apr 7, 2020 at 4:15

jrd1 · Accepted Answer · 2020-04-07 03:16:50Z

Remove lines=True - that's meant for JSON files in which an object exists on each line, or if you want to read in each object individually. That is, with line=True although each object has the same properties, they are not collated into a single entity.

Making that modification, you'll be able to access the properties you desire:

import pandas as pd
url = 'https://raw.githubusercontent.com/Cyral/Bakeoof/master/full_format_recipes.json'
df = pd.read_json(url)
print(df['directions'])
print(df['title'])

Ref: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_json.html

umarf786 · Accepted Answer · 2020-04-07 03:21:50Z

0

If you get rid of lines=True it should format your code accordingly to allow you to access your JSON as you normally would. You don't need it in that structure.

answered Apr 7, 2020 at 3:21

umarf786

1

Collectives™ on Stack Overflow

Extract specific data from JSON file

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related