Synopsis

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

# of comments in  March :  45546
# gold set to comments: 21
Total comment score for comments in  March :  205738
Average comment score for comments in March :  4.517147
[1] "most frequent commentors, their avg and total score"
              author freq mean_score total_score
       RainierRancor  942   1.504246        1417
 hellofellowstudents  575   3.387826        1948
  my_lucid_nightmare  550   6.905455        3798
         Potato13579  426   3.213615        1369
       MrsWhatsit-75  409   3.838631        1570
        ChefJoe98136  403   3.679901        1483

[1] "comments on posts by category"
 link_flair_text mean_count count
        Politics   50.69608  5171
        Question   16.56522  3810
      Discussion   57.09677  3540
           Crime   41.28750  3303
      Government   33.14433  3215
         Transit   24.90598  2914
            News   31.48718  2456
[1] "Total score for the hour a comment is made"
 created_pacific_hour score
                   10 17527
                    9 17075
                   12 16413
                   11 16322
                   15 13390
                   14 13333
                   16 12869
[1] "Total comments created by hour"
 created_pacific_hour freq
                   10 3418
                   12 3235
                   11 3233
                    9 3210
                   14 3071
                   13 3036
                   15 2944
[1] "Total score for the weekday a comment is made"
 created_pacific_weekday score
                Thursday 38414
                  Friday 38006
               Wednesday 35222
                  Monday 29247
                 Tuesday 27953
                Saturday 18961
                  Sunday 17935
[1] "Total comments created by weekday"
 created_pacific_weekday freq
                Thursday 8543
               Wednesday 8045
                  Friday 7888
                 Tuesday 6419
                  Monday 6269
                Saturday 4414
                  Sunday 3968
[1] "Total comments created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                Thursday                   10  707
                  Friday                   10  661
                  Friday                    9  661
                Thursday                   11  656
                Thursday                   12  648
                Thursday                    9  632
                Thursday                   13  605
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    3   19
                  Monday                    3   20
                 Tuesday                    4   22
                  Friday                    4   23
                  Sunday                    5   23
                Saturday                    4   24
                Saturday                    5   25

Warning: Ignoring unknown parameters: binwidth, bins, pad

Total comments using 'Nimby' or 'Nimbies':  144
Total comments using 'Trump':  976
Total comments using 'tacotime(s)' or 'tacotime(s)nw' or 'taco time(s)' or 'taco time(s)nw':  210
Total comments made by an account that has since been deleted: 336
Total comments deleted by user: 1868
Total comments removed by mod: 109

Comment word cloud