表转为矩阵,如何补全缺少的股票?

比如,一张表4600只股票,有个向量股票4740只,希望转为矩阵之后股票列为4740个。

请先 登录 后评论

2 个回答

Juntao Wang

示例代码:

t = table(2022.07.04T09:45:00 2022.07.04T09:45:00 2022.07.04T09:45:00 2022.07.04T09:45:00 as time, `A`B`C`D as sym, 1.0 2.0 3.0 4.0 as value)
syms = `A`B`C`D`E`F
symsTmp = syms[not syms in (exec sym from t)]
insert into t(sym) values(symsTmp)
select value from t pivot by time, sym
请先 登录 后评论
mhxiang
cols=[`a,`f,`b,`c,`d,`e]
tb=table(rand(1.0,10) as a,rand(10.0,10) as d,rand(100.0,10) as c )
for (icol in (set(cols)-set(colNames(tb))).keys()){
	tb[icol]=double()
	}

reorderColumns!(tb,cols)
m=matrix(tb).rename!(cols)

attachments-2022-07-AdOroxhu62c526eb65d5c.png

请先 登录 后评论