[R] Using while statements to insert rows in a dataframe

Dieter Menne dieter.menne at menne-biomed.de
Tue May 19 17:55:27 CEST 2009




Eric McKibben wrote:
> 
> Within column 6 (Question) the numbers 1:33 repeat down the entire column. 
> Occasionally, however, another value (-32767) appears.  I need to locate
> this value everytime it appears and in its place insert 33 rows that are
> numbered 1:33 in column Question.  
> Additionally, I need to maintain the integrity of the other columns so
> that the values at that location in each column are also repeated 33
> times.  So, in the example below, I currently have 68 rows of data, but I
> actually need 132 rows (two -32767 values need to be replaced). 
> 
> Year Month Day Time PartID Question Latency Response
> 2008 2 7 194556 6 1 265 -1
> 2008 2 7 194556 6 2 466 84
> 2008 2 7 194556 6 3 199 68
> ..
> 2008 2 8 122203 6 -32767 0 NA
> 

It's always good to boil down you example to the minimal possible, your
example is too big.
To clarify you point: assuming there are only two questions:

You have:

Question Latency Response
1        265 -1
2        466 84
-32767 0   NA

You need? 

Question Latency Response
1        265 -1
2        466 84
1        265 -1
2        466 84






-- 
View this message in context: http://www.nabble.com/Using-while-statements-to-insert-rows-in-a-dataframe-tp23618849p23619171.html
Sent from the R help mailing list archive at Nabble.com.




More information about the R-help mailing list