[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