This is visualizing comment data from the SeattleWA subreddit for the month of December. The data was taken from https://bigquery.cloud.google.com/table/fh-bigquery:reddit_comments.2016_12
# of comments in December : 33522
# gold set to comments: 8
Total comment score for comments in December : 150103
Average comment score for comments in December : 4.477746
[1] "most frequent commentors, their avg and total score"
author freq mean_score total_score
[deleted] 1856 2.151401 3993
RainierRancor 724 1.244475 901
AmericanDerp 570 6.614035 3770
ChefJoe98136 507 4.240631 2150
JohnDanielsWhiskey 480 4.716667 2264
it-is-sandwich-time 404 3.230198 1305
kamiikoneko 392 3.709184 1454
[1] "comments on posts by category"
link_flair_text mean_count count
Government 59.55128 4645
Discussion 42.14103 3287
Question 15.55801 2816
Transit 52.20755 2767
News 33.91892 2510
Crime 30.54667 2291
Business 34.24194 2123
[1] "Total score for the hour a comment is made"
created_pacific_hour score
10 12468
8 12111
9 11613
12 11288
11 10848
13 9476
15 8903
[1] "Total comments created by hour"
created_pacific_hour freq
10 2530
11 2490
12 2233
9 2232
15 2133
16 2122
14 2121
[1] "Total score for the weekday a comment is made"
created_pacific_weekday score
Friday 26324
Thursday 25491
Tuesday 22379
Wednesday 21386
Monday 20750
Saturday 18664
Sunday 15109
[1] "Total comments created by weekday"
created_pacific_weekday freq
Friday 5880
Thursday 5668
Tuesday 4953
Wednesday 4854
Monday 4480
Saturday 4106
Sunday 3581
[1] "Total comments created by weekday by hour"
created_pacific_weekday created_pacific_hour freq
Friday 10 559
Friday 9 475
Friday 11 468
Friday 12 419
Thursday 11 414
Wednesday 10 411
Friday 16 405
created_pacific_weekday created_pacific_hour freq
Monday 3 13
Sunday 5 15
Thursday 3 16
Monday 4 18
Wednesday 3 21
Saturday 4 22
Thursday 4 23
Warning: Ignoring unknown parameters: binwidth, bins, pad
Total comments using 'Nimby' or 'Nimbies': 88
Total comments using 'Trump': 867
Total comments deleted by user: 1469
Total comments removed by mod: 102
Comment word cloud