读取zip中的所有csv文件，并将各自的csv文件名作为数据帧变量名

import zipfile
import pandas as pd

zip_path = 'path_to_zip_file.zip'  # 替换为zip文件的路径
csv_files = []

with zipfile.ZipFile(zip_path, 'r') as zip_ref:
    for file_name in zip_ref.namelist():
        if file_name.endswith('.csv'):
            csv_files.append(file_name)
            zip_ref.extract(file_name, 'extracted_folder')  # 替换为解压缩后的文件存放路径

data_frames = {}

for csv_file in csv_files:
    df_name = csv_file[:-4]  # 去除文件名后缀.csv
    df = pd.read_csv(f'extracted_folder/{csv_file}')  # 替换为解压缩后的文件存放路径
    data_frames[df_name] = df