Changing Data in Rapidminer

SimonW18272

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

ceaperez

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, 

Cesar

SimonW18272

Thanks a lot!