Synopsis

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

# of comments in  April :  42909
# gold set to comments: 23
Total comment score for comments in  April :  211047
Average comment score for comments in April :  4.918479
[1] "most frequent commentors, their avg and total score"
              author freq mean_score total_score
 hellofellowstudents  633  4.0094787        2538
        ChefJoe98136  486  5.0288066        2444
       RainierRancor  440  0.5590909         246
     ramona_the_pest  437  4.7002288        2054
             Errk_fu  426  5.8943662        2511
               Kazan  421  4.5106888        1899

[1] "comments on posts by category"
 link_flair_text mean_count count
        Politics   55.04959  6661
        Question   22.37778  5035
           Crime   32.63441  3035
      Discussion   50.85106  2390
     Real Estate   47.59574  2237
      Government   23.38824  1988
         Transit   27.07353  1841
[1] "Total score for the hour a comment is made"
 created_pacific_hour score
                    9 20792
                    8 16567
                   10 16013
                   12 14812
                   11 14748
                   15 12617
                   13 12539
[1] "Total comments created by hour"
 created_pacific_hour freq
                    9 3311
                   10 3159
                   11 3125
                   12 2903
                   13 2736
                   14 2609
                   16 2601
[1] "Total score for the weekday a comment is made"
 created_pacific_weekday score
                Thursday 37886
               Wednesday 34871
                 Tuesday 32742
                  Monday 32532
                  Friday 29088
                Saturday 22137
                  Sunday 21791
[1] "Total comments created by weekday"
 created_pacific_weekday freq
                Thursday 7512
               Wednesday 6967
                 Tuesday 6794
                  Friday 6148
                  Monday 6141
                Saturday 4776
                  Sunday 4571
[1] "Total comments created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                Thursday                    9  630
               Wednesday                    9  602
                Thursday                   11  589
                Thursday                   10  587
                 Tuesday                   10  556
                 Tuesday                   11  552
                Thursday                   16  550
 created_pacific_weekday created_pacific_hour freq
                  Monday                    4   13
                Saturday                    4   14
               Wednesday                    4   14
                  Monday                    3   15
                 Tuesday                    3   17
                  Friday                    4   18
               Wednesday                    2   20

Warning: Ignoring unknown parameters: binwidth, bins, pad

Total comments using 'Nimby' or 'Nimbies':  124
Total comments using 'Trump':  691
Total comments using 'tacotime(s)' or 'tacotime(s)nw' or 'taco time(s)' or 'taco time(s)nw':  89
Total comments made by an account that has since been deleted: 546
Total comments deleted by user: 1758
Total comments removed by mod: 106

Comment word cloud