check_abc_columns.py 264 B

12345678910
  1. import pandas as pd
  2. df = pd.read_excel(r'C:\Users\EDY\Desktop\日记账\橙风-农行-账户明细查询列表 (3).xls', header=2)
  3. print('所有列名:')
  4. for i, col in enumerate(df.columns):
  5. print(f'{i}: {col}')
  6. print('\n前20行数据:')
  7. print(df.head(20))