Synopsis

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

# of comments in  July :  725
# gold set to comments: 0
Total comment score for comments in  July :  1399
Average comment score for comments in July :  1.929655
[1] "most frequent commentors, their avg and total score"
               author freq mean_score total_score
  it-is-sandwich-time   75  2.0266667         152
               rattus   49  1.8979592          93
            [deleted]   31  1.7096774          53
         YopparaiNeko   29  2.5172414          73
             DustbinK   28 -0.4642857         -13
 WantToStopRedditting   26  2.1538462          56
         sir_deadlock   24  1.5833333          38

[1] "comments on posts by category"
 link_flair_text mean_count count
           Help!   5.309524   223
            News   4.833333   116
            Meta  15.000000    75
          Region   7.600000    38
                   2.916667    35
           Event   3.000000    30
          Notice   2.300000    23
[1] "Total score for the hour a comment is made"
 created_pacific_hour score
                   16   122
                   11   121
                   19   108
                   12   101
                   22    79
                   10    76
                   20    76
[1] "Total comments created by hour"
 created_pacific_hour freq
                   11   59
                   12   54
                   16   54
                   19   52
                   20   50
                   15   47
                   21   47
[1] "Total score for the weekday a comment is made"
 created_pacific_weekday score
                  Sunday   300
                Thursday   266
                  Monday   230
                  Friday   212
                Saturday   155
                 Tuesday   133
               Wednesday   103
[1] "Total comments created by weekday"
 created_pacific_weekday freq
                  Monday  136
                Thursday  135
                  Sunday  133
                  Friday   97
                Saturday   84
               Wednesday   75
                 Tuesday   65
[1] "Total comments created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                Thursday                   19   20
                  Friday                   11   19
                  Sunday                   21   18
                  Sunday                   16   16
               Wednesday                   15   15
                  Friday                   12   15
                  Sunday                   15   12
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    1    0
                  Sunday                    2    0
                  Sunday                    3    0
                  Sunday                    4    0
                  Sunday                    5    0
                  Sunday                    6    0
                  Sunday                    7    0

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

Comment word cloud