import pandas as pd df = pd.read_excel(r'C:\Users\EDY\Desktop\日记账\微众银行(202601)(人民币)交易明细.xlsx', header=1) print('所有列名:') for i, col in enumerate(df.columns): print(f'{i}: {col}') print('\n前20行数据:') print(df.head(20))