Writing data to an Excel file

In this recipe, you will export a DataFrame as an Excel file format and leverage the different parameters available to use in the DataFrame.to_excel() writer function.

Getting ready

In the Reading data from an Excel file recipe in Chapter 2, Reading Time Series Data from Files, you were instructed to install openpyxl for the read engine. For this recipe, you will be using the same openpyxl for the write engine.

The file is provided in the GitHub repository for this book, which you can find here: https://github.com/PacktPublishing/Time-Series-Analysis-with-Python-Cookbook. The file is named movieboxoffice.csv.

To install openpyxl using conda, run the following:

>>> conda install openpyxl

You can also use pip:

>>> pip install openpyxl

How to do it…

To write the DataFrame to an Excel file, you need to provide the writer function with filename and sheet_name parameters. The file name contains the file path...