POPESTIMATES是2010-2015年的实际pop估计值,我想得到年份之间的最大差值。所以我必须检查| POPESTIMATE2015-POPESTIMATE2014 |,| POPESTIMATE2015-POPESTIMATE2014 |…| POPESTIMATE2013-POPESTIMATE2010 |。。。然后找到最高的绝对值。 这是我写的方法,但我收到了一个无法将浮点Nan转换为整数的错误,它太慢了。我相信有一个更有效的方法来做到这一点。有什么想法吗
def question7():
c = census_df
c['delta'] = 0
c['delta_max'] = 0
x = 5
y = 0
for index, row in c.iterrows():
while x > 0:
while y > -1:
c.loc[index, ['delta']] = (c.loc[index, ['POPESTIMATE201' + str(x)]] - c.loc[index, ['POPESTIMATE201' + str(y)]]).abs()
if int(c.loc[index, ['delta']]) > int(c.loc[index, ['delta_max']]):
c.loc[index, ['delta_max']] = c.loc[index, ['delta']]
y -= 1
x -= 1
return c['delta_max']
我认为需要^{} :
相关问题 更多 >
编程相关推荐