Monday, December 12, 2016

Pivot Tables



In the previous lesson we cleaned up the data we’ve been collecting. Now the question is: what can we do with it? Look at this table. It was created from the over 65,000 rows of data in the movie rating dataset we saw a few lessons ago….

WomenMen
NumberAvg. RatingNumberAvg Rating
All Movies16,7163.5448,8193.53
Star Wars1024.232844.37
Abyss, The204.00823.55

How long do you think it would take you to calculate the values in this table from the raw dataset of ~65,000 rows? Justify your answer.