import pandas as pd import xlwings as xw excel1 = '분개장_1.xlsx' excel2 = '분개장_2.xlsx' df_excel1 = pd.read_excel(excel1, 'Sheet1', na_values=['NA']) df_excel2 = pd.read_excel(excel2, 'Sheet1', na_values=['NA']) df_excel1['version'] = 'cur' df_excel2['version'] = 'new' gb_excel1 = df_excel1.groupby(['전표일자', '전표번호']) gb_excel2 = df_excel2.groupby(['전표일자', '전표번호']) df_excel1['전표번호seq'] = gb_excel1.cu..