Try this:
aggregate(x["VALUE"], list(substr(x[,"ID"], 1, 1)), sum)
On Thu, Jul 9, 2009 at 7:27 PM, Mark Na <
mtb954@...> wrote:
> Dear R-helpers,
>
> I have two rows in my dataframe:
>
> ID VALUE
> 1A 10
> 1B 15
>
> and I would like to combine these two rows into a single (new) row in my
> dataframe:
>
> ID VALUE
> 1 25
>
> ...simply by specifying a new value for ID and summing the two VALUES.
>
> I have been trying to do this with with rbind, but it's not working.
>
> I'd appreciate any pointers.
>
> Thanks, Mark Na
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
>
R-help@... 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.
>
--
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O
[[alternative HTML version deleted]]
______________________________________________
R-help@... mailing list
https://stat.ethz.ch/mailman/listinfo/r-helpPLEASE do read the posting guide
http://www.R-project.org/posting-guide.htmland provide commented, minimal, self-contained, reproducible code.
