Pages: [1]
  Print  
Author Topic: [SOLVED] VLOOKUP Equivalent in Operators  (Read 2806 times)
scooter7
Newbie
*
Posts: 6


« on: December 31, 2013, 04:33:02 PM »

Hi, I am wondering if there is an equivalent operator to Excel's VLOOKUP formula.

I have two spreadsheets that I want to import into Rapidminer. One spreadsheet lists all zip codes in the U.S. and then the median income for each zip code in an adjacent column. The other spreadsheet (sample data) has many variables, one of which is zip code for each person/row on the spreadsheet. I am seeking to import both spreadsheets into Rapidminer and then create a process in which the spreadsheets are ultimately appended and a new column/variable is created in the one with the sample data that provides the median income based on the person/rows' zip code.

I know how to do this in Excel using the VLOOKUP formula. However, I would like to be able to accomplish the same thing in Rapidminer. Can anyone help me with this? Thanks in advance!
« Last Edit: January 03, 2014, 11:11:15 AM by Marius » Logged
awchisholm
Sr. Member
****
Posts: 393


WWW
« Reply #1 on: December 31, 2013, 06:59:55 PM »

Hello scooter7

The Join operator should do what you want. Set the left join example set to be the sample data and the right join example set as the zip code reference data. Set the key attributes to be the zip codes in the example sets.

regards

Andrew
Logged

scooter7
Newbie
*
Posts: 6


« Reply #2 on: January 03, 2014, 02:25:09 AM »

Hello Andrew,
Your solution worked perfectly. Thank you very much for your assistance.
Happy new year!
Logged
Pages: [1]
  Print  
 
Jump to: