如何检查一列是否从数据框架中的其他列计算?

Question

我的数据帧命名为daily_activity，列是TotalDistance, ActiveDistance, ModeratelyActiveDistance, LightActiveDistance和SedentaryActiveDistance

if daily_activity['TotalDistance'] == daily_activity['ActiveDistance'] + daily_activity['ModeratelyActiveDistance'] + daily_activity['LightActiveDistance'] + daily_activity['SedentaryActiveDistance']:
  print('True')
else:
  print('False')

我一直得到SyntaxError: invalid syntax

Answer 1

daily_activity['TotalDistance'] == daily_activity['ActiveDistance'] + daily_activity['ModeratelyActiveDistance'] + daily_activity['LightActiveDistance'] + daily_activity['SedentaryActiveDistance']

返回一系列基于匹配的True, False值。

在序列上使用all()查看是否每个值都是True，如:

if (daily_activity['TotalDistance'] == daily_activity['ActiveDistance'] + daily_activity['ModeratelyActiveDistance'] + daily_activity['LightActiveDistance'] + daily_activity['SedentaryActiveDistance']).all():
   print('True')
else:
   print('False')