Re: [R] MODE , VARIANCE , NTH PERCENTAILE
On 07/11/2012 05:38 PM, Rantony wrote: Hi, Here i have an matrix like this, ABCPQRXYZ MNO -- --- -- 367 15 2 122415 20 5 1 2 25 50 15 35 i need to get the MODE - for each column-wise VARIANCE - for each column-wise 25TH-PERCENTAILE -for each column-wise i tried alots, and it was difficult to get. Someone can help me out please ? Hi Rantony, Try this: testdat-matrix(c(3,2,20,25,6,12,5,50,7,24,1,15,15,15,2,35),nrow=4) colnames(testdat)-c(ABC,PQR,XYZ,MNO) library(prettyR) # make a function for 25th percentile q25-function(x,na.rm) return(quantile(x,prob=0.25,na.rm=na.rm)) testdesc-describe(testdat,num.desc=c(Mode,var,q25),xname=testdat) print(testdesc) Note that the values in the data frame testdesc are numeric, except for the first column, as there are text messages that no mode exists for columns ABC, PQR and XYZ. When testdesc is printed, it is converted to a matrix, which coerces everything to character type. Jim __ 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] MODE , VARIANCE , NTH PERCENTAILE
Hi Jim, Thanks alots for helping me. Is it possible to get the any percentile without using library? Thanks -Antony. From: Jim Lemon [via R] [mailto:ml-node+s789695n4636272...@n4.nabble.com] Sent: Thursday, July 12, 2012 2:46 PM To: Akkara, Antony (GE Energy, Non-GE) Subject: Re: MODE , VARIANCE , NTH PERCENTAILE On 07/11/2012 05:38 PM, Rantony wrote: Hi, Here i have an matrix like this, ABCPQRXYZ MNO -- --- -- 367 15 2 122415 20 5 1 2 25 50 15 35 i need to get the MODE - for each column-wise VARIANCE - for each column-wise 25TH-PERCENTAILE -for each column-wise i tried alots, and it was difficult to get. Someone can help me out please ? Hi Rantony, Try this: testdat-matrix(c(3,2,20,25,6,12,5,50,7,24,1,15,15,15,2,35),nrow=4) colnames(testdat)-c(ABC,PQR,XYZ,MNO) library(prettyR) # make a function for 25th percentile q25-function(x,na.rm) return(quantile(x,prob=0.25,na.rm=na.rm)) testdesc-describe(testdat,num.desc=c(Mode,var,q25),xname=testdat ) print(testdesc) Note that the values in the data frame testdesc are numeric, except for the first column, as there are text messages that no mode exists for columns ABC, PQR and XYZ. When testdesc is printed, it is converted to a matrix, which coerces everything to character type. Jim __ [hidden email] 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. If you reply to this email, your message will be added to the discussion below: http://r.789695.n4.nabble.com/MODE-VARIANCE-NTH-PERCENTAILE-tp4636112p46 36272.html To unsubscribe from MODE , VARIANCE , NTH PERCENTAILE, click here http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscrib e_by_codenode=4636112code=YW50b255LmFra2FyYUBnZS5jb218NDYzNjExMnwxNTUx OTQzMDI5 . NAML http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_view erid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.Bas icNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.tem plate.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml -instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemai l.naml -- View this message in context: http://r.789695.n4.nabble.com/MODE-VARIANCE-NTH-PERCENTAILE-tp4636112p4636274.html Sent from the R help mailing list archive at Nabble.com. [[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.
[R] MODE , VARIANCE , NTH PERCENTAILE
Hi, Here i have an matrix like this, ABCPQRXYZ MNO -- --- -- 367 15 2 122415 20 5 1 2 25 50 15 35 i need to get the MODE - for each column-wise VARIANCE - for each column-wise 25TH-PERCENTAILE -for each column-wise i tried alots, and it was difficult to get. Someone can help me out please ? - Antony -- View this message in context: http://r.789695.n4.nabble.com/MODE-VARIANCE-NTH-PERCENTAILE-tp4636112.html Sent from the R help mailing list archive at Nabble.com. __ 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] MODE , VARIANCE , NTH PERCENTAILE
Thank you chamilka. From: chamilka [via R] [mailto:ml-node+s789695n4636142...@n4.nabble.com] Sent: Wednesday, July 11, 2012 8:13 PM To: Akkara, Antony (GE Energy, Non-GE) Subject: Re: MODE , VARIANCE , NTH PERCENTAILE Din't you try sapply function? I tried it for you. Just convert your matrix into a data frame using as.data.frame and then rantony ABC PQR XYZ MNO [1,] 3 6 7 15 [2,] 2 12 24 15 [3,] 20 5 1 2 [4,] 25 50 15 35 rantony=as.data.frame(rantony) sapply(rantony,var) #calculates column wise variance ABC PQR XYZ MNO 137.7 457.58333 99.58333 185.58333 sapply(rantony,Mode) #calculates column vise Mode, where the mode function is available in prettyR http://cran.r-project.org/web/packages/prettyR/index.html package ABC PQR XYZ MNO 1 mode 1 mode 1 mode 15 # the above means there are no modes in first three columns and in the last column Mode is 15 sapply(rantony,quantile) ABC PQR XYZ MNO 0%2.00 5.00 1.00 2.00 25% 2.75 5.75 5.50 11.75 50% 11.50 9.00 11.00 15.00 75% 21.25 21.50 17.25 20.00 100% 25.00 50.00 24.00 35.00 If you reply to this email, your message will be added to the discussion below: http://r.789695.n4.nabble.com/MODE-VARIANCE-NTH-PERCENTAILE-tp4636112p46 36142.html To unsubscribe from MODE , VARIANCE , NTH PERCENTAILE, click here http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscrib e_by_codenode=4636112code=YW50b255LmFra2FyYUBnZS5jb218NDYzNjExMnwxNTUx OTQzMDI5 . NAML http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_view erid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.Bas icNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.tem plate.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml -instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemai l.naml -- View this message in context: http://r.789695.n4.nabble.com/MODE-VARIANCE-NTH-PERCENTAILE-tp4636112p4636144.html Sent from the R help mailing list archive at Nabble.com. [[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] MODE , VARIANCE , NTH PERCENTAILE
Din't you try sapply function? I tried it for you. Just convert your matrix into a data frame using as.data.frame and then * rantony* ABC PQR XYZ MNO [1,] 3 6 7 15 [2,] 2 12 24 15 [3,] 20 5 1 2 [4,] 25 50 15 35 * rantony=as.data.frame(rantony)* * sapply(rantony,var)* #calculates column wise variance ABC PQR XYZ MNO 137.7 457.58333 99.58333 185.58333 * sapply(rantony,Mode)* #calculates column vise Mode, where the mode function is available in http://cran.r-project.org/web/packages/prettyR/index.html prettyR package ABC PQR XYZ MNO 1 mode 1 mode 1 mode 15 # the above means there are no modes in first three columns and in the last column Mode is 15 sapply(rantony,quantile) ABC PQR XYZ MNO 0%2.00 5.00 1.00 2.00 25% 2.75 5.75 5.50 11.75 50% 11.50 9.00 11.00 15.00 75% 21.25 21.50 17.25 20.00 100% 25.00 50.00 24.00 35.00 -- View this message in context: http://r.789695.n4.nabble.com/MODE-VARIANCE-NTH-PERCENTAILE-tp4636112p4636142.html Sent from the R help mailing list archive at Nabble.com. __ 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] MODE , VARIANCE , NTH PERCENTAILE
Hi, Just try: dat4-read.table(text= ABC PQR XYZ MNO 3 6 7 15 2 12 24 15 20 5 1 2 25 50 15 35 ,sep=,header=TRUE) apply(dat4,2,quantile) apply(dat4,2,var) #For mode calculation, use package ?modalvalue {rattle} A.K. , - Original Message - From: Rantony antony.akk...@ge.com To: r-help@r-project.org Cc: Sent: Wednesday, July 11, 2012 3:38 AM Subject: [R] MODE , VARIANCE , NTH PERCENTAILE Hi, Here i have an matrix like this, ABC PQR XYZ MNO -- --- -- 3 6 7 15 2 12 24 15 20 5 1 2 25 50 15 35 i need to get the MODE - for each column-wise VARIANCE - for each column-wise 25TH-PERCENTAILE -for each column-wise i tried alots, and it was difficult to get. Someone can help me out please ? - Antony -- View this message in context: http://r.789695.n4.nabble.com/MODE-VARIANCE-NTH-PERCENTAILE-tp4636112.html Sent from the R help mailing list archive at Nabble.com. __ 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. __ 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.