Re: [R] Problem in Binning of a data set

From: Petr PIKAL <petr.pikal_at_precheza.cz>
Date: Thu, 19 Jun 2008 10:03:39 +0200

Hi

"sumit gupta" <sumit.iitm_at_gmail.com> napsal dne 18.06.2008 14:24:28:

> the range of data in all three columns is different. so obviously the
cut
> points are different.
> What I want to do is to create a 3D matrix
>
> Lets say I have the following data
>
> A B C
> 500 5 4000
> 563 4 6540
> 563 4 3456
> 587 2 8000
> . . .
> . . .
> Now I will divide each and every colums in 3 bins
A1,A2,A3,B1,B2,B3,C1,C2,C3
>
> Now I want a matrix like
>
> for
> C1
>
> A1 A2 A3
> B1 a b c
> B2 d e f
> B3 g h i
>
> and create a separate table for each bin( a,b,c,d,e,f,g,h,i) that is
what all
> elements are there in each bin a ,b, c, and so on..
> I hope this clarify the problem.

Not too much. What do you mean by bins? Is it some range of values from respective column? E.g. for A column the A1 bin is from 0 to 570? Then you can use my suggestion to split your whole data to list according to created factor.

And of course you can do it for B and C values too, e.g. with interaction.

split(data, interaction(A.bins, B.bins, C.bins))

shall give you a list of data values which are located in respective bins. If you are not satisfied with my answer, please do as posting guide suggests and provide some toy example which can be reproduced.

Regards
Petr

>
> Thanx
> Regards,
> Sumit
>

> On 6/18/08, Petr PIKAL <petr.pikal_at_precheza.cz> wrote:
> Hi
>
> Well. I am a bit lost in your bins. If I understand correctly you shall
> have some factor with bin values
>
> bin.f <- cut(some data, levels)
>
> then you can split your data according to values of bin.f
>
> split(complete data, bin.f)
>
> If this does not solve your problem just throw it to some other bin :-)

>
> Regards
> Petr
>
> r-help-bounces_at_r-project.org napsal dne 18.06.2008 08:04:50:
>
> > Hello,
> >
> > I am having problem with binning the data. I have a 50X3 matrix and I
> binned
> > the data for all the 3 columns. Using table command I got the total
no.
> of
> > elements in a particular bin.
> > Could you please tell me how to see that what all elements are there
in
> a
> > particular bin and then create a different matrix for each bin?
> >
> > Thanks.
> >
> > Regards,
> > Sumit
> >
> > [[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.

>
>
>
> --
> Sumit Kumar Gupta
> 4thYear ,Biotechnology
> IIT Madras



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. Received on Thu 19 Jun 2008 - 09:02:01 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 19 Jun 2008 - 09:31:03 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive