Parsing a file with dates to datetim64
Hey,
I have a file:
;;;;;;;;;Eintrittsdatum;;;
;;;;;;;;;04.03.16;;10,00 €;genehmigt
;;;;;;;;;04.03.16;;10,00 €;genehmigt
which I try to parse using
def dateToNumpyDate(s):
s = s.decode("utf-8")
ret = datetime.datetime.strptime(s, "%d.%m.%y").isoformat()
return ret
def generateMembers():
members = np.genfromtxt("test_CSC_Mitglieder.csv",
dtype = { "names" : ["EntryDate"],
"formats" : ['datetime64[D]'] },
converters = { 9 : dateToNumpyDate },
skip_header = 1,
delimiter = ";",
usecols = (9))
count = members.shape[0]
y = np.linspace(1, count, count)
print(members)
print(members.dtype)
plt.plot(members["EntryDate"], y)
plt.show()
but the datatype was ignored homehow,
participants (1)
-
Florian Lindner