need help combining two datasets

Dieter Menne · 2009-01-28T08:05:39Z

Adam D. I. Kramer ilovebacon.org> writes: > > You probably want the merge function. > > ?merge > > On Wed, 28 Jan 2009, Somani, Dinesh K wrote: > > > 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 ove

Dieter Menne

Wed, Jan 28, 2009 12:05 AM

Adam D. I. Kramer <adik <at> ilovebacon.org> writes:

I think the merge function will not do it here, because he has different sets of
stock. I would suggest the following

-- Read in A.CSV and B.CSV into data frames a and b
-- Remove uninteresing columns 
-- a$method = 'a'
-- b$method = 'b'
-- rename column returnA and return B to "return"
-- rbind(a,b)

Dieter

Thread (3 messages)

Somani, Dinesh K need help combining two datasets Jan 27 Adam D. I. Kramer need help combining two datasets Jan 27 Dieter Menne need help combining two datasets Jan 28