[R] reshaping a data frame
John Kane
jrkrideau at inbox.com
Mon Jun 10 15:47:50 CEST 2013
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.vit at gmail.com
> Sent: Sun, 9 Jun 2013 23:15:48 -0700
> To: r-help at 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 at 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!
More information about the R-help
mailing list