在python中按日期对csv对象进行排序 [英] Sorting a csv object by dates in python
本文介绍了在python中按日期对csv对象进行排序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试对具有类似数据的csv文件进行读取和排序
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
我这样做
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)
问题是,它通过将日期读取为String而不是日期来对日期进行排序.因此,数据的排序方式如下,
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?
推荐答案
使用 datetime.strptime
从日期字段中获取datetime
:
from datetime import datetime
data = sorted(data, key = lambda row: datetime.strptime(row[0], "%d-%b-%y"))
这篇关于在python中按日期对csv对象进行排序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文