Synopsis

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

# of posts in  January :  1505
# gold set to posts: 2
Total post score for posts created in  January :  106205
Average post score for posts created in  January :  70.56811
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
        Question  229
      Government  141
           Media  115
            News   93
           Crime   90
      Discussion   87
                   81

Total unique post domains:  211
[1] "Domains with highest mean post score and their frequency."
                          domain mean_score freq
                     twitter.com   1000.818   11
 dougericksen.src.wastateleg.org    516.000    1
                        npca.org    437.000    1
              cdn.discordapp.com    409.000    1
               whaleresearch.com    241.000    1
                      apnews.com    225.000    1
            salsa3.salsalabs.com    222.000    1
[1] "Domains with highest post frequency and their mean score."
              domain mean_score freq
      self.SeattleWA   86.67404  497
    seattletimes.com   33.36905  168
        komonews.com   52.15385   52
           imgur.com  167.67500   40
 i.reddituploads.com   76.67568   37
            kuow.org   34.13514   37
         i.imgur.com  129.05556   36

Total unique post authors:  635
[1] "Authors with highest mean post score and their frequency."
            author mean_score freq
 resetuserpassword   3641.667    3
 the_aluminum_army   3429.000    1
      TheRealGrabo   1068.000    1
      creamcheese0   1059.000    1
      AmericanDerp   1010.031   32
     davidahoffman    611.000    1
[1] "Authors with highest post frequency and their mean score."
        author mean_score freq
      Seafugee   39.79528  127
  ChefJoe98136   35.13514   74
      drew1492   37.89831   59
  AmericanDerp 1010.03125   32
 AutoModerator    9.68750   32
  thedivegrass   62.67742   31

Total unique PSA post authors:  12[1] "PSA Authors with highest mean post score and their frequency."
           author mean_score freq
 terminal_moraine      584.0    1
      Raptorsatan      242.0    1
          Chumkil       65.0    1
         drew1492       41.5    2
        DackelFan       31.0    1
       NotLurk1ng       30.0    1
           billga       20.0    1
[1] "PSA Authors with highest post frequency and their mean score."
           author mean_score freq
         drew1492       41.5    2
 terminal_moraine      584.0    1
      Raptorsatan      242.0    1
          Chumkil       65.0    1
        DackelFan       31.0    1
       NotLurk1ng       30.0    1
           billga       20.0    1
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                   17 32873
                   13 14437
                   14  5808
                   11  5223
                   10  4492
                    9  4188
                    7  4089
[1] "Total posts created by hour"
 created_pacific_hour freq
                   10  107
                   11  102
                    9  100
                   13   97
                   15   96
                   12   95
                   14   86
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                Saturday 41160
               Wednesday 17848
                  Sunday 11016
                  Monday 10510
                 Tuesday 10291
                  Friday  8572
                Thursday  6808
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                 Tuesday  264
                  Monday  246
               Wednesday  222
                  Friday  219
                Thursday  193
                  Sunday  191
                Saturday  170
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                 Tuesday                   15   25
               Wednesday                   10   25
                  Friday                   13   22
                  Monday                   11   20
                 Tuesday                    6   20
               Wednesday                    9   20
                  Monday                    9   19
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    2    0
                  Sunday                    3    0
                  Sunday                    4    0
                  Monday                    1    0
                  Monday                    2    0
                  Monday                    4    0
                 Tuesday                    2    0

Warning: Ignoring unknown parameters: binwidth, bins, pad