Hi,
you might try writing your own function, something like
roundDown <- function(x) floor(x/100)*100
> roundDown(c(2282,174,273,432))
[1] 2200 100 200 400
and than apply it to your column.
Please use ?dput next time to present your data, and post in plain text,
instead of HTML.
best,
daniel
________________________________________
Feladó: r-help-boun...@r-project.org [r-help-boun...@r-project.org] ;
meghatalmazó: Assa Yeroslaviz [fry...@gmail.com]
Küldve: 2014. május 15. 11:54
To: R help forum
Tárgy: [R] bin a vector of continuous variables
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.
______________________________________________
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.
