aggregation

.py

# what columns you want to group by
cols = ['Day', 'Ocean']

# picking the aggregation type ex: 'mean'
group = df_example.groupby(cols).agg({
 '1': ['mean'],
 '2: ['mean']})
  
# rename the column names with their respective aggregation type
group.columns = ["_".join(x) for x in group.columns.ravel()]
  
# look at the groupings
group.head()
  
# see how it looks on the original dataframe level 
grouped_df = group.reset_index()
grouped_df.head()