Here is my situation: 我目前有一个看起来像这样的数据表:
Symbol Date Time Sequence Type
---------------------------------------------------------------------------
A 2013.06.06 20:00:00.137 36654383 BestAsk
A 2013.06.06 20:00:00.137 36654383 BestBid
A 2013.06.07 04:00:00.788 3 BestAsk
A 2013.06.07 04:00:00.788 3 BestBid
A 2013.06.07 04:00:00.788 3 BestAsk
A 2013.06.07 04:00:00.788 3 BestBid
A 2013.06.07 07:01:09.584 43126 BestAsk
A 2013.06.07 07:01:09.584 43126 BestBid
A 2013.06.07 07:02:09.012 43431 BestAsk
A 2013.06.07 07:02:09.012 43431 BestBid
如您所知,行成对出现 . 每个BestAsk和BestBid行具有相同的符号日期时间和序列 . 因为它们都很好地排序,我认为行可以与它们的顺序相关联,但是我看到的所有连接命令只组合了列(aj,aj0等) . 我尝试将表格翻转成字典,然后以字典形式组合,但一直不成功 .
What I am looking for in the result is that the identical values Symbol Date Time Sequence don't have to be duplicated but in the Type column, show BestAsk and BestBid :
Symbol Date Time Sequence Type
---------------------------------------------------------------------------
A 2013.06.06 20:00:00.137 36654383 BestAsk,BestBid
A 2013.06.07 04:00:00.788 3 BestAsk,BestBid
A 2013.06.07 04:00:00.788 3 BestAsk,BestBid
A 2013.06.07 07:01:09.584 43126 BestAsk,BestBid
A 2013.06.07 07:02:09.012 43431 BestAsk,BestBid
这样的话,谢谢!
1 回答
或使用xgroup