Convert panda date list to python list of date strings

Question

I have a panda date list created from the code below.

import pandas as pd
panda_datelist = pd.bdate_range(pd.datetime.today(), periods=3).tolist()

I would like to convert panda_datelist into a python list. It should look something like this;

python_datelist_from_panda = ['10/2/2017','10/3/2017','10/4/2017']

I am using python v3.6

Zero · Accepted Answer · 2017-10-20 03:32:26Z

1

Use list comprehension

In [4553]: [x.strftime('%m/%d/%Y') for x in panda_datelist]
Out[4553]: ['10/20/2017', '10/23/2017', '10/24/2017']

Or, use map

In [4554]: map(lambda x: x.strftime('%m/%d/%Y'), panda_datelist)
Out[4554]: ['10/20/2017', '10/23/2017', '10/24/2017']

But, before converting to list you can actually use strftime

In [4559]: pd.bdate_range(pd.datetime.today(), periods=3).strftime('%m/%d/%Y')
Out[4559]:
array([u'10/20/2017', u'10/23/2017', u'10/24/2017'],
      dtype='<U10')

Details

In [4555]: panda_datelist
Out[4555]:
[Timestamp('2017-10-20 00:00:00', freq='B'),
 Timestamp('2017-10-23 00:00:00', freq='B'),
 Timestamp('2017-10-24 00:00:00', freq='B')]

edited Oct 20, 2017 at 3:32

answered Oct 20, 2017 at 3:25

Zero

77.4k22 gold badges153 silver badges153 bronze badges

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

2 Comments

user3848207 Over a year ago

Thanks. I didn't know strftime works for panda. Panda gives me the impression of being a totally different animal from python data structures.

user3848207 Over a year ago

I'm trying to understand the solution of using map and lambda. They look pretty foreign to me. Is it some kind of functional programming?

Collectives™ on Stack Overflow

Convert panda date list to python list of date strings

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related