[R] merge
    n.vialma at libero.it 
    n.vialma at libero.it
       
    Mon Apr 19 13:59:43 CEST 2010
    
    
  
I have a problem with the merge function.
I have to merge two big dataframes which  look like the following example.The 
problems is that I get duplicated rows.
CODPROD       N1           N3           N4
23                       3               55                 4
24                       5              67                36
25                      3               73                 24
second data frame
CODPROD                  N1              N2       
30                                   34               45
45                                   0                    78
65                                    0                    56
The result that I get its like:
CODPROD                 N1       N2         N3            N4      N1.1
23                                 3           NA        55            
4             3
24                                 5           NA        67           
36           0
25                                 3           NA        73           
24             0
30                                 34         45          NA           
NA         0
45                                  0          78          NA           
NA           0
65                                  0           56          NA            
NA     .   0
So N1.1 is a duplication of N1.I think I could solve the problems by 
specifying  the same columns but I have a lot of colums which have the same 
names in the two dataframe so I think its not the right way to solve it.
Anyone knows how to avoid duplication??
    
    
More information about the R-help
mailing list