Guest User

Untitled

a guest
Nov 24th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. 2015-01-30 1 Fri
  2. 2015-01-30 2 Sat
  3. 2015-02-01 3 Sun
  4. 2015-02-02 1 Mon
  5. 2015-02-03 1 Tue
  6. 2015-02-04 1 Wed
  7. 2015-02-05 1 Thu
  8. 2015-02-06 1 Fri
  9. 2015-02-07 1 Sat
  10. 2015-02-08 1 Sun
  11.  
  12. firstweek 6
  13. secondweek 7
  14.  
  15. data <- as.xts(data$value,order.by=as.Date(data$interval))
  16. weekly <- apply.weekly(data,sum)
  17.  
  18. df <- read.csv(textConnection("2015-01-30, 1, Fri,
  19. 2015-01-30, 2, Sat,
  20. 2015-02-01, 3, Sun,
  21. 2015-02-02, 1, Mon,
  22. 2015-02-03, 1, Tue,
  23. 2015-02-04, 1, Wed,
  24. 2015-02-05, 1, Thu,
  25. 2015-02-06, 1, Fri,
  26. 2015-02-07, 1, Sat,
  27. 2015-02-08, 1, Sun"), header=F, stringsAsFactors=F)
  28. names(df) <- c("date", "something", "day")
  29. df$date <- as.Date(df$date, format="%Y-%m-%d")
  30. df$week <- format(df$date, "%W")
  31. aggregate(df$something, list(df$week), sum)
  32.  
  33. library(plyr) # install.packages("plyr")
  34.  
  35. colnames(m) = c("Date", "count","Day")
  36. start = as.Date("2015-01-26")
  37. m$Week <- floor(unclass(as.Date(m$Date) - as.Date(start)) / 7) + 1
  38. m$Week = as.numeric(m$Week)
  39. m %>% group_by(Week) %>% summarise(count = sum(count))
  40.  
  41. my.df <- read.table(header=FALSE, text=
  42. '2015-01-30 1 Fri
  43. 2015-01-30 2 Sat
  44. 2015-02-01 3 Sun
  45. 2015-02-02 1 Mon
  46. 2015-02-03 1 Tue
  47. 2015-02-04 1 Wed
  48. 2015-02-05 1 Thu
  49. 2015-02-06 1 Fri
  50. 2015-02-07 1 Sat
  51. 2015-02-08 1 Sun')
  52. my.df %>% mutate(week = isoweek(V1)) %>% group_by(week) %>% summarise(sum(V2))
  53.  
  54. my.df %>% group_by(isoweek(V1)) %>% summarise(sum(V2))
Add Comment
Please, Sign In to add comment