如何使用python pandas从excel路径列表创建一个包含特定excel信息的大型数据帧。

pip install pandas

import pandas as pd
import os

def read_excel_to_dataframe(file_path):
    # 读取Excel文件
    df = pd.read_excel(file_path)
    return df

def create_dataframe_from_excel_paths(excel_paths):
    # 创建一个空的数据帧
    df_combined = pd.DataFrame()

    # 遍历Excel路径列表
    for path in excel_paths:
        # 检查路径是否存在
        if os.path.exists(path):
            # 读取Excel文件并将其添加到数据帧中
            df = read_excel_to_dataframe(path)
            df_combined = pd.concat([df_combined, df], ignore_index=True)
        else:
            print(f"文件路径不存在：{path}")

    return df_combined

excel_paths = ["path/to/excel1.xlsx", "path/to/excel2.xlsx", "path/to/excel3.xlsx"]
df_combined = create_dataframe_from_excel_paths(excel_paths)