Sorting a python list based on date?

Question

I have a list of lists where each sub-list contains date values. How can I sort this based on Date?

tList=[['xX0001', '10006', '102', '', '2018-02-02', 3233.9, 0.0, 36816.18, ''], 
['xX0001', '10006', '102', '', '2018-02-01', 4142.45, 0.0, 40146.55, ''], 
['xX0001', '10006', '200', '', '2018-02-02', 14367.539999999999, 0.0, 41496.42999999999, ''], 
['xX0001', '10006', '200', '', '2018-02-01', 12663.27, 0.0, 56043.94, '']]

Possible duplicate of [How to sort (list/tuple) of lists/tuples?](https://stackoverflow.com/questions/3121979/how-to-sort-list-tuple-of-lists-tuples) — blhsing, Aug 30 '18 at 06:41
@MadPhysicist Agree with you, (i think you couldn't close this as duplicate because you close this as too broad right?) — U13-Forward, Aug 30 '18 at 06:49
@MadPhysicist There's actually no need to convert the date strings to `datetime` objects in both this case and the question you link to because the lexicographical order happens to be the same as the chronological order. — blhsing, Aug 30 '18 at 06:52

score 4 · Accepted Answer · answered Aug 30 '18 at 06:41

try, and you will get you expect sort

In [51]: a=[['xX0001', '10006', '102', '', '2018-02-02', 3233.9, 0.0, 36816.18, ''], 
    ...: ['xX0001', '10006', '102', '', '2018-02-01', 4142.45, 0.0, 40146.55, ''], 
    ...: ['xX0001', '10006', '200', '', '2018-02-02', 14367.539999999999, 0.0, 41496.42999999999, ''], 
    ...: ['xX0001', '10006', '200', '', '2018-02-01', 12663.27, 0.0, 56043.94, '']]
In [52]: sorted(a, key=lambda b: b[4])
Out[52]: 
[['xX0001', '10006', '102', '', '2018-02-01', 4142.45, 0.0, 40146.55, ''],
 ['xX0001', '10006', '200', '', '2018-02-01', 12663.27, 0.0, 56043.94, ''],
 ['xX0001', '10006', '102', '', '2018-02-02', 3233.9, 0.0, 36816.18, ''],
 ['xX0001',
  '10006',
  '200',
  '',
  '2018-02-02',
  14367.539999999999,
  0.0,
  41496.42999999999,
  '']]

In [53]: sorted(a, key=lambda b: b[4])

score 1 · Answer 2 · answered Aug 30 '18 at 06:44

1

Try:

print(sorted(tList,key=lambda x: x[4]))

Or:

tList.sort(key=lambda x: x[4])
print(tList)

answered Aug 30 '18 at 06:44

U13-Forward

69,221
14
89
114

Sorting a python list based on date?

2 Answers2