How to merge excel using python
import pandas as pd
excel1 = 'workbook1.xlsx'
excel2 = 'workbook2.xlsx'
df1 = pd.read_excel(excel1)
df2 = pd.read_excel(excel2)
values1 = df1['Locations','Employees','Revenue','Profit']
values2 = df2['Locations','Employees','Revenue','Profit']
dataframes = [values1, values2]
join = pd.concat(dataframes)
join.to_excel("output.xlsx")
No comments