Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on August 21, 2019 4:33PM
Likes: 1
Replies: 3
Hi Farid,
You can do it with a Python Recipe using:
df.columns = df.columns.str.replace(',', '').replace(' ','')
Another option is to use a Preparation Recipe and add step "Rename Columns" but you have to change each column manually.
Hello,
Old thread but I'm still having issues replacing whitespaces in columns in mass (have 500+ columns).
When using the above code, columns are changed, but all rows come out null
Is there a better way to do this?
NEVERMIND.
It worked in the end; thank you so much!