回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我想按日期对csv文件排序,但出现了此错误</p>
<pre><code>ValueError: time data '.' does not match format '%d/%m/%Y'
</code></pre>
<p>我不知道我做错了什么。你知道吗</p>
<p>csv文件:</p>
<pre><code>T.No,Date,Task,Project,Context,Message,Status
1,12/07/2019,meet @sam and @jack,python,@sam,hello,Incomplete
1,11/07/2019,meet @sam and @jack,python,@jack,hello,Incomplete
3,15/07/2019,meet @sam and @ jack,python,@sam & @,at room 12,Incomplete
4,13/07/2019,meet @sam and @jack,python,@sam & @jack,at room 12,Incomplete
5,15/07/2019,meet sam,python,,at room 12,Incomplete
</code></pre>
<pre><code> def sort():
data = open("csv.csv", 'r')
stdata = sorted(data, key=lambda row: datetime.strptime(row[1], "%d/%m/%Y"))
with open("csv.csv", 'w') as f1:
writer = csv.writer(f1)
for eachline in stdata:
writer.writerows(eachline)
</code></pre>