Post - March
czf
May 18, 2017
Synopsis
This is visualizing data on Posts from the SeattleWA subreddit for the month of March. The data was taken from https://bigquery.cloud.google.com/table/fh-bigquery:reddit_posts.2017_03
# of posts in March : 1532# gold set to posts: 7Total post score for posts created in March : 62515Average post score for posts created in March : 40.80614[1] "Frequency of Categories(link_flair_text) in posts" link_flair_text freq
Question 216
Transit 115
113
Politics 96
Government 88
Crime 81
News 76
Total unique post domains: 217[1] "Domains with highest mean post score and their frequency." domain mean_score freq
oregonlive.com 1134 2
theoatmeal.com 532 1
blog.kexp.org 449 1
getorcasmart.com 386 1
static.seattletimes.com 358 1
cbc.ca 239 1
nwprogressive.org 236 1[1] "Domains with highest post frequency and their mean score." domain mean_score freq
self.SeattleWA 17.42205 526
seattletimes.com 54.14650 157
i.redd.it 108.98182 55
komonews.com 42.06667 45
imgur.com 117.72727 44
king5.com 33.45238 42
mynorthwest.com 22.36364 33
Total unique post authors: 695[1] "Authors with highest mean post score and their frequency." author mean_score freq
resetuserpassword 1209.5 2
imjoiningreddit 859.0 1
StudBoi69 827.0 1
notbrakos 775.0 1
derrickito1 762.0 1
whore-chata 541.0 2[1] "Authors with highest post frequency and their mean score." author mean_score freq
Seafugee 46.75630 119
ChefJoe98136 27.65714 70
it-is-sandwich-time 37.81395 43
Planet_Iscandar 44.58333 36
drew1492 33.84848 33
AutoModerator 7.15625 32
Total unique PSA post authors: 7
[1] "PSA Authors with highest mean post score and their frequency."
author mean_score freq
bruceki 165 1
oreosprinkles 69 1
pickleshy 63 1
mmmSouls 32 1
SovietJugernaut 18 1
Sketches_Stuff_Maybe 15 1
[deleted] 0 1
[1] "PSA Authors with highest post frequency and their mean score."
author mean_score freq
bruceki 165 1
oreosprinkles 69 1
pickleshy 63 1
mmmSouls 32 1
SovietJugernaut 18 1
Sketches_Stuff_Maybe 15 1
[deleted] 0 1[1] "Total score for the hour a post is made" created_pacific_hour score
10 6721
9 5152
13 5112
8 4850
15 4738
11 4492
7 4213[1] "Total posts created by hour" created_pacific_hour freq
10 135
9 124
13 119
11 107
14 95
12 91
15 85[1] "Total score for the weekday a post is made" created_pacific_weekday score
Friday 12779
Wednesday 11106
Thursday 11099
Tuesday 8743
Monday 7012
Saturday 6220
Sunday 5556[1] "Total posts created by weekday" created_pacific_weekday freq
Wednesday 309
Thursday 262
Friday 257
Tuesday 216
Monday 206
Sunday 148
Saturday 134[1] "Total posts created by weekday by hour" created_pacific_weekday created_pacific_hour freq
Wednesday 11 34
Wednesday 10 30
Friday 7 29
Wednesday 9 25
Thursday 13 25
Thursday 14 25
Friday 9 25 created_pacific_weekday created_pacific_hour freq
Sunday 2 0
Sunday 4 0
Monday 4 0
Tuesday 3 0
Wednesday 3 0
Wednesday 4 0
Friday 4 0
Warning: Ignoring unknown parameters: binwidth, bins, pad
