dateinterval()
Here are how to use dateinterval() functions.
A.dateinterval()
Description:
The external library function (See External Library Guide) generates multiple date difference variables for a datetime sequence/table sequence variable.
Syntax:
|
A.dateinterval(T) |
During modeling, generate multiple date difference variables for a sequence of datetime variables and return a binary sequence where the first bit is a table sequence made up of all the derivative variables and the second bit is generation process records Rec; the derivative variables automatically perform subsequent pre-processing |
|
A.dateinterval@r(Rec) |
During scoring, generate a table sequence consisting of multiple date difference variables according to sequence A of datetime variables and generation process records Rec |
Parameter:
|
A |
A sequence, which is a datetime variable |
|
T |
The target variable value used to perform potential data smoothing |
|
Rec |
A sequence of generation process records |
Option:
|
@bnie |
Each option specifies a target type, and options are mutual-exclusive; automatically judge the type when no option is used; the order of priorities of the options is binary, numeric, integer and enumerated |
Return value:
A sequence/table sequence
Example:
|
|
A |
|
|
1 |
=T("D: //catering_sale.csv").run(date1=date(date1,"yyyy/MM/dd"),date2=date(date2,"yyyy/MM/dd")) |
|
|
2 |
=[A1.(date1),A1.(date2)] |
A sequence of datetime variables |
|
3 |
=A1.(sales) |
The target variable |
|
4 |
=A2.dateinterval@n(A3) |
A4(1) A table sequence of derivative variables A4(2) Generation process records Rec @n specifies the target variable as numeric |
|
5 |
=A2.dateinterval@r(A4(2)) |
Generate date difference variables for A2 according to A4’s generation process records Rec |
P.dateinterval()
Description:
The external library function (See External Library Guide) generates multiple date difference variables for a datetime table sequence/record sequence variable.
Syntax:
|
P.dateinterval(cns, T) |
During modeling, generate multiple date difference variables for sequence cns of datetime variables and return a binary sequence where the first bit is a table sequence made up of all the derivative variables and the second bit is generation process records Rec; the derivative variables automatically perform subsequent pre-processing |
|
P.dateinterval@r(cns, Rec) |
During scoring, generate a table sequence consisting of multiple date difference variables according to sequence cns of datetime variables and generation process records Rec |
Parameter:
|
P |
A table sequence/record sequence |
|
cns |
A sequence of names of columns ( or column numbers starting from 1) of a record sequence |
|
T |
A sequence of target variable values used to perform potential data smoothing |
|
Rec |
A sequence of generation process records |
Option:
|
@bnie |
Each option specifies a target type, and options are mutual-exclusive; automatically judge the type when no option is used; the order of priorities of the options is binary, numeric, integer and enumerated |
Return value:
A sequence/table sequence
Example:
|
|
A |
|
|
1 |
=T("D: //catering_sale.csv").run(date1=date(date1,"yyyy/MM/dd"),date2=date(date2,"yyyy/MM/dd")) |
|
|
2 |
=A1.(sales) |
|
|
3 |
=A1.dateinterval@n(["date1","date2"],A2) |
Generate difference between “date1” and “date2”, and perform smoothing according to target variable A2 A3(1) A table sequence of derivative variables A3(2) Generation process records Rec |
|
4 |
=A1.dateinterval@r(["date1","date2"],A3(2)) |
Generate multiple difference variables between “date1” and “date2” according to A3’s generation process records Rec |