That seems to have solved it.
Thanks Mark.
On 15/11/2007, at 9:57 AM, Marc Schwartz wrote:
>
> On Thu, 2007-11-15 at 09:41 +1100, Andrew Hoskins wrote:
>> Hi,
>>
>> I have a data frame with two columns of data, one an indexing column
>> and the other a data column. My issue is, this data frame is
>> incomplete and there are missing lines. I want to know how I can
>> find and add data into these missing lines. See example below
>>
>> ## Example data
>>
>> data <- data.frame(index=c(1:4,6:10), data=c
>> (1.5,4.3,5.6,6.7,7.1,12.5,14.5,16.8,3.4))
>>
>> index data
>> 1 1 1.5
>> 2 2 4.3
>> 3 3 5.6
>> 4 4 6.7
>> 5 6 7.1
>> 6 7 12.5
>> 7 8 14.5
>> 8 9 16.8
>> 9 10 3.4
>>
>> ## note: index number 5 is missing
>>
>> ## What I want
>>
>> index data
>> 1 1 1.5
>> 2 2 4.3
>> 3 3 5.6
>> 4 4 6.7
>> 5 5 NA
>> 6 6 7.1
>> 7 7 12.5
>> 8 8 14.5
>> 9 9 16.8
>> 10 10 3.4
>>
>> I'm running R2.6.0 on Mac OSX.
>
> How about this:
>
>> DF
> index data
> 1 1 1.5
> 2 2 4.3
> 3 3 5.6
> 4 4 6.7
> 5 6 7.1
> 6 7 12.5
> 7 8 14.5
> 8 9 16.8
> 9 10 3.4
>
>
> DF.NEW <- data.frame(index = seq(max(DF$index)))
>
>> DF.NEW
> index
> 1 1
> 2 2
> 3 3
> 4 4
> 5 5
> 6 6
> 7 7
> 8 8
> 9 9
> 10 10
>
>
> DF.NEW <- merge(DF.NEW, DF, all.x = TRUE)
>
>> DF.NEW
> index data
> 1 1 1.5
> 2 2 4.3
> 3 3 5.6
> 4 4 6.7
> 5 5 NA
> 6 6 7.1
> 7 7 12.5
> 8 8 14.5
> 9 9 16.8
> 10 10 3.4
>
>
> See ?merge for more information.
>
> HTH,
>
> Marc Schwartz
>
Andrew Hoskins
PhD Candidate
Deakin University, Australia
Email: [EMAIL PROTECTED]
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
