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

功能介绍

指定模型(通过ProphetTrainBatchOp训练得到),对每一行的MTable数据, 进行Prophet时间序列预测，给出下一时间段的预测结果。

算法原理

Prophet是facebook开源的一个时间序列预测算法, github地址：https://github.com/facebook/prophet.
Prophet适用于具有明显的内在规律的数据, 例如：

  • 有一定的历史数据，有至少几个月的每小时、每天或每周观察的历史数据
  • 有较强的季节性趋势：每周的一些天，每年的一些时间
  • 有已知的以不定期的间隔发生的重要节假日（比如国庆节）
  • 缺失的历史数据或较大的异常数据的数量在合理范围内
  • 对于数据中蕴含的非线性增长的趋势都有一个自然极限或饱和状态

    使用方式

    参考文档 https://www.yuque.com/pinshu/alink_guide/xbp5ky

    参数说明

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

| predictionCol | 预测结果列名 | 预测结果列名 | String | ✓ | | |

| valueCol | value列，类型为MTable | value列，类型为MTable | String | ✓ | 所选列类型为 [M_TABLE] | |

| modelFilePath | 模型的文件路径 | 模型的文件路径 | String | | | null |

| predictNum | 预测条数 | 预测条数 | Integer | | | 1 |

| predictionDetailCol | 预测详细信息列名 | 预测详细信息列名 | String | | | |

| pythonEnv | Python 环境路径 | Python 环境路径，一般情况下不需要填写。如果是压缩文件，需要解压后得到一个目录，且目录名与压缩文件主文件名一致，可以使用 http://, https://, oss://, hdfs:// 等路径；如果是目录，那么只能使用本地路径，即 file://。 | String | | | “” |

| 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. downloader = AlinkGlobalConfiguration.getPluginDownloader()
  12. downloader.downloadPlugin('tf115_python_env_linux')
  14. data = pd.DataFrame([
  15.             [1,  datetime.datetime.fromtimestamp(1), 10.0],
  16.             [1,  datetime.datetime.fromtimestamp(2), 11.0],
  17.             [1,  datetime.datetime.fromtimestamp(3), 12.0],
  18.             [1,  datetime.datetime.fromtimestamp(4), 13.0],
  19.             [1,  datetime.datetime.fromtimestamp(5), 14.0],
  20.             [1,  datetime.datetime.fromtimestamp(6), 15.0],
  21.             [1,  datetime.datetime.fromtimestamp(7), 16.0],
  22.             [1,  datetime.datetime.fromtimestamp(8), 17.0],
  23.             [1,  datetime.datetime.fromtimestamp(9), 18.0],
  24.             [1,  datetime.datetime.fromtimestamp(10), 19.0]
  25. ])
  27. source = dataframeToOperator(data, schemaStr='id int, ts timestamp, val double', op_type='batch')
  29. prophetModel = source.link(\
  30.                     ProphetTrainBatchOp()\
  31.                         .setTimeCol("ts")\
  32.                         .setValueCol("val")
  33.                 )
  35. ProphetPredictBatchOp()\
  36.     .setValueCol("data")\
  37.     .setPredictNum(4)\
  38.     .setPredictionCol("pred")\
  39.     .linkFrom(
  40.          prophetModel,
  41.          source.link(\
  42.             GroupByBatchOp()\
  43.                 .setGroupByPredicate("id")\
  44.                 .setSelectClause("id, mtable_agg(ts, val) as data")
  45.             )
  46.     )\
  47.     .print()

Java 代码

  1. package com.alibaba.alink.operator.batch.timeseries;
  3. import org.apache.flink.types.Row;
  5. import com.alibaba.alink.common.AlinkGlobalConfiguration;
  6. import com.alibaba.alink.operator.batch.sql.GroupByBatchOp;
  7. import com.alibaba.alink.operator.batch.source.MemSourceBatchOp;
  8. import org.junit.Test;
  10. import java.sql.Timestamp;
  11. import java.util.Arrays;
  13. public class ProphetBatchOpTest {
  15.     @Test
  16.     public void testModel() throws Exception {
  17.         Row[] rowsData =
  18.             new Row[] {
  19.                 Row.of("1", new Timestamp(117, 11, 1, 0, 0, 0, 0), 9.59076113897809),
  20.                 Row.of("1", new Timestamp(117, 11, 2, 0, 0, 0, 0), 8.51959031601596),
  21.                 Row.of("2", new Timestamp(117, 11, 3, 0, 0, 0, 0), 9.59076113897809),
  22.                 Row.of("1", new Timestamp(117, 11, 4, 0, 0, 0, 0), 8.18367658262066),
  23.                 Row.of("2", new Timestamp(117, 11, 5, 0, 0, 0, 0), 8.51959031601596),
  24.                 Row.of("1", new Timestamp(117, 11, 6, 0, 0, 0, 0), 8.07246736935477),
  25.                 Row.of("2", new Timestamp(117, 11, 7, 0, 0, 0, 0), 8.18367658262066),
  26.                 Row.of("2", new Timestamp(117, 11, 8, 0, 0, 0, 0), 8.18367658262066),
  27.                 Row.of("2", new Timestamp(117, 11, 9, 0, 0, 0, 0), 8.18367658262066),
  28.                 Row.of("2", new Timestamp(117, 11, 10, 0, 0, 0, 0), 8.18367658262066),
  29.                 Row.of("2", new Timestamp(117, 11, 11, 0, 0, 0, 0), 8.18367658262066),
  30.                 Row.of("2", new Timestamp(117, 11, 12, 0, 0, 0, 0), 8.18367658262066),
  31.                 Row.of("2", new Timestamp(117, 11, 13, 0, 0, 0, 0), 8.18367658262066),
  32.                 Row.of("2", new Timestamp(117, 11, 14, 0, 0, 0, 0), 8.18367658262066),
  33.                 Row.of("1", new Timestamp(117, 11, 15, 0, 0, 0, 0), 7.8935720735049),
  34.                 Row.of("1", new Timestamp(117, 11, 16, 0, 0, 0, 0), 7.78364059622125),
  35.                 Row.of("2", new Timestamp(117, 11, 17, 0, 0, 0, 0), 8.07246736935477),
  36.                 Row.of("1", new Timestamp(117, 11, 18, 0, 0, 0, 0), 8.41405243249672),
  37.                 Row.of("1", new Timestamp(117, 11, 19, 0, 0, 0, 0), 8.82922635473185),
  38.                 Row.of("1", new Timestamp(117, 11, 20, 0, 0, 0, 0), 8.38251828808963),
  39.                 Row.of("1", new Timestamp(117, 11, 21, 0, 0, 0, 0), 8.06965530688617),
  40.                 Row.of("1", new Timestamp(117, 11, 22, 0, 0, 0, 0), 9.59076113897809),
  41.                 Row.of("1", new Timestamp(117, 11, 23, 0, 0, 0, 0), 8.51959031601596),
  42.                 Row.of("1", new Timestamp(117, 11, 24, 0, 0, 0, 0), 8.18367658262066),
  43.                 Row.of("1", new Timestamp(117, 11, 25, 0, 0, 0, 0), 8.07246736935477),
  44.                 Row.of("1", new Timestamp(117, 11, 26, 0, 0, 0, 0), 7.8935720735049),
  45.                 Row.of("1", new Timestamp(117, 11, 27, 0, 0, 0, 0), 7.78364059622125),
  46.                 Row.of("1", new Timestamp(117, 11, 28, 0, 0, 0, 0), 8.41405243249672),
  47.                 Row.of("1", new Timestamp(117, 11, 29, 0, 0, 0, 0), 8.82922635473185),
  48.                 Row.of("1", new Timestamp(117, 12, 1, 0, 0, 0, 0), 8.38251828808963),
  49.                 Row.of("1", new Timestamp(117, 12, 2, 0, 0, 0, 0), 8.06965530688617),
  50.                 Row.of("2", new Timestamp(117, 12, 3, 0, 0, 0, 0), 8.07246736935477),
  51.                 Row.of("2", new Timestamp(117, 12, 4, 0, 0, 0, 0), 7.8935720735049),
  52.                 Row.of("2", new Timestamp(117, 12, 5, 0, 0, 0, 0), 7.78364059622125),
  53.                 Row.of("2", new Timestamp(117, 12, 6, 0, 0, 0, 0), 8.41405243249672),
  54.                 Row.of("2", new Timestamp(117, 12, 7, 0, 0, 0, 0), 8.82922635473185),
  55.                 Row.of("2", new Timestamp(117, 12, 8, 0, 0, 0, 0), 8.38251828808963),
  56.                 Row.of("2", new Timestamp(117, 12, 9, 0, 0, 0, 0), 8.06965530688617)
  57.             };
  58.         String[] colNames = new String[] {"id", "ts", "val"};
  60.         //train batch model.
  61.         MemSourceBatchOp source = new MemSourceBatchOp(Arrays.asList(rowsData), colNames);
  63.         ProphetTrainBatchOp model = new ProphetTrainBatchOp()
  64.             .setTimeCol("ts")
  65.             .setValueCol("val");
  67.         source.link(model).print();
  69.         //construct times series by id.
  70.         GroupByBatchOp groupData = new GroupByBatchOp()
  71.             .setGroupByPredicate("id")
  72.             .setSelectClause("mtable_agg(ts, val) as data");
  74.         ProphetPredictBatchOp prophetPredict = new ProphetPredictBatchOp()
  75.             .setValueCol("data")
  76.             .setPredictNum(4)
  77.             .setPredictionCol("pred");
  79.         prophetPredict.linkFrom(model, source.link(groupData)).print();
  80.     }
  81. }

运行结果

| id | data | predict | | —- | —- | —- |

| 1 | {“data”:{“ts”:[“1970-01-01 08:00:00.001”,”1970-01-01 08:00:00.002”,”1970-01-01 08:00:00.003”,”1970-01-01 08:00:00.004”,”1970-01-01 08:00:00.005”,”1970-01-01 08:00:00.006”,”1970-01-01 08:00:00.007”,”1970-01-01 08:00:00.008”,”1970-01-01 08:00:00.009”,”1970-01-01 08:00:00.01”],”val”:[10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0]},”schema”:”ts TIMESTAMP,val DOUBLE”} | {“data”:{“ts”:[“1970-01-01 08:00:00.011”,”1970-01-01 08:00:00.012”,”1970-01-01 08:00:00.013”,”1970-01-01 08:00:00.014”,”1970-01-01 08:00:00.015”,”1970-01-01 08:00:00.016”,”1970-01-01 08:00:00.017”,”1970-01-01 08:00:00.018”,”1970-01-01 08:00:00.019”,”1970-01-01 08:00:00.02”,”1970-01-01 08:00:00.021”,”1970-01-01 08:00:00.022”],”val”:[20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0]},”schema”:”ts TIMESTAMP,val DOUBLE”} |

t