I am trying to get the month with the most passenger trips. Currently my code gets the correct maximum Passenger trips for each route but gives busiest month of 12 for all. What have I missed?
import pandas as pd
df = pd.read_csv("data.csv")
df.rename(columns={'MonthNum': 'BusiestMonth', 'PassengerTrips': 'Numtrips'}, inplace=True)
df = df[['City1', 'City2', 'BusiestMonth', 'Numtrips']]
df = df.groupby(['City1', 'City2']).max('Numtrips') #doesnt get busiest month, just gets december
print('Each routes busiest month:')
print(df)