Skip to content

Instantly share code, notes, and snippets.

@DrSkippy

DrSkippy/facebookcounts.csv

Created February 8, 2012 16:00
Show Gist options
  • Save DrSkippy/1770649 to your computer and use it in GitHub Desktop.
Save DrSkippy/1770649 to your computer and use it in GitHub Desktop.
Download ZIP
Plot hourly facebook mention volumes for brands/ads/mascots during the superbowl
Raw
facebookcounts.csv
brand date count
Acura and Seinfeld 2012-02-04 23:31:00 6
Acura and Seinfeld 2012-02-05 00:31:00 6
Acura and Seinfeld 2012-02-05 01:31:00 6
Acura and Seinfeld 2012-02-05 02:31:00 6
Acura and Seinfeld 2012-02-05 03:31:00 6
Acura and Seinfeld 2012-02-05 04:31:00 6
Acura and Seinfeld 2012-02-05 05:31:00 15
Acura and Seinfeld 2012-02-05 06:31:00 6
Acura and Seinfeld 2012-02-05 07:31:00 6
Acura and Seinfeld 2012-02-05 08:32:00 6
Acura and Seinfeld 2012-02-05 09:32:00 10
Acura and Seinfeld 2012-02-05 10:32:00 7
Acura and Seinfeld 2012-02-05 11:32:00 12
Acura and Seinfeld 2012-02-05 12:32:00 16
Acura and Seinfeld 2012-02-05 13:32:00 19
Acura and Seinfeld 2012-02-05 14:32:00 16
Acura and Seinfeld 2012-02-05 15:32:00 10
Acura and Seinfeld 2012-02-05 16:32:00 20
Acura and Seinfeld 2012-02-05 17:32:00 19
Acura and Seinfeld 2012-02-05 18:32:00 461
Acura and Seinfeld 2012-02-05 19:32:00 84
Acura and Seinfeld 2012-02-05 20:32:00 2064
Acura and Seinfeld 2012-02-05 21:32:00 636
Audi and Vampires 2012-02-04 23:31:00 5
Audi and Vampires 2012-02-05 00:31:00 5
Audi and Vampires 2012-02-05 01:31:00 5
Audi and Vampires 2012-02-05 02:31:00 5
Audi and Vampires 2012-02-05 03:31:00 5
Audi and Vampires 2012-02-05 04:31:00 5
Audi and Vampires 2012-02-05 05:31:00 5
Audi and Vampires 2012-02-05 06:31:00 5
Audi and Vampires 2012-02-05 07:31:00 5
Audi and Vampires 2012-02-05 08:32:00 6
Audi and Vampires 2012-02-05 09:32:00 11
Audi and Vampires 2012-02-05 10:32:00 6
Audi and Vampires 2012-02-05 11:32:00 6
Audi and Vampires 2012-02-05 12:32:00 9
Audi and Vampires 2012-02-05 13:32:00 14
Audi and Vampires 2012-02-05 14:32:00 10
Audi and Vampires 2012-02-05 15:32:00 8
Audi and Vampires 2012-02-05 16:32:00 9
Audi and Vampires 2012-02-05 17:32:00 13
Audi and Vampires 2012-02-05 18:32:00 1481
Audi and Vampires 2012-02-05 19:32:00 808
Audi and Vampires 2012-02-05 20:32:00 823
Audi and Vampires 2012-02-05 21:32:00 476
Budweiser and Clydesdales 2012-02-04 23:31:00 7
Budweiser and Clydesdales 2012-02-05 00:31:00 9
Budweiser and Clydesdales 2012-02-05 01:31:00 6
Budweiser and Clydesdales 2012-02-05 02:31:00 4
Budweiser and Clydesdales 2012-02-05 03:31:00 4
Budweiser and Clydesdales 2012-02-05 04:31:00 4
Budweiser and Clydesdales 2012-02-05 05:31:00 5
Budweiser and Clydesdales 2012-02-05 06:31:00 8
Budweiser and Clydesdales 2012-02-05 07:31:00 5
Budweiser and Clydesdales 2012-02-05 08:32:00 8
Budweiser and Clydesdales 2012-02-05 09:32:00 30
Budweiser and Clydesdales 2012-02-05 10:32:00 15
Budweiser and Clydesdales 2012-02-05 11:32:00 21
Budweiser and Clydesdales 2012-02-05 12:32:00 22
Budweiser and Clydesdales 2012-02-05 13:32:00 27
Budweiser and Clydesdales 2012-02-05 14:32:00 22
Budweiser and Clydesdales 2012-02-05 15:32:00 28
Budweiser and Clydesdales 2012-02-05 16:32:00 32
Budweiser and Clydesdales 2012-02-05 17:32:00 36
Budweiser and Clydesdales 2012-02-05 18:32:00 590
Budweiser and Clydesdales 2012-02-05 19:32:00 547
Budweiser and Clydesdales 2012-02-05 20:32:00 984
Budweiser and Clydesdales 2012-02-05 21:32:00 163
Coca cola and Polar Bears 2012-02-04 23:31:00 8
Coca cola and Polar Bears 2012-02-05 00:31:00 7
Coca cola and Polar Bears 2012-02-05 01:31:00 8
Coca cola and Polar Bears 2012-02-05 02:31:00 7
Coca cola and Polar Bears 2012-02-05 03:31:00 7
Coca cola and Polar Bears 2012-02-05 04:31:00 7
Coca cola and Polar Bears 2012-02-05 05:31:00 7
Coca cola and Polar Bears 2012-02-05 06:31:00 7
Coca cola and Polar Bears 2012-02-05 07:31:00 7
Coca cola and Polar Bears 2012-02-05 08:32:00 7
Coca cola and Polar Bears 2012-02-05 09:32:00 12
Coca cola and Polar Bears 2012-02-05 10:32:00 8
Coca cola and Polar Bears 2012-02-05 11:32:00 9
Coca cola and Polar Bears 2012-02-05 12:32:00 8
Coca cola and Polar Bears 2012-02-05 13:32:00 10
Coca cola and Polar Bears 2012-02-05 14:32:00 12
Coca cola and Polar Bears 2012-02-05 15:32:00 11
Coca cola and Polar Bears 2012-02-05 16:32:00 12
Coca cola and Polar Bears 2012-02-05 17:32:00 15
Coca cola and Polar Bears 2012-02-05 18:32:00 676
Coca cola and Polar Bears 2012-02-05 19:32:00 652
Coca cola and Polar Bears 2012-02-05 20:32:00 1089
Coca cola and Polar Bears 2012-02-05 21:32:00 3
Doritos 2012-02-04 23:31:00 4
Doritos 2012-02-05 00:31:00 4
Doritos 2012-02-05 01:31:00 4
Doritos 2012-02-05 02:31:00 4
Doritos 2012-02-05 03:31:00 7
Doritos 2012-02-05 04:31:00 5
Doritos 2012-02-05 05:31:00 5
Doritos 2012-02-05 06:31:00 5
Doritos 2012-02-05 07:31:00 5
Doritos 2012-02-05 08:32:00 7
Doritos 2012-02-05 09:32:00 29
Doritos 2012-02-05 10:32:00 15
Doritos 2012-02-05 11:32:00 23
Doritos 2012-02-05 12:32:00 28
Doritos 2012-02-05 13:32:00 27
Doritos 2012-02-05 14:32:00 35
Doritos 2012-02-05 15:32:00 32
Doritos 2012-02-05 16:32:00 44
Doritos 2012-02-05 17:32:00 52
Doritos 2012-02-05 18:32:00 928
Doritos 2012-02-05 19:32:00 1431
Doritos 2012-02-05 20:32:00 1040
Doritos 2012-02-05 21:32:00 2
GoDaddy 2012-02-04 23:31:00 6
GoDaddy 2012-02-05 00:31:00 6
GoDaddy 2012-02-05 01:31:00 6
GoDaddy 2012-02-05 02:31:00 6
GoDaddy 2012-02-05 03:31:00 20
GoDaddy 2012-02-05 04:31:00 6
GoDaddy 2012-02-05 05:31:00 6
GoDaddy 2012-02-05 06:31:00 6
GoDaddy 2012-02-05 07:31:00 8
GoDaddy 2012-02-05 08:32:00 6
GoDaddy 2012-02-05 09:32:00 8
GoDaddy 2012-02-05 10:32:00 9
GoDaddy 2012-02-05 11:32:00 13
GoDaddy 2012-02-05 12:32:00 11
GoDaddy 2012-02-05 13:32:00 14
GoDaddy 2012-02-05 14:32:00 8
GoDaddy 2012-02-05 15:32:00 10
GoDaddy 2012-02-05 16:32:00 12
GoDaddy 2012-02-05 17:32:00 11
GoDaddy 2012-02-05 18:32:00 983
GoDaddy 2012-02-05 19:32:00 171
GoDaddy 2012-02-05 20:32:00 81
GoDaddy 2012-02-05 21:32:00 239
H&M and Beckham 2012-02-04 23:31:00 6
H&M and Beckham 2012-02-05 00:31:00 5
H&M and Beckham 2012-02-05 01:31:00 5
H&M and Beckham 2012-02-05 02:31:00 5
H&M and Beckham 2012-02-05 03:31:00 5
H&M and Beckham 2012-02-05 04:31:00 5
H&M and Beckham 2012-02-05 05:31:00 5
H&M and Beckham 2012-02-05 06:31:00 5
H&M and Beckham 2012-02-05 07:31:00 7
H&M and Beckham 2012-02-05 08:32:00 9
H&M and Beckham 2012-02-05 09:32:00 25
H&M and Beckham 2012-02-05 10:32:00 10
H&M and Beckham 2012-02-05 11:32:00 13
H&M and Beckham 2012-02-05 12:32:00 15
H&M and Beckham 2012-02-05 13:32:00 7
H&M and Beckham 2012-02-05 14:32:00 15
H&M and Beckham 2012-02-05 15:32:00 5
H&M and Beckham 2012-02-05 16:32:00 15
H&M and Beckham 2012-02-05 17:32:00 29
H&M and Beckham 2012-02-05 18:32:00 2710
H&M and Beckham 2012-02-05 19:32:00 3258
H&M and Beckham 2012-02-05 20:32:00 2099
H&M and Beckham 2012-02-05 21:32:00 650
Honda and Bueller, Broderick 2012-02-04 23:31:00 17
Honda and Bueller, Broderick 2012-02-05 00:31:00 8
Honda and Bueller, Broderick 2012-02-05 01:31:00 14
Honda and Bueller, Broderick 2012-02-05 02:31:00 6
Honda and Bueller, Broderick 2012-02-05 03:31:00 6
Honda and Bueller, Broderick 2012-02-05 04:31:00 9
Honda and Bueller, Broderick 2012-02-05 05:31:00 6
Honda and Bueller, Broderick 2012-02-05 06:31:00 6
Honda and Bueller, Broderick 2012-02-05 07:31:00 10
Honda and Bueller, Broderick 2012-02-05 08:32:00 7
Honda and Bueller, Broderick 2012-02-05 09:32:00 48
Honda and Bueller, Broderick 2012-02-05 10:32:00 17
Honda and Bueller, Broderick 2012-02-05 11:32:00 16
Honda and Bueller, Broderick 2012-02-05 12:32:00 19
Honda and Bueller, Broderick 2012-02-05 13:32:00 41
Honda and Bueller, Broderick 2012-02-05 14:32:00 32
Honda and Bueller, Broderick 2012-02-05 15:32:00 28
Honda and Bueller, Broderick 2012-02-05 16:32:00 33
Honda and Bueller, Broderick 2012-02-05 17:32:00 48
Honda and Bueller, Broderick 2012-02-05 18:32:00 931
Honda and Bueller, Broderick 2012-02-05 19:32:00 402
Honda and Bueller, Broderick 2012-02-05 20:32:00 2164
Honda and Bueller, Broderick 2012-02-05 21:32:00 501
Pepsi 2012-02-04 23:31:00 8
Pepsi 2012-02-05 00:31:00 13
Pepsi 2012-02-05 01:31:00 8
Pepsi 2012-02-05 02:31:00 8
Pepsi 2012-02-05 03:31:00 8
Pepsi 2012-02-05 04:31:00 8
Pepsi 2012-02-05 05:31:00 8
Pepsi 2012-02-05 06:31:00 10
Pepsi 2012-02-05 07:31:00 8
Pepsi 2012-02-05 08:32:00 9
Pepsi 2012-02-05 09:32:00 30
Pepsi 2012-02-05 10:32:00 19
Pepsi 2012-02-05 11:32:00 25
Pepsi 2012-02-05 12:32:00 22
Pepsi 2012-02-05 13:32:00 20
Pepsi 2012-02-05 14:32:00 25
Pepsi 2012-02-05 15:32:00 26
Pepsi 2012-02-05 16:32:00 39
Pepsi 2012-02-05 17:32:00 47
Pepsi 2012-02-05 18:32:00 1657
Pepsi 2012-02-05 19:32:00 784
Pepsi 2012-02-05 20:32:00 1265
Pepsi 2012-02-05 21:32:00 39
Raw
plotHourlyVolumes.r
#!/usr/bin/env Rscript
library(ggplot2)
library(gridExtra)
#read data
X <-read.delim("./facebookcounts.csv", sep=",", header=TRUE)
# make dates
X$dates <- as.POSIXct(X$date)
# see some data
X[1:10,]
# stats
summary(X)
# plot facets
p <-ggplot(aes(dates, count), data=X) +
geom_point(shape = 2) +
facet_wrap( ~ brand) +
geom_line(color="red") +
scale_x_datetime(lim = c(as.POSIXct("2012-02-05 14:00:00"),as.POSIXct("2012-02-06 00:00:00")) , major = "1 hours", format = "%H") +
opts(title="Superbowl - Facebook", xlab="Easter Time")
ggsave(file="./facebook.png", width=6, height=6, dpi=100)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment