Tena koe Why is merge() not helpful? From your description I would imagine
merge(file1, file2, by='Date') would do what you require. HTH .... Peter Alspach > -----Original Message----- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r- > project.org] On Behalf Of raghu > Sent: Wednesday, 7 July 2010 10:18 a.m. > To: r-help@r-project.org > Subject: [R] Adding two files into one and vlookup > > > I have two files with dates and prices in each. The number of rows in > each of > them will differ. How do I create a new file which contains data from > both > these files? Cbind and merge are not helpful. For cbind because the > rows are > not the same replication occurs. Also if I have similar data how do I > write > a vlookup kind of function? I am giving an example below: > Say Price1 file contains the following: > Date Price > 2/3/2010 134.00 > 3/3/2010 133.90 > 4/3/2010 135.55 > > And say price2 contains the following: > Date Price > 2/3/2010 2300 > 3/3/2010 3200 > 4/3/2010 1800 > 5/3/2010 1900 > > I want to take both these data together in a single file, and take the > smaller vector (or matrix or dataframe??..i am new to R and still > confused > with the various objects) which is file1 (because it contains fewer > rows ) > and vlookup prices in the second file basedon the dates on file1 and > write > three columns (date, price from 1 and price from2) in a new file. How > do i > do this please? > > Many thanks... > R > -- > View this message in context: http://r.789695.n4.nabble.com/Adding-two- > files-into-one-and-vlookup-tp2280277p2280277.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. ______________________________________________ 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.
