Synopsis

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

# of comments in  September :  12684
# gold set to comments: 11
Total comment score for comments in  September :  52970
Average comment score for comments in September :  4.176127
[1] "most frequent commentors, their avg and total score"
              author freq mean_score total_score
           [deleted]  591   1.597293         944
        AmericanDerp  453   7.141280        3235
 it-is-sandwich-time  269   2.345725         631
        ChefJoe98136  249   3.919679         976
              rattus  204   3.529412         720
  my_lucid_nightmare  196   5.250000        1029
       widdershins13  195   2.671795         521

[1] "comments on posts by category"
 link_flair_text mean_count count
            Meta   40.80702  2326
        Question   15.14737  1439
      Government   14.42623   880
           Crime   16.57447   779
         Transit   14.19231   738
       Lifestyle   17.52500   701
        Homeless   19.55172   567
[1] "Total score for the hour a comment is made"
 created_pacific_hour score
                    9  4249
                    8  3840
                   11  3799
                   10  3623
                   15  3621
                   13  3380
                   20  3128
[1] "Total comments created by hour"
 created_pacific_hour freq
                    9  947
                   10  924
                   12  920
                   15  851
                   11  825
                   14  809
                   13  764
[1] "Total score for the weekday a comment is made"
 created_pacific_weekday score
                  Friday 11505
                 Tuesday 10390
               Wednesday  8932
                Thursday  8620
                  Monday  5733
                  Sunday  4772
                Saturday  3018
[1] "Total comments created by weekday"
 created_pacific_weekday freq
               Wednesday 2455
                 Tuesday 2414
                  Friday 2386
                Thursday 2184
                  Monday 1471
                  Sunday 1003
                Saturday  771
[1] "Total comments created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                  Friday                   12  263
               Wednesday                    9  204
                 Tuesday                   10  193
               Wednesday                   11  189
                 Tuesday                    9  184
               Wednesday                   15  177
                Thursday                    9  175
 created_pacific_weekday created_pacific_hour freq
                  Monday                    3    3
                  Sunday                    4    3
                  Monday                    1    4
                  Sunday                    3    4
                  Sunday                    5    4
                Thursday                    3    4
                  Friday                    3    5

Warning: Ignoring unknown parameters: binwidth, bins, pad

Total comments using 'Nimby' or 'Nimbies':  33
Total comments deleted by user: 508
Total comments removed by mod: 36

Comment word cloud