The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Changing attribute type from polynomial to date
Learner I
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
-
MarcoBarradas
Administrator, Employee-RapidMiner, 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!