But first, speaking of "tweets," here's a picture of my friend Danielle's favorite tweeter. Thanks for letting me use your picture, Danielle!
In my version (below, and click through here to see the full-sized interactive version), I decided to make a few changes.
- Rather than using a 3-color gradient, I used a single color with transparency. That way, when multiple tweets lined up in nearly the same spot in the graph, the colors would combine and make a darker shade.
- I added a note indicating when the data snapshot was taken (Nov 30, 2017).
- I added time labels along the right-hand-side axis tick marks.
- I include a blank space for December in the axis, making it more evident that this data does not include December tweets.
- I left off the 'Time' label on the Y-axis (I think people will know that these are 'time' values).
- I added 'Noon' and 'Midnight' labels on the time axis, to help prevent confusion between 12pm and 12am.
- I use reference lines between the months, instead of in the middle of the months.
While importing the data, I noticed that there were actually tweets available for quite a few years, and thought it might be interesting to also plot the previous years' data. The original author also went down this path, posting the following graph in a follow-up comment on the reddit thread. But his new graph had several problems. Why didn't the "High Tweet Density" colors in this graph match up with the colors used in the previous graph? (Has the definition of "High" changed?) And the tick marks & labels along the bottom axis are poorly chosen (looks like he let it auto-scale, and didn't include the year in the labels, which makes them very confusing).
In my version (below, and click through here to see the full interactive version), I label the bottom axis by year, and add reference lines between each year. I also go back to 2009, rather than just 2013 (if you're going to show a historical graph, why not go back as far as you have data, eh?)
Looks like Trump's tweeting habits have varied over the years - can you correlate any events, or maybe his "job changes" with the density of his tweets? Or perhaps he changed the type of phone he was using in early 2013? I wonder if he was using an automated system to tweet during the night, in the 2013/2014/2015 time period? Perhaps he had employees tweeting for him?
It was a big surprise to me that it appears Trump has actually been tweeting less since he became president! What interesting things do you see in these graphs?
[This blog originally appeared on SAS Learning Post, and you can read the original there.]