Sep-10-2020, 07:02 PM
(This post was last modified: Sep-10-2020, 07:02 PM by eddywinch82.)
Hi traibr,
Try the following, I hope they work for you :-
in place of the hashed out lines of Code :-
Best Regards
Eddie ))
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 ))