python pandas处理excel两列数据叠加，运行速度最快的运行方式

pandas处理excel两列数据叠加，运行速度最快的运行方式

def deijia(ysdata,data,Index):
    f1 = open(ysdata,encoding='utf-8', errors='ignore')
    f2 = open(data,encoding='utf-8',errors='ignore')

    df1 = pd.read_csv(f1)
    df2 = pd.read_csv(f2)
    df1.head()
    df2.head()
    print(df2)
    print (df1)

    test = pd.DataFrame()
    test = pd.DataFrame()
    now = datetime.datetime.now()
    print(now)
    for index, Num in enumerate(df1['relative_ts']):
        for ind, num in enumerate(df2['relative_ts']):
            if num + Index == index:
                df1.iloc[index] = list(df2.iloc[ind] + df1.iloc[index])
    now = datetime.datetime.now()
    print(now)
    df1.to_csv(ysdata, index=False)