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

Dataprep101

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

lionelderkrikor

嗨@Dataprep101,

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



Hope it helps,

Regards,

Lionel

Maerkli

Hallo Dataprep,

When you import your CSV file into RM Data repository, you have underFormat your columnsstepthe possibility to rename your columns.

Bonne chance,

Maerkli

Dataprep101

Thanks Lionel. It worked.

Maerkli

Bravo Lionel!

Maerkli