Displaying 1 result from an estimated 1 matches for "file1v3".
Did you mean:
file1,3
2012 Mar 16
1
R merge two dataframes with different row?
...50 55 p1
3 402 449 p2
4 550 650 p3
4 651 660 p4
2 150 250 p5
2 250 350 p6
3 450 499 p7
2 100 250 p8
I hope to have the merged file3 meet the following three criteria:
(1) File1$V1==File2$V1, and
(2) File1V2>=File2$V2, and
(3) File1V3<=File2$V3.
In this case, we can see that there should be four records meet these three
criteria. So the final merge file should looks like:
File1$V1 File1$V2 File1$V3 File1$V4 File2$V1 File2$V2 File2$V3 File2$V4
2 200 201 name2 2 150
250 p5
2...