Synopsis

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

# of posts in  April :  1613
# gold set to posts: 3
Total post score for posts created in  April :  59284
Average post score for posts created in  April :  36.75387
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
        Question  223
        Politics  120
                   97
           Crime   93
      Government   89
            News   70
         Transit   70

Total unique post domains:  219
[1] "Domains with highest mean post score and their frequency."
                             domain mean_score freq
 seattletimes.us10.list-manage2.com   386.0000    1
                   theintercept.com   323.0000    1
                    bencarson.media   273.3333    3
                         leg.wa.gov   193.0000    1
                           ktvz.com   152.0000    1
                      workingwa.org   151.0000    1
                       theverge.com   146.0000    1
[1] "Domains with highest post frequency and their mean score."
           domain mean_score freq
   self.SeattleWA   16.74667  525
 seattletimes.com   43.47475  198
        i.redd.it   82.46591   88
  thestranger.com   45.83333   60
     komonews.com   53.76596   47
        imgur.com   79.58537   41
        king5.com   26.27500   40

Total unique post authors:  711
[1] "Authors with highest mean post score and their frequency."
          author mean_score freq
   iBlowAtCoding      811.0    1
    MisterMizuta      631.0    1
  InLogicWeTrust      604.0    1
     _rainwalker      546.0    1
 zachtothafuture      492.0    1
     johnnywash1      452.5    2
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
            Seafugee   51.27200  125
     ramona_the_pest   27.77193  114
        ChefJoe98136   33.92647   68
            drew1492   61.04545   44
 it-is-sandwich-time   39.82927   41
       AutoModerator    6.87500   24

Total unique PSA post authors:  6 
[1] "PSA Authors with highest mean post score and their frequency."
              author mean_score freq
          DoctorFork        163    1
           pickleshy        112    1
 RealityIsMyReligion        108    1
             bruceki         51    1
           [deleted]          1    1
         ballarddude          0    1
[1] "PSA Authors with highest post frequency and their mean score."
              author mean_score freq
          DoctorFork        163    1
           pickleshy        112    1
 RealityIsMyReligion        108    1
             bruceki         51    1
           [deleted]          1    1
         ballarddude          0    1
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                    9  6088
                    8  5852
                   13  5024
                   11  4545
                   18  3523
                    7  3430
                    6  3294
[1] "Total posts created by hour"
 created_pacific_hour freq
                   11  135
                    9  119
                    8   96
                   13   94
                   12   93
                   14   93
                   10   92
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                Saturday  9584
                 Tuesday  9246
                Thursday  8873
                  Monday  8623
                  Friday  7859
               Wednesday  7691
                  Sunday  7408
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                Thursday  248
                 Tuesday  247
                  Monday  245
               Wednesday  234
                  Friday  233
                Saturday  214
                  Sunday  192
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                  Monday                    9   22
                Thursday                    9   22
                  Friday                    9   22
                  Friday                   11   22
                  Monday                   16   21
                 Tuesday                   11   21
               Wednesday                   11   21
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    3    0
                  Sunday                    4    0
                  Monday                    4    0
                Thursday                    2    0
                  Friday                    5    0
                Saturday                    4    0
                  Sunday                    5    1

Warning: Ignoring unknown parameters: binwidth, bins, pad