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

[Mohan L]

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.

Thanks for you time.

Thanks & Rg
Mohan L