Hi
r-help-bounces at 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 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.