[R] need help combining two datasets

Adam D. I. Kramer adik at ilovebacon.org
Wed Jan 28 07:21:06 CET 2009


You probably want the merge function.

?merge

--Adam

On Wed, 28 Jan 2009, Somani, Dinesh K wrote:

> Hi
>
> I am a new R user.
>
> I have two CSV files, one with daily stock returns using method A {date,
> stock, returnA, some uninteresting columns}, and another with method B
> {date, stock, returnB, more columns}.  Both have different sets of stocks.
>
> I want to combine the two into a single data table, so that I can run some
> analyses for the overlapping date ranges and stocks.  I know how to do
> this using a database but is there an equivalent way to perform a similar
> kind of join in R?
>
> Data size is small - just a few years worth of daily data.
>
> Would appreciate your help.
>
> Thanks a lot
> Dinesh
>
> ______________________________________________
> 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.
>




More information about the R-help mailing list