[R] help to merge two data frame if name matches

Uwe Ligges ligges at statistik.tu-dortmund.de
Tue Nov 9 16:32:34 CET 2010



On 09.11.2010 16:17, Mohan L wrote:
> Dear All,
>
> I have two data like this :
>
> $cat main.csv
>
> name,id,memory,storage
> mohan,1,100.20,1.10
> ram,1,200,100
> kumar,1,400,50
> xxx,1,100,40
> aaa,1,800,45
> mount,1,200,80
>
>> main<- read.csv(file='main.csv',sep=',' , header=TRUE)
>> main
>     name    id    memory storage
> 1 mohan   1    100.2      10
> 2   ram      1   200.0     100
> 3 kumar    1   400.0      50
> 4   xxx      1   100.0      40
> 5   aaa      1   800.0      45
> 6 mount    1   200.0      80
>
>
> $cat other.csv
> name,ip,bsent,breceived
> mohan,1,12.00,0.01 	
> xxx,1,00.00,1.110
> kumat,1,1.00,1.00
> mmm,1,10.00,8.08
> own,1,20.13,12.08
> per,1,1.89,0.89
>
>
>> other<- read.csv(file='other.csv',sep=',' , header=TRUE)
>> other
>     name    ip   bsent   breceived
> 1 mohan   1   12.00     0.01
> 2   xxx      1   0.00      1.11
> 3 kumat    1   1.00      1.00
> 4   mmm   1   10.00     8.08
> 5   own      1  20.13     12.08
> 6   per       1  1.89       0.89
>
>
>
> I want to merge ip,bsent,breceived column to "main" , If the name in
> the the "main" data frame is there in the "other" data frame . some
> thinng like this:
>
> name    id  memory   storage  ip       bsent     breceived
>
> mohan    1    100      20         1         12.00     0.01
> ram        1    200      100        0         00.00    0.00
> kumar    1    400      50          1         1.00      1.00
> xxx        1    100      40          1         00.00    1.110
> aaa         1    800      45         0	       00.00    00.00
> mount    1    200      80          0         00.00    00.00
>
>
> If in case the name in the "main" data frame does not there in the
> "other" data frame, simple I want to add zero to ip,bsent,breceived
> value.
>
>
> I hope this can be done with R. Any help will appricated.


See ?merge including its argument all=TRUE.

Uwe Ligges



> Thanks for you time.
>
> Thanks&  Rg
> Mohan L
>
> ______________________________________________
> 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