怎么导入含有array vector的csv文件

请教下下面这种格式的csv可以解析成Double[]类型吗?

attachments-2024-03-ne46hRNd65fd0357ef535.png

样例数据是如这个附件data.csv

请先 登录 后评论

1 个回答

wale

请参考下面demo:

login(`admin,`123456)
path = getHomeDir()+"/data.csv"
schema = extractTextSchema(path)
update schema set type = "DOUBLE[]" where name in ["bidPrice","bidOrderQty","bidNumOrders","offerPrice","offerOrderQty","offerNumOrders"]
t=loadText(path,schema=schema,arrayDelimiter="|")
请先 登录 后评论