In [1]:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
%matplotlib inline
from pandas import DataFrame, Series

In [2]:
from datetime import datetime
now = datetime.now()
now


Out[2]:
datetime.datetime(2016, 7, 21, 19, 16, 12, 527000)

In [3]:
now.year, now.month, now.day


Out[3]:
(2016, 7, 21)

In [4]:
delta = datetime(2011, 1, 7) - datetime(2008, 6, 24, 8, 15)
delta


Out[4]:
datetime.timedelta(926, 56700)

In [5]:
delta.days


Out[5]:
926

In [6]:
delta.seconds


Out[6]:
56700

In [7]:
from datetime import timedelta
start = datetime(2011, 1, 7)
start + timedelta(12)


Out[7]:
datetime.datetime(2011, 1, 19, 0, 0)

In [9]:
start - 2 * timedelta(12)


Out[9]:
datetime.datetime(2010, 12, 14, 0, 0)

In [10]:
now + timedelta(30)


Out[10]:
datetime.datetime(2016, 8, 20, 19, 16, 12, 527000)

In [12]:
stamp = datetime(2011, 1, 3)
str(stamp)


Out[12]:
'2011-01-03 00:00:00'

In [13]:
stamp.strftime('%Y-%m-%d')


Out[13]:
'2011-01-03'

In [14]:
value = '2011-01-03'
datetime.strptime(value, '%Y-%m-%d')


Out[14]:
datetime.datetime(2011, 1, 3, 0, 0)

In [15]:
datestrs = ['7/6/2011', '8/6/2011']
[datetime.strptime(x, '%m/%d/%Y') for x in datestrs]


Out[15]:
[datetime.datetime(2011, 7, 6, 0, 0), datetime.datetime(2011, 8, 6, 0, 0)]

In [16]:
from dateutil.parser import parse
parse('2011-01-03')


Out[16]:
datetime.datetime(2011, 1, 3, 0, 0)

In [17]:
parse('Jan 31, 1997 10:45 PM')


Out[17]:
datetime.datetime(1997, 1, 31, 22, 45)

In [18]:
parse('6/12/2011', dayfirst=True)


Out[18]:
datetime.datetime(2011, 12, 6, 0, 0)

In [19]:
datestrs


Out[19]:
['7/6/2011', '8/6/2011']

In [20]:
pd.to_datetime(datestrs)


Out[20]:
DatetimeIndex(['2011-07-06', '2011-08-06'], dtype='datetime64[ns]', freq=None)

In [21]:
idx = pd.to_datetime(datestrs + [None])
idx


Out[21]:
DatetimeIndex(['2011-07-06', '2011-08-06', 'NaT'], dtype='datetime64[ns]', freq=None)

In [22]:
idx[2]


Out[22]:
NaT

In [23]:
pd.isnull(idx)


Out[23]:
array([False, False,  True], dtype=bool)

In [24]:
parse('42')


Out[24]:
datetime.datetime(2042, 7, 21, 0, 0)

In [ ]:


In [ ]: