[R] melt dataframe

arun smartpink111 at yahoo.com
Sun Nov 17 08:25:25 CET 2013

dat1 <- read.csv("precipitationRglimclim.csv",header=TRUE,stringsAsFactors=FALSE,sep="\t")
dat2M <- melt(dat1,id.var=c("year","month","day"))
dat2M1 <- dat2M[with(dat2M,order(year,month,day,variable)),]
#[1] 1972320       5
 row.names(dat2M1) <- 1:nrow(dat2M1)
 colnames(dat2M1)[4:5] <- c("site","rain")

#[1] 1972320


On Saturday, November 16, 2013 11:28 PM, Zilefac Elvis <zilefacelvis at yahoo.com> wrote:

Hello AK,
I would like to melt the attached dataframe (precipitationRglimclim.csv) into a format as in sampleRglimclim.csv.
I tried doing it using the reshape2 package but did not succeed.

Explanation: The daily data is for 120 sites (G1...G120). For each year, there are 12 months and for each month, there are 1...28 or 30 or 31 days.
Melt the dataframe such that each day in a month has 120 values corresponding to the 120 sites.

If you need further explanation let me know.
Thanks so much.

More information about the R-help mailing list