p********a
发帖数: 5352 | 1 ☆─────────────────────────────────────☆
lwxzt (smallpp) 于 (Sat Dec 2 13:05:04 2006) 提到:
我有两组数据
id position
1 21223
2 31332
3 453267
4 14944
5 3321776
6 7209436
第二组数据是
Gene startposition endposition
FKBP5 20012 78332
CRH 333409 467431
TKC 6121707 7341880
CRHR1 2855 17661
SCLC 2021533 4412210
如果第一组数据中position在第二组数据的startposition和endposition之间，则将相
应的gene与第一组数据合并，结果应该是
id position gene
1 21223 FKBP5
2 31332 FKBP5
3 |
|
H******i
发帖数: 4704 | 2 A-08275-92324 COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION
A-08277-93045 COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION
A-08277-93050 COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION
A-08280-93408 COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION
A-08302-00111 COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION
A-08303-00405 COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION
A-08322-06546 COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION
A-08322-06588 COGNIZANT TECHNOLOGY SOLUTIONS US CORPORAT... 阅读全帖 |
|
|
