可以以表1作为最终结果模板,因为表1除了Timestamp列均为空,可以将表1比表2多出来的列取出,再添加到表2,并调整顺序。
示例代码如下:
Timestamp = 2014.01.06T09:30:03.000 2014.01.06T09:30:06.000 2014.01.06T09:30:09.000 2014.01.06T09:30:12.000 2014.01.06T09:30:15.000 2014.01.06T09:30:18.000 2014.01.06T09:30:21.000 2014.01.06T09:30:24.000 2014.01.06T09:30:27.000 2014.01.06T09:30:30.000 t1 = table(Timestamp) t1.addColumn(`SH600000, DOUBLE) t1.addColumn(`SH600519, DOUBLE) t1.addColumn(`SH600001, DOUBLE) Timestamp = 2014.01.06T09:30:03.000 2014.01.06T09:30:06.000 2014.01.06T09:30:09.000 2014.01.06T09:30:12.000 2014.01.06T09:30:15.000 2014.01.06T09:30:18.000 2014.01.06T09:30:21.000 2014.01.06T09:30:24.000 2014.01.06T09:30:27.000 2014.01.06T09:30:30.000 SH600000 = 9.3 9.34 9.34 9.31 9.31 9.3 9.3 9.3 9.31 9.29 SH600519 = 122.88 122.88 122.88 122.88 122.88 122.88 122.80 122.80 122.80 122.80 t2 = table(Timestamp, SH600000, SH600519) cols_missing = t1.colNames()[not t1.colNames() in t2.colNames()] t2.addColumn(cols_missing, take(DOUBLE, cols_missing.size())) t2.reorderColumns!(t1.colNames())