How to save Pandas DataFrame as Excel File

You can save the Pandas DataFrame as Excel 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 Excel File in same folder in which code is running
df.to_excel("Data.xlsx", index=False)

Free Learning Resources

Recommended Laptops

Leave a Comment

Your email address will not be published.