Synopsis

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

# of posts in  July :  221
# gold set to posts: 0
Total post score for posts created in  July :  1489
Average post score for posts created in  July :  6.737557
[1] "Frequency of Categories(link_flair_text) in posts"
 link_flair_text freq
           Help!   50
            News   43
                   22
           Event   18
          Notice   11
           Other   11
           Photo    9

Total unique post domains:  63
[1] "Domains with highest mean post score and their frequency."
                     domain mean_score freq
 photographyisnotacrime.com   18.00000    1
         seattleartfair.com   18.00000    1
                m.imgur.com   17.00000    1
     seattletransitblog.com   16.33333    3
                    flic.kr   16.00000    1
        i.reddituploads.com   16.00000    1
             seattlemet.com   16.00000    1
[1] "Domains with highest post frequency and their mean score."
           domain mean_score freq
   self.SeattleWA   5.510417   96
      youtube.com   5.571429   14
 seattletimes.com   8.500000   10
       reddit.com   3.625000    8
     komonews.com   9.833333    6
     crosscut.com   5.166667    6
        imgur.com   7.600000    5

Total unique post authors:  132
[1] "Authors with highest mean post score and their frequency."
            author mean_score freq
     jordanissport       21.5    2
         Curtineer       18.0    1
        isiramteal       17.0    1
   mylampisawesome       17.0    1
       _Piratical_       16.0    1
 BarbieDreamHearse       16.0    1
      Gil-Aegerter       16.0    1
[1] "Authors with highest post frequency and their mean score."
              author mean_score freq
    SmittenInSeattle   8.571429   28
 it-is-sandwich-time   8.565217   23
           [deleted]   1.882353   17
    charlesgrodinfan   8.083333   12
          ExtraNoise  12.750000    4
        sir_deadlock   8.250000    4
        YopparaiNeko   7.250000    4

[1] "Total score for the hour a post is made"
 created_pacific_hour score
                   15   146
                   19   140
                   20    99
                    9    95
                   14    92
                   11    89
                   10    87
[1] "Total posts created by hour"
 created_pacific_hour freq
                   19   21
                   15   19
                    9   16
                   17   15
                   10   14
                   12   14
                   14   14
[1] "Total score for the weekday a post is made"
 created_pacific_weekday score
                  Friday   291
                Thursday   256
                  Sunday   218
                Saturday   200
                 Tuesday   189
                  Monday   185
               Wednesday   150
[1] "Total posts created by weekday"
 created_pacific_weekday freq
                Thursday   38
                  Friday   34
               Wednesday   33
                  Sunday   32
                 Tuesday   30
                  Monday   29
                Saturday   25
[1] "Total posts created by weekday by hour"
 created_pacific_weekday created_pacific_hour freq
               Wednesday                   19    7
                  Monday                   20    6
                 Tuesday                   12    6
                 Tuesday                   15    6
                Thursday                   15    6
                  Sunday                   18    5
                  Monday                   19    5
 created_pacific_weekday created_pacific_hour freq
                  Sunday                    0    0
                  Sunday                    1    0
                  Sunday                    2    0
                  Sunday                    3    0
                  Sunday                    4    0
                  Sunday                   13    0
                  Sunday                   14    0