Changing attribute type from polynomial to date
Ritika
New Altair Community Member
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.
Tagged:
0
Best Answer
-
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/54189/converting-excel-numerical-dates-to-rapidminer-date-time-attributes
0
Altair EmployeeAnswers
-
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/54189/converting-excel-numerical-dates-to-rapidminer-date-time-attributes
0 -
Hi Marco,
Thank you so much!0