Dear R family,
I hope you all be doing great. I have a dataset of following format. The data
file is of the following format.
st year month day discharge
1 A 2004 1 1 6.752828
2 A 2004 1 2 7.602053
3 A 2004 1 3 5.583619
4 A 2004 1 4 5.019562
5 A 2004 1 5 4.804489
6 A 2004 1 6 4.363541
7 A 2004 1 7 3.801333
8 A 2004 1 8 3.455991
9 A 2004 1 9 3.402634
10 A 2004 1 10 3.250693
......
......
continue
......
......
st year month day discharge
20000 AY 1967 10 3 0.56
20001 AY 1967 10 4 0.56
20002 AY 1967 10 5 0.48
20003 AY 1967 10 6 0.56
20004 AY 1967 10 7 0.48
20005 AY 1967 10 8 0.40
20006 AY 1967 10 9 0.40
20007 AY 1967 10 10 0.56
20008 AY 1967 10 11 0.56
20009 AY 1967 10 12 0.65
20010 AY 1967 10 13 0.85
you can see that there are five columns.
The first column has the name of the station. I want to split the data w.r.t
the names of the stations. Each station has data for certain years. for example
"A" has data for years from 2004 to 2010 and for "AY" its from 1967 to
2000.similarly for other years there is data for different number of years.
I want to make a list of matrices each containing the data for that station in
the following format
$A
2004 2005 2006 2007 2008 2009 2010
..
...
...
..
...
$AY
1967 1968 .... 2000
each column should have 365 to 366 values depending on whether there is a leap
year or not. obviously for non-leap years 366th row should be an NA.
kindly help me on it.
Thankyou very much in advance.
Eliza
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.