讀取sh600004.csv文件，第二列是時(shí)間，格式是年-月-日。下面的代碼變量ddate存儲(chǔ)讀出的時(shí)間。
import numpy as np
import matplotlib.dates as mdates
ddate,dopen = np.loadtxt('sh600004.csv', delimiter=',', skiprows=1,converters={0:mdates.strpdate2num('%Y-%m-%d')}, usecols= (1,2), unpack=True)
報(bào)錯(cuò)信息：
ValueError: could not convert string to float: b'2014-12-31'
2 回答
BIG陽(yáng)
TA貢獻(xiàn)1859條經(jīng)驗(yàn) 獲得超6個(gè)贊
python3
import numpy as np
import matplotlib.dates as mdates
data = '''code date open high low close change volume money traded_market_value market_value turnover adjust_price report_type report_date PE_TTM PS_TTM PC_TTM PB
sh600004 2014/12/31 10.8 10.94 10.7 10.93 0.013915 19707899 213624420 12569500000 12569500000 0.017137303 12.13 2014/9/30 00:00 2014/10/30 00:00 12.88897481 2.317142523 7.472838539 1.561138066
sh600004 2014/12/30 11.18 11.26 10.65 10.78 -0.041778 25075183 273427007 12397000000 12397000000 0.021804507 11.96 2014/9/30 00:00 2014/10/30 00:00 12.71208613 2.285341989 7.370281078 1.53971296
'''
open('sh600004.csv','w').write(data)
ddate,dopen = np.loadtxt('sh600004.csv', delimiter=' ', skiprows=1,
converters={1:mdates.bytespdate2num('%Y/%m/%d')},
usecols= (1,2), unpack=True)
print((ddate,dopen))(array([ 735598., 735597.]), array([ 10.8 , 11.18]))添加回答
舉報(bào)
0/150
提交
取消