ipython-sessions-started-per-hour-of-day.py

from IPython.core.history import HistoryAccessor
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
hist_access = HistoryAccessor()
start_times, n_cmds = zip(*list(hist_access.db.execute('select start, num_cmds from sessions')))
num_cmds = pd.Series(n_cmds, index=start_times)
cmds_hod = num_cmds.groupby(num_cmds.index.hour).agg(sum)

starts = pd.Series(np.ones(len(start_times)), index=start_times)
starts_hod = starts.groupby(starts.index.hour).agg(sum)
starts_prob = starts_hod / starts.sum()
title_text = 'ipython session start probabilities (hour of day) (Total starts: {})'.format(starts.sum())
starts_prob.plot(title=title_text, kind='bar')
plt.gcf().show()