[R] "order" issue

Zoppoli, Gabriele (NIH/NCI) [G] zoppolig at mail.nih.gov
Mon May 24 00:28:55 CEST 2010


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: zoppolig at mail.nih.gov
________________________________________
From: Jorge Ivan Velez [jorgeivanvelez at 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] <zoppolig at mail.nih.gov<mailto:zoppolig at 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: zoppolig at mail.nih.gov<mailto:zoppolig at mail.nih.gov>
______________________________________________
R-help at r-project.org<mailto: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.



More information about the R-help mailing list