Read JSON file in Python Pandas

Question

I have the following part of a JSON file:

[{"Date":"2020-02-17","Rt_low":0.5,"Rt_avg":1.93,"Rt_up":4,"population":"hosp"},{"Date":"2020-02-18","Rt_low":0,"Rt_avg":1.74,"Rt_up":4,"population":"hosp"}]

I want to read this in Python Pandas as a dataframe with the 4 columns as headers:

L = ['Date','Rt_low','Rt_up','population']

I tried the following:

df = pd.DataFrame(pd.read_json(file_name, lines=True))

Which gives me a [1 rows x 235 columns] for the whole dataset. I want to get 4 columns dataframe. How do I do this?

Destroyer-byte · Accepted Answer · 2020-10-14 08:28:06Z

1

you may try this approach.

import pandas as pd
dataframe = pd.read_json('sample_json_file.json', orient='values')
print(dataframe)

output for the final dataframe will be one that consists of a header row, and two observations.

edited Oct 14, 2020 at 8:28

answered Oct 14, 2020 at 8:19

Destroyer-byte

1211 silver badge4 bronze badges

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

Comments

Jeroen · Accepted Answer · 2020-10-14 07:51:07Z

0

I just did by:

df = pd.DataFrame(pd.read_json(file_name))

answered Oct 14, 2020 at 7:51

Jeroen

8512 gold badges7 silver badges25 bronze badges

Collectives™ on Stack Overflow

Read JSON file in Python Pandas

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related