Synopsis

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

# of posts in  Q3 :  1431
# gold set to posts: 7
Total post score for posts created in  Q3 :  31125
Average post score for posts created in  Q3 :  21.75052
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
            News  159
          Notice  103
        Question   97
                   90
       Lifestyle   78
      Government   72
           Event   71

Total unique post domains:  229
[1] "Domains with highest mean post score and their frequency."
                   domain mean_score freq
               gfycat.com      252.0    1
                 nasa.gov      210.0    1
               atg.wa.gov      153.0    1
        nwteafestival.com       82.0    1
          historylink.org       81.5    2
 seattlegreekfestival.com       79.0    1
            foxsports.com       78.0    1
[1] "Domains with highest post frequency and their mean score."
              domain mean_score freq
      self.SeattleWA  21.155000  400
    seattletimes.com  22.277108   83
     thestranger.com  16.575758   66
          reddit.com  37.333333   51
 westseattleblog.com  14.348837   43
       seattlepi.com   9.263158   38
        komonews.com  25.351351   37

Total unique post authors:  411
[1] "Authors with highest mean post score and their frequency."
            author mean_score freq
  436172656c657373      550.0    1
           Oculata      443.0    1
         DickDover      368.0    1
 shadow_banned_man      358.5    2
  livedheresince83      300.0    1
           jrandom      292.0    1
    BlaineMaverick      273.0    1
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
 it-is-sandwich-time   7.941358  324
        AmericanDerp  27.141732  127
           [deleted]   6.788991  109
            Seafugee  24.291667   48
          rabidfurby  21.818182   44
       hyperviolator  32.550000   40
    SmittenInSeattle  10.000000   35

Total unique PSA post authors:  2[1] "PSA Authors with highest mean post score and their frequency."
          author mean_score freq
    ChefJoe98136         34    1
 mylampisawesome         17    1
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                    9  2820
                   11  2088
                    8  1916
                    6  1842
                   14  1805
                   15  1801
                   10  1776
[1] "Total posts created by hour"
 created_pacific_hour freq
                    9  195
                    8  140
                   10  138
                    7   87
                   11   82
                   15   70
                   12   67
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                 Tuesday  6104
                Thursday  5950
               Wednesday  5348
                  Friday  4877
                  Monday  4724
                  Sunday  2500
                Saturday  1622
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                 Tuesday  255
               Wednesday  241
                Thursday  235
                  Friday  228
                  Monday  208
                  Sunday  142
                Saturday  122
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
               Wednesday                    8   43
                Thursday                    8   39
                 Tuesday                   10   37
                 Tuesday                    9   35
                  Monday                    9   34
               Wednesday                   10   32
                  Friday                    9   29
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    1    0
                  Sunday                    2    0
                  Sunday                    3    0
                  Sunday                    4    0
                  Monday                    2    0
                  Monday                    3    0
                 Tuesday                    3    0

Warning: Ignoring unknown parameters: binwidth, bins, pad