Options
Changing attribute type from polynomial to date
Newbie
Hi,
I have an attribute in my dataset that records dates. On the Excel files I'm importing, the values are formatted as dates but when I import them into RapidMiner, some stay as dates while others get identified as polynomials.
I tried using the nominal to date operator but because some values are actually dates, they become numbers that cannot become dates. For example, the date 9/10/2019 becomes 43718 and when I use the operator, it is unable to parse that number since it's not in the same format.
How can I fix this?
I have an attribute in my dataset that records dates. On the Excel files I'm importing, the values are formatted as dates but when I import them into RapidMiner, some stay as dates while others get identified as polynomials.
I tried using the nominal to date operator but because some values are actually dates, they become numbers that cannot become dates. For example, the date 9/10/2019 becomes 43718 and when I use the operator, it is unable to parse that number since it's not in the same format.
0
Best Answer
-
Options
MarcoBarradas
Administrator, Employee, RapidMiner Certified Analyst, Member Posts: 272 
Unicorn
Hi @Ritika
It seem that excel stored the date on their own format.
Please read this thread that would help you.
https://community.rapidminer.com/discussion/54654/converting-excel-numerical-dates-to-rapidminer-date-time-attributes
0
Answers
Thank you so much!