Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Date in auto model

Hello everyone,

I noticed that every time i run an auto model with a dataset having date as a variable(column) it doesn't include it in the prediction or the classification, even if check its format as date-time format, but nothing works.

I hope that you can help me with this problem, because i really need the model to take the date colunm in consideration.

Thank you.

Find more posts tagged with

AI Studio

Auto Model

Accepted answers

IngoRM

Hi,

You are right, date columns are currently not used in Auto Model. But here is what you can do (and typically get better results by doing this):

Go to the Process view
Build a simple data prep process there where you load your data set (containing the date column), extract some meaningful information (see next point), and store the final result in your repository again. Run this process.
Use the operator "Date to Numerical" and extract meaningful new features from your date column. Those could be things like "Month of the Year", "Day of the Week", "Quarter", "Calendar Week" etc. Only you know what makes most sense for your application.
Run Auto Model on this transformed data set with the extracted information.

Hope this helps,

Ingo

All comments

IngoRM

Hi,

You are right, date columns are currently not used in Auto Model. But here is what you can do (and typically get better results by doing this):

Go to the Process view
Build a simple data prep process there where you load your data set (containing the date column), extract some meaningful information (see next point), and store the final result in your repository again. Run this process.
Use the operator "Date to Numerical" and extract meaningful new features from your date column. Those could be things like "Month of the Year", "Day of the Week", "Quarter", "Calendar Week" etc. Only you know what makes most sense for your application.
Run Auto Model on this transformed data set with the extracted information.

Hope this helps,

Ingo

data1maths

Thank you so much Mr Ingo for your help.