[Python] Output pandas.DataFrame as json

Summary

Data analysis is performed using python. The analysis itself is performed using pandas, and the final results are stored in pandas.DataFrame format.

I want to output this result to a file in json format in order to use it in other applications.

How to do it

1 Convert pandas.DataFrame to dictionary

data = df.to_dict(orient='records')

2 Save to file

with open(file_path, 'w', encoding='utf-8') as file:
    json.dump(data, file, indent=4, ensure_ascii=False)

Specify the path of the file you want to save in file_path.

If it contains Japanese characters, set ensure_ascii = False to avoid garbled characters

Notes

pandas.DataFrame also has a method called to_json(), but don't use this.

to_json() is a method that converts to a json-like format string.

If you read the output of this, it will be read as one long string.