How to save a Pandas DataFrame in JSON format

1 min

Sometimes, you will need to save a DataFrame in JSON format, either to share it or store it.

Here is how to save a DataFrame in JSON format.

# Import the Pandas library
import pandas as pd

# We create our example dataframe
df = pd.DataFrame({"col1" : range(0,10)})

# We save the dataframe as JSON
df.to_json("my_df.json")
How to save a DataFrame in JSON format

Here you are! You now know how to save a DataFrame in JSON format!

More on DataFrames

If you want to know more about DataFrame and Pandas. Checkout the other articles I wrote on the topic, just here :

Pandas - The Python You Need
We gathered the only Python essentials that you will probably ever need.