Sort timestamp in python dictionary

Question

mydict = [{'Counted number': '26', 'Timestamp': '8/10/2015 13:07:38'},{'Counted number': '14','Timestamp': '8/10/2015 11:51:14'},{'Counted number': '28','Timestamp': '8/10/2015 13:06:27'}, {'Counted number': '20','Timestamp': '8/10/2015 12:53:42'}]

How to sort this dict based on timestamp?

score 10 · Answer 1 · answered Nov 24 '15 at 05:45

10

This should work

import time
mydict.sort(key=lambda x:time.mktime(time.strptime(x['Timestamp'], '%d/%m/%Y %H:%M:%S')))

answered Nov 24 '15 at 05:45

agamagarwal

978
7
17

score 3 · Accepted Answer · edited May 23 '17 at 11:51

3

mydict.sort(key=lambda x:x['Timestamp'])

This will compare the elements of mydict based on their time stamp and sort it that way. Now, if you want to sort it by the actual time, then you have to convert that timestamp string to a Time object of some sort, and then sort mydict based on that. This question will likely help with that.

edited May 23 '17 at 11:51

Community

1
1

answered Nov 24 '15 at 05:38

El'endia Starman

2,204
21
35

1

This treats the timestamp as a string and sorts on that. If the first entry was `08/10/2015 13:07:38` instead of `8/10/2015 13:07:38`, this method would give incorrect result. – agamagarwal Nov 24 '15 at 05:41
3

@agamagarwal: Yes, I know. Did you not read my second sentence? – El'endia Starman Nov 24 '15 at 05:43
1

I'm just getting `AttributeError: 'dict' object has no attribute 'sort'` – Marki Dec 25 '18 at 19:18
1

@Marki The original question has a list of dicts. – El'endia Starman Dec 25 '18 at 19:21

Sort timestamp in python dictionary

2 Answers2