Series.dt can be used to access the values of the series as datetimelike and return several properties. Pandas Series.dt.strftime() function is used to convert to Index using specified date_format. The function return an Index of formatted strings specified by date_format, which supports the same string format as the python standard library.
Syntax: Series.dt.strftime(*args, **kwargs)
Parameter :
date_format : Date format string (e.g. “%Y-%m-%d”)Returns : Index of formatted strings
Example #1: Use Series.dt.strftime() function to convert the dates in the given series object to the specified date format.
# importing pandas as pdimport pandas as pd # Creating the Seriessr = pd.Series(['2012-12-31 08:45', '2019-1-1 12:30', '2008-02-2 10:30', '2010-1-1 09:25', '2019-12-31 00:00']) # Creating the indexidx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5'] # set the indexsr.index = idx # Convert the underlying data to datetime sr = pd.to_datetime(sr) # Print the seriesprint(sr) |
Output :
Now we will use Series.dt.strftime() function to convert the dates in the given series object to the specified format.
# convert to the given date formatresult = sr.dt.strftime('% B % d, % Y, % r') # print the resultprint(result) |
Output :
As we can see in the output, the Series.dt.strftime() function has successfully converted the dates in the given series object to the specified format.
Example #2 : Use Series.dt.strftime() function to convert the dates in the given series object to the specified date format.
# importing pandas as pdimport pandas as pd # Creating the Seriessr = pd.Series(pd.date_range('2012-12-31 09:45', periods = 5, freq = 'M', tz = 'Asia / Calcutta')) # Creating the indexidx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5'] # set the indexsr.index = idx # Print the seriesprint(sr) |
Output :
Now we will use Series.dt.strftime() function to convert the dates in the given series object to the specified format.
# convert to the given date formatresult = sr.dt.strftime('% d % m % Y, % r') # print the resultprint(result) |
Output :
As we can see in the output, the Series.dt.strftime() function has successfully converted the dates in the given series object to the specified format.
