[R] Median on second group of CSV file produce Na

Navien naving2uk at gmail.com
Tue Sep 1 09:57:16 CEST 2015


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]]



More information about the R-help mailing list