Add new column if then in existing column

syazwaan

I have a dataset something like this:

I want to make a new column if data in column_1 is start with a number and ends with a letter and return 'Complete' or 'Incomplete' in a new column.

Expected output:

Thank you.

BalazsBaranyRM

Hi!

You could use Generate Attributes for this.
Determining if a text starts with a number and ends with a letter is the domain of regular expressions. These are usable in different places in RapidMiner, there's even a nice regular expression editor for example in the Replace operator.

In Generate Attributes, you would use the if() and matches() functions. Here's an example for your use case:

if(matches(column_1, "^[0-9]+.+[a-zA-Z]$"), "Complete", "Incomplete") 

The regexp is a bit terrifying in the beginning but it is simple to explain.

^    beginning of the string
[0-9]  character class: Numbers from 0 to 9
+    at least one of the element before (the character class)
.+   anything
[a-zA-Z]   letters (if you need additional characters, enter them after the Z)
$    end of the string

So the logic goes: If the value of column_1 matches the regular expression, the if function returns the second argument (Complete), else the third one.

Regards,
Balázs