Hi all,

I have a data.frame of three columns:
                   partner1 partner2 Substract
1_5000_5001_10000         1     5001      2282.3435
1_5000_10001_15000        1    10001       174.1275
1_5000_15001_20000        1    15001       273.822
1_5000_20001_25000        1    20001       546.27
1_5000_25001_30000        1    25001       701.299
1_5000_30001_35000        1    30001       189.2345
...

I would like to create a new column for this data, but to bin the variable
into separate bin of 0-100, 100-200, 200-300, 300-400, etc.
 so that the new data will look like that
                   partner1 partner2 Substract    binnedData
1_5000_5001_10000         1     5001      2282.3435    2200
1_5000_10001_15000        1    10001       174.1275    100
1_5000_15001_20000        1    15001       273.822     200
1_5000_20001_25000        1    20001       546.27      500
1_5000_25001_30000        1    25001       701.299     700
1_5000_30001_35000        1    30001       189.2345    100
...

Can someone give me a hint how to achieve this conversion?

thanks
Assa

	[[alternative HTML version deleted]]

