Hello list I have a problem with a dataset (see toy example below) where I am trying to find the difference between two (or more numbers) and discard those observations which fall outside a set interval.
An example and further explanation: values ind 1 2655 7A5 2 3028 7A5 3 689 ABBA-1 4 1336 ABBA-1 5 1560 ABBA-1 6 2820 ABLIM1 7 3339 ABLIM1 8 171 ACSM5 9 195 ACSM5 10 43 ADAMDEC1 11 129 ADAMDEC1 12 1105 AFF1 13 3202 AFF1 14 852 AFF3 15 2461 AFF3 16 45 AKT1 17 397 AKT1 18 1430 AQP2 19 2402 AQP2 20 2551 ARHGAP19 Each number in the values column above is associated with a label (in the ind column). For some inds there will be only 2 values but as can be seen from the data other inds have many values. Here's what I want to do using the ABBA-1 data from above as an example: calculate the differences between each value: 1560-1336 = 224 1336-689 = 647 then use these values to create an index that will allow me to pull out values between set limits. If I set the limits to between 200 and 300 then the index will reference rows 4 & 5 in the above data set. I hope this is reasonably clear and I appreciate any suggestions. Thanks Iain ______________________________________________ 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.