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.
