Try your hand at analyzing royal sentiment in Dataiku DSS! Learn more

cleaning cell from the numbers

Level 1
cleaning cell from the numbers
Hello!

I have a question according the cleaning data. I have the colomnes with names and surenames and some times i have some numbers with the text information, as:

NOM PRENOM
Soloma Anastasiia2
Ri5grit Stephanie

Is any code existe to clean all the numbers from these colomnes?



Thank you in advance!



Best regards,
Anastasiia
0 Kudos
2 Replies
Dataiker Alumni

Hi Anastasiia,



Yes, you can do that easily with DSS. Create a Prepare recipe and add a new "Find & Replace" step.



The simple/easy way is to replace 0 with nothing, 1 with nothing, ... 9 with nothing.





A better way to do it, is to replace all occurrences of the regular expression [0-9] which matches any digit.





If you want to remove the numbers in multiple columns, configure the step accordingly as in the above screenshots.



Hope this helps,



Arnaud



VP Engineering, Dataiku

0 Kudos
Level 1
Author
Ah exact! Thank you very much for such fast answer!
Have a nice day
0 Kudos