Dear Users This is my dataset called mydata4. I want to sort the dataframe on the first column PxMid which is basically a column with dates.
I've tried mydata4<-mydata4[order(mydata4$PxMid),] but it doesnt work. Could it be because these are dates? Please help I'm really stuck !! Thank you for your time. Regards Meenu PxMid EU0006MIndex.x DMSW1Curncy.x DMSW2Curncy.x DMSW3Curncy.x 1 01/01/2003 2.80113 2.7070 2.8920 3.1720 2 01/01/2007 3.85350 4.0760 4.1250 4.1230 3 01/02/2002 3.41563 3.6385 4.0810 4.3587 4 01/02/2006 2.70000 2.9545 3.1672 3.2792 5 01/05/2002 3.49863 3.7940 4.2300 4.4920 6 01/05/2006 3.03588 3.3254 3.5950 3.7380 DMSW4Curncy.x DMSW5Curncy.x DMSW6Curncy.x DMSW7Curncy.x DMSW8Curncy.x 1 3.4360 3.6640 3.8640 4.0360 4.1790 2 4.1230 4.1250 4.1350 4.1460 4.1620 3 4.5487 4.6988 4.8313 4.9338 5.0138 4 3.3627 3.4342 3.4899 3.5437 3.5941 5 4.7650 4.8675 5.0550 5.1600 5.2400 6 3.8290 3.9050 3.9690 4.0240 4.0750 DMSW9Curncy.x DMSW10Curncy.x DMSW12Curncy.x DMSW15Curncy.x DMSW20Curncy.x 1 4.2990 4.4000 4.5575 4.7175 4.8600 2 4.1800 4.2000 4.2330 4.2750 4.3120 3 5.0788 5.1263 5.2100 5.2887 5.3562 4 3.6457 3.6913 3.7725 3.8669 3.9410 5 5.3050 5.3575 5.4450 5.5425 5.6300 6 4.1230 4.1650 4.2360 4.3170 4.3960 DMSW30Curncy.x EUSA40Curncy.x EUSA50Curncy.x spread.x level.x State1 State2 1 4.8925 4.8400 4.7975 2.0005 4.006772 NA NA 2 4.2890 4.2460 4.2040 0.1640 4.165147 NA NA 3 5.3412 5.2913 5.2638 1.2602 4.792737 NA NA 4 3.9840 3.9760 3.9560 0.8168 3.550524 NA NA 5 5.6275 5.5775 5.5375 1.3975 5.007331 NA NA 6 4.4290 4.4190 4.3980 0.8340 3.998781 NA NA State3 State4 State5 State6 State7 State8 State9 1 NA NA NA 6 NA NA NA 2 NA NA 5 NA NA NA NA 3 NA NA NA NA NA NA 9 4 NA NA NA 6 NA NA NA 5 NA NA NA NA NA NA 9 6 NA NA NA 6 NA NA NA [[alternative HTML version deleted]] ______________________________________________ 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.