I tried this, but it doesn't change the "division" between negative and positive values (see that you have first positive from max to min, and then negative from min to max, as if "order" considered only the absolute values...)
Product hsa.miR.204 hsa.miR.210 Tissue 48 "ME:SK_MEL_5" "1.74749" "-1.47817" "Melanoma" 47 "ME:SK_MEL_28" "1.7425" "1.45266" "Melanoma" 46 "ME:SK_MEL_2" "0.55255" "-1.6667" "Melanoma" 50 "ME:UACC_62" "0.52503" "0.1605" "Melanoma" 45 "ME:MDA_N" "0.21077" "0.05502" "Melanoma" 16 "CNS:SNB_19" "0.16583" "0.03737" "CNS" 18 "CNS:U251" "0.01263" "1.66389" "CNS" 33 "LC:NCI_H460" "0.0042" "-0.6023" "Lung" 30 "LC:NCI_H226" "-4.37408" "-0.22311" "Lung" 58 "PR:DU_145" "-4.33961" "1.57548" "Prostate" 27 "LC:EKVX" "-4.32847" "1.66042" "Lung" 32 "LC:NCI_H322M" "-4.28534" "1.66783" "Lung" 41 "ME:LOXIMVI" "-4.2572" "0.37259" "Melanoma" 23 "CO:HT29" "-4.11624" "-0.02799" "Colon" 51 "OV:IGROV1" "-4.02758" "2.04324" "Ovarian" 10 "BR:MCF7" "-4.00187" "1.46303" "Breast" 67 "RE:UO_31" "-3.99791" "-1.09215" "Renal" 62 "RE:ACHN" "-3.96246" "-0.62365" "Renal" 31 "LC:NCI_H23" "-3.91625" "-1.14955" "Lung" 65 "RE:SN12C" "-3.90776" "0.85244" "Renal" 15 "CNS:SF_539" "-3.86184" "1.39114" "CNS" 8 "BR:BT_549" "-3.80239" "-0.43099" "Breast" 55 "OV:OVCAR_5" "-3.7852" "2.43038" "Ovarian" 24 "CO:KM12" "-3.68703" "2.19991" "Colon" 56 "OV:OVCAR_8" "-3.66053" "-0.9594" "Ovarian" 20 "CO:COLO205" "-3.64656" "0.54344" "Colon" 13 "CNS:SF_268" "-3.63916" "2.54378" "CNS" 21 "CO:HCC_2998" "-3.61457" "-0.32362" "Colon" 29 "LC:HOP_92" "-3.60636" "0.87116" "Lung" 35 "LE:CCRF_CEM" "-3.54526" "-2.09262" "Leukemia" 60 "RE:786_0" "-3.5086" "1.75056" "Renal" 28 "LC:HOP_62" "-3.4968" "0.67884" "Lung" 64 "RE:RXF_393" "-3.49615" "2.59144" "Renal" 22 "CO:HCT_15" "-3.45342" "0.16357" "Colon" 12 "BR:T47D" "-3.41228" "1.13818" "Breast" 19 "CO:HCT_116" "-3.39764" "0.43061" "Colon" 59 "PR:PC_3" "-3.36612" "1.39328" "Prostate" 11 "BR:MDA_MB_231" "-3.24907" "1.58326" "Breast" 38 "LE:MOLT_4" "-3.20055" "-1.72841" "Leukemia" 36 "LE:HL_60" "-3.16745" "-3.16745" "Leukemia" 54 "OV:OVCAR_4" "-3.13137" "-0.47497" "Ovarian" 14 "CNS:SF_295" "-3.09348" "-1.00095" "CNS" 53 "OV:OVCAR_3" "-3.0705" "-0.31743" "Ovarian" 57 "OV:SK_OV_3" "-3.04477" "2.15405" "Ovarian" 52 "OV:NCI_ADR_RES" "-3.04456" "0.17046" "Ovarian" 66 "RE:TK_10" "-2.95281" "1.26245" "Renal" 34 "LC:NCI_H522" "-2.94381" "0.3859" "Lung" 9 "BR:HS578T" "-2.94118" "1.1217" "Breast" 61 "RE:A498" "-2.89402" "0.93287" "Renal" 26 "LC:A549" "-2.66221" "0.71215" "Lung" 39 "LE:RPMI_8226" "-2.59561" "-1.9448" "Leukemia" 63 "RE:CAKI_1" "-2.48443" "0.43245" "Renal" 25 "CO:SW_620" "-1.53265" "-1.35446" "Colon" 40 "LE:SR" "-0.93541" "2.95346" "Leukemia" 42 "ME:M14" "-0.73942" "-0.73904" "Melanoma" 49 "ME:UACC_257" "-0.72431" "-1.84753" "Melanoma" 43 "ME:MALME_3M" "-0.67327" "-1.33493" "Melanoma" 37 "LE:K_562" "-0.58218" "1.8581" "Leukemia" 17 "CNS:SNB_75" "-0.23183" "1.03945" "CNS" 44 "ME:MDA_MB_435" "-0.1915" "-0.16744" "Melanoma" Gabriele Zoppoli, MD Ph.D. Fellow, Experimental and Clinical Oncology and Hematology, University of Genova, Genova, Italy Guest Researcher, LMP, NCI, NIH, Bethesda MD Work: 301-451-8575 Mobile: 301-204-5642 Email: zoppo...@mail.nih.gov ________________________________________ From: Jorge Ivan Velez [jorgeivanve...@gmail.com] Sent: Sunday, May 23, 2010 6:09 PM To: Zoppoli, Gabriele (NIH/NCI) [G] Subject: Re: [R] "order" issue Hi Gabriele, Take a look at the "decreasing" argument in ?order > xx <-c(1,3,4,10, 5,2,3,8,9) > xx [1] 1 3 4 10 5 2 3 8 9 > xx[order(xx)] [1] 1 2 3 3 4 5 8 9 10 > xx[order(xx, decreasing = TRUE)] [1] 10 9 8 5 4 3 3 2 1 HTH, Jorge On Sun, May 23, 2010 at 5:39 PM, Zoppoli, Gabriele (NIH/NCI) [G] <zoppo...@mail.nih.gov<mailto:zoppo...@mail.nih.gov>> wrote: Hi everybody, this is a real dummy thing. I sorted a matrix based on a given column, and what I get is right, until it comes to columns of negative and positive values; than, "order" orders everything from max to min in the negative values, and then AGAIN from max to min in the positive values!!! Why isn't everything order from max to min, and that's it? Thank you!!! Attached is the txt file I use; try: x=x[order(x[,2]),] What I get is: print(x) Product A B Tissue 44 ME:MDA_MB_435 -0.1915 -0.16744 Melanoma 17 CNS:SNB_75 -0.23183 1.03945 CNS 37 LE:K_562 -0.58218 1.8581 Leukemia 43 ME:MALME_3M -0.67327 -1.33493 Melanoma 49 ME:UACC_257 -0.72431 -1.84753 Melanoma 42 ME:M14 -0.73942 -0.73904 Melanoma 40 LE:SR -0.93541 2.95346 Leukemia 25 CO:SW_620 -1.53265 -1.35446 Colon 63 RE:CAKI_1 -2.48443 0.43245 Renal 39 LE:RPMI_8226 -2.59561 -1.9448 Leukemia 26 LC:A549 -2.66221 0.71215 Lung 61 RE:A498 -2.89402 0.93287 Renal 9 BR:HS578T -2.94118 1.1217 Breast 34 LC:NCI_H522 -2.94381 0.3859 Lung 66 RE:TK_10 -2.95281 1.26245 Renal 52 OV:NCI_ADR_RES -3.04456 0.17046 Ovarian 57 OV:SK_OV_3 -3.04477 2.15405 Ovarian 53 OV:OVCAR_3 -3.0705 -0.31743 Ovarian 14 CNS:SF_295 -3.09348 -1.00095 CNS 54 OV:OVCAR_4 -3.13137 -0.47497 Ovarian 36 LE:HL_60 -3.16745 -3.16745 Leukemia 38 LE:MOLT_4 -3.20055 -1.72841 Leukemia 11 BR:MDA_MB_231 -3.24907 1.58326 Breast 59 PR:PC_3 -3.36612 1.39328 Prostate 19 CO:HCT_116 -3.39764 0.43061 Colon 12 BR:T47D -3.41228 1.13818 Breast 22 CO:HCT_15 -3.45342 0.16357 Colon 64 RE:RXF_393 -3.49615 2.59144 Renal 28 LC:HOP_62 -3.4968 0.67884 Lung 60 RE:786_0 -3.5086 1.75056 Renal 35 LE:CCRF_CEM -3.54526 -2.09262 Leukemia 29 LC:HOP_92 -3.60636 0.87116 Lung 21 CO:HCC_2998 -3.61457 -0.32362 Colon 13 CNS:SF_268 -3.63916 2.54378 CNS 20 CO:COLO205 -3.64656 0.54344 Colon 56 OV:OVCAR_8 -3.66053 -0.9594 Ovarian 24 CO:KM12 -3.68703 2.19991 Colon 55 OV:OVCAR_5 -3.7852 2.43038 Ovarian 8 BR:BT_549 -3.80239 -0.43099 Breast 15 CNS:SF_539 -3.86184 1.39114 CNS 65 RE:SN12C -3.90776 0.85244 Renal 31 LC:NCI_H23 -3.91625 -1.14955 Lung 62 RE:ACHN -3.96246 -0.62365 Renal 67 RE:UO_31 -3.99791 -1.09215 Renal 10 BR:MCF7 -4.00187 1.46303 Breast 51 OV:IGROV1 -4.02758 2.04324 Ovarian 23 CO:HT29 -4.11624 -0.02799 Colon 41 ME:LOXIMVI -4.2572 0.37259 Melanoma 32 LC:NCI_H322M -4.28534 1.66783 Lung 27 LC:EKVX -4.32847 1.66042 Lung 58 PR:DU_145 -4.33961 1.57548 Prostate 30 LC:NCI_H226 -4.37408 -0.22311 Lung 33 LC:NCI_H460 0.0042 -0.6023 Lung 18 CNS:U251 0.01263 1.66389 CNS 16 CNS:SNB_19 0.16583 0.03737 CNS 45 ME:MDA_N 0.21077 0.05502 Melanoma 50 ME:UACC_62 0.52503 0.1605 Melanoma 46 ME:SK_MEL_2 0.55255 -1.6667 Melanoma 47 ME:SK_MEL_28 1.7425 1.45266 Melanoma 48 ME:SK_MEL_5 1.74749 -1.47817 Melanoma Gabriele Zoppoli, MD Ph.D. Fellow, Experimental and Clinical Oncology and Hematology, University of Genova, Genova, Italy Guest Researcher, LMP, NCI, NIH, Bethesda MD Work: 301-451-8575 Mobile: 301-204-5642 Email: zoppo...@mail.nih.gov<mailto:zoppo...@mail.nih.gov> ______________________________________________ R-help@r-project.org<mailto: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.