Synopsis

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

# of comments in  August :  391
# gold set to comments: 0
Total comment score for comments in  August :  835
Average comment score for comments in August :  2.13555
[1] "most frequent commentors, their avg and total score"
              author freq mean_score total_score
 it-is-sandwich-time  129   1.410853         182
          Garden_Dad   19   1.210526          23
        YopparaiNeko   13   2.846154          37
            DustbinK   11   1.818182          20
              rattus   11   1.636364          18
           [deleted]    9   2.111111          19
       widdershins13    8   3.000000          24

[1] "comments on posts by category"
 link_flair_text mean_count count
            News   3.151515   104
       Lifestyle   5.750000    69
            Rant  12.666667    38
            Rave  16.000000    32
          Notice   2.307692    30
           Other   6.750000    27
           Help!   4.750000    19
[1] "Total score for the hour a comment is made"
 created_pacific_hour score
                    9   108
                   17    96
                   11    70
                   10    68
                   14    61
                   16    61
                   12    55
[1] "Total comments created by hour"
 created_pacific_hour freq
                    9   59
                   11   43
                   10   39
                   12   32
                   17   29
                   18   20
                   16   18
[1] "Total score for the weekday a comment is made"
 created_pacific_weekday score
                 Tuesday   217
                  Monday   152
                  Friday   124
               Wednesday   108
                Thursday    96
                Saturday    80
                  Sunday    58
[1] "Total comments created by weekday"
 created_pacific_weekday freq
                  Monday   82
                 Tuesday   73
               Wednesday   68
                  Friday   64
                  Sunday   35
                Saturday   35
                Thursday   34
[1] "Total comments created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                  Monday                    9   18
               Wednesday                   10   15
                  Monday                   11   12
               Wednesday                    9   11
                  Friday                   12   11
                Saturday                    9   11
                 Tuesday                   11    8
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    0    0
                  Sunday                    2    0
                  Sunday                    3    0
                  Sunday                    4    0
                  Sunday                    5    0
                  Sunday                    6    0
                  Sunday                   10    0

Total comments using 'Nimby' or 'Nimbies':  0

Comment word cloud