Re: [R] matrix transformation into 3 columns

From: Dimitrios Rizopoulos <Dimitris.Rizopoulos_at_med.kuleuven.be>
Date: Fri 19 May 2006 - 03:03:34 EST

probably ?reshape() could be used in this case; I hope it helps.

Best,
Dimitris

-- 
Dimitris Rizopoulos
Ph.D. Student
Biostatistical Centre
School of Public Health
Catholic University of Leuven

Address: Kapucijnenvoer 35, Leuven, Belgium
Tel: +32/(0)16/336899
Fax: +32/(0)16/337015
Web: http://med.kuleuven.be/biostat/
     http://www.student.kuleuven.be/~m0390867/dimitris.htm


Quoting Rado Bonk <rado.bonk@jrc.it>:


> Dear R-users,
>
> I have matrix (mprecip) with headers:
>
> > dim(mprecip)
> [1] 6268 170
>
> > mprecip
> date GilzeRijen Eindhoven Volkel ZuidLimburg Arcen
> Ubachsberg
> 1 01/01/1978 NA 0.0 NA 0.1 NA
> NA
> 2 01/02/1978 NA 0.0 NA 0.0 NA
> NA
> 3 01/03/1978 NA 1.9 NA 0.7 NA
> NA
> 4 01/04/1978 NA 3.5 NA 6.9 NA
> 6.0
> 5 01/05/1978 NA 1.6 NA 1.8 NA
> 1.3
> 6 01/06/1978 NA 0.0 NA 0.0 NA
> NA
> 7 01/07/1978 NA 0.0 NA 0.0 NA
> NA
> 8 01/08/1978 NA 0.0 NA 0.0 NA
> NA
>
> Columns are: DATE and PRECIP values for each station listed in the
> header.
>
> I would like to transform the matrix into three columns (database
> like)
> to be able to load the data in the database:
>
> STATION_NAME1 DATE PRECIP
> STATION_NAME1 DATE PRECIP
> STATION_NAME1 DATE PRECIP
> STATION_NAME1 DATE PRECIP
> .
> .
> .
> .
> STATION_NAME2 DATE PRECIP
> STATION_NAME1 DATE PRECIP.
> .
> .
> .
> STATION_NAME3 DATE PRECIP
>
>
>
>
> --
> Dr. Radoslav Bonk
> European Commission - DG Joint Research Centre (JRC)
> Institute of Environment and Sustainability (IES)
> LM Unit - Natural Hazards
> Via E. Fermi, TP 261, 210 20 Ispra (VA), ITALY
> tel: 0039 0332 78 6013
> fax: 0039 0332 78 6653
> http://natural-hazards.jrc.it/floods
>
> ______________________________________________
> 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
>
>
Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm ______________________________________________ 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
Received on Fri May 19 03:08:53 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 19 May 2006 - 04:10:14 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.