python pandas - replace character of one column [duplicate]

Question

I'm trying to replace the '@' of Timestamp with a white space with pandas. Currently my dataframe looks like this:

Timestamp                    name                    sex
2020-03-10@15:45:15           x                      y
2020-03-10@16:00:15           x                      y
2020-03-10@17:15:15           x                      y

What I want as an output:

Timestamp                    name                    sex
2020-03-10 15:45:15           x                      y
2020-03-10 16:00:15           x                      y
2020-03-10 17:15:15           x                      y

The replacement of @ to white space works, but for some reason it only returns the Timestamp column and the others are just gone.

Is timestamp a datetime column or an object column?

dper
– dper

2020-06-12 16:14:39 +00:00
Commented Jun 12, 2020 at 16:14 — dper
– dper, Commented Jun 12, 2020 at 16:14
So you want to provide a space instead of the character T?

dper
– dper

2020-06-12 16:18:19 +00:00
Commented Jun 12, 2020 at 16:18 — dper
– dper, Commented Jun 12, 2020 at 16:18

dper · Accepted Answer · 2020-06-12 16:24:06Z

1

You can directly replace the string using :

df['TimeStamp'] = df['TimeStamp'].str.replace('T',' ')

answered Jun 12, 2020 at 16:24

dper

9141 gold badge11 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

dper Over a year ago

@minpik I thought you have a dataframe that's why I used dataframe. Do you need to perform it on the list? I see that you have changed it to content['Timestamp'] which is not a dataframe but a list

Collectives™ on Stack Overflow

python pandas - replace character of one column [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related