how to assign factor level into each value
?cut
x <- read.table(text = " Country Price
+ 1 CN 44.25 + 2 CN 21.07 + 3 CN 92.70 + 4 CN 47.41 + 5 CN 111.67 + 6 CN 50.57", as.is = TRUE, header = TRUE)
x$levels <- cut(x$Price, breaks = c(0,30,50,75,100,150,200,300,400,500,Inf)) x
Country Price levels 1 CN 44.25 (30,50] 2 CN 21.07 (0,30] 3 CN 92.70 (75,100] 4 CN 47.41 (30,50] 5 CN 111.67 (100,150] 6 CN 50.57 (50,75]
On Wed, Dec 5, 2012 at 7:26 AM, Tammy Ma <metal_licaling at live.com> wrote:
HI, All
I met the following problem. I dont know how to handle it.
Country Price
1 CN 44.25
2 CN 21.07
3 CN 92.70
4 CN 47.41
5 CN 111.67
6 CN 50.57
I want to create the 3rd colume with different factor levels:
[1] "0-30" "51-75" "31-50" "76-100" "101-150" "151-200" "201-300" "500+"
[9] "301-400" "401-500"
then the final result which I want is:
Country Price levels
1 CN 44.25 "31-50"
2 CN 21.07 "0-30"
3 CN 92.70 "76-100"
4 CN 47.41 "31-50"
5 CN 111.67 "101-150"
6 CN 50.57 "51-75"
How can I do this?
Thanks.
Tammy
[[alternative HTML version deleted]]
______________________________________________ R-help at 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.
Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it.