data4_pivot = data4.pivot_table(index=['user_id', 'month'], values=['distance', 'duration', 'name'], aggfunc={'distance':'sum', 'duration':'sum', 'name':'count'}) data4_pivot.columns = ['total_distance', 'total_duration', 'trip_count', 'subscription_type'] data4_pivot