title: Plot rolling mean together with data
body: <p>I have a DataFrame that looks something like this:</p>
  
  <pre><code>####delays:
              Worst case  Avg case
  2014-10-27    2.861433  0.953108
  2014-10-28    2.899174  0.981917
  2014-10-29    3.080738  1.030154
  2014-10-30    2.298898  0.711107
  2014-10-31    2.856278  0.998959
  2014-11-01    3.118587  1.147104
  ...
  </code></pre>
  
  <p>I would like to plot the data of this DataFrame, together with the rolling mean of the data. I would like the data itself should be a dotted line and the rolling mean to be a full line. The worst case column should be in red, while the average case column should be in blue.</p>
  
  <p>I've tried the following code:</p>
  
  <pre><code>import pandas as pd
  import matplotlib.pyplot as plt
  
  rolling = pd.rolling_mean(delays, 7)
  delays.plot(x_compat=True, style='r--')
  rolling.plot(style='r')
  plt.title('Delays per day on entire network')
  plt.xlabel('Date')
  plt.ylabel('Minutes')
  plt.show()
  </code></pre>
  
  <p>Unfortunately, this gives me 2 different plots. One with the data and one with the rolling mean. Also, the worst case column and average case column are both in red.</p>
  
  <p>How can I get this to work?</p>