Replace characters with a space within a column while maintaining original value (In Pandas)-CodePudding

I have a dataset, where, in one column I would like to replace the '.' with a ' ' or space.

note - the Date is an object type

Data

Date    Type
Q1.27   A
Q2.27   B

Desired

Date    Type
Q1 27   A
Q2 27   B

Doing

df['Date'] = df['Date'].replace('.','', regex=True)

However this eliminates the full value. Any suggestion is appreciated. I think I may need to incorporate a split since the code is instructing the value to be replaced by a space.

CodePudding user response：

In a regular expression, . is a wildcard that matches any character. So you're replacing all characters with an empty string. Use regex=False to make this a literal string instead of a regular expression.

And you said you wanted the replacement to be a single space, not an empty string.

df['Date'] = df['Date'].str.replace('.',' ', regex=False)

CodePudding user response：

df['Date'] =df['Date'].str.replace('\.',' ',regex=True)



    Date Type
0  Q1 27    A
1  Q2 27    B