[R] how to create duplicated ID in multi-records per subject dataset

markleeds at verizon.net markleeds at verizon.net
Mon Dec 15 03:52:57 CET 2008


  andrew has a point which makes my solution wrong. you'd have to change 
the factors to numerics and I'm not sure what
would happen when you did that. if you want to send a sample file of 
your data, that would be best but andrew's suggestion may
work right off the bat.



On Sun, Dec 14, 2008 at  9:19 PM, andrew wrote:

> if the records are in the file dupIDs.txt, then when you read them in,
> the IDs become factors.  Coercing them to numeric gets them to assign
> a unique number to each factor.
>
> So, you could try the following:
>
> dupIDs <- read.table("dupIDs.txt", header = T)
> dupIDs$ID2 <- cummax(as.numeric(dupIDs$ID)-1)
>
>> dupIDs
>   ID record ID2
> 1  1     20   1
> 2  .     30   1
> 3  .     25   1
> 4  2     26   2
> 5  .     15   2
> 6  3     21   3
>
> HTH,
>
> Andrew.
>
>
> On Dec 15, 12:56 pm, "Zhixin Liu" <z... at efs.mq.edu.au> wrote:
>> Hi R helpers,
>>
>> If I have a dataset looks like:
>> ID   record
>> 1        20
>> .         30
>> .         25
>> 2         26
>> .         15
>> 3         21
>> 4.....................
>>
>> And I want it becomes
>> ID   record
>> 1        20
>> 1        30
>> 1        25
>> 2         26
>> 2        15
>> 3         21
>> 4.....................
>>
>> That is, I have to duplicate IDs for those with multiple records. I 
>> am wondering it is possible to be done in R, and I am grateful if you 
>> would like to show me the direction.
>>
>> Many thanks!
>>
>> Zhixin
>>
>> ______________________________________________
>> R-h... at r-project.org mailing 
>> listhttps://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting 
>> guidehttp://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>
> ______________________________________________
> 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.



More information about the R-help mailing list