How To Export Python Data To Excel

Export a Pandas Dataframe to an Excel File

Created: October-24, 2021 | Updated: November-26, 2021

Consign a Pandas dataframe Into Excel File by Using the to_excel() Function
Export a Pandas dataframe by Using the ExcelWriter() Method
Export Multiple Pandas dataframes Into Multiple Excel Sheets

We will demonstrate in this tutorial how to consign a pandas dataframe to an excel file using two unlike ways. The get-go method is to consign a pandas dataframe to an excel file by calling the to_excel() office with the file proper noun. The other method discussed in this commodity is the ExcelWriter() method. This method writes objects into the excel sheet and so exports them into the excel file using the to_excel role.

In this guide, we volition also discuss how to add multiple Pandas dataframes into the multiple excel sheets using the ExcelWriter() method. Moreover, we have executed multiple examples on our system to explicate each method in detail.

Export a Pandas `dataframe` Into Excel File by Using the `to_excel()` Function

When we export a pandas dataframe to an excel sheet using the dataframe.to_excel() role, it writes an object into the excel sheet directly. To implement this method, create a dataframe and and so specify the name of the excel file. Now, by using the dataframe.to_excel() function, export a pandas dataframe into an excel file.

In the post-obit example, nosotros created a dataframe named as sales_record containing Products_ID, Product_Names, Product_Prices, Product_Sales columns. After that, we specified the proper name for the excel file ProductSales_sheet.xlsx. We used the sales_record.to_excel() method to save all data into the excel sheet.

See the below example lawmaking:

              import pandas as pd  # DataFrame Cosmos sales_record = pd.DataFrame({'Products_ID': {0: 101, 1: 102, 2: 103,                                  3: 104, 4: 105, 5: 106,                                  half-dozen: 107, 7: 108, viii: 109},                           'Product_Names': {0: 'Mosuse', 1: 'Keyboard',                                    2: 'Headphones', 3: 'CPU',                                    4: 'Flash Drives', 5: 'Tablets',                                    half-dozen: 'Android Box', 7: 'LCD',                                    8: 'OTG Cables' },                           'Product_Prices': {0: 700, ane: 800, 2: 200, 3: 2000,                                     iv: 100, v: 1500, six: 1800, 7: 1300,                                     8: ninety},                           'Product_Sales': {0: 5, ane: 13, 2: 50, 3: 4,                                     four: 100, 5: 50, 6: 6, 7: 1,                                     8: 50}})    # Specify the proper name of the excel file file_name = 'ProductSales_sheet.xlsx'    # saving the excelsheet sales_record.to_excel(file_name) print('Sales record successfully exported into Excel File')

Output:

              Sales record successfully exported into Excel File

After executing the above source, the excel file ProductSales_sheet.xlsx will be stored in the current running projection's folder.

export pandas dataframe into an excel file using the to_excel function

Export a Pandas `dataframe` by Using the `ExcelWriter()` Method

The Excelwrite() method is likewise useful to export a pandas dataframe into the excel file. First, we use the Excewriter() method to write the object into the excel sheet, and and so, by using the dataframe.to_excel() role, we can export the dataframe into the excel file.

See the instance lawmaking below.

              import pandas as pd  students_data = pd.DataFrame({'Student': ['Samreena', 'Ali', 'Sara',                                     'Amna', 'Eva'],                           'marks': [800, 830, 740, 910, 1090],                           'Grades': ['B+', 'B+', 'B',                                      'A', 'A+']})    # writing to Excel student_result = pd.ExcelWriter('StudentResult.xlsx')    # write students information to excel students_data.to_excel(student_result)    # save the students upshot excel student_result.save() print('Students data is successfully written into Excel File')

Output:

              Students data is successfully written into Excel File

export pandas dataframe into an excel file using the ExcelWriter function

Consign Multiple Pandas `dataframes` Into Multiple Excel Sheets

In the above methods, we exported a unmarried pandas dataframe into the excel sheet. But, using this method, we tin export multiple pandas dataframes into multiple excel sheets.

See the following example in which we exported multiple dataframes separately into the multiple excel sheets:

              import pandas as pd import numpy as np import xlsxwriter  # Creating records or dataset using dictionary Science_subject = {     'Name': ['Ali', 'Umar', 'Mirha', 'Asif', 'Samreena'],     'Curl no': ['101', '102', '103', '104', '105'],     'scientific discipline': ['88', '60', '66', '94', 'xl']}  Computer_subject = {     'Name': ['Ali', 'Umar', 'Mirha', 'Asif', 'Samreena'],     'Roll no': ['101', '102', '103', '104', '105'],     'computer_science': ['73', '63', '50', '95', '73']}  Art_subject = {     'Name': ['Ali', 'Umar', 'Mirha', 'Asif', 'Samreena'],     'Gyre no': ['101', '102', '103', '104', '105'],     'fine_arts': ['95', '63', '50', '60', '93']}  # Dictionary to Dataframe conversion dataframe1 = pd.DataFrame(Science_subject) dataframe2 = pd.DataFrame(Computer_subject) dataframe3 = pd.DataFrame(Art_subject)  with pd.ExcelWriter('studentsresult.xlsx', engine='xlsxwriter') equally writer:     dataframe1.to_excel(writer, sheet_name='Science')     dataframe2.to_excel(writer, sheet_name='Computer')     dataframe3.to_excel(writer, sheet_name='Arts')  print('Please check out subject-wise studentsresult.xlsx file.')

Output:

              Please check out field of study-wise studentsresult.xlsx file.

export mutliple pandas dataframes into multiple sheets

Write for u.s.a.

DelftStack articles are written past software geeks like you. If you also would similar to contribute to DelftStack by writing paid articles, you tin can check the write for us page.