Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
140 views
in Technique[技术] by (71.8m points)

表的一行数据怎么转换成vector

我在dolphindb database中有一个n*m的table,然后我单独取一行,这一行我能转成vector吗?
举例说明,假如我有个一个表如下:

sym = `C`MS`MS`MS`IBM`IBM`C`C`C$SYMBOL 
price= 49.6 29.46 29.52 30.02 174.97 175.23 50.76 50.32 51.29
qty = 2200 1900 2100 3200 6800 5400 1300 2500 8800           
timestamp = [09:34:07,09:35:42,09:36:51,09:36:59,09:35:47,09:36:26,09:34:16,09:35:26,09:36:12]
t = table(timestamp, sym, qty, price);    

表的数据如下图所示:
image.png
现在我想得到某一行的数据,比如图中绿框圈中的第一行,请问有什么办法把它转成vector?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

如果要取一个表t的某一行,可以使用t[i],其中i是从0开始的行号。t[i]返回一个字典。如果要进一步获取所有的值,可以使用t[i].values()

sym = `C`MS`MS`MS`IBM`IBM`C`C`C$SYMBOL                       
price= 49.6 29.46 29.52 30.02 174.97 175.23 50.76 50.32 51.29 
qty = 2200 1900 2100 3200 6800 5400 1300 2500 8800          
timestamp = [09:34:07,09:35:42,09:36:51,09:36:59,09:35:47,09:36:26,09:34:16,09:35:26,09:36:12]
t = table(timestamp, sym, qty, price)

t[0].values()

如果要保证输出的tuple的元素的顺序,改成

t[0][`timestamp`sym`qty`price]

or

t[0][t.columnNames()]

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...