[R] matrix transformation into 3 columns

From: Rado Bonk <rado.bonk_at_jrc.it>
Date: Fri 19 May 2006 - 02:26:42 EST


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
Received on Fri May 19 02:46:07 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.