df['gross_revenue'] = df['sales'] * df['quantity'] df['tax'] = df['gross_revenue'] * 0.075 df['net_revenue'] = df['gross_revenue'] - df['tax'] # But you only actually needed net_revenue