大量数据，分块读取。

    1. import pandas as pd
    3. read_path = r'D:\06_items\01_数据处理\dispose_data\aaa.xlsx'
    5. def read_thunk(read_path, nrows):
    6.     xl = pd.ExcelFile(read_path)
    7.     print('xl--->', xl)
    9.     sheet_names = xl.sheet_names
    10.     print(sheet_names)
    11.     sheet = xl.sheet_names[0]
    12.     # 只获取第一行，即表头
    13.     df_header = pd.read_excel(read_path, sheet_name=sheet, nrows=1)
    14.     print(f"Excel file: {read_path} (worksheet: {sheet})")
    16.     chunks = []
    17.     i_chunk = 0
    18.     skiprows = 1
    19.     while True:
    20.         df_chunk = pd.read_excel(
    21.             read_path, sheet_name=sheet,
    22.             nrows=nrows, skiprows=skiprows, header=None)
    23.         skiprows += nrows
    24.         # 判断读取的行数df_chunk.shape[0]，(df.shape[1]表示列数)
    25.         if not df_chunk.shape[0]:
    26.             break
    27.         else:
    28.             print(f"  - chunk {i_chunk} ({df_chunk.shape[0]} rows)")
    29.             chunks.append(df_chunk)
    30.             i_chunk += 1
    32.             df_chunks = pd.concat(chunks)
    33.             columns = {i: col for i, col in enumerate(df_header.columns.tolist())}
    34.             df_chunks.rename(columns=columns, inplace=True)
    35.             # 连接表头和数据
    36.             df = pd.concat([df_header, df_chunks])
    37.             return df
    39. if __name__ == '__main__':
    40.     # 每次读取1000行
    41.     df = read_thunk(read_path, 1000)