I have called copy number and I have 2 files (I have shared the link of my files ); One contains some ranges
> head(cndata[,c(2,3,4)])
Chromosome Start End
4470 1 51479 817980
4471 1 818499 1136753
4472 1 1138735 2558308
4473 1 2558740 5724264
4474 1 5724940 5749083
4475 1 5749226 12529544
>
https://www.dropbox.com/s/wei3i787c9nrz8q/WTSI-OESO_121_1pre.copynumber.caveman.txt.csv?dl=0
I have another file like below
Chromosome Position
rs62635286 1 51479
rs75454623 1 114930
rs806731 1 30923
https://www.dropbox.com/s/tiqjhkrpfr9d9gu/WTSI-OESO_121_1pre.copynumber.txt?dl=0
In first column I have some SNPs, how I can count the number of SNP in each range? For example based on the second table how many SNP are in range of 51479
to 817980
?