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?? ______________________________________________ R-help@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.
