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

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

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

我想你需要

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


欢迎分享,转载请注明来源:内存溢出

原文地址: https://outofmemory.cn/zaji/5498870.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2022-12-12
下一篇 2022-12-12

发表评论

登录后才能评论

评论列表(0条)

保存