Re: [R] Simple but elusive - expand back from counts

From: Peter Alspach <Peter.Alspach_at_plantandfood.co.nz>
Date: Wed, 30 Mar 2011 08:17:49 +1300

Tena koe

Try something like:

tmp[rep(1:nrow(tmp), each=tmp[,4]),] # untested

HTH ... Peter Alspach

> -----Original Message-----
> From: r-help-bounces_at_r-project.org [mailto:r-help-bounces_at_r-
> project.org] On Behalf Of jjap
> Sent: Wednesday, 30 March 2011 7:16 a.m.
> To: r-help_at_r-project.org
> Subject: [R] Simple but elusive - expand back from counts
>
> Dear R-users,
>
> This should be simple but still eludes me:
>
> Given the following
> tmp<-as.data.frame(matrix(c(44, 10, "abc", 1, 44, 10, "def", 1, 44, 12,
> "abc", 2), 3, 4, byrow=T))
>
> I want to expand the data to the following form:
>
> V1 V2 V3 V4
> 1 44 10 abc 1
> 2 44 10 def 1
> 3 44 12 abc 1
> 4 44 12 abc 1
>
> The last row of the original df was duplicated the row by the number in
> the
> 4th column (which could be expendable being all ones)
> I clumsily tried a few variants of a loop but I am not making any
> progress.
> Any hints would be greatly appreciated.
> for (i in 1:3){
> rbind(rep(tmp[i,], temp[i,4])
> }
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Simple-but-
> elusive-expand-back-from-counts-tp3415727p3415727.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.

The contents of this e-mail are confidential and may be subject to legal privilege.  If you are not the intended recipient you must not use, disseminate, distribute or  reproduce all or any part of this e-mail or attachments. If you have received this  e-mail in error, please notify the sender and delete all material pertaining to this  e-mail. Any opinion or views expressed in this e-mail are those of the individual  sender and may not represent those of The New Zealand Institute for Plant and  Food Research Limited.



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. Received on Tue 29 Mar 2011 - 19:27:33 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 29 Mar 2011 - 19:40:25 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive