Python Forum
PANDAS: DataFrame | White Spaces & Special Character Removal
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PANDAS: DataFrame | White Spaces & Special Character Removal
#2
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 ))
Reply


Messages In This Thread
RE: PANDAS: DataFrame | White Spaces & Special Character Removal - by eddywinch82 - Sep-10-2020, 07:02 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  HTML Decoder pandas dataframe column mbrown009 3 962 Sep-29-2023, 05:56 PM
Last Post: deanhystad
  Use pandas to obtain cartesian product between a dataframe of int and equations? haihal 0 1,091 Jan-06-2023, 10:53 PM
Last Post: haihal
  Pandas Dataframe Filtering based on rows mvdlm 0 1,396 Apr-02-2022, 06:39 PM
Last Post: mvdlm
  Pandas dataframe: calculate metrics by year mcva 1 2,269 Mar-02-2022, 08:22 AM
Last Post: mcva
  Pandas dataframe comparing anto5 0 1,243 Jan-30-2022, 10:21 AM
Last Post: anto5
  PANDAS: DataFrame | Replace and others questions moduki1 2 1,759 Jan-10-2022, 07:19 PM
Last Post: moduki1
  PANDAS: DataFrame | Saving the wrong value moduki1 0 1,527 Jan-10-2022, 04:42 PM
Last Post: moduki1
  update values in one dataframe based on another dataframe - Pandas iliasb 2 9,105 Aug-14-2021, 12:38 PM
Last Post: jefsummers
  empty row in pandas dataframe rwahdan 3 2,423 Jun-22-2021, 07:57 PM
Last Post: snippsat
  Outliers remain in the scatterplot even after removal d8a988 0 1,278 Mar-12-2021, 12:58 PM
Last Post: d8a988

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020