Re: [R] Merge usage to update data.frame

2010-06-06 Thread Mario Valle
That is! Match, not merge is the solution. Ahhh, memory, memory... Thanks a lot! mario On 07-Jun-10 0:09, jim holtman wrote: try this: a V1 V2 1 AAA 1 2 BBB 2 3 CCC 3 u V1 V2 1 BBB 22 a$V2[match(u$V1, a$V1)]<- u$V2 a V1 V2 1 AAA 1 2 BBB 22 3 CCC 3

Re: [R] Merge usage to update data.frame

2010-06-06 Thread jim holtman
try this: > a V1 V2 1 AAA 1 2 BBB 2 3 CCC 3 > u V1 V2 1 BBB 22 > a$V2[match(u$V1, a$V1)] <- u$V2 > a V1 V2 1 AAA 1 2 BBB 22 3 CCC 3 > On Sun, Jun 6, 2010 at 12:41 PM, Mario Valle wrote: > Good morning! > I have two datasets with the same structure, one containing all my values > a

[R] Merge usage to update data.frame

2010-06-06 Thread Mario Valle
Good morning! I have two datasets with the same structure, one containing all my values and the second one that update same of these values (see example below). I want to create a data.frame with all the values of the first dataset except when an entry is present in the second dataset, in which