Synopsis

This is visualizing comment data from the SeattleWA subreddit for the month of January. The data was taken from https://bigquery.cloud.google.com/table/fh-bigquery:reddit_comments.2017_01

# of comments in  January :  48440
# gold set to comments: 24
Total comment score for comments in  January :  239314
Average comment score for comments in January :  4.940421
[1] "most frequent commentors, their avg and total score"
             author freq mean_score total_score
      RainierRancor  763  0.2267366         173
          Cosmo-DNA  687  5.3289665        3661
       AmericanDerp  632  9.0474684        5718
       ChefJoe98136  576  5.0190972        2891
 JohnDanielsWhiskey  516  3.4282946        1769
 my_lucid_nightmare  461  5.7960954        2672

[1] "comments on posts by category"
 link_flair_text mean_count count
      Government   53.28358  7140
        Question   18.21200  4553
      Discussion   45.80435  4214
        Politics   97.57500  3903
            News   38.28395  3101
           Crime   34.12360  3037
          Notice   41.40000  2898
[1] "Total score for the hour a comment is made"
 created_pacific_hour score
                   19 18891
                    9 16874
                   11 15897
                   18 15743
                   10 15603
                   15 15515
                   21 14997
[1] "Total comments created by hour"
 created_pacific_hour freq
                   10 3194
                   11 3078
                   12 3060
                   15 3038
                    9 2932
                   16 2913
                   13 2890
[1] "Total score for the weekday a comment is made"
 created_pacific_weekday score
                Saturday 56433
               Wednesday 34025
                Thursday 31980
                  Monday 31787
                 Tuesday 31777
                  Friday 31434
                  Sunday 21878
[1] "Total comments created by weekday"
 created_pacific_weekday freq
                  Monday 7629
                 Tuesday 7592
                Saturday 7141
                  Friday 6920
                Thursday 6681
               Wednesday 6399
                  Sunday 6078
[1] "Total comments created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                Saturday                   21  652
                Saturday                   22  639
                  Friday                   15  555
                  Monday                   10  549
                 Tuesday                   16  538
                 Tuesday                   11  528
                 Tuesday                   10  514
 created_pacific_weekday created_pacific_hour freq
                  Friday                    3   14
               Wednesday                    3   14
                  Friday                    2   19
               Wednesday                    2   21
                  Friday                    1   23
                 Tuesday                    4   26
                Thursday                    4   33

Warning: Ignoring unknown parameters: binwidth, bins, pad

Total comments using 'Nimby' or 'Nimbies':  93
Total comments using 'Trump':  2605
Total comments using 'tacotime(s)' or 'tacotime(s)nw' or 'taco time(s)' or 'taco time(s)nw':  18
Total comments made by an account that has since been deleted: 306
Total comments deleted by user: 2151
Total comments removed by mod: 157

Comment word cloud