Lauri Nikkinen wrote:
> Hi R-users,
>
> What is the best way to achieve a table which contains all days and months
> between years 2007-2020? I would like to calculate number of days in each
> month within those years (to data frame).
>
> Regards,
>
> Lauri
How about this?
X <- seq(ISOdate(2007,1,1), ISOdate(2020,12,31), by=60*60*24)
mytab <- table(substring(X, 3, 4), substring(X, 6, 7))
mytab
01 02 03 04 05 06 07 08 09 10 11 12
07 31 28 31 30 31 30 31 31 30 31 30 31
08 31 29 31 30 31 30 31 31 30 31 30 31
09 31 28 31 30 31 30 31 31 30 31 30 31
10 31 28 31 30 31 30 31 31 30 31 30 31
11 31 28 31 30 31 30 31 31 30 31 30 31
12 31 29 31 30 31 30 31 31 30 31 30 31
13 31 28 31 30 31 30 31 31 30 31 30 31
14 31 28 31 30 31 30 31 31 30 31 30 31
15 31 28 31 30 31 30 31 31 30 31 30 31
16 31 29 31 30 31 30 31 31 30 31 30 31
17 31 28 31 30 31 30 31 31 30 31 30 31
18 31 28 31 30 31 30 31 31 30 31 30 31
19 31 28 31 30 31 30 31 31 30 31 30 31
20 31 29 31 30 31 30 31 31 30 31 30 31
head(as.data.frame(mytab))
Var1 Var2 Freq
1 07 01 31
2 08 01 31
3 09 01 31
4 10 01 31
5 11 01 31
6 12 01 31
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
--
Chuck Cleland, Ph.D.
NDRI, Inc.
71 West 23rd Street, 8th floor
New York, NY 10010
tel: (212) 845-4495 (Tu, Th)
tel: (732) 512-0171 (M, W, F)
fax: (917) 438-0894
______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
