Timestamp to date conversion in Pandas 0.10

Question

I have a old version of Pandas (0.10...) and getting the new version will take time as it is an enterprise-wide change.

I am looking to convert a timestamp into mm/dd/yyyy format in Pandas 0.10, and I am at a loss as to_datetime() method does not seem to have format argument.

Can you please suggest a workaround?

Other option would be to have a way to convert the column to mm/dd/yyyy during to_csv() invocation.

I can't check it on such an old version, but you can try it out: df['column'].dt.strftime('%m/%d/%Y') ... — MaxU - stand with Ukraine
– MaxU - stand with Ukraine, Commented Feb 2, 2017 at 20:20

MaxU - stand with Ukraine · Accepted Answer · 2017-02-02 20:35:18Z

2

If your old version of Pandas (0.10) doesn't have yet DateTimeSeries.dt accessor, you can try this slower approach:

In [68]: df['date'].apply(lambda x: x.strftime('%m/%d/%Y'))
Out[68]:
0    01/29/2017
1    01/30/2017
2    01/31/2017
4    02/02/2017
0    01/29/2017
1    01/30/2017
2    01/31/2017
3    02/01/2017
Name: dt, dtype: object

answered Feb 2, 2017 at 20:35

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

Collectives™ on Stack Overflow

Timestamp to date conversion in Pandas 0.10

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related