Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- date CMA0013 CMA0047 CMA0052 CMA0067
- 1975-10-01 0 0.012 0.078 0
- 1975-10-02 0 0.012 0.078 0
- 1975-10-03 0 0.012 0.078 0
- 1975-10-04 0 0.012 0.078 0
- 1975-10-05 0 0.012 0.078 0
- 1975-10-06 0 0.012 0.078 0
- ...
- month year CMA0013 CMA0047 CMA0052 CMA0067
- 10 1975 6 0 0 6
- 11 1975 ...
- df$year <- year(df$date)
- df$month <- month(df$date)
- df2 <- ddply(df,~year+month,summarise,
- count = length(df[df$CMA0010 < 0.001,]))
- library(lubridate) #to extract the year and month
- df$year <- year(df$date)
- df$month <- month(df$date)
- df2 <- aggregate(df[, grep("CMA", names(df))], #just summarise columns starting "CMA"
- by = list(year=df$year, month=df$month),
- function(x) sum(x<0.001))
- df2
- year month CMA0013 CMA0047 CMA0052 CMA0067
- 1 1975 10 6 0 0 6
- sum_df <- daily %>%
- mutate(month = lubridate::month(date),
- year= lubridate::year(date)) %>%
- group_by(year, month) %>%
- summarise(CMA0013 = sum(CMA0013 < 0.001),
- #The rest of you sums...
- )
- library(dplyr)
- library(lubridate)
- library(tidyr)
- d %>%
- gather(key, value, -date) %>%
- mutate(year = year(date), month = month(date)) %>%
- select(-date) %>%
- group_by(year, month, key) %>%
- summarize(N = sum(value < 0.001)) %>%
- spread(key, N)
- # A tibble: 1 x 6
- # Groups: year, month [1]
- year month CMA0013 CMA0047 CMA0052 CMA0067
- * <dbl> <dbl> <int> <int> <int> <int>
- 1 1975 10 6 0 0 6
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement