How to save Pandas DataFrame as JSON File

You can save the Pandas DataFrame as a JSON file with the given code.

# Import the Pandas library as pd
import pandas as pd

# Initialize a dictionary
dict = {'Students':['Harry', 'John', 'Hussain', 'Satish'],
        'Scores':[77, 59, 88, 93]}

# Create a DataFrame
df = pd.DataFrame(dict)

# Save DataFrame as JSON File in same folder in which code is running
df.to_json('Data.json', orient='index')

Free Learning Resources

Recommended Laptops

Leave a Comment

Your email address will not be published.