Unless I completely misunderstand what you are doing you don't need to aggregate, just drop the one column and rename things
newtemp <- temp_df[, c(1,3)] names(newtemp) <- c("names", "w") newtemp John Kane Kingston ON Canada > -----Original Message----- > From: abhishek....@gmail.com > Sent: Sun, 9 Jun 2013 23:15:48 -0700 > To: r-help@r-project.org > Subject: [R] reshaping a data frame > > Hi Guys > > I am trying to cast a data frame but not aggregate the rows for the > same variable. > > here is a contrived example. > > **input** > temp_df <- > data.frame(names=c('foo','foo','foo'),variable=c('w','w','w'),value=c(34,65,12)) >> temp_df > names variable value > 1 foo w 34 > 2 foo w 65 > 3 foo w 12 > > > ########### > **Want this** > ############ > names w > foo 34 > foo 65 > foo 12 > > > ## > **getting this*** > ## >> cast(temp_df) > Aggregation requires fun.aggregate: length used as default > names w > 1 foo 3 > > > In real dataset the categorical column 'variable' will have many more > categorical variable. > > Thanks! > -Abhi > > ______________________________________________ > 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. ____________________________________________________________ FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop! ______________________________________________ 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.