Message-ID: <1350452883.72707.YahooMailNeo@web142602.mail.bf1.yahoo.com>
Date: 2012-10-17T05:48:03Z
From: arun
Subject: frequency table with custom bands
In-Reply-To: <CAAxdm-62=rKk2FYjnB3XgDxoLLvejh2+Xm5z=-DRNmgjFgSgdg@mail.gmail.com>
Hi Jim,
I am gettng the error message that the breaks are not unique: (R 2.15)
table(cut(Prices,breaks=Bands))
Error in cut.default(Prices, breaks = Bands) : 'breaks' are not unique
So, I tried using:
res<-rbind(as.data.frame(table(cut(Prices,breaks=seq1))),as.data.frame(table(cut(Prices,breaks=seq2))))
res2<-apply(res,2,function(x) gsub("\\(|\\]","",gsub("[,]","-",x)))
res3<-within(as.data.frame(res2),{Freq<-as.numeric(Freq)})
head(res3)
#?? Var1 Freq
#1?? 0-5??? 1
#2? 5-10??? 6
#3 10-15??? 2
#4 15-20??? 2
#5 20-25??? 6
#6 25-30??? 2
A.K.
----- Original Message -----
From: jim holtman <jholtman at gmail.com>
To: jcrosbie <james at crosb.ie>
Cc: r-help at r-project.org
Sent: Tuesday, October 16, 2012 8:52 PM
Subject: Re: [R] frequency table with custom bands
?cut
try this:
> seq1 = seq(0, 95, by = 5)
> seq2 = seq(100, 1000, by = 100)
> Bands = c(seq1, seq2)
> Prices = sample(1:1000, 200, replace=F)
> table(cut(Prices, breaks = Bands))
? ? ? (0,5]? ? ? (5,10]? ? (10,15]? ? (15,20]? ? (20,25]
(25,30]? ? (30,35]? ? (35,40]
? ? ? ? ? 1? ? ? ? ? 2? ? ? ? ? 1? ? ? ? ? 1? ? ? ? ? 0
2? ? ? ? ? 1? ? ? ? ? 1
? ? (40,45]? ? (45,50]? ? (50,55]? ? (55,60]? ? (60,65]
(65,70]? ? (70,75]? ? (75,80]
? ? ? ? ? 1? ? ? ? ? 1? ? ? ? ? 1? ? ? ? ? 1? ? ? ? ? 1
1? ? ? ? ? 1? ? ? ? ? 0
? ? (80,85]? ? (85,90]? ? (90,95]? ? (95,100]? (100,200]
(200,300]? (300,400]? (400,500]
? ? ? ? ? 1? ? ? ? ? 2? ? ? ? ? 0? ? ? ? ? 1? ? ? ? ? 22
20? ? ? ? ? 17? ? ? ? ? 22
? (500,600]? (600,700]? (700,800]? (800,900] (900,1e+03]
? ? ? ? 25? ? ? ? ? 20? ? ? ? ? 16? ? ? ? ? 18? ? ? ? ? 20
>
>
>
On Tue, Oct 16, 2012 at 4:37 PM, jcrosbie <james at crosb.ie> wrote:
> I would like to create a frequency table with custom bands.
>
> seq1 = seq(0, 100, by = 5)
> seq2 = seq(100, 1000, by = 100)
> Bands = c(seq1, seq2)
> Prices = sample(1:1000, 200, replace=F)
>
> How would? I go about find the frequency of prices within each band?
>
>
>
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/frequency-table-with-custom-bands-tp4646413.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
______________________________________________
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.