?sort,
?unique, and
subset come to mind.

Clint Bowman                    INTERNET:       cl...@ecy.wa.gov
Air Quality Modeler             INTERNET:       cl...@math.utah.edu
Department of Ecology           VOICE:          (360) 407-6815
PO Box 47600                    FAX:            (360) 407-7534
Olympia, WA 98504-7600

        USPS:           PO Box 47600, Olympia, WA 98504-7600
        Parcels:        300 Desmond Drive, Lacey, WA 98503-1274

On Fri, 13 Jun 2014, eliza botto wrote:


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]]

______________________________________________
R-help@r-project.org 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.


______________________________________________
R-help@r-project.org 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.

Reply via email to