[index [] [列]中没有一个 - modfiy多个CSV文件

Question

我想使用以下代码修改多个CSV文件：

files = glob.glob(r'path')
df2 = pd.read_csv(r'path')

for fp in files:

    df = pd.read_csv(fp, names=["vermittler", "vermittler 2", "vermittler 3", "kunde", "nachname", "vorname", "strasse", "plz", "ort", "geburtsdatum", "beruf", "land", "per_du", "login", "login 2", "nationalitaet", "rechtsform", "id", "versicherungsscheinnummer", "sparte", "gesellschaft", "zahlweise", "beginn", "ablauf", "beitrag_netto", "status", "risiko", "antragsdatum", "stornodatum"], sep=',',on_bad_lines='skip')

    df.to_csv
for fp in files:
    

    df = df.fillna(0)
    df2 = df2.fillna(0)
    #df1['sparte']=df1['sparte'].astype(int)
    #df2['sparte']=df2['sparte'].astype(int)

    df['gesellschaft']=df['gesellschaft'].astype(object)
    #df2['gesellschaft']=df2['gesellschaft'].astype(object)


    df3 = pd.merge(df,df2[['status','stati']].astype(object),on='status', how='left').drop(columns = ['status'])
    df3.rename({'stati':'status'}, axis=1, inplace=True)


    df4 = df3.merge(df2[['sparte','sparten']].astype(object),on='sparte', how='left').drop(columns = ['sparte'])
    df4.rename({'sparten':'sparte'}, axis=1, inplace=True)


    df5 = df4.merge(df2[['gesellschaft','gesellschaften']].astype(object), left_on='gesellschaft',
    right_on = df2['gesellschaft'].astype(object), how='left')
    
    df5.to_csv

但是我收到错误消息：

KeyError: "None of [Index(['status', 'stati'], dtype='object')] are in the [columns]"

我不明白为什么，因为我尝试了一个非常相似的代码，但是对于一个文件，我

df1 = pd.read_csv(r'path')
df2 = pd.read_csv(r'path')

df1 = df1.fillna(0)
df2 = df2.fillna(0)

df1['gesellschaft']=df1['gesellschaft'].astype(object)

df3 = pd.merge(df1,df2[['status','stati']].astype(object),on='status', how='left').drop(columns = ['status'])
df3.rename({'stati':'status'}, axis=1, inplace=True)

是否会出现错误全球。

我被卡住了：？也许有人知道是什么原因引起了问题。