我想你需要
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
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)