Dear Michael , Thank you very much for your reply , kindly please can i send you the program and data please , y is shown a normal csv file no issue with it :( Kind Regards On Tue, Sep 1, 2015 at 8:36 AM, Michael Dewey-3 [via R] < ml-node+s789695n4711707h94 at n4.nabble.com> wrote:> Dear Shawin > > You probably did not get an answer because > 1 - you seem to have posted in HTML which mangled your post into > unreadability > 2 - there seem to be lots of lines which do not do anything germane to > the problem. > > Why not try summary(y) or str(y) before you convert it to a matrix and > see what it says? > > On 31/08/2015 20:46, shawin wrote: > > > I have an issue ans i posted it , so i would like to receive a solution > > please > > > > On Mon, Aug 31, 2015 at 8:35 PM, shawin [via R] < > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=0>> > wrote: > > > >> I have a data frame csv file and I'm trying to calculate median for > each > >> group separately row by row . When I separate the data frame in two > groups > >> and calculate the median for each one, I am getting an NA result for > the > >> second group : > >> the data > >> x1 x2 x3 x4 x5 x6 x7 y1 y2 y3 y4 y5 y6 y7 y8 > >> 9.488404158 9.470895414 9.282433728 9.366707445 9.955383045 9.640816474 > >> 9.606262272 9.329651027 9.434541611 9.473922432 9.311412966 9.3154885 > >> 9.434977488 9.470895414 9.764258059 > >> 8.630629966 8.55831075 8.788391003 8.576231135 8.671587906 8.842979993 > >> 8.861958856 8.58330436 8.603596508 8.570129609 8.59798922 8.572686772 > >> 8.679751791 8.663950953 8.432875347 > >> 9.354748885 9.367668838 9.259952558 9.421538213 9.554635162 9.603744578 > >> 9.452197983 9.284228877 9.404607878 9.317737979 9.343115301 9.310644266 > >> 9.27227486 9.360337823 9.44706281 > >> 9.944863964 9.950427516 10.19101759 10.07350804 10.03269879 10.1307908 > >> 10.03487287 9.74609383 9.886379007 9.775472567 10.036596 > 9.544738458 > >> 9.699611598 9.911962567 > >> 9.625804277 > >> > >> > >> Code: > >> > >> rowN <- nrow(AT1) > >> MD1<-vector(length=rowN) > >> MD2<-vector(length=rowN) > >> > >> MD1[1:rowN]<-NA > >> MD2[1:rowN]<-NA > >> > >> > >> x<- AT1[,c(2,3,4,5,6,7,8) ] > >> write.csv(x,"x.csv",row.names=TRUE) > >> x<-as.matrix(x) > >> for(i in 2:rowN) { > >> MD1[i]=median(x[i,]) > >> } > >> write.csv(MD1,"MD1.csv",row.names=TRUE) > >> > >> y<- AT1[,c(9,10,11,12,13,14,15,16)] > >> write.csv(y,"y.csv",row.names=TRUE) > >> y<-as.matrix(y) > >> for(j in 2:rowN) { > >> MD2[j]=median(y[j,]) > >> } > >> write.csv(MD2,"MD2.csv",row.names=TRUE) > >> > >> > >> ------------------------------ > >> If you reply to this email, your message will be added to the > discussion > >> below: > >> > >> > http://r.789695.n4.nabble.com/Median-on-second-group-of-CSV-file-produce-Na-tp4711689.html > >> To start a new topic under R help, email > >> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=1> > >> To unsubscribe from R, click here > >> < > >> . > >> NAML > >> < > http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > > >> > > > > > > > > > > -- > > View this message in context: > http://r.789695.n4.nabble.com/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711690.html > > Sent from the R help mailing list archive at Nabble.com. > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=2> > mailing list -- To UNSUBSCRIBE and more, see > > 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. > > > > -- > Michael > http://www.dewey.myzen.co.uk/home.html > > ______________________________________________ > [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=3> > mailing list -- To UNSUBSCRIBE and more, see > 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/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711707.html > To start a new topic under R help, email > ml-node+s789695n789696h53 at n4.nabble.com > To unsubscribe from R, click here > <http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=789695&code=bmF2aW5nMnVrQGdtYWlsLmNvbXw3ODk2OTV8LTczNzQxMTY0Ng==> > . > NAML > <http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> >-- View this message in context: http://r.789695.n4.nabble.com/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711709.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]]
What happened when you did summary(y) or str(y)? On 01/09/2015 08:57, Navien wrote:> Dear Michael , > > Thank you very much for your reply , kindly please can i send you the > program and data please , y is shown a normal csv file no issue with it :( > > > Kind Regards > > On Tue, Sep 1, 2015 at 8:36 AM, Michael Dewey-3 [via R] < > ml-node+s789695n4711707h94 at n4.nabble.com> wrote: > >> Dear Shawin >> >> You probably did not get an answer because >> 1 - you seem to have posted in HTML which mangled your post into >> unreadability >> 2 - there seem to be lots of lines which do not do anything germane to >> the problem. >> >> Why not try summary(y) or str(y) before you convert it to a matrix and >> see what it says? >> >> On 31/08/2015 20:46, shawin wrote: >> >>> I have an issue ans i posted it , so i would like to receive a solution >>> please >>> >>> On Mon, Aug 31, 2015 at 8:35 PM, shawin [via R] < >>> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=0>> >> wrote: >>> >>>> I have a data frame csv file and I'm trying to calculate median for >> each >>>> group separately row by row . When I separate the data frame in two >> groups >>>> and calculate the median for each one, I am getting an NA result for >> the >>>> second group : >>>> the data >>>> x1 x2 x3 x4 x5 x6 x7 y1 y2 y3 y4 y5 y6 y7 y8 >>>> 9.488404158 9.470895414 9.282433728 9.366707445 9.955383045 9.640816474 >>>> 9.606262272 9.329651027 9.434541611 9.473922432 9.311412966 9.3154885 >>>> 9.434977488 9.470895414 9.764258059 >>>> 8.630629966 8.55831075 8.788391003 8.576231135 8.671587906 8.842979993 >>>> 8.861958856 8.58330436 8.603596508 8.570129609 8.59798922 8.572686772 >>>> 8.679751791 8.663950953 8.432875347 >>>> 9.354748885 9.367668838 9.259952558 9.421538213 9.554635162 9.603744578 >>>> 9.452197983 9.284228877 9.404607878 9.317737979 9.343115301 9.310644266 >>>> 9.27227486 9.360337823 9.44706281 >>>> 9.944863964 9.950427516 10.19101759 10.07350804 10.03269879 10.1307908 >>>> 10.03487287 9.74609383 9.886379007 9.775472567 10.036596 >> 9.544738458 >>>> 9.699611598 9.911962567 >>>> 9.625804277 >>>> >>>> >>>> Code: >>>> >>>> rowN <- nrow(AT1) >>>> MD1<-vector(length=rowN) >>>> MD2<-vector(length=rowN) >>>> >>>> MD1[1:rowN]<-NA >>>> MD2[1:rowN]<-NA >>>> >>>> >>>> x<- AT1[,c(2,3,4,5,6,7,8) ] >>>> write.csv(x,"x.csv",row.names=TRUE) >>>> x<-as.matrix(x) >>>> for(i in 2:rowN) { >>>> MD1[i]=median(x[i,]) >>>> } >>>> write.csv(MD1,"MD1.csv",row.names=TRUE) >>>> >>>> y<- AT1[,c(9,10,11,12,13,14,15,16)] >>>> write.csv(y,"y.csv",row.names=TRUE) >>>> y<-as.matrix(y) >>>> for(j in 2:rowN) { >>>> MD2[j]=median(y[j,]) >>>> } >>>> write.csv(MD2,"MD2.csv",row.names=TRUE) >>>> >>>> >>>> ------------------------------ >>>> If you reply to this email, your message will be added to the >> discussion >>>> below: >>>> >>>> >> http://r.789695.n4.nabble.com/Median-on-second-group-of-CSV-file-produce-Na-tp4711689.html >>>> To start a new topic under R help, email >>>> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=1> >>>> To unsubscribe from R, click here >>>> < >>>> . >>>> NAML >>>> < >> http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> >> >>>> >>> >>> >>> >>> >>> -- >>> View this message in context: >> http://r.789695.n4.nabble.com/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711690.html >>> Sent from the R help mailing list archive at Nabble.com. >>> [[alternative HTML version deleted]] >>> >>> ______________________________________________ >>> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=2> >> mailing list -- To UNSUBSCRIBE and more, see >>> 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. >>> >> >> -- >> Michael >> http://www.dewey.myzen.co.uk/home.html >> >> ______________________________________________ >> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=3> >> mailing list -- To UNSUBSCRIBE and more, see >> 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/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711707.html >> To start a new topic under R help, email >> ml-node+s789695n789696h53 at n4.nabble.com >> To unsubscribe from R, click here >> <http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=789695&code=bmF2aW5nMnVrQGdtYWlsLmNvbXw3ODk2OTV8LTczNzQxMTY0Ng==> >> . >> NAML >> <http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> >> > > > > > -- > View this message in context: http://r.789695.n4.nabble.com/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711709.html > Sent from the R help mailing list archive at Nabble.com. > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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. >-- Michael http://www.dewey.myzen.co.uk/home.html
The str() out come is : chr [1:31099, 1:8] " 9.329651" " 8.583304" " 9.284229" " 9.746094" "10.200084" " 9.249863" " 7.979661" "11.271934" ... - attr(*, "dimnames")=List of 2 ..$ : NULL ..$ : chr [1:8] "GSM215579.CEL" "GSM215580.CEL" "GSM215581.CEL" "GSM215582.CEL" ... On Tue, Sep 1, 2015 at 2:32 PM, Michael Dewey-3 [via R] < ml-node+s789695n4711716h95 at n4.nabble.com> wrote:> What happened when you did summary(y) or str(y)? > > On 01/09/2015 08:57, Navien wrote: > > > Dear Michael , > > > > Thank you very much for your reply , kindly please can i send you the > > program and data please , y is shown a normal csv file no issue with it > :( > > > > > > Kind Regards > > > > On Tue, Sep 1, 2015 at 8:36 AM, Michael Dewey-3 [via R] < > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711716&i=0>> > wrote: > > > >> Dear Shawin > >> > >> You probably did not get an answer because > >> 1 - you seem to have posted in HTML which mangled your post into > >> unreadability > >> 2 - there seem to be lots of lines which do not do anything germane to > >> the problem. > >> > >> Why not try summary(y) or str(y) before you convert it to a matrix and > >> see what it says? > >> > >> On 31/08/2015 20:46, shawin wrote: > >> > >>> I have an issue ans i posted it , so i would like to receive a > solution > >>> please > >>> > >>> On Mon, Aug 31, 2015 at 8:35 PM, shawin [via R] < > >>> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=0>> > > >> wrote: > >>> > >>>> I have a data frame csv file and I'm trying to calculate median for > >> each > >>>> group separately row by row . When I separate the data frame in two > >> groups > >>>> and calculate the median for each one, I am getting an NA result for > >> the > >>>> second group : > >>>> the data > >>>> x1 x2 x3 x4 x5 x6 x7 y1 y2 y3 y4 y5 y6 y7 y8 > >>>> 9.488404158 9.470895414 9.282433728 9.366707445 9.955383045 > 9.640816474 > >>>> 9.606262272 9.329651027 9.434541611 9.473922432 9.311412966 > 9.3154885 > >>>> 9.434977488 9.470895414 9.764258059 > >>>> 8.630629966 8.55831075 8.788391003 8.576231135 8.671587906 > 8.842979993 > >>>> 8.861958856 8.58330436 8.603596508 8.570129609 8.59798922 > 8.572686772 > >>>> 8.679751791 8.663950953 8.432875347 > >>>> 9.354748885 9.367668838 9.259952558 9.421538213 9.554635162 > 9.603744578 > >>>> 9.452197983 9.284228877 9.404607878 9.317737979 9.343115301 > 9.310644266 > >>>> 9.27227486 9.360337823 9.44706281 > >>>> 9.944863964 9.950427516 10.19101759 10.07350804 10.03269879 > 10.1307908 > >>>> 10.03487287 9.74609383 9.886379007 9.775472567 10.036596 > >> 9.544738458 > >>>> 9.699611598 9.911962567 > >>>> 9.625804277 > >>>> > >>>> > >>>> Code: > >>>> > >>>> rowN <- nrow(AT1) > >>>> MD1<-vector(length=rowN) > >>>> MD2<-vector(length=rowN) > >>>> > >>>> MD1[1:rowN]<-NA > >>>> MD2[1:rowN]<-NA > >>>> > >>>> > >>>> x<- AT1[,c(2,3,4,5,6,7,8) ] > >>>> write.csv(x,"x.csv",row.names=TRUE) > >>>> x<-as.matrix(x) > >>>> for(i in 2:rowN) { > >>>> MD1[i]=median(x[i,]) > >>>> } > >>>> write.csv(MD1,"MD1.csv",row.names=TRUE) > >>>> > >>>> y<- AT1[,c(9,10,11,12,13,14,15,16)] > >>>> write.csv(y,"y.csv",row.names=TRUE) > >>>> y<-as.matrix(y) > >>>> for(j in 2:rowN) { > >>>> MD2[j]=median(y[j,]) > >>>> } > >>>> write.csv(MD2,"MD2.csv",row.names=TRUE) > >>>> > >>>> > >>>> ------------------------------ > >>>> If you reply to this email, your message will be added to the > >> discussion > >>>> below: > >>>> > >>>> > >> > http://r.789695.n4.nabble.com/Median-on-second-group-of-CSV-file-produce-Na-tp4711689.html > >>>> To start a new topic under R help, email > >>>> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=1> > > >>>> To unsubscribe from R, click here > >>>> < > >>>> . > >>>> NAML > >>>> < > >> > http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > > >> > >>>> > >>> > >>> > >>> > >>> > >>> -- > >>> View this message in context: > >> > http://r.789695.n4.nabble.com/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711690.html > >>> Sent from the R help mailing list archive at Nabble.com. > >>> [[alternative HTML version deleted]] > >>> > >>> ______________________________________________ > >>> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=2> > > >> mailing list -- To UNSUBSCRIBE and more, see > >>> 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. > >>> > >> > >> -- > >> Michael > >> http://www.dewey.myzen.co.uk/home.html > >> > >> ______________________________________________ > >> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711707&i=3> > >> mailing list -- To UNSUBSCRIBE and more, see > >> 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/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711707.html > >> To start a new topic under R help, email > >> [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711716&i=1> > >> To unsubscribe from R, click here > >> < > >> . > >> NAML > >> < > http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > > >> > > > > > > > > > > -- > > View this message in context: > http://r.789695.n4.nabble.com/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711709.html > > Sent from the R help mailing list archive at Nabble.com. > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711716&i=2> > mailing list -- To UNSUBSCRIBE and more, see > > 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. > > > > -- > Michael > http://www.dewey.myzen.co.uk/home.html > > ______________________________________________ > [hidden email] <http:///user/SendEmail.jtp?type=node&node=4711716&i=3> > mailing list -- To UNSUBSCRIBE and more, see > 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/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711716.html > To start a new topic under R help, email > ml-node+s789695n789696h75 at n4.nabble.com > To unsubscribe from R, click here > <http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=789695&code=c2hhd2lua2FyaW1AZ21haWwuY29tfDc4OTY5NXwtMjQ0MzkwMjQ1> > . > NAML > <http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> >-- View this message in context: http://r.789695.n4.nabble.com/Median-on-second-group-of-CSV-file-produce-Na-tp4711689p4711718.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]]