R - Date Sorting

Question

I am having the data set filtered from from other data base, which is as below

        Date| freq
____________|_________
 01-Aug-2017| 3079
 02-Aug-2017| 3239
 03-Aug-2017| 3026
 04-Aug-2017| 2700
 05-Aug-2017|  846
 05-Jul-2017| 2647
 06-Aug-2017|  579
 07-Aug-2017| 3145
 08-Aug-2017| 3386
 09-Aug-2017| 3350
 10-Aug-2017| 3127
 11-Aug-2017| 2824
 12-Aug-2017|  784
 12-Jun-2017| 2359
 13-Aug-2017| 575
 13-Jun-2017| 2074
 14-Aug-2017| 3258
 14-Jun-2017| 2022
 15-Aug-2017| 2948
 15-Jun-2017| 2143

Sorting is not happening as per the date, but as per the characters. I tried to convert the date format with as.Date but not successful. It will be a great help, to convert the date in any format and sort it date wise. Any support in this direction will be a great help.

Thanks, Praveen

Try somethinkg like yourData$newDates <- as.Date(yourData$Date, "%d-%b-%Y") — wolf_wue
– wolf_wue, Commented Oct 11, 2017 at 9:08
Or just yourData[order(as.Date(yourData$Date, format = "%d-%b-%Y")), ] — nghauran
– nghauran, Commented Oct 11, 2017 at 9:18

PraneetNigam · Accepted Answer · 2017-10-11 10:01:50Z

1

Let assume your dataframe is named 'd' Apply code to sort according to dates:

d[order(as.Date(d$V3, format="%d/%m/%Y)),]

answered Oct 11, 2017 at 10:01

PraneetNigam

1,00710 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

nghauran Over a year ago

In this case, we need to use format = "%d-%b-%Y" instead of format = "%d/%m/%Y". This can help to understand the specification of dates format.

PraneetNigam Over a year ago

Yes in the above case we can use "%d-%b-%Y" format.

Collectives™ on Stack Overflow

R - Date Sorting

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related