You need to convert Series to DataFrame, first. I think, this will work:

df_new = df_agg.to_frame().reset_index()

Also, inplace=True flag is used to modify DataFrame without assignment, like:

df_new = df_agg.to_frame()
df_new.reset_index(inplace=True)