Pandas Datetime

by Online Tutorials Library July 14, 2022

Pandas Datetime

The Pandas can provide the features to work with time-series data for all domains. It also consolidates a large number of features from other Python libraries like scikits.timeseries by using the NumPy datetime64 and timedelta64 dtypes. It provides new functionalities for manipulating the time series data.

The time series tools are most useful for data science applications and deals with other packages used in Python.

Example1:

  import pandas as pd     # Create the dates with frequency     info = pd.date_range(‘5/4/2013′, periods = 8, freq =’S’)     info  

Output:

DatetimeIndex(['2013-05-04 00:00:00', '2013-05-04 00:00:01',                 '2013-05-04 00:00:02', '2013-05-04 00:00:03',                 '2013-05-04 00:00:04', '2013-05-04 00:00:05',                 '2013-05-04 00:00:06', '2013-05-04 00:00:07'],                dtype='datetime64[ns]', freq='S')

Example2:

  info = pd.DataFrame({‘year’: [2014, 2012],  ‘month’: [5, 7],  ‘day’: [20, 17]})  pd.to_datetime(info)  0   2014-05-20  1   2012-07-17  dtype: datetime64[ns]  

You can pass errors=’ignore’ if the date does not meet the timestamp. It will return the original input without raising any exception.

If you pass errors=’coerce’, it will force an out-of-bounds date to NaT.

  import pandas as pd  pd.to_datetime(‘18000706′, format=’%Y%m%d’, errors=’ignore’)  datetime.datetime(1800, 7, 6, 0, 0)  pd.to_datetime(‘18000706′, format=’%Y%m%d’, errors=’coerce’)  

Output:

Timestamp('1800-07-06 00:00:00')

Example3:

  import pandas as pd  dmy = pd.date_range(‘2017-06-04′, periods=5, freq=’S’)  dmy  

Output:

DatetimeIndex(['2017-06-04 00:00:00',                  '2017-06-04 00:00:01',                 '2017-06-04 00:00:02',                 '2017-06-04 00:00:03',                 '2017-06-04 00:00:04'],                 dtype='datetime64[ns]', freq='S')

Example4:

Output:

DatetimeIndex(['2017-06-04 00:00:00+00:00', '2017-06-04 00:00:01+00:00',                 '2017-06-04 00:00:02+00:00',                  '2017-06-04 00:00:03+00:00',                 '2017-06-04 00:00:04+00:00'],                dtype='datetime64[ns, UTC]', freq='S')

Example5:

  import pandas as pd  dmy = pd.date_range(‘2017-06-04′, periods=5, freq=’S’)  dmy  

Output:

DatetimeIndex(['2017-06-04 00:00:00', '2017-06-04 00:00:01',                 '2017-06-04 00:00:02', '2017-06-04 00:00:03',                 '2017-06-04 00:00:04'],          dtype='datetime64[ns]', freq='S')

Next TopicPandas Time Offset

Pandas Datetime

Pandas Datetime

Example1:

Example2:

Example3:

Example4:

Example5:

Arithmetic in Prolog

Automate Instagram Messages using Python

You may also like