I am trying to read and sort a csv file that has data that looks like
Date Open High Low Close Volume
27-Mar-12 8.25 8.35 8.17 8.19 9801989
26-Mar-12 8.16 8.25 8.12 8.24 8694416
23-Mar-12 8.05 8.12 7.95 8.09 8149170
I do this with
import csv
data = csv.reader(open('data.csv','r'))
To sort data by Date. I do:
sorteddata = sorted(data,key=operator.itemgetter(1),reverse=False)
The problem is, that it sorted the dates by reading them as String and not as dates. So the data is sorted like so,
['3-Aug-11', '7.06', '7.23', '6.84', '7.16', '31583617']
['3-Feb-12', '7.02', '7.12', '6.98', '7.08', '15318044']
['3-Jan-12', '5.53', '5.59', '5.44', '5.48', '12678923']
['3-Jun-11', '8.09', '8.17', '7.92', '7.97', '21273812']
['3-May-11', '9.00', '9.04', '8.63', '8.80', '17356005']
Does anybody know how to sort by dates?
解决方案
Use datetime.strptime to get a datetime from the date field:
from datetime import datetime
data = sorted(data, key = lambda row: datetime.strptime(row[0], "%d-%b-%y"))