Friday, July 21, 2017

Looking at Reddit Comment Data, Part 2 (Trump, Bernie, Hillary, & Harry Potter)

(Note: This post was written using reddit comment data from Jan 2015 up to June 2017.)

To see the most popular subreddits in terms of comments, I calculated the following values for all subreddits:
  • comments: number of comments in the subreddit
  • c_rank: subreddit rank by number of comments
  • users: number of commenters, or users who posted at least 1 comment
  • u_rank: subreddit rank by number of commenters
  • avg cmts: average number of comments per commenter
Again, AutoModerator and '[deleted]' users were not counted.

The following table shows the subreddits that are in top 20 by either the number of comments, or the number of users (who posted at least 1 comment). You can click on column headers to sort the table by column.

subreddit comments c_rank users u_rank avg cmts
AskReddit12952601814054395131.95
politics3345949827226961746.3
leagueoflegends2425981236067362139.98
nba2004286242800395471.57
nfl1953646652718905671.85
worldnews1889391361176059816.07
The_Donald1883557473937693847.83
funny184179138184434439.99
pics171253079185140229.25
news167503431010196621016.43
videos15047577111439067410.46
pcmasterrace14464493126903851920.95
SquaredCircle1421659113126425133112.45
todayilearned14207850141359651510.45
soccer13818732152509606655.06
hockey127144811615328711482.95
gaming1215733617122506479.92
movies116848271810071131211.6
DotA211243969192396916946.91
GlobalOffensive11106482203600584230.85
gifs870065825124775066.97
Showerthoughts716228730106102296.75
aww4890833351015063114.82
IAmA400519555989388134.05
mildlyinteresting449680144950380144.73
WTF818811726827009159.9
Music315712878736537164.29
AdviceAnimals9202993237109051812.95
explainlikeimfive474529740683992206.94

No real surprise here. Ask reddit, politics, gaming, sports, news, and Donald Trump.

The Donald, Bernie Sanders, Hillary Clinton, and Harry Potter


From the data, we can see the popularity, or at least the celebrity, of Donald Trump. /r/The_Donald is the number one subreddit focused on an individual, by either the number of comments or the number of users. The next individual-focused subreddit is for Bernie Sanders, and Hillary Clinton is way behind. I also noticed the Harry Potter subreddit while looking at the data.

subreddit comments c_rank users u_rank avg cmts
The_Donald1883557473937693847.83
SandersForPresident4176126512087817820.00
harrypotter8325613638216722110.13
hillaryclinton11932522434141849328.81


The fact that /r/The_Donald is the top subreddit focused on an individual is also confirmed by reddistlist, which ranks subreddits by recent activity and subscribers.

Now, would Harry Potter win a presidential race against Donald Trump, Bernie Sanders, or Hillary Clinton ? It's tough to predict. Potter is a great wizard, but from all indications, Trump is also a great wizard in his own right.

We know Potter has great name recognition and is popular with young voters, but he has yet to be attacked politically. All we have are some pro-Potter propaganda books by JK Rowling.