R help - Feb 2008 - union of two data frames

I have a thirty thousand row data frame imported from excel and a
60,000 row data frame imported from excel.  they share a common subset
of the same data and I would like to combine the two into one data
frame merged together on the data in common.  I have looked at the
help file for merge and intersect and cbind and rbind etc... And I
can't figure it out.  Thanks in advance

Stephen

-- 
Let's not spend our time and resources thinking about things that are
so little or so large that all they really do for us is puff us up and
make us feel like gods.  We are mammals, and have not exhausted the
annoying little problems of being mammals.

								-K. Mullis

You probably need to provide an example here, show us your data.frame 
column names, and what you mean by 'common subset of the same data' at 
least.  What did you try and what did it do that you didn't expect?

stephen sefick wrote:
> I have a thirty thousand row data frame imported from excel and a
> 60,000 row data frame imported from excel.  they share a common subset
> of the same data and I would like to combine the two into one data
> frame merged together on the data in common.  I have looked at the
> help file for merge and intersect and cbind and rbind etc... And I
> can't figure it out.  Thanks in advance
> 
> Stephen
>

stephen,
are you sure you want a union? in db term, union has a specific meaning.
it seems to me you want a innerjoin, isn't it?
sqldf package is a good one, which will also help you grasp the
knowledge of SQL and complete your request as well.

On Mon, Feb 25, 2008 at 4:59 PM, stephen sefick <ssefick at gmail.com>
wrote:
> I have a thirty thousand row data frame imported from excel and a
>  60,000 row data frame imported from excel.  they share a common subset
>  of the same data and I would like to combine the two into one data
>  frame merged together on the data in common.  I have looked at the
>  help file for merge and intersect and cbind and rbind etc... And I
>  can't figure it out.  Thanks in advance
>
>  Stephen
>
>  --
>  Let's not spend our time and resources thinking about things that are
>  so little or so large that all they really do for us is puff us up and
>  make us feel like gods.  We are mammals, and have not exhausted the
>  annoying little problems of being mammals.
>
>                                                                 -K. Mullis
>
>  ______________________________________________
>  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.
>


-- 
==============================WenSui Liu
ChoicePoint Precision Marketing
Phone: 678-893-9457
Email : wensui.liu at choicepoint.com
Blog   : statcompute.spaces.live.com