title: pandas averaging data between timestamps
body: <p>If I have some data (24 hours time series) read into Pandas:</p>
  
  <pre><code>import pandas as pd
  import numpy as np
  
  
  #read CSV file
  df = pd.read_csv('https://raw.githubusercontent.com/bbartling/Building-Demand-Electrical-Load-Profiles/master/july15.csv', 
                   index_col='Date', parse_dates=True)
  </code></pre>
  
  <p>How can I average the <code>df</code> column <code>kW</code> between these time stamps into a new separate pandas df?</p>
  
  <pre><code>bkps_timestamps_kW = [
  '2013-06-19 00:15:00',
  '2013-06-19 05:15:00',
  '2013-06-19 16:30:00',
  '2014-06-18 00:00:00']
  </code></pre>
  
  <p>The new pandas df could have column names something like <code>avg_kw1, avg_kw2, avg_kw3</code> that would represent the averaging of the data between the time stamps in <code>bkps_timestamps_kW</code></p>
  
  <p>thanks for any help/tips</p>