Message-ID: <CAAxdm-6gwO4gawkSMd-3Crdx5TzXWH0sdmNcxaG08vskwg-NTw@mail.gmail.com>
Date: 2012-12-05T21:22:55Z
From: jim holtman
Subject: how to assign factor level into each value
In-Reply-To: <DUB116-W61EBC90BEB13389312993B86460@phx.gbl>
?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.