[R] matrix transformation into 3 columns II.

[Rado Bonk]

Dear  R-users

Sorry for posting the previous message too soon before I have finished it.

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. Here is the output I would 
like to get get it, number of rows = ncol x nrow. Output should look 
like this:

STATION_NAME1 DATE PRECIP
STATION_NAME1 DATE PRECIP
STATION_NAME1 DATE PRECIP
STATION_NAME1 DATE PRECIP
.
.
.
.
STATION_NAME2 DATE PRECIP
STATION_NAME2 DATE PRECIP
STATION_NAME2 DATE PRECIP
.
.
.
STATION_NAME170 DATE PRECIP
STATION_NAME170 DATE PRECIP
STATION_NAME170 DATE PRECIP
STATION_NAME170 DATE PRECIP
STATION_NAME170 DATE PRECIP


Thanks again for your help.


Rado

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