Adding two files into one and vlookup

raghu wrote:

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?

I think all this can be accomplished with merge.  Can you give reproducible
examples as the posting guide suggests?

Use read.table to read in your data into R objects, then use ?dput to give
us
the exact copies of the objects (probably data.frames by your example), and
what
output you want to have.  Being precise with the classes of objects you're
working with is key, and ?dput is a great way to make sure we have the same
objects as you.

Another tip is common terminology. For instance, `vlookup` is not a term
used in
R, and many people will not know what it means.

This way, everything is reproducible for us, and we can offer suggestions
and
show you what the exact output will be.  In short, making sure everyone is
on
the same page goes a long way when getting help from a mailing list.