Here is one way, using the reshape package:
library(reshape) Dat <- read.table(textConnection("variable YEAR VAR EC01 2006 100 EC01 2007 200 EC02 2006 500 EC02 2007 450 PROD 2006 567 PROD 2007 543"), header=TRUE) closeAllConnections() c.Dat1 <- as.data.frame(cast(Dat, YEAR ~ variable, value = "VAR")) m.Dat <- melt(c.Dat1, measure.vars = c("EC01", "EC02")) m.Dat$value/m.Dat$PROD -Ista On Tue, Apr 27, 2010 at 8:04 AM, n.via...@libero.it <n.via...@libero.it> wrote: > > Dear list, > > I have a big data frame which looks like this: > variable YEAR VAR > EC01 2006 100 > > EC01 2007 200 > > EC02 2006 500 > > EC02 2007 450 > > PROD 2006 567 > > PROD 2007 543 > > What I would like to do is to divide each variables by PROD,namely: > EC01(2006)/PROD(2006) > EC01(2007)/PROD(2007) > EC02(2006)/PROD(2006) > EC02(2007)/PROD(2007) > Anyone knows how to do it?? > THANKS!!! > > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > 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. > -- Ista Zahn Graduate student University of Rochester Department of Clinical and Social Psychology http://yourpsyche.org ______________________________________________ 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.