This is visualizing comment data from the SeattleWA subreddit for the month of November. The data was taken from https://bigquery.cloud.google.com/table/fh-bigquery:reddit_comments.2016_11
# of comments in November : 35122
# gold set to comments: 12
Total comment score for comments in November : 172914
Average comment score for comments in November : 4.923239
[1] "most frequent commentors, their avg and total score"
author freq mean_score total_score
[deleted] 2438 2.887613 7040
ycgfyn 680 -1.438235 -978
JohnDanielsWhiskey 471 3.740977 1762
RainierRancor 431 1.633411 704
MrsWhatsit-75 427 4.009368 1712
ChefJoe98136 394 6.045685 2382
AmericanDerp 389 8.922879 3471
[1] "comments on posts by category"
link_flair_text mean_count count
Government 48.53271 5193
Question 17.20717 4319
Discussion 51.61290 3200
Transit 41.07895 3122
Crime 34.51389 2485
Other 40.24561 2294
Media 25.04762 1578
[1] "Total score for the hour a comment is made"
created_pacific_hour score
8 15359
9 15130
10 13250
11 11790
13 11280
12 10078
14 9652
[1] "Total comments created by hour"
created_pacific_hour freq
9 2533
10 2512
11 2432
13 2315
12 2250
14 2187
15 2111
[1] "Total score for the weekday a comment is made"
created_pacific_weekday score
Wednesday 38793
Tuesday 30403
Monday 26733
Friday 22406
Thursday 22390
Saturday 16904
Sunday 15285
[1] "Total comments created by weekday"
created_pacific_weekday freq
Wednesday 7052
Tuesday 6253
Friday 5251
Thursday 4954
Monday 4862
Saturday 3735
Sunday 3015
[1] "Total comments created by weekday by hour"
created_pacific_weekday created_pacific_hour freq
Wednesday 11 517
Wednesday 9 503
Wednesday 10 494
Tuesday 13 474
Tuesday 10 471
Wednesday 12 446
Wednesday 8 444
created_pacific_weekday created_pacific_hour freq
Friday 4 12
Saturday 4 15
Monday 3 16
Sunday 3 18
Sunday 4 19
Monday 4 20
Monday 2 24
Warning: Ignoring unknown parameters: binwidth, bins, pad
Total comments using 'Nimby' or 'Nimbies': 69
Total comments using 'Trump': 1806
Total comments deleted by user: 1990
Total comments removed by mod: 16
Comment word cloud