Synopsis

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

# of posts in  October :  1452
# gold set to posts: 4
Total post score for posts created in  October :  56610
Average post score for posts created in  October :  38.9876
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
        Question  233
      Government  110
         Transit   90
           Crime   89
           Media   85
            News   77
                   73

Total unique post domains:  200
[1] "Domains with highest mean post score and their frequency."
              domain mean_score freq
   nwprogressive.org      472.0    1
         imgflip.com      411.0    2
        alternet.org      219.0    1
  m.soundtransit.org      217.0    1
         m.imgur.com      187.5    2
             vox.com      166.0    1
 council.seattle.gov      156.0    1
[1] "Domains with highest post frequency and their mean score."
           domain mean_score freq
   self.SeattleWA   21.58541  562
 seattletimes.com   47.18447  103
        imgur.com   83.76316   76
     komonews.com   53.97368   38
      i.imgur.com   93.10811   37
  thestranger.com   31.88571   35
        king5.com   55.85294   34

Total unique post authors:  692
[1] "Authors with highest mean post score and their frequency."
               author mean_score freq
          ArchGoodwin        683    1
       AmazonDrone_99        635    1
          kris10leigh        588    1
          deauxpamine        498    1
             xosherry        424    1
              jaymzx0        382    1
 JowsephVonSassypantz        369    1
[1] "Authors with highest post frequency and their mean score."
          author mean_score freq
       [deleted]   8.201299  154
        Seafugee  35.477124  153
    AmericanDerp  48.156863   51
 just_add_coffee  83.421053   38
   AutoModerator  14.941176   34
        drew1492  69.478261   23
   hyperviolator  52.500000   20

Total unique PSA post authors:  10[1] "PSA Authors with highest mean post score and their frequency."
        author mean_score freq
  AmericanDerp        190    1
 pheonixblade9        175    1
  ChefJoe98136        117    1
      ManDrone         76    1
       Vodulas         26    1
   strawdawgOG         21    1
    BurdenJack         20    1
[1] "PSA Authors with highest post frequency and their mean score."
        author mean_score freq
  AmericanDerp        190    1
 pheonixblade9        175    1
  ChefJoe98136        117    1
      ManDrone         76    1
       Vodulas         26    1
   strawdawgOG         21    1
    BurdenJack         20    1
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                   11  5213
                    8  4862
                   10  4764
                    6  4325
                   12  4062
                    9  4016
                   13  3886
[1] "Total posts created by hour"
 created_pacific_hour freq
                    9  104
                    8  103
                   11  101
                   10   98
                    6   96
                   13   93
                   12   89
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                Thursday  9653
                  Friday  9580
               Wednesday  8056
                 Tuesday  7969
                Saturday  7877
                  Monday  7692
                  Sunday  5783
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                Thursday  236
                  Friday  227
                 Tuesday  225
               Wednesday  224
                  Monday  208
                Saturday  182
                  Sunday  150
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                Thursday                    8   26
                Thursday                   11   26
                  Monday                    9   22
                 Tuesday                    8   22
                 Tuesday                    9   22
               Wednesday                    6   22
                  Monday                   14   20
 created_pacific_weekday created_pacific_hour freq
                  Monday                    1    0
                  Monday                    2    0
                  Monday                    3    0
                  Monday                    4    0
                 Tuesday                    4    0
               Wednesday                    5    0
                Thursday                    2    0

Warning: Ignoring unknown parameters: binwidth, bins, pad