How to Create a JSON File from a Pandas DataFrame in Python

In Pandas, you can use the to_json() method to convert a DataFrame to a JSON file. This method takes several arguments, such as the file path, the orient, and indent. I have an another article How to Create a Pandas DataFrame in Python, where you will learn how to create a Pandas DataFrame in Python. In this tutorial, I will use a sample DataFrame as below:

       id      name  math_score
0  202301    Minhaj          92
1  202302   Ridhwan          86
2  202303   Tanveer          76
3  202304  Sharodia          89
4  202305      Alve          99
5  202306   Intisar          99

Here’s an example of how you might use this to_json()method to write a DataFrame to an JSON file:
import pandas as pd
# Write the DataFrame to a JSON file
df.to_json(r'C:\Users\Minhaj\Desktop\data.json', orient='records', indent=4)

This will create a file named data.json in the current working directory, with the contents of the DataFrame in JSON format. Contents of the above written JSON file:


The orient parameter of the to_json() method allows you to specify the format of the JSON file. The default value is ‘columns’, which means the JSON file will have the column names as the top-level keys.

You can also use the json module to convert a DataFrame to a JSON string and then write it to a file:

import json
# Convert DataFrame to a JSON string
data_json = df.to_json(orient='records')

# Write JSON string to a file
with open(“data.json”, “w”) as f:

In this tutorial, I tried to brief how to create an JSON file from a Pandas DataFrame in Python. Hope you have enjoyed the tutorial. If you want to get updated, like my facebook page and stay connected.

Add a Comment