Hi I'm having a simple issue with the order function. When I use the following code my data is not ordered correctly > output[order(output[,3]),] Name beta pval 881 9.09303277751237 0.000100253350483199 7402 6.40553461638365 0.00010228641631914 4879 -8.88509881106217 0.000103251645995887 However when I export the data and sort it in excel I see the following: Name beta pval pval 25037 -5.70737 2.48E-07 34294 -19.6931 1.04E-05 36002 -12.2478 1.63E-05 Any suggestions on how I can get this sort to work properly on data in scientifict format? .kripa [[alternative HTML version deleted]]
Hi I'm having a simple issue with the order function. When I use the following code my data is not ordered correctly> output[order(output[,3]),]Name beta pval 881 9.09303277751237 0.000100253350483199 7402 6.40553461638365 0.00010228641631914 4879 -8.88509881106217 0.000103251645995887 However when I export the data and sort it in excel I see the following: Name beta pval pval 25037 -5.70737 2.48E-07 34294 -19.6931 1.04E-05 36002 -12.2478 1.63E-05 Any suggestions on how I can get this sort to work properly on data in scientifict format? .kripa [[alternative HTML version deleted]]
On 01.02.2013 17:52, Kripa R wrote:> > Hi I'm having a simple issue with the order function. When I use the following code my data is not ordered correctly > output[order(output[,3]),] > > Name beta pval > 881 9.09303277751237 0.000100253350483199 > 7402 6.40553461638365 0.00010228641631914 > 4879 -8.88509881106217 0.000103251645995887This is obviously sorted correctly according to the values in the third column.> However when I export the data and sort it in excel I see the following:Name beta pval pval> 25037 -5.70737 2.48E-07 > 34294 -19.6931 1.04E-05 > 36002 -12.2478 1.63E-05 Any suggestions on how I can get this sort to work properly on data in scientifict format?This is not sorted correctly, so please ask Microsoft. R did it well. Best, Uwe Ligges> > > > > > > > > > > > > > > > > > > > > > > > > > > > .kripa > [[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. >