PANDAS: DataFrame | White Spaces & Special Character Removal

[eddywinch82]

Hi traibr,

Try the following, I hope they work for you :-

df['Inbound Tel'] = df['Inbound Tel'].str.replace({" ": ""})

Or

df['Inbound Tel'] = df['Inbound Tel'].replace({" ": ""})

And

df['Text6'] = df['Text6'].str.replace({" ": ""})

Or

df['Text6'] = df['Text6'].replace({" ": ""})

Or insert the Line :-

df.columns = ['Inbound Tel', 'Text6']

Above these Lines in your Code :-

df['Inbound Tel'] = df['Inbound Tel'].str.replace(" ", "")
df['Text11'] = df['Text11'].str.replace(".", "")
df['Text6'] = df['Text6'].str.replace(" ", "")

Hash out the Inbound Tel, and Text6 Lines of the above lines of Code, and use the following line of Code instead,
in place of the hashed out lines of Code :-

df.columns = df.columns.str.replace(" ", "")

Or

df.columns = df.columns.str.replace(' ', '')

I hope some of those work for you.

Best Regards

Eddie ))