Answered step by step
Verified Expert Solution
Question
1 Approved Answer
After grouping a df by 'user id' and then getting the average rating by users, how do I add the average ratings as a column
After grouping a df by 'user id' and then getting the average rating by users, how do I add the average ratings as a column to the original data frame?
My codes so far are:
avgrat_df = rat_df.groupby(['user id'])['rating'].agg(["mean"])
avgrat_df.sort_values(by='mean', ascending=False).head(10)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started