On Mar 13, 2010, at 11:38 PM, Adrian Johnson wrote:
Hi David,
Sorry. I want to test those lines in file1 match name in file2.
IF File1$Name == File2$Name then:
check if File1$X is in range of File2$(x,y):
Not an adequately specific bit os pseudo code.
if yes:
print File1$Name '\t' File1$X '\t' File2$Name '\t'
File2$X '\t' File2$Y.
So your example only provides three rows that should be considered,
the ones with Name, "UK", right? What do you expect as a result?
Obviously row 3 won't be in any of the ranges, but 199 is in range for
row 2 for file2 and 230 is also in range for row 2 in file2.
Thanks
Adrian
On Sat, Mar 13, 2010 at 11:21 PM, David Winsemius
<dwinsem...@comcast.net> wrote:
On Mar 13, 2010, at 10:14 PM, Adrian Johnson wrote:
Hi:
I have a two large files (over 300K lines).
file 1:
Name X
UK 199
UK 230
UK 139
......
UAE 194
UAE 94
File 2:
Name X Y
UK 140 180
UK 195 240
UK 304 340
....
I haven't figured out what you are expecting. Cannot tell whether
you want
to make this test a) all file1$X within values of "Name" or b) all
file1$X
across all values, or c) to pick a specific line in file1, or d)
file1$X on
a line by line basis in file2. This implements that last of those
three and
has the downside of generating warnings.
file1[file2[, "X"] < file1[, "X"] & file1[, "X"] < file2[,"Y"], ]
Name X
2 UK 230
Warning messages:
1: In file2[, "X"] < file1[, "X"] :
longer object length is not a multiple of shorter object length
2: In file1[, "X"] < file2[, "Y"] :
longer object length is not a multiple of shorter object length
I want to select X of File 1 and search if it falls in range of X
and
Y of File 2 and Print only those lines of File 1 that are in range
of
File 2 X and Y
How can it be done it in R.
thanks
Adrian
______________________________________________
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.
David Winsemius, MD
West Hartford, CT
David Winsemius, MD
West Hartford, CT
______________________________________________
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.
