Java 类名：com.alibaba.alink.operator.batch.timeseries.LookupValueInTimeSeriesBatchOp
Python 类名：LookupValueInTimeSeriesBatchOp

功能介绍

在时间序列中查找对应时间的值。

注意事项

  • 时间序列列，是特殊的MTable类型，一列是时间，一列是值，参考运行结果的data列。
  • 查找的时间在数据列中不存在时，用相邻时刻的值差值得到结果。

    参数说明

    | 名称 | 中文名称 | 描述 | 类型 | 是否必须？ | 取值范围 | 默认值 | | —- | —- | —- | —- | —- | —- | —- |

| outputCol | 输出结果列列名 | 输出结果列列名，必选 | String | ✓ | | |

| timeCol | 时间戳列(TimeStamp) | 时间戳列(TimeStamp) | String | ✓ | 所选列类型为 [TIMESTAMP] | |

| timeSeriesCol | 时间序列列 | 时间序列列，是特殊的MTable类型，一列是时间，一列是值 | String | ✓ | 所选列类型为 [M_TABLE] | |

| reservedCols | 算法保留列名 | 算法保留列 | String[] | | | null |

| numThreads | 组件多线程线程个数 | 组件多线程线程个数 | Integer | | | 1 |

代码示例

Python 代码

  1. from pyalink.alink import *
  3. import pandas as pd
  5. useLocalEnv(1)
  7. import time, datetime
  8. import numpy as np
  9. import pandas as pd
  11. data = pd.DataFrame([
  12.             [1,  datetime.datetime.fromtimestamp(1), 10.0],
  13.             [1,  datetime.datetime.fromtimestamp(2), 11.0],
  14.             [1,  datetime.datetime.fromtimestamp(3), 12.0],
  15.             [1,  datetime.datetime.fromtimestamp(4), 13.0],
  16.             [1,  datetime.datetime.fromtimestamp(5), 14.0],
  17.             [1,  datetime.datetime.fromtimestamp(6), 15.0],
  18.             [1,  datetime.datetime.fromtimestamp(7), 16.0],
  19.             [1,  datetime.datetime.fromtimestamp(8), 17.0],
  20.             [1,  datetime.datetime.fromtimestamp(9), 18.0],
  21.             [1,  datetime.datetime.fromtimestamp(10), 19.0]
  22. ])
  24. source = dataframeToOperator(data, schemaStr='id int, ts timestamp, val double', op_type='batch')
  26. source.link(
  27.         GroupByBatchOp()
  28.             .setGroupByPredicate("id")
  29.             .setSelectClause("id, mtable_agg(ts, val) as data")
  30.         ).link(
  31.             ShiftBatchOp()
  32.                     .setValueCol("data")
  33.                     .setShiftNum(7)
  34.                     .setPredictNum(12)
  35.                     .setPredictionCol("predict")
  36.         ).link(
  37.             FlattenMTableBatchOp()
  38.                     .setReservedCols(["id", "predict"])
  39.                     .setSelectedCol("predict")
  40.                     .setSchemaStr("ts timestamp, val double")
  41.         ).link(
  42.             LookupValueInTimeSeriesBatchOp()
  43.                 .setTimeCol("ts")
  44.                 .setTimeSeriesCol("predict")
  45.                 .setOutputCol("out")
  46.                 .setReservedCols(["id","ts"])
  47.         ).print()

Java 代码

  1. package com.alibaba.alink.operator.batch.timeseries;
  3. import org.apache.flink.types.Row;
  5. import com.alibaba.alink.common.MTable;
  6. import com.alibaba.alink.operator.batch.source.MemSourceBatchOp;
  7. import org.junit.Test;
  9. import java.sql.Timestamp;
  10. import java.util.Arrays;
  11. import java.util.List;
  13. public class LookupValueInTimeSeriesBatchOpTest {
  14.     @Test
  15.     public void test() throws Exception {
  17.         List <Row> mTableData = Arrays.asList(
  18.             Row.of(new Timestamp(1), 10.0),
  19.             Row.of(new Timestamp(2), 11.0),
  20.             Row.of(new Timestamp(3), 12.0),
  21.             Row.of(new Timestamp(4), 13.0),
  22.             Row.of(new Timestamp(5), 14.0),
  23.             Row.of(new Timestamp(6), 15.0),
  24.             Row.of(new Timestamp(7), 16.0),
  25.             Row.of(new Timestamp(8), 17.0),
  26.             Row.of(new Timestamp(9), 18.0),
  27.             Row.of(new Timestamp(10), 19.0)
  28.         );
  30.         MTable mtable = new MTable(mTableData, "ts timestamp, val double");
  32.         MemSourceBatchOp source = new MemSourceBatchOp(
  33.             new Object[][] {
  34.                 {1, new Timestamp(5), mtable}
  35.             },
  36.             new String[] {"id", "ts", "data"});
  38.         source
  39.             .link(new LookupValueInTimeSeriesBatchOp()
  40.                 .setTimeCol("ts")
  41.                 .setTimeSeriesCol("data")
  42.                 .setOutputCol("out")
  43.                 .setReservedCols("id","ts")
  44.             )
  45.             .print();
  46.     }
  47. }

运行结果

| id | ts | data | out | | —- | —- | —- | —- |

| 1 | 1970-01-01 08:00:00.005 | MTable(10,2)(ts,val)
1970-01-01 08:00:00.001 | 10.000
1970-01-01 08:00:00.002 | 11.000
1970-01-01 08:00:00.003 | 12.000
1970-01-01 08:00:00.004 | 13.000
1970-01-01 08:00:00.005 | 14.000 | 14.0000 |