Python Pandas Write to Excel + Examples

In this Python Pandas tutorial, we will learn about Python Pandas Write DataFrame to Excel.

In Pandas, writing a DataFrame to an Excel file is a common task that can be accomplished in 3 ways. The most popular methods include:

• Using to_excel() method
• Using openpyxl library
• Using xlsxwriter library

Python Pandas Write DataFrame to Excel

Here we will discuss 3 different methods to write a DataFrame to Excel with examples. Let us start with the first example.

Method-1: Using to_excel() method

The to_excel() method is a convenient and straightforward way to write a DataFrame to an Excel file. It is a built-in method of the Pandas DataFrame class and can be used by simply calling df.to_excel() where df is the DataFrame object.

import pandas as pd

# Creating a sample dataframe
df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]})

# Writing the dataframe to an Excel file
df.to_excel("dataframe.xlsx", index=False)

The above code uses the Pandas library to create a sample dataframe (a table-like data structure) and writes it to an Excel file.

• The dataframe is created with three columns (A, B, and C) and three rows of data.
• The to_excel method is then used to write the dataframe to an Excel file named “dataframe.xlsx”, with the index argument set to False to exclude the index from the file.

Read: Python Pandas DataFrame Iterrows

Method-2: Using openpyxl library

To write a DataFrame to an Excel file using the openpyxl library, we need to create a Pandas ExcelWriter object and call the to_excel() method on the DataFrame object.

import pandas as pd
import openpyxl

# Creating a sample dataframe
df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]})

# Writing the dataframe to an Excel file
writer = pd.ExcelWriter("dataframe.xlsx", engine='openpyxl')
df.to_excel(writer, index=False)
writer.save()

The above code creates a sample dataframe in Pandas and writes it to an Excel file using the openpyxl library.

• The Pandas ExcelWriter class is used to create a writer object that can write the dataframe to the Excel file.
• The dataframe is written to the writer object with the to_excel method and the index argument is set to False. The writer object is then saved to the Excel file with the save method.

Read: Pandas Delete Column

Method-3: Using xlsxwriter library

In this method, the Pandas ExcelWriter class is then used to create a writer object that can write the dataframe to an Excel file.

import pandas as pd
import xlsxwriter

# Creating a sample dataframe
df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]})

# Writing the dataframe to an Excel file
writer = pd.ExcelWriter("dataframe.xlsx", engine='xlsxwriter')
df.to_excel(writer, index=False)
writer.save()

The above code uses the Pandas library and the xlsxwriter library to create a sample dataframe (a table-like data structure) and write it into an Excel file.

• The dataframe is created with three columns (A, B, and C) and three rows of data.
• The writer object is created with the name “dataframe.xlsx” and the engine is set to ‘xlsxwriter’ to specify the use of the xlsxwriter library.
• The dataframe is then written to the writer object using the to_excel method, with the index argument set to False to exclude the index from the file.
• Finally, the save method is called on the writer object to save the dataframe to the Excel file.

You may also like to read the following Python Pandas tutorials.

• Crosstab in Python Pandas
• Missing Data in Pandas in Python
• Get index Pandas Python
• Python DataFrame to CSV

In this tutorial, we have learned about Python Pandas Write DataFrame to Excel by following the below methods:

• Using to_excel() method
• Using openpyxl library
• Using xlsxwriter library