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

shawin shawinkarim at gmail.com
Tue Sep 1 15:48:33 CEST 2015


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



More information about the R-help mailing list