Synopsis

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

# of posts in  December :  1117
# gold set to posts: 2
Total post score for posts created in  December :  40962
Average post score for posts created in  December :  36.67144
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
        Question  168
      Government   79
      Discussion   77
            News   76
                   72
           Crime   70
           Media   62

Total unique post domains:  182
[1] "Domains with highest mean post score and their frequency."
        domain mean_score freq
  sbnation.com   230.0000    1
    medium.com   206.0000    1
    flickr.com   175.6667    3
 seattlish.com   175.0000    1
  theonion.com   147.0000    1
    snopes.com   130.0000    1
    gfycat.com   120.0000    1
[1] "Domains with highest post frequency and their mean score."
              domain mean_score freq
      self.SeattleWA   22.70976  379
    seattletimes.com   38.53488  129
           imgur.com   76.93333   45
        komonews.com   51.09302   43
     mynorthwest.com   49.06897   29
         i.imgur.com   77.35714   28
 i.reddituploads.com   61.17391   23

Total unique post authors:  494
[1] "Authors with highest mean post score and their frequency."
              author mean_score freq
       Slippery_John        562    1
   DumbMotherfuckers        425    1
              wahday        420    1
              zipfiz        415    1
 Kindletookawaymyjob        330    1
        Gil-Aegerter        315    1
         Thighrocker        306    1
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
            Seafugee  35.604478  134
           [deleted]  15.643478  115
        ChefJoe98136  42.807018   57
       AutoModerator   7.933333   30
             MAGA_WA  14.538462   26
 it-is-sandwich-time  46.086957   23
            drew1492  46.590909   22

Total unique PSA post authors:  10[1] "PSA Authors with highest mean post score and their frequency."
              author mean_score freq
          seattleeco        130    1
          lumpytrout         93    1
 SeattlePSAReminders         71    1
        Jersey_Girl_         70    1
             tandm13         39    1
              sdyawg         21    1
     Underpowerlines         12    1
[1] "PSA Authors with highest post frequency and their mean score."
              author mean_score freq
          seattleeco        130    1
          lumpytrout         93    1
 SeattlePSAReminders         71    1
        Jersey_Girl_         70    1
             tandm13         39    1
              sdyawg         21    1
     Underpowerlines         12    1
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                    7  3979
                    6  3183
                   10  3020
                    8  2779
                   13  2501
                   12  2437
                   14  2355
[1] "Total posts created by hour"
 created_pacific_hour freq
                    7   86
                   10   84
                   13   70
                   12   67
                    8   65
                    9   63
                   11   62
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                  Friday  7490
                Thursday  7331
                Saturday  6079
               Wednesday  5826
                  Monday  5260
                 Tuesday  5193
                  Sunday  3783
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                  Friday  212
                Thursday  198
               Wednesday  169
                  Monday  149
                 Tuesday  143
                Saturday  131
                  Sunday  115
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
               Wednesday                    7   22
                Thursday                   15   21
                  Friday                   10   20
                  Friday                    7   18
               Wednesday                   11   17
                Thursday                   10   17
                Saturday                   14   17
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    2    0
                  Monday                    5    0
                  Monday                   22    0
                 Tuesday                    3    0
                 Tuesday                    4    0
               Wednesday                    4    0
                Thursday                    4    0

Warning: Ignoring unknown parameters: binwidth, bins, pad