The Best Time to Post on Reddit
I used R to visualize the best time to post on Reddit using data collected with Google's BigQuery. I queried a publicly accessible dataset containing almost 200 million Reddit posts (all of the posts between January 2006 and August 2015), extracting the score (upvotes minus downvotes) and the timestamp for each post. I proceeded to separate the posts into the day of the week and the time of day it was posted, summed the scores for that period of time, and divided the result by the total number of posts made in that period of time. I visualized this normalized data as a heatmap using ggplot2.