How to read Json File into a list of Rows?

Question

I am trying to read a JSON file into lists of Rows where each entry in the list is a single row from the file.

See code below

with open("C:\Users\Derrick.Speirs\Desktop\jcpenney_reviewers.json", "r") as fid: dat = [dict(json.loads(row)) for row in fid] print(dat) display(type(dat))

This code results in the following whereby each entry is not on a single row.

[{'ID': 'bkpn1412', 'DOB': '31.07.1988', 'State': 'Oregon', 'Reviewed': ['cea76118f6a9110a893de2b7654319c0']}, {'Usern

Any help appreciated thanks.

Alex_X1 · Accepted Answer · 2022-12-16 12:58:13Z

1

with open("C:\\Users\\David.Johnson\\Desktop\\bigjohn.json", "r") as fid:
    dat = [dict(json.loads(line)) for line in fid]

Using dict and zip might cause the issue

answered Dec 16, 2022 at 12:58

Alex_X1

3332 silver badges13 bronze badges

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

3 Comments

user18605114 Over a year ago

Thanks. That sorrted it. Appreciated

Alex_X1 Over a year ago

I am glad I was able to help

user18605114 Over a year ago

The only issue now is each entry is not on a single row.

Collectives™ on Stack Overflow

How to read Json File into a list of Rows?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related