Synopsis

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

# of posts in  September :  1019
# gold set to posts: 7
Total post score for posts created in  September :  28398
Average post score for posts created in  September :  27.8685
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
        Question   97
      Government   72
            Meta   59
          Notice   59
         Transit   59
                   58
            News   57

Total unique post domains:  179
[1] "Domains with highest mean post score and their frequency."
            domain mean_score freq
        gfycat.com  252.00000    1
          nasa.gov  210.00000    1
        atg.wa.gov  153.00000    1
         imgur.com   88.19231   26
    seattlemag.com   83.50000    2
 nwteafestival.com   82.00000    1
   historylink.org   81.50000    2
[1] "Domains with highest post frequency and their mean score."
              domain mean_score freq
      self.SeattleWA   27.12153  288
    seattletimes.com   24.70423   71
     thestranger.com   19.30612   49
          reddit.com   44.50000   42
 westseattleblog.com   17.60606   33
           king5.com   28.00000   32
        komonews.com   29.13793   29

Total unique post authors:  281
[1] "Authors with highest mean post score and their frequency."
            author mean_score freq
  436172656c657373      550.0    1
           Oculata      443.0    1
        isiramteal      379.5    2
         DickDover      368.0    1
 shadow_banned_man      358.5    2
  livedheresince83      300.0    1
           jrandom      292.0    1
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
 it-is-sandwich-time   9.212121  165
        AmericanDerp  27.141732  127
           [deleted]   8.240964   83
            Seafugee  24.291667   48
          rabidfurby  21.818182   44
       hyperviolator  32.550000   40
              Cadoc7  35.117647   34

[1] "Total score for the hour a post is made"
 created_pacific_hour score
                    9  2304
                   11  1875
                    6  1810
                   14  1691
                   17  1669
                    7  1663
                   21  1655
[1] "Total posts created by hour"
 created_pacific_hour freq
                    9  110
                   10   99
                    8   87
                    7   79
                   11   54
                    6   51
                   12   49
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                 Tuesday  5675
                Thursday  5566
               Wednesday  5026
                  Friday  4383
                  Monday  4260
                  Sunday  2196
                Saturday  1292
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                 Tuesday  185
                Thursday  176
               Wednesday  174
                  Friday  164
                  Monday  144
                  Sunday   94
                Saturday   82
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                Thursday                    8   30
               Wednesday                    8   27
                 Tuesday                   10   24
                  Friday                    7   24
               Wednesday                   10   23
                Thursday                   10   22
                 Tuesday                    9   21
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    1    0
                  Sunday                    2    0
                  Sunday                    3    0
                  Sunday                    4    0
                  Sunday                    5    0
                  Monday                    2    0
                  Monday                    3    0

Warning: Ignoring unknown parameters: binwidth, bins, pad