I was carrying out the requested exercise and I tried to produce some code which saved the rows where revenue was more than target as a separate variable. I’m not sure why my code didn’t work, if anyone could explain that would be much appreciated.
crushing_it = sales_vs_targets .revenue > sales_vs_targets.target this code has only selected the columns of a table that has such columns. we need to specify the table we are fetching this info from
so your code needs to state the data-frame and then the columns like this crushing_it = sales_vs_targets [sales_vs_targets.revenue > sales_vs_targets.target]