Python - converting a JSON read file into a usable DataFrame

Question

I am new to Python and was trying to use the following code to read in a JSON file and convert it to a dataframe with column headers etc. I just cannot seem to understand what I am doing wrong here as the output is as shown below

import pandas as pd
import matplotlib as plt

other_path = "c:\\users\\xyz\\documents\\covid.json"
df = pd.read_json(other_path)
print (df.head())
print (type (df))

Output

Eric · Accepted Answer · 2020-05-17 08:25:36Z

1

Use the argument orient="records" see the docs here

df = pd.read_json(other_path, orient="records")

answered May 17, 2020 at 8:25

Eric

8476 silver badges26 bronze badges

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

2 Comments

John Over a year ago

Thank you so much for responding - I tried that and it still shows the same output as before. Just can;t get it to work.

Eric Over a year ago

@John Could you edit your answer to include the input json structure, in a code block at the top?

Collectives™ on Stack Overflow

Python - converting a JSON read file into a usable DataFrame

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related