如何从一个CSV写入到HDF5,以及读?
path= "C:\\Users\\Administrator\\Desktop\\SH600000.csv";
data =readcsv(path)
path_hdf5= "C://Users//Administrator//Desktop//SH6.h5"
下面是data的数据结构:
data[:,3:end]不能直接写入到HDF5, 需要进行相应的数据转换,data[:,3:end]不能h5write.因为视为Array{Any,2}.即Matrix Any .而不是Matrix Float64.
(row,col) =size(data)
dat =Array(Float64,row,col-2)
for i =1:row # 最好以列为先,速度会更快一些。
for j =1:col-2
dat[i,j] =data[i,j+2]
end
end
写和读。
h5write(path_hdf5,"mygroup/SH600000",dat)
D=h5read(path_hdf5,"mygroup/SH600000")