import pandas as pd import os

获取文件夹内所有csv文件的路径

folder_path = "./2023_2_20No2" csv_files = [os.path.join(folder_path, f) for f in os.listdir(folder_path) if f.endswith('.csv')]

对每一个csv文件进行处理

for csv_file in csv_files: # 读取csv文件 df = pd.read_csv(csv_file, encoding='utf-8') df = df.iloc[:, 1:18] df_tumor = df[df['name'] == 'tumor'] df_peritumor = df[df['name'] == 'peritumor'] tumor_dict = {} peritumor_dict = {} for name in ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H']: df_tumor_name = df_tumor[df_tumor['property'] == name] df_peritumor_name = df_peritumor[df_peritumor['property'] == name] tumor_dict[name] = df_tumor_name peritumor_dict[name] = df_peritumor_name median = df_tumor_name.iloc[:, 2:33].median() print(f"Tumor {name}: {median}")

    # 将计算的结果保存到该文件夹内
    output_path = os.path.join(folder_path, f"{os.path.splitext(os.path.basename(csv_file))[0]}_{name}_median.csv")
    median.to_csv(output_path