merge函数连接两个文件

def select(inputfile,outputfile):
    df = pd.read_csv(inputfile2)
    df1= pd.read_csv(outputfile)
    df_reset = df.reset_index(drop=True) # 创建副本，重置索引
    merged_df = df1.merge(df_reset[['InnerCode', 'SecuCode', 'SecuAbbr']], 
                          how='left', on='InnerCode', suffixes=('', '_match'))
    # merge函数 left保留df1所有行, on指定连接的列
    df1['SecuCode'] = merged_df['SecuCode'].fillna('')
    df1['SecuAbbr'] = merged_df['SecuAbbr'].fillna('') # 未找到为空 
    df1.to_csv(outputfile, index=False)

if __name__ == "__main__":
    inputfile=f'xxxfilename.csv'
    outputfile=f'xxxfilename.csv'
    select(inputfile,outputfile)