'How do I check if a column is calculated from other columns in a dataframe?

my data frame is named daily_activity and the columns are TotalDistance, ActiveDistance, ModeratelyActiveDistance, LightActiveDistance, and SedentaryActiveDistance

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

I keep getting SyntaxError: invalid syntax

Solution 1:^[1]

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

returns a series of True, False values based on matches.

Use all() on the series to see if every value is True like:

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	SomeDude

'How do I check if a column is calculated from other columns in a dataframe?

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]