I need to be able to sort time column in r (but it's a collection of hours, days, weeks spent, not time in its normal format)

Asked Apr 30 '21 at 15:14

Active Apr 30 '21 at 20:04

Viewed 30 times

I have a chr column that contains time spent on a request in the following format -> 1mos 3w 1d 0h 0m 0s. When I am trying to sort the column and arrange the content in the desc order, it does not work (of course), as the order is based on numerics:

How could I convert this into time column (or smth) to be able to sort it correctly (with 6 months bigger then 7 days? Thank you in advance. I am out of ideas...

edited Apr 30 '21 at 20:04

Phil

5,491
3
26
61

asked Apr 30 '21 at 15:14

Katy B

Could you provide an example of how your data looks like? please take a look at this guide: https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example – Guibor Camargo Salamanca Apr 30 '21 at 15:34
1

Use a regex. `hours – dash2 Apr 30 '21 at 15:43

I need to be able to sort time column in r (but it's a collection of hours, days, weeks spent, not time in its normal format)

0 Answers0