Hi
I have a file some thing like below. I want to bin the data. My Bin size is 100.
Code:
items number
HELIX1 75
HELIX6 160
HELIX2 88
HELIX19 114
HELIX5 61
HELIX4 167
it should consider each elemet under the number column and bin all the lines like below with 100 as an interval. The third column should represent the bin range
Code:
bin_75-175.txt
HELIX1 75 75-175
HELIX2 88 75-175
HELIX19 114 75-175
HELIX6 160 75-175
HELIX4 167 75-175
Code:
bin_160-260.txt
HELIX6 160 160-260
HELIX4 167 160-260
Code:
bin_88-188.txt
HELIX2 88 88-188
HELIX19 114 88-188
HELIX6 160 88-188
HELIX4 167 88-188
and so on based on the number of rows in inpit file