How to convert JSON to a dataframe with python

Question

How do I open a json file and turn it into a dataframe? I want to create graphs with Plotly later but I cannot seem to create a dataframe.

def open_file(filename):
  with open(filename, "r") as file:
    file_list = json.load(file)
    output_df = pd.DataFrame(file_list)
    return output_df


open_file("LT.json")

The error I get:

ValueError("DataFrame constructor not properly called!")

Use pandas.read_json.

9769953
– 9769953

2021-10-16 16:24:30 +00:00
Commented Oct 16, 2021 at 16:24 — 9769953
– 9769953, Commented Oct 16, 2021 at 16:24
share the json and explain how the df should look like.

balderman
– balderman

2021-10-16 18:27:14 +00:00
Commented Oct 16, 2021 at 18:27 — balderman
– balderman, Commented Oct 16, 2021 at 18:27

Abdella Solomon · Accepted Answer · 2021-10-16 16:55:03Z

1

The error ValueError("DataFrame constructor not properly called!") is telling you that you passed the incorrect type of data to the DataFrame. So, most probably file_list is not a dictionary. In my case, your code is 100% working. So, I think the problem is definitely from the JSON file. Maybe file_list is a type of string. If that is the case, using the eval method might help.

output_df = pd.DataFrame(eval(file_list))

But using pandas.read_json works 99% of the time

output_df = pd.read_json(filename)

answered Oct 16, 2021 at 16:55

Abdella Solomon

761 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

How to convert JSON to a dataframe with python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related