Sorting datetime.datetime 2d array

Question

I have the following 2D array, the date format is %Y-%m-%d %H:%M:%S :

[['second comment test', datetime.datetime(2018, 8, 22, 15, 49, 40), 's']
['this comment originated in service now', datetime.datetime(2018, 8, 22, 14, 45), 's']
['this is a longer description used for testing', datetime.datetime(2018, 8, 22, 14, 13, 49), 'z']]

I noticed that if one of the logs for time is at exactly a minute for example 2018-08-22 14:45:00 Meaning that it ends in 00 it wont log the seconds. So how can I order this array by date?

arr.sort(key=lambda x: x[1]) will sort by the second element in each list if your list is named arr. This will sort in-place. — Dietrich Epp
– Dietrich Epp, Commented Aug 22, 2018 at 15:57
What exactly is this? A numpy array or a Series? Or just a Python list? — roganjosh
– roganjosh, Commented Aug 22, 2018 at 15:57
datetime objects are stored internally as integers. Not sure why you think you have date format is %Y..... As such, sorting will work regardless of the seconds value being 0. — jpp
– jpp, Commented Aug 22, 2018 at 15:58
I agree with @jpp . You'll need a reproducible example for this — roganjosh
– roganjosh, Commented Aug 22, 2018 at 15:59
I am initializaing as this : all_comments = [] @DietrichEpp I just tried that and it says "'NoneType' object has no attribute 'sort'" — Mario Landa
– Mario Landa, Commented Aug 22, 2018 at 16:03

lmiguelvargasf · Accepted Answer · 2018-08-22 16:05:26Z

1

Assuming what you have is a list, as mentioned by @DietrichEpp, you can simply sort this array by:

list_ = [
    ['second comment test', datetime.datetime(2018, 8, 22, 15, 49, 40), 's'],
    ['this comment originated in service now', datetime.datetime(2018, 8, 22, 14, 45), 's'],
    ['this is a longer description used for testing', datetime.datetime(2018, 8, 22, 14, 13, 49), 'z'],]
list_.sort(key=lambda x: x[1])

answered Aug 22, 2018 at 16:05

lmiguelvargasf

71.2k55 gold badges231 silver badges239 bronze badges

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

2 Comments

Mario Landa Over a year ago

had to make some minor changes, but this is the correct answer. Thank you!

lmiguelvargasf Over a year ago

@MarioLanda, I'm glad to know it was useful.

Collectives™ on Stack Overflow

Sorting datetime.datetime 2d array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related