我有以下错误:
line 73, in formatFile outRow.append(datetime.datetime.strptime(row[5],'%m/%d/%Y').strftime('%Y-%m-%d')) ValueError: time data '' does not match format '%m/%d/%Y'
以下脚本:
import datetime
def formatFile(fname):
print(fname)
formattedFile=open(workingFolder() + '\\FormattedFile.csv','w')
writer = csv.writer(formattedFile, delimiter=',', quotechar='"', quoting=csv.QUOTE_ALL,lineterminator='\n')
writer.writerow(["Name","Unit","Unit Size","Other","Note","Mode Here"])
with open(fName) as f:
reader=csv.reader(f,delimiter=',')
next(reader)
for row in reader:
outRow=[]
outRow.append(datetime.datetime.strptime(row[5],'%m/%d/%Y').strftime('%Y-%m-%d'))
#other script here that works well as part of a for loop
print(outRow)
writer.writerow(outRow)
我的日期在一个.csv文件中,文本如下所示:“11/19/2017” 我想要这样的格式:“2017-11-19”。不知道我做错了什么?在
我已经读了大约5遍了,但仍然不确定它为什么会给我错误: https://docs.python.org/2/library/datetime.html
csv文件示例:
^{pr2}$
在列表的底部有一行使文件崩溃。。。更正如下:
相关问题 更多 >
编程相关推荐