Synopsis

This is visualizing data on Posts from the SeattleWA subreddit for the month of May. The data was taken from https://bigquery.cloud.google.com/table/fh-bigquery:reddit_posts.2017_05

# of posts in  May :  2204
# gold set to posts: 4
Total post score for posts created in  May :  70332
Average post score for posts created in  May :  31.91107
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
        Question  291
            News  226
        Politics  163
      Government  162
           Crime  137
           Media  135
                  123

Total unique post domains:  251
[1] "Domains with highest mean post score and their frequency."
                       domain mean_score freq
 ballardhs.seattleschools.org      370.0    1
                 ritholtz.com      314.0    1
                thenation.com      314.0    1
         techtalk.seattle.gov      295.0    1
                      cnn.com      228.5    2
           blog.alaskaair.com      218.0    1
                mercergov.org      217.0    1
[1] "Domains with highest post frequency and their mean score."
           domain mean_score freq
   self.SeattleWA   21.14634  492
 seattletimes.com   29.81948  349
     komonews.com   28.40323  124
        i.redd.it  100.78889   90
        king5.com   28.78889   90
        kiro7.com   32.00000   60
        imgur.com   68.03704   54

Total unique post authors:  684
[1] "Authors with highest mean post score and their frequency."
              author mean_score freq
 1ftinfrntoftheother     1617.5    2
      TheBestSpeller     1469.0    1
            3magdnim     1186.0    1
         _illogical_      797.0    1
        moroccahamed      514.0    1
       SkaankHuunt69      508.0    1
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
     ramona_the_pest  25.761506  717
            Seafugee  25.550000   80
    SeattleRedditBot   7.047619   63
 it-is-sandwich-time  11.193548   62
        ChefJoe98136  37.060000   50
 PoisonousAntagonist  33.545455   33

Total unique PSA post authors:  4 
[1] "PSA Authors with highest mean post score and their frequency."
       author mean_score freq
 GoldenFalcon        121    1
    pickleshy         51    2
       klekje          8    1
    [deleted]          0    2
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                   15  6397
                   10  6285
                    8  5079
                   12  4156
                   19  4094
                   11  4023
                    9  4016
[1] "Total posts created by hour"
 created_pacific_hour freq
                   11  170
                   10  160
                    9  145
                   12  141
                   16  140
                   15  134
                   21  110
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                Thursday 13480
               Wednesday 12155
                 Tuesday 11744
                  Monday 10911
                  Friday  9318
                  Sunday  6627
                Saturday  6097
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                  Monday  386
                 Tuesday  385
               Wednesday  374
                Thursday  361
                  Friday  304
                  Sunday  198
                Saturday  196
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
               Wednesday                   11   39
                  Monday                   10   36
                  Monday                   11   32
               Wednesday                    9   32
                 Tuesday                   12   30
                Thursday                   10   30
                Thursday                   16   30
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    4    0
                  Monday                    3    0
                 Tuesday                    3    0
                  Friday                    4    0
                Saturday                    4    0
                  Sunday                    5    1
                  Sunday                    6    1

Warning: Ignoring unknown parameters: binwidth, bins, pad