擅长:python、mysql、java
<p>我不知道您希望丢失的数据是什么,但此代码将日期列转换为datetime.date日期将缺少的值设置为NaN时。你知道吗</p>
<pre class="lang-py prettyprint-override"><code>import numpy as np
import datetime
def convert_iso_string_to_date(s):
year, month, day = (int(x) for x in s.decode("ascii").split("-"))
return datetime.date(year, month, day)
data = np.genfromtxt("test.txt", delimiter=",", converters={0: convert_iso_string_to_date}, invalid_raise=True, usemask=False)
print(data)
</code></pre>
<pre><code>[(datetime.date(2000, 1, 5), nan, -0.8803937, nan, nan, nan, nan, nan, nan, -0.83160235, nan)
(datetime.date(2000, 1, 6), nan, nan, nan, nan, nan, nan, nan, nan, nan, nan)
(datetime.date(2000, 1, 7), nan, nan, nan, nan, nan, nan, nan, nan, -0.31339761, nan)
(datetime.date(2000, 1, 10), -0.26878028, nan, nan, nan, nan, nan, nan, nan, nan, nan)
(datetime.date(2000, 1, 11), nan, nan, nan, nan, nan, nan, nan, 1.07872957, nan, nan)]
</code></pre>