🎉 🎉   RAPIDMINER 9.5 BETA IS OUT!!!   🎉 🎉

GRAB THE HOTTEST NEW BETA OF RAPIDMINER STUDIO, SERVER, AND RADOOP. LET US KNOW WHAT YOU THINK!

CLICK HERE TO DOWNLOAD

🦉 🎤   RapidMiner Wisdom 2020 - CALL FOR SPEAKERS   🦉 🎤

We are inviting all community members to submit proposals to speak at Wisdom 2020 in Boston.


Whether it's a cool RapidMiner trick or a use case implementation, we want to see what you have.
Form link is below and deadline for submissions is November 15. See you in Boston!

CLICK HERE TO GO TO ENTRY FORM

"Need help on how to replace an example set with descriptions using Replace (Dictionary)"

Dataprep101Dataprep101 Member Posts: 2 Newbie
edited May 23 in Help
Need help on how to replace an example set with descriptions using Replace (Dictionary).The example set has attributes with alphanumeric codes. I have an excel spreadsheet (csv format) that has descriptions of the alphanumeric codes(e.g. A11, A12, A13, etc.) that I want to replace. What step by step approach can be used to replace all the alphanumeric codes with descriptions from excel table automatically. I am working on replicating the example on chapter 4, pg. 78 of Predictive analytics and data mining textbook but got stuck on replacing the alphanumeric codes in the example set with the descriptive values in excel. I appreciate any help. Thanks

Best Answer

  • lionelderkrikorlionelderkrikor Posts: 783   Unicorn
    Solution Accepted
    HI @Dataprep101,

    The attributes names in your dictionnary and the attribute names you set in the Replace (Dictionnary) operator parameters must be the same :



    Hope it helps,

    Regards,

    Lionel 

Answers

  • MaerkliMaerkli Member Posts: 84   Unicorn
    Hallo Dataprep,

    When you import your CSV file into RM Data repository, you have under Format your columns step the possibility to rename your columns.
    Bonne chance,
    Maerkli

    sgenzer
  • Dataprep101Dataprep101 Member Posts: 2 Newbie
    Thanks Lionel. It worked.
    Maerklilionelderkrikor
  • MaerkliMaerkli Member Posts: 84   Unicorn
    Bravo Lionel!
    Maerkli
    lionelderkrikor
Sign In or Register to comment.