Synopsis

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

# of posts in  Q4 :  3740
# gold set to posts: 12
Total post score for posts created in  Q4 :  143921
Average post score for posts created in  Q4 :  38.48155
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
        Question  637
      Government  299
           Crime  231
         Transit  219
           Media  218
            News  210
                  206

Total unique post domains:  396
[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
   nwprogressive.org        472    1
         imgflip.com        411    2
      oregonlive.com        322    1
        sbnation.com        230    1
[1] "Domains with highest post frequency and their mean score."
           domain mean_score freq
   self.SeattleWA   22.27625 1419
 seattletimes.com   41.87952  332
        imgur.com   85.01648  182
     komonews.com   54.73333  105
  mynorthwest.com   34.36667   90
      i.imgur.com   87.34483   87
        king5.com   43.75000   72

Total unique post authors:  1433
[1] "Authors with highest mean post score and their frequency."
            author mean_score freq
        tjayrocket        695    1
    AmazonDrone_99        635    1
       kris10leigh        588    1
      CheezRavioli        584    1
 PM_me_m0re_pylons        564    1
     Slippery_John        562    1
       CrunchApple        479    1
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
            Seafugee   36.69031  423
           [deleted]   12.03316  392
        AmericanDerp   46.25510   98
       AutoModerator   10.27368   95
        ChefJoe98136   46.26087   92
            drew1492   60.89855   69
 it-is-sandwich-time   35.72414   58

Total unique PSA post authors:  25[1] "PSA Authors with highest mean post score and their frequency."
              author mean_score freq
        AmericanDerp        190    1
       pheonixblade9        175    1
          seattleeco        130    1
          lumpytrout         93    1
            ManDrone         76    1
      Themeatmachine         75    1
 SeattlePSAReminders         71    1
[1] "PSA Authors with highest post frequency and their mean score."
        author mean_score freq
  ChefJoe98136       58.5    2
      drew1492       42.5    2
     [deleted]        0.5    2
  AmericanDerp      190.0    1
 pheonixblade9      175.0    1
    seattleeco      130.0    1
    lumpytrout       93.0    1
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                    6 14398
                    8 11691
                   11 10704
                    7 10463
                   10 10391
                    9  9867
                   12  9788
[1] "Total posts created by hour"
 created_pacific_hour freq
                   10  260
                    6  253
                    9  251
                    7  243
                    8  235
                   11  235
                   13  234
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
               Wednesday 23099
                Thursday 23027
                  Friday 22325
                 Tuesday 21690
                  Monday 19780
                Saturday 19197
                  Sunday 14803
[1] "Total posts created by weekday"
 created_pacific_weekday freq
               Wednesday  614
                 Tuesday  596
                  Friday  593
                Thursday  588
                  Monday  551
                Saturday  429
                  Sunday  369
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
               Wednesday                    7   55
                 Tuesday                    9   52
                  Friday                    7   50
                Thursday                   11   49
                Saturday                    6   48
                Thursday                    8   48
               Wednesday                   10   45
 created_pacific_weekday created_pacific_hour freq
                  Friday                    1    1
                  Friday                    4    1
                Saturday                    3    1
                Saturday                    4    1
                Thursday                    4    1
                 Tuesday                    4    1
                  Monday                    2    2

Warning: Ignoring unknown parameters: binwidth, bins, pad