[R] range and intersection

[David Winsemius]

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
> <dwinsemius at 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 at 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