擅长:python、mysql、java
<p>按日期排序:</p>
<pre><code>from datetime import datetime
mylist = [['CustomerID_12345', 'TransactionID_1001', '12/31/2012'],
['CustomerID_12345', 'TransactionID_1002', '3/12/2013'],
['CustomerID_12345', 'TransactionID_1003', '1/7/2013'],
['CustomerID_12345', 'TransactionID_1004', '12/31/2012']]
sorted_list = sorted(mylist, key=lambda x: datetime.strptime(x[2],'%m/%d/%Y'))
for item in sorted_list:
print item
</code></pre>
<p>或者您可以首先将日期存储为datetime。如果它们是字符串,那么您可以首先添加一个datetime列:</p>
^{pr2}$