Synopsis

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

# of posts in  June :  1870
# gold set to posts: 1
Total post score for posts created in  June :  65641
Average post score for posts created in  June :  35.10214
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
        Question  336
            News  189
      Government  173
           Media  132
       Lifestyle  128
           Crime  116
        Politics  114

Total unique post domains:  219
[1] "Domains with highest mean post score and their frequency."
                         domain mean_score freq
                governor.wa.gov  2461.0000    1
           upload.wikimedia.org   668.0000    1
 kenludwick.files.wordpress.com   476.0000    1
                theguardian.com   438.5000    2
                   linkedin.com   362.0000    1
                    i.imgur.com   329.1786   28
                     gfycat.com   281.0000    1
[1] "Domains with highest post frequency and their mean score."
           domain mean_score freq
   self.SeattleWA   13.14381  452
 seattletimes.com   33.96000  250
     komonews.com   25.24348  115
        i.redd.it   67.32500   80
        king5.com   31.61538   65
        kiro7.com   33.77049   61
         kuow.org   18.64444   45

Total unique post authors:  615
[1] "Authors with highest mean post score and their frequency."
         author mean_score freq
      nocaustic  4584.0000    1
          neur0   981.0000    1
 TheyDidItFirst   836.0000    1
     penecow290   832.3333    3
        Teknull   667.0000    1
      squint_91   614.0000    1
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
     ramona_the_pest  30.020339  295
    SeattleRedditBot   7.836066   61
        ChefJoe98136  27.518519   54
 PoisonousAntagonist  35.529412   51
 it-is-sandwich-time  29.681818   44
            drew1492  42.733333   30

Total unique PSA post authors:  10 
[1] "PSA Authors with highest mean post score and their frequency."
             author mean_score freq
        wiscowonder      138.0    1
         MigosAmigo       77.0    1
         solongmsft       75.0    1
       pipedreamSEA       59.0    1
        run_dog_run       38.0    1
         achillesLS       29.0    1
 Floaty_Mcfloatface       24.5    2
[1] "PSA Authors with highest post frequency and their mean score."
             author mean_score freq
          [deleted]        0.5    4
 Floaty_Mcfloatface       24.5    2
        wiscowonder      138.0    1
         MigosAmigo       77.0    1
         solongmsft       75.0    1
       pipedreamSEA       59.0    1
        run_dog_run       38.0    1
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                   18  7272
                   14  6190
                    8  5078
                    9  4858
                   11  4538
                   10  4403
                   16  4001
[1] "Total posts created by hour"
 created_pacific_hour freq
                   10  133
                   11  131
                    8  130
                   15  123
                    9  121
                   16  112
                   13  104
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                Thursday 12427
                  Sunday 10892
                  Friday  9102
                  Monday  8987
                 Tuesday  8743
               Wednesday  8726
                Saturday  6764
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                Thursday  343
                  Friday  309
                  Monday  303
               Wednesday  273
                 Tuesday  266
                  Sunday  189
                Saturday  187
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                  Friday                   10   35
                Thursday                    7   28
                Thursday                   15   27
               Wednesday                   11   26
                  Friday                   11   25
                  Friday                   16   25
                  Monday                   10   24
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    2    0
                  Sunday                    3    0
                  Sunday                    4    0
                  Sunday                    6    0
                  Monday                    3    0
                 Tuesday                    2    0
                 Tuesday                    3    0

Warning: Ignoring unknown parameters: binwidth, bins, pad