Synopsis

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

# of posts in  November :  1159
# gold set to posts: 6
Total post score for posts created in  November :  46146
Average post score for posts created in  November :  39.81536
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
        Question  233
      Government  109
         Transit   74
           Crime   72
           Media   70
                   59
      Discussion   58

Total unique post domains:  171
[1] "Domains with highest mean post score and their frequency."
                     domain mean_score freq
                i.giphy.com        610    1
          cdn4.everyjoe.com        564    1
        results.vote.wa.gov        479    1
             oregonlive.com        322    1
                thinkpol.ca        209    1
 business.financialpost.com        173    1
            bigstory.ap.org        143    2
[1] "Domains with highest post frequency and their mean score."
              domain mean_score freq
      self.SeattleWA   22.91102  472
    seattletimes.com   40.73000  100
           imgur.com   93.66667   60
     mynorthwest.com   30.92593   27
        komonews.com   62.45833   24
         i.imgur.com   90.36364   22
 i.reddituploads.com   84.63636   22

Total unique post authors:  558
[1] "Authors with highest mean post score and their frequency."
            author mean_score freq
        tjayrocket        695    1
      CheezRavioli        584    1
 PM_me_m0re_pylons        564    1
       CrunchApple        479    1
            ryanlf        471    1
     strangermouse        411    1
     WestSeattlite        366    1
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
            Seafugee  39.125000  136
           [deleted]  13.532787  122
       AutoModerator   7.419355   31
        AmericanDerp  52.160000   25
            drew1492  65.791667   24
        ChefJoe98136  53.958333   24
 it-is-sandwich-time  29.736842   19

Total unique PSA post authors:  7[1] "PSA Authors with highest mean post score and their frequency."
          author mean_score freq
  Themeatmachine       75.0    1
        drew1492       42.5    2
      NotLurk1ng       39.0    1
           edrea       27.0    1
      ribbitcoin       23.0    1
 princessodactyl       11.0    1
       [deleted]        0.0    1
[1] "PSA Authors with highest post frequency and their mean score."
          author mean_score freq
        drew1492       42.5    2
  Themeatmachine       75.0    1
      NotLurk1ng       39.0    1
           edrea       27.0    1
      ribbitcoin       23.0    1
 princessodactyl       11.0    1
       [deleted]        0.0    1
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                    6  6890
                    8  4050
                    9  3573
                    7  3297
                   12  3289
                   11  3189
                   10  2607
[1] "Total posts created by hour"
 created_pacific_hour freq
                    6   96
                    9   84
                    7   79
                   10   78
                   11   72
                   12   72
                   13   71
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
               Wednesday  9217
                 Tuesday  8528
                  Monday  6625
                Thursday  6043
                  Friday  5255
                Saturday  5241
                  Sunday  5237
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                 Tuesday  228
               Wednesday  221
                  Monday  182
                Thursday  154
                  Friday  154
                Saturday  116
                  Sunday  104
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                Thursday                    6   25
                 Tuesday                    7   23
                 Tuesday                    9   21
               Wednesday                    7   21
                 Tuesday                   10   20
                 Tuesday                   13   19
               Wednesday                    9   19
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    1    0
                  Sunday                    3    0
                  Monday                    4    0
                 Tuesday                    2    0
               Wednesday                    5    0
                Thursday                    2    0
                  Friday                    1    0

Warning: Ignoring unknown parameters: binwidth, bins, pad