早上好，我對Python真的很陌生，我正在嘗試將數(shù)據(jù)時間加載到Python中。我找到了各種選項，但沒有一個能夠正確解決問題。我看到這段代碼，但它顯然不起作用，“因為 strptime () 恰好需要 2 個參數(shù)（給定 1 個）”from datetime import datetimedata2012 = numpy.loadtxt("C:\\Users\\...\\onde_corr_2012.txt", converters={0:datetime.strptime('%m/%d/%y %H:%M:%S')}, delimiter=',')txt 文件的結(jié)構(gòu)如下：01-01-2012 00:00,0.36,-3.42,0.7601-01-2012 00:30,0.35,-3.45,0.7501-01-2012 01:00,0.35,-3.42,0.7601-01-2012 01:30,0.36,-3.43,0.7601-01-2012 02:00,0.36,-3.44,0.75...
1 回答
嚕嚕噠
TA貢獻(xiàn)1784條經(jīng)驗 獲得超7個贊
嘗試：
from datetime import datetime
data2012 = np.loadtxt("try.txt", converters={0:lambda t: datetime.strptime(t.decode(), '%m-%d-%Y %H:%M')}, delimiter=','
, dtype={
'names': ('time', 'col1', 'col2', 'col3',),
'formats': ('datetime64[m]', 'float', 'float', 'float')
}
)
data2012
array([('2012-01-01T00:00', 0.36, -3.42, 0.76),
('2012-01-01T00:30', 0.35, -3.45, 0.75),
('2012-01-01T01:00', 0.35, -3.42, 0.76),
('2012-01-01T01:30', 0.36, -3.43, 0.76),
('2012-01-01T02:00', 0.36, -3.44, 0.75)],
dtype=[('time', '<M8[m]'), ('col1', '<f8'), ('col2', '<f8'), ('col3', '<f8')])
或者：
df = pd.read_csv("try.txt", header=None, date_parser=[0])
df
0 1 2 3
0 01-01-2012 00:00 0.36 -3.42 0.76
1 01-01-2012 00:30 0.35 -3.45 0.75
2 01-01-2012 01:00 0.35 -3.42 0.76
3 01-01-2012 01:30 0.36 -3.43 0.76
4 01-01-2012 02:00 0.36 -3.44 0.75
- 1 回答
- 0 關(guān)注
- 132 瀏覽
添加回答
舉報
0/150
提交
取消