CODEWITHSUNDEEP
pythonlistdictionarydatetime
TIMEX
TIMEX

Reputation: 271664

How do I sort this list in Python, if my date is in a String?

[{'date': '2010-04-01', 'people': 1047, 'hits': 4522}, {'date': '2010-04-03', 'people': 617, 'hits': 2582}, {'date': '2010-04-02', 'people': 736, 'hits': 3277}]

Suppose I have this list. How do I sort by "date", which is an item in the dictionary. But, "date" is a string...

Upvotes: 16

Views: 42876

Answers (5)

damzam
damzam

Reputation: 1961

Satoru.Logic's solution is clean and simple. But, per Alex's post, you don't need to manipulate the date string to get the sort order right...so lose the .split('-')

This code will suffice:

records.sort(key=lambda x:x['date'])

Upvotes: 18

Alex Martelli
Alex Martelli

Reputation: 881555

Fortunately, ISO format dates, which seems to be what you have here, sort perfectly well as strings! So you need nothing fancy:

import operator
yourlistofdicts.sort(key=operator.itemgetter('date'))

Upvotes: 27

Rescommunes
Rescommunes

Reputation: 805

In python 2.6 you can use soerted w/operator.itemgetter. Since date is YYYY-MM-DD it is sorted even though its a string cause its largest to smallest - i use that format all the time for this reason 

>>> import operator
>>> l = [{'date': '2010-04-01','people': 1047, 'hits': 4522}, 
         {'date': '2010-04-03', 'people': 617, 'hits': 2582}, 
         {'date': '2010-04-02', 'people': 736, 'hits': 3277}]
>>> sorted( l, key = operator.itemgetter('date') )
[{'date': '2010-04-01', 'hits': 4522, 'people': 1047}, {'date': '2010-04-02', 'hits': 3277, 'people': 736}, {'date': '2010-04-03', 'hits': 2582, 'people': 617}]

Upvotes: 4

satoru
satoru

Reputation: 33215

records = [
     {'date': '2010-04-01', 'people': 1047, 'hits': 4522}, 
     {'date': '2010-04-03', 'people': 617, 'hits': 2582}, 
     {'date': '2010-04-02', 'people': 736, 'hits': 3277}
     ]
records.sort(key=lambda x: x['date'].split('-'))

Upvotes: 2

Ignacio Vazquez-Abrams
Ignacio Vazquez-Abrams

Reputation: 798536

.sort(key=lambda x: datetime.datetime.strptime(x['date'], '%Y-%m-%d'))

Upvotes: 45

Related Questions