- income = all_data.pivot_table(index=['user_id', 'month'], values = ['distance', 'duration', 'name', 'subscription_type'], aggfunc={'distance':'sum', 'duration':'sum', 'name':'count', 'subscription_type': 'min'})
- income.columns = [['total_distance', 'total_duration', 'trip_count', 'subscription_type']]
- 6.3.
- ultra = income.query('subscription_type == "ultra"')
- free = income.query('subscription_type == "free"')
- UndefinedVariableError: name 'subscription_type' is not defined