Synopsis

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