How to assign the average of a grouped dataframe to a column of another dataframe in python and pandas

Dash Python
2

Got the answer from Stack overflow as:

pd.merge(df_original,
         df.groupby('website')['amount_views'].mean().to_frame('average_views'),
         left_on='website',right_index=True,how='left')
1 Like