dta_004.py

df["month"] = df.index.month_name()

high_month_list = []
for year in list(df["year"].unique()):
    df_high_month = df[df["year"] == year][["year","funded_amount","month"]]
    df_high_month = df_high_month.groupby(["year","month"])["funded_amount"].sum().sort_values(ascending=False).head(1)
    high_month_list.append(df_high_month)
df_high_month = pd.concat(high_month_list).reset_index()
df_high_month