Hello everyone, i m trying to create a new column (using case when and contains/like) depending on the context of another string column, but i find it troublesome when it comes to containing numbers such as 50 and 500 for example:
HAVE DATASET
CPP
blabla DP50_L
blablablu DP 50 L
ble DP50
blx DP50_500
blibli DP500_L
bliblibla DP 500 L
bliblible DP500
blublu DP500 50
WANT DATASET
CPP SPEED
blabla DP50_L 50
blablablu DP 50 L 50
ble DP50 50
blx DP50_500 50
blibli DP500_L 500
bliblibla DP 500 L 500
bliblible DP500 500
blublu DP500 50 500
As a result, i have faulty classification. What is the proper way to create the column of the example above?
Thanks alot for your time and insights!
... View more