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]] ______________________________________________ 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.