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 Data in Rapidminer
SimonW18272
Member Posts: 13 
Learner I
in Help
Hello everyone,
I am currently working with rapidminer and I got a question for which i didnt find any helpful information yet.
For preparing my data I have a huge Excel file which i uploaded in Rapidminer. Since I want to analyse the data I need some new rows which I would like to create in Rapidminer. For example I have two rows with "Start date" and "End date" in these files and I would like to create a row in rapidminer which is
Duration = "Start date" - "End date"
or also for example I have data with the price and the currency which is different each line so I would need a join 2 tables where one is data with the currency and the other with the exchange rate so that i can create
worth in USD = amount * exchange rate
Could you help me with that?
Thanks so much
0
Best Answer
-
ceaperez
Member Posts: 541 
Unicorn
Hi @SimonW18272,
please take a look at the Generate Attribute operator.
https://academy.rapidminer.com/learn/video/generate-attributes
With this operator you can create new attributes, like the ones you need, and you have interesting functions with dates and text here, and many more.
Best,
Cesar2
Answers