Synopsis

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

# of comments in  February :  40513
# gold set to comments: 9
Total comment score for comments in  February :  202625
Average comment score for comments in February :  5.001481
[1] "most frequent commentors, their avg and total score"
              author freq mean_score total_score
       RainierRancor  758 -0.9709763        -736
     Planet_Iscandar  625  5.7792000        3612
        ChefJoe98136  419  4.7971360        2010
 it-is-sandwich-time  390  4.3307692        1689
        AmericanDerp  351 10.5498575        3703
           Cosmo-DNA  336  6.5803571        2211

[1] "comments on posts by category"
 link_flair_text mean_count count
        Politics   51.53378  7627
      Government   57.90816  5675
        Question   19.53540  4415
         Transit   36.23529  3080
            News   42.98361  2622
           Crime   31.26984  1970
      Discussion   36.40000  1820
[1] "Total score for the hour a comment is made"
 created_pacific_hour score
                   13 15333
                   16 15220
                   15 14721
                   10 14413
                   12 14333
                   11 13766
                    9 13394
[1] "Total comments created by hour"
 created_pacific_hour freq
                   12 2695
                   15 2687
                   10 2669
                   11 2642
                   16 2638
                    9 2565
                   14 2546
[1] "Total score for the weekday a comment is made"
 created_pacific_weekday score
                Thursday 43644
                 Tuesday 30712
               Wednesday 30069
                  Monday 30016
                  Friday 28415
                Saturday 22392
                  Sunday 17377
[1] "Total comments created by weekday"
 created_pacific_weekday freq
                Thursday 7234
                  Friday 6317
                 Tuesday 6128
                  Monday 6009
               Wednesday 5893
                Saturday 4796
                  Sunday 4136
[1] "Total comments created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                Thursday                   16  555
                Thursday                   15  542
                Thursday                   10  497
                Thursday                   14  497
                  Friday                   16  477
               Wednesday                   11  474
                  Friday                   15  473
 created_pacific_weekday created_pacific_hour freq
               Wednesday                    3   18
                  Monday                    4   21
                Saturday                    5   25
                Saturday                    4   27
                  Monday                    2   28
                  Monday                    3   29
                 Tuesday                    5   30

Warning: Ignoring unknown parameters: binwidth, bins, pad

Total comments using 'Nimby' or 'Nimbies':  60
Total comments using 'Trump':  1633
Total comments using 'tacotime(s)' or 'tacotime(s)nw' or 'taco time(s)' or 'taco time(s)nw':  106
Total comments made by an account that has since been deleted: 80
Total comments deleted by user: 1838
Total comments removed by mod: 66

Comment word cloud