How to convert JSON to CSV using python

Question

I have a JSON file around 120Mb, I tried converting the JSON file to CSV by running a python script

code:

import pandas as pd
file_path =r'D:\filename.json'
read_file = pd.read_json (file_path)
export_file_path = r'D:\output.csv'
read_file.to_csv (export_file_path, index = None, header=True)

The JSON file looks like this

[{"dateTime": "2019-11-01 00:00:05", "value": {"bpm": 54, "confidence": 3}}, {"dateTime": "2019-11-01 00:00:10", "value": {"bpm": 52, "confidence": 3}}..........

The CSV File looks like this

How can I get only the bpm values and also I want to remove the confidence values

elle.delle · Accepted Answer · 2021-05-28 08:34:16Z

1

You need to first create a dataframe from the JSON file It will have three columns: dateTime, bpm and confidence then df = df.drop(columns=['confidence'])

Then use df.to_csv

answered May 28, 2021 at 8:34

elle.delle

3384 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

How to convert JSON to CSV using 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