Convert a series of date strings to a time series in Pandas Dataframe

October 24, 2021October 24, 2021 User HandleUser Handle

Convert a series of date strings to a time series in Pandas Dataframe

During the analysis of a dataset, oftentimes it happens that the dates are not represented in proper type and are rather present as simple strings which makes it difficult to process them and perform standard date-time operations on them.

pandas.to_datetime() Function helps in converting a date string to a python date object. So, it can be utilized for converting a series of date strings to a time series.

Let’s see some examples:
Example 1: 

# import pandas library
import pandas as pd
 
# create a series of date strings
dt_series = pd.Series(['28 July 2020', '16 January 2013',
                       '29 February 2016 18:14'])
 
# display the series initially
print("Series of date strings:")
print(dt_series)
 
# display the series after being 
# converted to a time series
print("\nSeries of date strings after" +
       " being converted to a timeseries:")
 
print(pd.to_datetime(dt_series))

Output:

 

 

date string to time series conversion

Example 2: 

# import pandas library
import pandas as pd
 
# create a series of date strings
dt_series = pd.Series(['2020/07/28', '2013/01/16',
                       '2016/02/29 18:14'])
 
# display the series initially
print("Series of date strings:")
print(dt_series)
 
# display the series after being
# converted to a time series
print("\nSeries of date strings after " +
      "being converted to a timeseries:")
 
print(pd.to_datetime(dt_series))

Output:

date string to time series conversion-1

Example 3: 

# import pandas library
import pandas as pd
 
# create a series of date strings
dt_series = pd.Series(['2020-07-28', '2013-01-16', 
                       '2016-02-29 18:14'])
 
# display the series initially
print("Series of date strings:")
print(dt_series)
 
# display the series after 
# being converted to a time series
print("\nSeries of date strings after " +
      "being converted to a timeseries:")
 
print(pd.to_datetime(dt_series))

Output:

 

date string to time series conversion-2

Example 4: 

# import pandas library
import pandas as pd
 
# create a series of date strings
dt_series = pd.Series(['28/07/2020', '01/16/2013', 
                       '29/02/2016 18:14'])
 
# display the series initially
print("Series of date strings:")
print(dt_series)
 
# display the series after being
# converted to a time series
print("\nSeries of date strings after " +
      "being converted to a timeseries:")
 
print(pd.to_datetime(dt_series))

Output:

date string to time series conversion-3

Example 5: 

# import pandas library
import pandas as pd
 
# create a series of date strings
dt_series = pd.Series(['20200728', '20130116', 
                       '20160229 181431'])
 
# display the series initially
print("Series of date strings:")
print(dt_series)
 
# display the series after 
# being converted to a time series
print("\nSeries of date strings after " +
      "being converted to a timeseries:")
 
print(pd.to_datetime(dt_series))

Output:

date string to time series conversion-4

Example 6: 

# import pandas library
import pandas as pd
 
# create a series of date strings
dt_series = pd.Series(['28 July 2020', '2013-01-16',
                       '20160229 18:14', '5/03/2019 2215',
                       '20151204 09:23'])
 
# display the series initially
print("Series of date strings:")
print(dt_series)
 
# display the series after 
# being converted to a time series
print("\nSeries of date strings after " +
      "being converted to a timeseries:")
 
print(pd.to_datetime(dt_series))

Output:

date string to time series conversion-5

 

Last Updated on October 24, 2021 by admin

Leave a Reply

Your email address will not be published. Required fields are marked *

Recommended Blogs