pandas - read json file with only a list

Question

I have a given .json file which was saved as a list format (I guess it not proper json format)

as following:

users.json:

[ "user1", "user2" ]

I would like to read it into a pandas data frame and I tried using different types of arguments in the orient argument as following:

import pandas as pd
nodes = pd.read_json('users.json', orient='split')

I would like the results to look like this:

desired_df = pd.DataFrame({'col1': ["user1", "user2"]})

The closest so question I found was

Any help on that would be great! thanks in advance

what does each json node look like? you'll need to provide that at the least. — Umar.H
– Umar.H, Commented Oct 27, 2020 at 11:30
that's the format of the file I need to read :( if it's not possible to load it somehow, ill take it as an answer — Yehoshaphat Schellekens
– Yehoshaphat Schellekens, Commented Oct 27, 2020 at 11:32

balderman · Accepted Answer · 2020-10-27 11:33:12Z

2

The code below will create the df for you.

BTW - the json file is a valid json

import pandas as pd
import json
with open('users.json') as f:
  data = json.load(f)
desired_df = pd.DataFrame({'col1':data})
print(desired_df)

output

    col1
0  user1
1  user2

answered Oct 27, 2020 at 11:33

balderman

24k8 gold badges39 silver badges60 bronze badges

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

1 Answer 1