pandas 根据某一列数据merge文件，excel Vlookup的实现

import pandas as pd
import os
import functools

#水平拼接2个file, 以on_name这个关键字为主，方向用于设置以哪个df为主，尤其针对实验前后数据对比，比较好用
def H_merge_2files(df1,df2,on_name,Fangxiang='right')->pd.DataFrame:

    df = pd.merge(df1, df2, how=Fangxiang, on=on_name)

    df.dropna(axis=0, how='any', inplace=True, subset=None)

    return df


#水平拼接3个file, 以on_name这个关键字为主，方向用于设置以哪个df为主，尤其针对实验前后数据对比，比较好用
def H_merge_3files(df1,df2,df3,on_name,Fangxiang='right')->pd.DataFrame:

    df_temp1 = pd.merge(df1, df2, how=Fangxiang, on=on_name)

    df=pd.merge(df_temp1, df3, how=Fangxiang, on=on_name)

    df.dropna(axis=0, how='any', inplace=True, subset=None)

    return df


#水平拼接4个file, 以on_name这个关键字为主，方向用于设置以哪个df为主，尤其针对实验前后数据对比，比较好用
def H_merge_4files(df1,df2,df3,df4,on_name,Fangxiang='right')->pd.DataFrame:

    df_temp1 = pd.merge(df1, df2, how=Fangxiang, on=on_name)
    df_temp2 = pd.merge(df_temp1, df3, how=Fangxiang, on=on_name)
    df = pd.merge(df_temp2, df4, how=Fangxiang, on=on_name)
    df.dropna(axis=0, how='any', inplace=True, subset=None)


    return df


#水平拼接5个file, 以on_name这个关键字为主，方向用于设置以哪个df为主，尤其针对实验前后数据对比，比较好用
def H_merge_5files(df1,df2,df3,df4,df5,on_name,Fangxiang='right')->pd.DataFrame:

    df_temp1 = pd.merge(df1, df2, how=Fangxiang, on=on_name)
    df_temp2 = pd.merge(df_temp1, df3, how=Fangxiang, on=on_name)
    df_temp3 = pd.merge(df_temp2, df4, how=Fangxiang, on=on_name)
    df = pd.merge(df_temp3, df5, how=Fangxiang, on=on_name)
    df.dropna(axis=0, how='any', inplace=True, subset=None)

    return df


if __name__ == '__main__':

    df1=pd.read_excel(r'C:\Users\jackey\Desktop\TXRXRSSI\ATE_Summary.xlsx',sheet_name='P1P2')
    df2=pd.read_excel(r'C:\Users\jackey\Desktop\TXRXRSSI\ATE_Summary.xlsx',sheet_name='R1')
    df3 = pd.read_excel(r'C:\Users\jackey\Desktop\TXRXRSSI\ATE_Summary.xlsx', sheet_name='R2')
    on_name='4010:mac_l_1st'
    Fangxiang='right'
    df=H_merge_3files(df1,df2,df3,on_name,Fangxiang)
    df.to_excel(r'C:\Users\jackey\Desktop\TXRXRSSI\TG7100C_12K_TXRXRSSI_20220530.xlsx',index=None)