Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2015-01-30 1 Fri
- 2015-01-30 2 Sat
- 2015-02-01 3 Sun
- 2015-02-02 1 Mon
- 2015-02-03 1 Tue
- 2015-02-04 1 Wed
- 2015-02-05 1 Thu
- 2015-02-06 1 Fri
- 2015-02-07 1 Sat
- 2015-02-08 1 Sun
- firstweek 6
- secondweek 7
- data <- as.xts(data$value,order.by=as.Date(data$interval))
- weekly <- apply.weekly(data,sum)
- df <- read.csv(textConnection("2015-01-30, 1, Fri,
- 2015-01-30, 2, Sat,
- 2015-02-01, 3, Sun,
- 2015-02-02, 1, Mon,
- 2015-02-03, 1, Tue,
- 2015-02-04, 1, Wed,
- 2015-02-05, 1, Thu,
- 2015-02-06, 1, Fri,
- 2015-02-07, 1, Sat,
- 2015-02-08, 1, Sun"), header=F, stringsAsFactors=F)
- names(df) <- c("date", "something", "day")
- df$date <- as.Date(df$date, format="%Y-%m-%d")
- df$week <- format(df$date, "%W")
- aggregate(df$something, list(df$week), sum)
- library(plyr) # install.packages("plyr")
- colnames(m) = c("Date", "count","Day")
- start = as.Date("2015-01-26")
- m$Week <- floor(unclass(as.Date(m$Date) - as.Date(start)) / 7) + 1
- m$Week = as.numeric(m$Week)
- m %>% group_by(Week) %>% summarise(count = sum(count))
- my.df <- read.table(header=FALSE, text=
- '2015-01-30 1 Fri
- 2015-01-30 2 Sat
- 2015-02-01 3 Sun
- 2015-02-02 1 Mon
- 2015-02-03 1 Tue
- 2015-02-04 1 Wed
- 2015-02-05 1 Thu
- 2015-02-06 1 Fri
- 2015-02-07 1 Sat
- 2015-02-08 1 Sun')
- my.df %>% mutate(week = isoweek(V1)) %>% group_by(week) %>% summarise(sum(V2))
- my.df %>% group_by(isoweek(V1)) %>% summarise(sum(V2))
Add Comment
Please, Sign In to add comment