Pandas Excel: Import three datasheets from a given excel data into a single dataframe and export the result into new Excel file
25. Export Combined Datasheets to a New Excel File
Write a Pandas program to import three datasheets from a given excel data (employee.xlsx ) into a single dataframe and export the result into new Excel file. Go to Excel data
Note: Structure of the three datasheets are same.
Sample Solution:
Python Code :
import pandas as pd
import numpy as np
df1 = pd.read_excel('E:\employee.xlsx',sheet_name=0)
df2 = pd.read_excel('E:\employee.xlsx',sheet_name=1)
df3 = pd.read_excel('E:\employee.xlsx',sheet_name=2)
df = pd.concat([df1, df2, df3])
df.to_excel('e:\output.xlsx', index=False)
Excel Data:
employee.xlsx:
Sheet-1
Sheet-2
Sheet-3
For more Practice: Solve these Related Problems:
- Write a Pandas program to import three datasheets from employee.xlsx, combine them into one DataFrame, and export the result to a new Excel file.
- Write a Pandas program to merge multiple sheets from an Excel file and save the combined DataFrame to a new file.
- Write a Pandas program to concatenate three datasheets with identical structure and then write the merged DataFrame to Excel.
- Write a Pandas program to read three sheets from employee.xlsx, verify their compatibility, and then export the unified DataFrame as a new Excel document.
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.