SCM

Forum: help

Monitor Forum | Start New Thread Start New Thread
Count within defined range [ Reply ]
By: Lee Smith on 2017-03-10 03:14
[forum:43915]


Hope this makes sense: I am receiving data from colleagues in the form of csv files, each of which can be thousands of lines long. There are multiple columns in these files, but initially the 2 I am interested in are named "target" and "temperature". There are multiple categories for '"target" and within each catergory there can be many (or few) data points for "temperature". For example:

target temperature
RSV 87.2
RSV 86.9
......
HSV 84.3
HSV 89.7

etc

Each target has its own defined temperature range so I need some way of defining these ranges, and then counting the number of samples for each target are within or outside the defined range.

Any and all suggestions gratefully received

Thanks to:
Vienna University of Economics and Business Powered By FusionForge