From the course: Data Engineering Foundations

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Challenge: Transforming data

Challenge: Transforming data

From the course: Data Engineering Foundations

Start my 1-month free trial

Challenge: Transforming data

(bright music) - [Instructor] So here's a quick challenge for you to transform the users data frame by aggregating all the ratings. You have to fill in these blanks with the right function and the columns to aggregate the data. And then the second task is to join the two tables. That is, the movies data fame and the average rating data frame based on the common columns that is there in each of these tables. The last task is to actually print the final data frame that you have just returned after merging the two tables.

Contents