Weekly clustering of timestamps with pandas

timestamp_cluster_weekly.py

#!/usr/bin/env python

import pandas as pd, numpy as np
d = pd.read_table('input.txt', skiprows=0, header=None, parse_dates=True, index_col=0)
d['values'] = np.ones(len(d))
e = d.resample('w', how='sum')
f = e.fillna(value=0)
f.to_csv('output_weekly.txt', sep='\t')

#import matplotlib as mpl
#f.plot()
#mpl.pyplot.show()