Replace values in a column based on a condition in Azure ML Studio

Question

How do I replace the values in a specific column with a particular value based on a condition in Azure ML Studio? I can do this using panda in python as follows:

df.loc[df['col_name'] > 1990, 'col_name'] = 1

I'm trying to find a Module in Azure Machine Learning Studio that does the equivalent of this.

I understand there is a replacement option under the ConverToDataset module and a Replace Discrete Values module. But neither of these seems to do what I want. Is there an option to replace the values in just one column to a specific value based on a condition?

Answer 1

You can use this clip values or for more complex rules, this .