Converting datetime to string python [duplicate]

Question

I have a pandas dataframe that has a datetime column called "time". From this column, I only want to extract the year-month-date in the syntax it is given in, and I want to create a new column with that value as a string. Please help!

Does this answer your question? Convient way to convert int(yyyymmdd) to datetime object and str — ti7
– ti7, Commented Mar 3, 2021 at 0:57
Does this answer your question? Python datetime to string without microsecond component — Scinana
– Scinana, Commented Mar 3, 2021 at 1:09
In general, please add data/samples as text, not image. This makes it much easier to give good answers, based on your example. — FObersteiner
– FObersteiner, Commented Mar 3, 2021 at 6:18

Pablo C · Accepted Answer · 2021-03-03 00:52:38Z

1

IIUC pandas.Series.dt.strftime is what you want:

df["new_time"] = df["time"].dt.strftime("%Y-%m-%d")

Also, check this documentation where you can find the datetime format codes.

answered Mar 3, 2021 at 0:52

Pablo C

4,7612 gold badges10 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Converting datetime to string python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related