Pandas Timestamp index to list of date strings

Question

I have the following index values in a pandas dataframe.

df.index[0:5]

DatetimeIndex(['2004-05-31', '2004-06-30', '2004-07-31', '2004-08-31',
           '2004-09-30'],
          dtype='datetime64[ns]', name='as_of_dt', freq=None)

How can I convert them into a list of like this:

['5/31/2004','6/30/2004','7/31/2004','8/31/2004']

Andy Hayden · Accepted Answer · 2017-12-01 00:52:19Z

13

You can use strftime:

In [11]: df.index.strftime("%Y/%m/%d")
Out[11]:
array(['2004/05/31', '2004/06/30', '2004/07/31', '2004/08/31', '2004/09/30'],
      dtype='<U10')

answered Dec 1, 2017 at 0:52

Andy Hayden

378k110 gold badges640 silver badges546 bronze badges

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

1 Comment

DeeeeRoy Over a year ago

list(df.index.strftime("%m/%d/%Y"))

user6903745 · Accepted Answer · 2022-09-28 07:05:45Z

0

List comprehension and built-in string conversion may work:

[str(t) for t in df.index]

answered Sep 28, 2022 at 7:05

user6903745

5,5274 gold badges23 silver badges38 bronze badges

Collectives™ on Stack Overflow

Pandas Timestamp index to list of date strings

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related