python 根据两个表格相同的列合并

pandas进行表格的合并

#!/bin/python

import pandas as pd
import openpyxl

excel_file = pd.read_excel('input1.xlsx', sheet_name=['sheet1', 'sheet2'])

table1 = excel_file['sheet1']
table2 = excel_file['sheet2']
#header_order = ['XX1', 'XX2','相同的列名XX']
merged_table = pd.merge(table1 , table2 , on='相同的列名XX')#.reindex(columns=header_order)
excel_writer = pd.ExcelWriter('merged_output.xlsx', engine='openpyxl')
merged_table.to_excel(excel_writer, sheet_name='merge_XX', index=False)

excel_writer._save()