[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.
Recent Posts
See AllPhenomenon I get a title error when trying to import firestore with raspberry pi. from from firebase_admin import firestore ImportError: Failed to import the Cloud Firestore library for Python. Make s
Overview If you want to do fitting, you can do it with scipy.optimize.leastsq etc. in python. However, when doing fitting, there are many cases where you want to condition the fitting parameters. For
Phenomenon A title error occurs when trying to fit with the least squares method in the leastsq of spicy.optimize. from scipy import optimize import numpy as np def internalFunc1(x, plist):