Combine Multiple Excel Worksheets Into a Single Pandas Dataframe
Prerequisites: Working with excel files using Pandas
In these articles, we will discuss how to Import multiple excel sheet into a single DataFrame and save into a new excel file. Let’s suppose we have two Excel files with the same structure (Excel_1.xlsx, Excel_2.xlsx), then merge both of the sheets into a new Excel file.
Approach :
- Import-Module
- Read Excel file and store into a DataFrame
- Concat both DataFrame into a new DataFrame
- Export DataFrame into an Excel File with DataFrame.to_excel() function
Below is the implementation.
Python3
import pandas as pd
df1 = pd.read_excel( 'excel_work\sample_data\Book_1.xlsx' )
df2 = pd.read_excel( 'excel_work\sample_data\Book_2.xlsx' )
df = pd.concat([df1, df2])
df.to_excel( 'final_output.xlsx' , index = False )
|
Output :
Last Updated :
05 Sep, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...