import pandas as pd
df=pd.read_excel(r'r:\downloads\excel.xlsx',header=None)
df.dropna(axis=0,how='all',inplace=True)
col=df.iloc[0,].fillna('col').tolist()
df=df[1:]
df.columns=col
print(df)
- 删除开头的空行,用首行充当列索引名称
- pandas不在意索引名称重合
- 去除行索引名称重合,可以用
df2=df2[~df2.index.duplicated(keep='first')]