Synopsis

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

# of comments in  October :  34587
# gold set to comments: 13
Total comment score for comments in  October :  156832
Average comment score for comments in October :  4.53442
[1] "most frequent commentors, their avg and total score"
             author freq mean_score total_score
          [deleted] 1765  1.7801700        3142
       AmericanDerp  533  6.2120075        3311
 JohnDanielsWhiskey  493  6.0385396        2977
             ycgfyn  470  0.4297872         202
       ChefJoe98136  358  4.4413408        1590
      MrsWhatsit-75  329  2.2279635         733
             tasdna  317  0.7602524         241

[1] "comments on posts by category"
 link_flair_text mean_count count
        Question   16.89388  4139
         Transit   39.56180  3521
      Government   29.02830  3077
           Crime   34.34483  2988
        Homeless   47.12500  2639
           Other   33.24490  1629
            News   23.50000  1598
[1] "Total score for the hour a comment is made"
 created_pacific_hour score
                   11 12874
                   12 12741
                    8 12137
                    9 11942
                   10 11690
                   13 10517
                   14 10032
[1] "Total comments created by hour"
 created_pacific_hour freq
                   12 2602
                   11 2405
                   13 2383
                   14 2319
                   10 2318
                   16 2271
                   15 2256
[1] "Total score for the weekday a comment is made"
 created_pacific_weekday score
                Thursday 27869
                  Monday 24129
                 Tuesday 23706
                  Friday 23276
               Wednesday 23200
                Saturday 18704
                  Sunday 15948
[1] "Total comments created by weekday"
 created_pacific_weekday freq
                 Tuesday 5601
                Thursday 5398
               Wednesday 5228
                  Monday 5028
                  Friday 5020
                Saturday 4383
                  Sunday 3929
[1] "Total comments created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                Thursday                   12  482
                 Tuesday                   13  452
                 Tuesday                   16  443
                 Tuesday                   15  440
               Wednesday                   12  440
               Wednesday                   13  437
                Thursday                   13  430
 created_pacific_weekday created_pacific_hour freq
                  Monday                    2   12
                Thursday                    3   12
                Thursday                    4   14
                 Tuesday                    4   14
                  Friday                    3   15
                 Tuesday                    2   16
                 Tuesday                    3   16

Warning: Ignoring unknown parameters: binwidth, bins, pad

Total comments using 'Nimby' or 'Nimbies':  79
Total comments deleted by user: 1519
Total comments removed by mod: 35

Comment word cloud