Synopsis

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

# of comments in  November :  35122
# gold set to comments: 12
Total comment score for comments in  November :  172914
Average comment score for comments in November :  4.923239
[1] "most frequent commentors, their avg and total score"
             author freq mean_score total_score
          [deleted] 2438   2.887613        7040
             ycgfyn  680  -1.438235        -978
 JohnDanielsWhiskey  471   3.740977        1762
      RainierRancor  431   1.633411         704
      MrsWhatsit-75  427   4.009368        1712
       ChefJoe98136  394   6.045685        2382
       AmericanDerp  389   8.922879        3471

[1] "comments on posts by category"
 link_flair_text mean_count count
      Government   48.53271  5193
        Question   17.20717  4319
      Discussion   51.61290  3200
         Transit   41.07895  3122
           Crime   34.51389  2485
           Other   40.24561  2294
           Media   25.04762  1578
[1] "Total score for the hour a comment is made"
 created_pacific_hour score
                    8 15359
                    9 15130
                   10 13250
                   11 11790
                   13 11280
                   12 10078
                   14  9652
[1] "Total comments created by hour"
 created_pacific_hour freq
                    9 2533
                   10 2512
                   11 2432
                   13 2315
                   12 2250
                   14 2187
                   15 2111
[1] "Total score for the weekday a comment is made"
 created_pacific_weekday score
               Wednesday 38793
                 Tuesday 30403
                  Monday 26733
                  Friday 22406
                Thursday 22390
                Saturday 16904
                  Sunday 15285
[1] "Total comments created by weekday"
 created_pacific_weekday freq
               Wednesday 7052
                 Tuesday 6253
                  Friday 5251
                Thursday 4954
                  Monday 4862
                Saturday 3735
                  Sunday 3015
[1] "Total comments created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
               Wednesday                   11  517
               Wednesday                    9  503
               Wednesday                   10  494
                 Tuesday                   13  474
                 Tuesday                   10  471
               Wednesday                   12  446
               Wednesday                    8  444
 created_pacific_weekday created_pacific_hour freq
                  Friday                    4   12
                Saturday                    4   15
                  Monday                    3   16
                  Sunday                    3   18
                  Sunday                    4   19
                  Monday                    4   20
                  Monday                    2   24

Warning: Ignoring unknown parameters: binwidth, bins, pad

Total comments using 'Nimby' or 'Nimbies':  69
Total comments using 'Trump':  1806
Total comments deleted by user: 1990
Total comments removed by mod: 16

Comment word cloud