Remove special character from column values using python

Asked Jun 03 '21 at 17:26

Active Jun 03 '21 at 17:35

Viewed 94 times

I have a dataframe that has a column where I would like to remove all periods within those values.

Data

Date       ID
Q1.2021    A
Q1.2021    A
Q2.2022    B
Q2.2022    B

Desired

Date       ID
Q1 2021    A
Q1 2021    A
Q2 2022    B
Q2 2022    B

Doing

  def remove_punctuations(text):
    for punctuation in string.punctuation:
        text = text.replace(punctuation, '')
    return text
# Apply to the DF series
df['new_column'] = df['column'].apply(remove_punctuations)

I am thinking I can use a function, however, is there a simpler way? Any suggestion is appreciated

asked Jun 03 '21 at 17:26

Lynn

4,292
5
21
44

4

Try `df['Date'] = df['Date'].replace('\.',' ', regex=True)` – Scott Boston Jun 03 '21 at 17:30
I believe must use the str accessor ```df['Date'] = df['Date'].str.replace('\.',' ', regex=True)``` – AmineBTG Jun 03 '21 at 17:34

Remove special character from column values using python

0 Answers0