sort a list using lambda and regex in python

Question

list = ['xxxx ResultDatetime:2017-05-31 09:38:00.000:ResultDatetime', 'xxxx ResultDatetime:2017-05-26 15:36:00.000:ResultDatetime', 'yyyyy' ResultDatetime:2017-10-23 16:16:00.000:ResultDatetime]

datet = re.compile(r'ResultDatetime:(\d{4}-\d{2}-\d{2} \d{2}:\d{2})')

list.sort(key = lambda x: ........)

I want to sort the lists in an order starting with the earliest date. How should I go about it using lambda and regex?

Why do you have these weird strings? What is the expected output for the given list? — timgeb
– timgeb, Commented Nov 14, 2018 at 16:33
sorry the original string had '<' characters in it which interfered with the way it was displayed. I have edited the question as you can see now — dratoms
– dratoms, Commented Nov 14, 2018 at 16:34
Avoid list as a variable name, there's already the builtin list. — timgeb
– timgeb, Commented Nov 14, 2018 at 16:51

Duncan · Accepted Answer · 2018-11-14 16:54:58Z

2

With the code you have there it is sufficient to do:

list.sort(key=lambda x: datet.search(x).group(1))

(but please, don't use list as a variable name).

There is no need to convert the extracted string to a datetime as it is already in a format that will sort naturally.

Note however that if any string does not match the regex this will generate an error, so you may be better to split the key out into a named multi-line function and test for a successful match before returning the matched group.

def sort_key(line):                                                                                                                                               
    match = datet.search(line)                                                                                                                                               
    if match:                                                                                                                                                     
        return match.group(1)                                                                                                                                                    
    return ''        

data = [
    'xxxx ResultDatetime:2017-05-31 09:38:00.000:ResultDatetime',
    'xxxx ResultDatetime:2017-05-26 15:36:00.000:ResultDatetime',
    'yyyyy ResultDatetime:2017-10-23 16:16:00.000:ResultDatetime'
]
data.sort(key=sort_key)

answered Nov 14, 2018 at 16:54

Duncan

96.4k15 gold badges129 silver badges160 bronze badges

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

1 Comment

dratoms Over a year ago

thanks for that syntax. that was elusive to me. and thanks for that neat little function there. Although the list element part is autogenerated and is unlikely that there will be missing values, your function is going to help me a lot in future, a newbie to python (and programming in general) that I am.

mrzasa · Accepted Answer · 2018-11-14 16:58:02Z

0

You can use dateutil.parser.parse (see this answer: Parse date strings?) to parse the date and re.findall to get it from a string

import re     
from dateutil.parser import parse

list = ['xxxx ResultDatetime:2017-05-31 09:38:00.000:ResultDatetime', 'xxxx ResultDatetime:2017-05-26 15:36:00.000:ResultDatetime', 'yyyyy ResultDatetime:2017-10-23 16:16:00.000:ResultDatetime]
datet = re.compile(r'ResultDatetime:(\d{4}-\d{2}-\d{2} \d{2}:\d{2})')

list.sort(key = lambda x : parse(re.findall(datet, x)[0]))

answered Nov 14, 2018 at 16:58

mrzasa

23.4k11 gold badges60 silver badges96 bronze badges

1 Comment

dratoms Over a year ago

I haven't used dateutil so far. But it seems promising. Will keep this in mind.

Nick · Accepted Answer · 2018-11-14 17:06:33Z

0

I think the simplest solution without any imports would be:

data  = ['xxxx ResultDatetime:2017-05-31 09:38:00.000:ResultDatetime',
         'xxxx ResultDatetime:2017-05-26 15:36:00.000:ResultDatetime', 
         'yyyyy ResultDatetime:2017-10-23 16:16:00.000:ResultDatetime']

sorted_data = sorted(data, key=lambda x: x[20:36])

print(sorted_data)

Output:

        ['xxxx ResultDatetime:2017-05-26 15:36:00.000:ResultDatetime', 
         'xxxx ResultDatetime:2017-05-31 09:38:00.000:ResultDatetime', 
         'yyyyy ResultDatetime:2017-10-23 16:16:00.000:ResultDatetime']

answered Nov 14, 2018 at 17:06

Nick

3,8586 gold badges36 silver badges61 bronze badges

2 Comments

Duncan Over a year ago

The last string has the date at a slightly different offset. I think the OP's intention is that xxxx and yyyyy could be any arbitrarily long strings.

dratoms Over a year ago

exactly. and there could be other string numbers before the regex pattern that would impede in natural sorting here.

Collectives™ on Stack Overflow

sort a list using lambda and regex in python

3 Answers 3

1 Comment

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related