Synopsis

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

# of posts in  February :  1419
# gold set to posts: 5
Total post score for posts created in  February :  73722
Average post score for posts created in  February :  51.95349
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
        Question  219
        Politics  136
      Government   99
                   94
           Media   89
         Transit   85
           Crime   64

Total unique post domains:  218
[1] "Domains with highest mean post score and their frequency."
            domain mean_score freq
      legiscan.com        864    1
    1077theend.com        748    1
        offnow.org        533    1
        medium.com        513    1
 independent.co.uk        488    1
   bencarson.media        425    1
       reuters.com        352    3
[1] "Domains with highest post frequency and their mean score."
              domain mean_score freq
      self.SeattleWA   17.04936  466
    seattletimes.com   93.63975  161
 i.reddituploads.com   65.40426   47
         i.imgur.com  147.30952   42
           imgur.com  110.61905   42
        komonews.com   47.41463   41
           i.redd.it   98.45714   35

Total unique post authors:  646
[1] "Authors with highest mean post score and their frequency."
          author mean_score freq
         cccCody    1080.00    1
      silverelan     864.00    1
 imjoiningreddit     861.00    1
       badwolf42     707.00    1
  driftingphotog     690.75    8
  pumpkinsunrise     554.00    1
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
            Seafugee  42.660377  106
            drew1492  45.275862   58
        ChefJoe98136  41.836364   55
 it-is-sandwich-time  52.468750   32
       AutoModerator   6.892857   28
         seattleslow  59.083333   24

Total unique PSA post authors:  10 
[1] "PSA Authors with highest mean post score and their frequency."
              author mean_score freq
 DownvotesFromIdiots       56.0    1
          lumpytrout       42.0    1
            ZypherBL       40.0    1
            Joeskyyy       36.5    2
         IFellinLava       27.0    1
        Jersey_Girl_       16.0    2
         ballarddude       14.0    1
[1] "PSA Authors with highest post frequency and their mean score."
              author mean_score freq
           [deleted]   5.333333    3
            Joeskyyy  36.500000    2
        Jersey_Girl_  16.000000    2
 DownvotesFromIdiots  56.000000    1
          lumpytrout  42.000000    1
            ZypherBL  40.000000    1
         IFellinLava  27.000000    1
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                   15 11495
                    9  6811
                   12  5445
                   11  4803
                    8  4091
                    5  4031
                   10  4004
[1] "Total posts created by hour"
 created_pacific_hour freq
                    9  113
                   11  108
                   15   99
                   10   96
                   12   96
                    8   88
                   14   85
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                Thursday 15390
                  Monday 14339
               Wednesday 10356
                  Friday  9820
                 Tuesday  9201
                Saturday  8938
                  Sunday  5678
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                  Monday  286
                 Tuesday  227
                Thursday  222
                  Friday  215
               Wednesday  205
                Saturday  148
                  Sunday  116
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                  Monday                    9   38
                  Monday                   15   28
                Thursday                   11   24
                  Monday                   10   21
                  Monday                   11   21
                 Tuesday                   11   21
                Thursday                   10   20
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    2    0
                  Sunday                    3    0
                  Sunday                    6    0
                  Monday                    3    0
                 Tuesday                    4    0
               Wednesday                    3    0
                Thursday                    1    0

Warning: Ignoring unknown parameters: binwidth, bins, pad