Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Date in auto model
data1maths
Member Posts: 27 
Contributor II
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.
Tagged:
0
Best Answer
-
IngoRM
Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 
RM Founder
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
2
Answers
Thank you so much Mr Ingo for your help.