from datetime import datetime
import pandas as pd
%matplotlib inline
import matplotlib.pyplot as pyplot

data = {'date': ['2014-05-01 18:47:05.069722', '2014-05-01 18:47:05.119994', '2014-05-02 18:47:05.178768', '2014-05-02 18:47:05.230071', '2014-05-02 18:47:05.230071', '2014-05-02 18:47:05.280592', '2014-05-03 18:47:05.332662', '2014-05-03 18:47:05.385109', '2014-05-04 18:47:05.436523', '2014-05-04 18:47:05.486877'], 
        'battle_deaths': [34, 25, 26, 15, 15, 14, 26, 25, 62, 41]}
df = pd.DataFrame(data, columns = ['date', 'battle_deaths'])
print(df)

df['date'] = pd.to_datetime(df['date'])

df.index = df['date']
del df['date']
df

df['2014']

df['2014-05']

df[datetime(2014, 5, 3):]

df['5/3/2014':'5/4/2014']

df.truncate(after='5/3/2014')

df.ix['5-2014']

df.groupby(level=0).count()

df.resample('D', how='mean')

df.resample('D', how='sum')

df.resample('D', how='sum').plot()