Synopsis

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

# of posts in  August :  191
# gold set to posts: 0
Total post score for posts created in  August :  1238
Average post score for posts created in  August :  6.481675
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
            News   59
          Notice   33
           Event   21
       Lifestyle   19
                   10
           Other    8
      Discussion    6

Total unique post domains:  60
[1] "Domains with highest mean post score and their frequency."
             domain mean_score freq
       wsdot.wa.gov       27.0    1
       komonews.com       17.0    2
  slublockparty.com       17.0    1
      np.reddit.com       16.5    2
       facebook.com       13.0    2
 washingtonpost.com       12.0    1
          king5.com       11.5    2
[1] "Domains with highest post frequency and their mean score."
                 domain mean_score freq
         self.SeattleWA   7.625000   16
          seattlepi.com   4.733333   15
 seattletransitblog.com   6.285714   14
          hosted.ap.org   5.428571   14
        thestranger.com   8.769231   13
               kuow.org  11.363636   11
      seattleweekly.com   6.875000    8

Total unique post authors:  37
[1] "Authors with highest mean post score and their frequency."
       author mean_score freq
   Blutchican       21.0    1
   isiramteal       15.0    1
  istrebitjel       13.0    1
    jdsamford       13.0    1
     IronOhki       12.0    1
 YopparaiNeko       11.8    5
      cliff99       11.0    1
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
 it-is-sandwich-time   6.294118  136
           [deleted]   2.666667    9
        YopparaiNeko  11.800000    5
    SmittenInSeattle   7.333333    3
           Curtineer   9.000000    2
            Edawg444   8.000000    2
             fool217   6.500000    2

No PSA posts for  August
[1] "Total score for the hour a post is made"
 created_pacific_hour score
                    9   421
                    8   233
                   10   172
                   11   124
                   18    41
                   13    38
                   20    34
[1] "Total posts created by hour"
 created_pacific_hour freq
                    9   69
                    8   44
                   10   25
                   11   15
                   18    5
                   20    5
                   12    4
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                  Monday   279
                 Tuesday   240
                  Friday   203
               Wednesday   172
                Saturday   130
                Thursday   128
                  Sunday    86
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                 Tuesday   40
                  Monday   35
               Wednesday   34
                  Friday   30
                Thursday   21
                  Sunday   16
                Saturday   15
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
                  Monday                    9   18
               Wednesday                    8   13
                 Tuesday                   10   12
                  Friday                    8   12
                 Tuesday                    9   11
                Thursday                    9   11
                Saturday                    9   11
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    0    0
                  Sunday                    1    0
                  Sunday                    2    0
                  Sunday                    3    0
                  Sunday                    4    0
                  Sunday                    5    0
                  Sunday                    6    0