title: pandas daily average, pandas.resample
body: <p>I have a csv file similar to this</p>
  
  <pre><code>Date,Temp1,Temp2
  
  23-Oct-09 01:00:00,21.1,22.3
  
  23-Oct-09 04:00:00,22.3,23.8
  
  23-Oct-09 07:00:00,21.4,21.3
  
  23-Oct-09 10:00:00,21.5,21.6
  
  23-Oct-09 13:00:00,22.3,23.8
  
  23-Oct-09 16:00:00,21.4,21.3
  
  23-Oct-09 19:00:00,21.1,22.3
  
  23-Oct-09 22:00:00,21.4,21.3
  
  24-Oct-09 01:00:00,22.3,23.8
  
  24-Oct-09 04:00:00,22.3,23.8
  
  24-Oct-09 07:00:00,21.1,22.3
  
  24-Oct-09 10:00:00,22.3,23.8
  
  24-Oct-09 13:00:00,21.1,22.3
  
  24-Oct-09 16:00:00,22.3,23.8
  
  24-Oct-09 19:00:00,21.1,22.3
  
  24-Oct-09 22:00:00,22.3,23.8
  </code></pre>
  
  <p>I have read the data with:</p>
  
  <pre><code>df=pd.read_csv('data.csv', index_col=0)
  </code></pre>
  
  <p>and converted the index to date time</p>
  
  <pre><code>df.index=pd.to_datetime(df.index)
  </code></pre>
  
  <p>Now I want to take the mean of each daily temperature, I have been trying to use pd.resample as below, but have been receiving errors. I've read the pandas.resample docs and numerous examples on here and am still at a loss...</p>
  
  <pre><code>df_avg = df.resample('D', how = 'mean')
  </code></pre>
  
  <blockquote>
    <p>DataError: No numeric types to aggregate</p>
  </blockquote>
  
  <p>I would like df_avg to be a dataframe with a datetime index and the two 2 columns. I am using pandas 0.17.1 and python 3.5.2, any help greatly appreciated!</p>