[R] how to assign factor level into each value
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 CN111.67 6 CN 50.57 I want to create the 3rd colume with different factor levels: [1] 0-3051-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 Pricelevels 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 CN111.67101-150 6 CN 50.57 51-75 How can I do this? Thanks. Tammy [[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.
Re: [R] how to assign factor level into each value
Hi Tammy, Check ?cut and its examples. HTH, Jorge.- On Wed, Dec 5, 2012 at 11:26 PM, Tammy Ma 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 CN111.67 6 CN 50.57 I want to create the 3rd colume with different factor levels: [1] 0-3051-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 Pricelevels 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 CN111.67101-150 6 CN 50.57 51-75 How can I do this? Thanks. Tammy [[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. [[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.
Re: [R] 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 CN111.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 Pricelevels 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_lical...@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 CN111.67 6 CN 50.57 I want to create the 3rd colume with different factor levels: [1] 0-3051-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 Pricelevels 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 CN111.67101-150 6 CN 50.57 51-75 How can I do this? Thanks. Tammy [[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. -- 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. __ 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.