R help - Feb 2009 - split/decompose lines

Dear R users,

I have a very simple problem but I can't find the function in R to deal with
it.

I need to split (or decompose) one line into many lines using one field as a
reference.

I have a table with the following format:

A   B   Frequency
23  3   2
24  2   5
25  1   3

And need to split each line into several lines according to the frequency to
achieve something like this:

 A   B   Frequency
23  3   1
23  3   1
24  2   1
 24  2   1
 24  2   1
 24  2   1
 24  2   1
25  1   1
25  1   1
25  1   1

Thank you very much for your help!


Mafalda

	[[alternative HTML version deleted]]

Mafalda Viana-2 wrote:
> 
> 
> I need to split (or decompose) one line into many lines using one field as
> a
> reference.
> 
> I have a table with the following format:
> 
> A   B   Frequency
> 23  3   2
> 24  2   5
> 25  1   3
> 
> 
olddata[rep(1:nrow(olddata),olddata$B),] 
repeats the rows of the data frame the appropriate number
of times.  The new Frequency column is trivial
(rep(1,sum(olddata$B))

  Ben Bolker

-- 
View this message in context:
http://www.nabble.com/split-decompose-lines-tp22146585p22148058.html
Sent from the R help mailing list archive at Nabble.com.