time function in the Factory
The time function composes a time starting from hours, minutes and seconds strings.
While the hour function extracts the time from a datetime attribute, the time function builds the time by merging strings coming from different columns.
Parameters Parameter Description hour The attribute containing the hour as an integer number. The hour parameter is mandatory. minute The attribute containing the minute as an integer number. second The attribute containing the second as a continuous number. Integer type valid formats (if the values aren’t this format, the function will return an error). 45; -44 Continuous type valid formats (if the values aren’t this format, the function will return an error). 34.000; 34563.876 Example The following example uses the Instagram_data dataset. Description Screenshot In this example, we want to create a new attribute which merges the Hour and Minute attributes. We add a new attribute, called Time, and type the following formula: and the attribute is filled with the time. time(hour, minute, second)
time($"Hour",$"Minute")