RapidMiner 9.7 is Now Available
Lots of amazing new improvements including true version control! Learn more about what's new here.
Calculate between two datasets with different attributes
I want to calculate fields from two datasets / .csv Files together.
The attributes from the two datasets are completely different.
In one dataset there are a few animals stored with the information of their weights (in gram) and the other dataset contains the price per gram.
I want to multiply every "weight" field from the first dataset with the "price" field from the second dataset.
As a result I want to get the price for the animal included in the first dataset.
See example for hopefully better understanding:
ID, Animal Name, Animal weight in gram
1, Dog, 1500
2, Cat, 800
3, Frog, 100
ID, Price per gram
RESULT included in the first dataset:
ID, Animal Name, Animal weight in gram, Price
1, Dog, 1500, 22.5
2, Cat, 800, 12
3, Frog, 100, 1.5
Thanks in advance for your help!