This is visualizing comment data from the SeattleWA subreddit for the month of October. The data was taken from https://bigquery.cloud.google.com/table/fh-bigquery:reddit_comments.2016_10
# of comments in October : 34587
# gold set to comments: 13
Total comment score for comments in October : 156832
Average comment score for comments in October : 4.53442
[1] "most frequent commentors, their avg and total score"
author freq mean_score total_score
[deleted] 1765 1.7801700 3142
AmericanDerp 533 6.2120075 3311
JohnDanielsWhiskey 493 6.0385396 2977
ycgfyn 470 0.4297872 202
ChefJoe98136 358 4.4413408 1590
MrsWhatsit-75 329 2.2279635 733
tasdna 317 0.7602524 241
[1] "comments on posts by category"
link_flair_text mean_count count
Question 16.89388 4139
Transit 39.56180 3521
Government 29.02830 3077
Crime 34.34483 2988
Homeless 47.12500 2639
Other 33.24490 1629
News 23.50000 1598
[1] "Total score for the hour a comment is made"
created_pacific_hour score
11 12874
12 12741
8 12137
9 11942
10 11690
13 10517
14 10032
[1] "Total comments created by hour"
created_pacific_hour freq
12 2602
11 2405
13 2383
14 2319
10 2318
16 2271
15 2256
[1] "Total score for the weekday a comment is made"
created_pacific_weekday score
Thursday 27869
Monday 24129
Tuesday 23706
Friday 23276
Wednesday 23200
Saturday 18704
Sunday 15948
[1] "Total comments created by weekday"
created_pacific_weekday freq
Tuesday 5601
Thursday 5398
Wednesday 5228
Monday 5028
Friday 5020
Saturday 4383
Sunday 3929
[1] "Total comments created by weekday by hour"
created_pacific_weekday created_pacific_hour freq
Thursday 12 482
Tuesday 13 452
Tuesday 16 443
Tuesday 15 440
Wednesday 12 440
Wednesday 13 437
Thursday 13 430
created_pacific_weekday created_pacific_hour freq
Monday 2 12
Thursday 3 12
Thursday 4 14
Tuesday 4 14
Friday 3 15
Tuesday 2 16
Tuesday 3 16
Warning: Ignoring unknown parameters: binwidth, bins, pad
Total comments using 'Nimby' or 'Nimbies': 79
Total comments deleted by user: 1519
Total comments removed by mod: 35
Comment word cloud