Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
Divide a column values with a column in another table.
Teja_Varanasi
I have a Table with these columns
A B C D
2 3 4 3
4 6 8 6
6 9 2 3
8 3 6 9
I have another table with same column names
A B C D
2 3 2 3
I want to get the result
A B C D
1 1 2 1
2 2 4 2
3 3 1 1
4 1 3 3
can anyone suggest what should i do here
Find more posts tagged with
AI Studio
Generate Attributes
Accepted answers
Mo Abdolrahim
Hi Teja, I was able to do this in Rapidminer Studio v10. I used two Read CSV Operators for reading data. Then I used two Generate Attribute Operators and added an id field wit value of one (1). Then I added an Inner Join Operator and joined Id from both tables. Finally I added a Generate Attribute Operator and divide data in one column with another column. Please see screenshots below:
Regards
Mo
All comments
Caperez
Hi
@Teja_Varanasi
,
one option is using the loop attributes operator combined with the extract Macro operator.
The idea is to use the extract Macro operator to extract the value of the second example set and then use it to operate over the first exampleset.
please find attached a simple approximation example.
Best
Attributes opetations.rmp
Teja_Varanasi
Hi,
@ceaperez
i got the same thought. I am getting error, when I do. And I was unable to open your file.
Caperez
Hi
@Teja_Varanasi
,
I attached the same process in XML format.
Best
Attributes operation.xml
Teja_Varanasi
ok thanks.. will do
Mo Abdolrahim
Hi Teja, I am new to Rapidminer, however, this can easily be done in Altair Monarch Dataprep studio software, the join table can be exported to a CSV file, the CSV file can be utilized by Rapidminer.
Regards
Mo
Mo Abdolrahim
Hi Teja, I was able to do this in Rapidminer Studio v10. I used two Read CSV Operators for reading data. Then I used two Generate Attribute Operators and added an id field wit value of one (1). Then I added an Inner Join Operator and joined Id from both tables. Finally I added a Generate Attribute Operator and divide data in one column with another column. Please see screenshots below:
Regards
Mo
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups