df = pdread_csv2023_2_20No22023_2_20_19csvencoding = utf-8df = dfiloc118df_tumor = dfdfname == tumordf_peritumor = dfdfname == peritumor dfname = dfname + dfpropertydf_tumor_A = df_tumordf_tumorprope
可以使用groupby()函数对数据进行分组,将代码简化如下:
df = pd.read_csv("./2023_2_20No2/2023_2_20_19.csv",encoding = 'utf-8') df = df.iloc[:,1:18] df['name'] = df['name'] + df['property'] df_tumor = df[df['name'].str.contains('tumor')] df_peritumor = df[df['name'].str.contains('peritumor')]
df_tumor_groups = df_tumor.groupby('property') df_peritumor_groups = df_peritumor.groupby('property')
df_tumor_A = df_tumor_groups.get_group('A') df_tumor_B = df_tumor_groups.get_group('B') df_tumor_C = df_tumor_groups.get_group('C') df_tumor_D = df_tumor_groups.get_group('D') df_tumor_E = df_tumor_groups.get_group('E') df_tumor_F = df_tumor_groups.get_group('F') df_tumor_G = df_tumor_groups.get_group('G') df_tumor_H = df_tumor_groups.get_group('H')
df_peritumor_A = df_peritumor_groups.get_group('A') df_peritumor_B = df_peritumor_groups.get_group('B') df_peritumor_C = df_peritumor_groups.get_group('C') df_peritumor_D = df_peritumor_groups.get_group('D') df_peritumor_E = df_peritumor_groups.get_group('E') df_peritumor_F = df_peritumor_groups.get_group('F') df_peritumor_G = df_peritumor_groups.get_group('G') df_peritumor_H = df_peritumor_groups.get_group('H'
原文地址: http://www.cveoy.top/t/topic/cVcM 著作权归作者所有。请勿转载和采集!