Christian Try:
data.frame(data[,1:2], data[,3:5]*data[,2]) Peter Alspach > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Christian Hof > Sent: Thursday, 31 January 2008 7:48 a.m. > To: r-help@r-project.org > Subject: [R] data.frame transformation > > Dear all, > maybe somebody can provide some help for this problem: > > Example: > I've got the following dataframe "data": > > grid.id<-c(1:4) > lat<-c(10,12,13,15) > species1<-c(0,0,0,1) > species2<-c(1,1,0,0) > species3<-c(1,1,1,1) > data<-data.frame(cbind(grid.id,lat,species1,species2,species3)) > > How can I, out of "data" make a new dataframe, where the > cells of value "1" in the species columns ("species1" to > "species3") are replaced by the respective "lat" values > automatically - so that the final dataframe looks like this: > > specieslat1<-c(0,0,0,15) > specieslat2<-c(10,12,0,0) > specieslat3<-c(10,12,13,15) > data.frame(cbind(grid.id,lat,specieslat1,specieslat2,specieslat3)) > > ? > > Thanks a lot, > cheers > Christian > > -- > Christian Hof .. PhD student > Biodiversity & Global Change Lab .. C/José Gutiérrez > Abascal, 2 Museo Nacional de Ciencias Naturales .. E-28006 > Madrid (España) > www.biochange-lab.eu > Center for Macroecology .. University of Copenhagen > www.macroecology.ku.dk > mobile ES .. +34 697 508 519 > mobile DE .. +49 176 205 189 27 > mail .. [EMAIL PROTECTED] > blog .. www.vogelwart.de > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > The contents of this e-mail are privileged and/or confidential to the named recipient and are not to be used by any other person and/or organisation. If you have received this e-mail in error, please notify the sender and delete all material pertaining to this e-mail. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.