如何为选定的列在一行中选择最大值和最小值

我想你需要

min

max

df_subset=df.set_index('CTYNAME')[['CENSUS2010POP', 'ESTIMATESbase1010', 'POPESTIMATE2010']]df1 = df_subset.min(axis=1)print (df1)df2= df_subset.max(axis=1)print (df2)

编辑：

df = pd.Dataframe({'CTYNAME':['Alabama','Autauga County','Baldwin County','Barbour County'],        'CENSUS2010POP':[4,5,6,2],        'ESTIMATESbase1010':[7,8,9,3],        'POPESTIMATE2010':[1,3,5,5]})print (df)   CENSUS2010POP         CTYNAME  ESTIMATESbase1010  POPESTIMATE20100   4         Alabama       7     11   5  Autauga County       8     32   6  Baldwin County       9     53   2  Barbour Countydf_subset=df.set_index('CTYNAME')[['CENSUS2010POP', 'ESTIMATESbase1010', 'POPESTIMATE2010']]df1 = df_subset.max(axis=1) - df_subset.min(axis=1)print (df1)CTYNAMEAlabama6Autauga County    5Baldwin County    4Barbour County    3dtype: int64print (df1.nlargest(1).reset_index(name='top1'))   CTYNAME  top10  Alabama     6