[R] matrix transformation into 3 columns

Rado Bonk rado.bonk at jrc.it
Thu May 18 18:26:42 CEST 2006


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




More information about the R-help mailing list