How to sort substring from a dataframe? I want to sort as per order-is from a string that conatins locn-date-digits format. My data is sorted according to store wise details evryday, i want to see all orders for a day using filter. suppose date is 04-06-19. My id are In-040419-101,In-040419-102. etc.