Hi r-help-boun...@r-project.org napsal dne 28.07.2009 12:40:59:
> 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? How do you know these are dates? I suspect str(mydata4) will have factor at PxMid and not date. If this is true, you need to transform it to dates by as.Date, strptime or other suitable time/date function e.g. fro chron package. Regards Petr > 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. ______________________________________________ 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.
