john kane jrkrideauyahooca need merge sum separate operation think may rename columns see names wed 8608 rkevinburtoncharternet wrote rkevinburtoncharternet subject r merging two datasets henrique dallazuanna shreyasee pradhan cc rhelprprojectorg received wednesday august 6 2008 1210 pm looked merge df1 df2 dataframes want merge column sum another say df1 df2 dataframes columns id1 id2 id3 qty want merge data frames produce new dataframe matching id2 dataframe sum qty value data fame first dont see function applied merge maybe done separate step next merge seems produce dataframe columns renamed preserve column names thank kevin henrique dallazuanna wrote try using mergedf1 df2 true wed aug 6 2008 1115 shreyasee pradhan wrote facing problem merging two datasets given codes names common datasets also uncommon gave gave following command mergedf1df2 rows columns merged common codes viewed results common codes seen remaining entries seen anyone guide regards merge two datasets completely without loss information thanks shreyasee alternative html version deleted ______________________________________________ rhelprprojectorg mailing list httpsstatethzchmailmanlistinforhelp please read posting guide httpwwwrprojectorgpostingguidehtml provide commented minimal selfcontained reproducible code henrique dallazuanna curitibaparanábrasil 25 25 40 49 16 22 ______________________________________________ rhelprprojectorg mailing list httpsstatethzchmailmanlistinforhelp please read posting guide httpwwwrprojectorgpostingguidehtml provide commented minimal selfcontained reproducible code ______________________________________________ rhelprprojectorg mailing list httpsstatethzchmailmanlistinforhelp please read posting guide httpwwwrprojectorgpostingguidehtml provide commented minimal selfcontained reproducible code __________________________________________________________________ looking perfect gift give gift flickr httpwwwflickrcomgift ______________________________________________ rhelprprojectorg mailing list httpsstatethzchmailmanlistinforhelp please read posting guide httpwwwrprojectorgpostingguidehtml provide commented minimal selfcontained reproducible code wed 06 aug 2008 101229 0700 r merging two datasets