title: python pandas dates not plotting correctly
body: <p>Im trying to plot my data which runs from date '2015-05-01' to '2015-05-08' (1st May to 8th of May) and heres my code</p>
  
  <pre><code>df = pd.read_csv(myfile.csv, parse_dates=[0], dayfirst=True)
  df = df.set_index('timestamp')
  df.index = df.index.to_datetime()
  df.sort_index(inplace=True)
  </code></pre>
  
  <p>but when I plot and limit the x-axis like </p>
  
  <pre><code>axs.set_xlim('2015-05-01','2015-05-08')
  </code></pre>
  
  <p>i get the following figure</p>
  
  <p><a href="https://i.stack.imgur.com/HCVbl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HCVbl.jpg" alt="enter image description here"></a></p>
  
  <p>which is missing days where data exists, for example if run the code</p>
  
  <pre><code>df[3000:3005]
  </code></pre>
  
  <p>I see</p>
  
  <pre><code>                          A
       timestamp  
  2015-03-05 13:51:00    71.000000
  2015-03-05 13:52:00    71.600000
  2015-03-05 13:53:00    72.500000
  2015-03-05 13:54:00    73.142857
  2015-03-05 13:55:00    77.625000
  </code></pre>
  
  <p>I think its becuase it thinks 2015-03-05 is the 5th of March, but its really the 3rd of May.</p>
  
  <p>So how can i get the plot to show the data for YYYY-DD-MM and not YYYY-MM-DD?</p>
  
  <p>EDIT: my raw data is like</p>
  
  <pre><code>05/03/2015 07:37    60.6
  05/03/2015 07:38    59.33333333
  05/03/2015 07:39    65.625
  05/03/2015 07:40    68.33333333
  05/03/2015 07:41    61
  </code></pre>
  
  <p>and im using the following code to plot</p>
  
  <pre><code>fig, axs = plt.subplots(1,1, figsize=(15,4))
  axs.plot( df.index, df.A , '*')
  axs.legend(loc='lower right', prop={'size':19})
  axs.set_xlim('2015-05-01','2015-05-08')
  axs.set_ylim(0,200)
  fig.show()
  </code></pre>
  
  <p>and using </p>
  
  <pre><code>axs.set_xlim('01-05-2015','08-05-2015')
  </code></pre>
  
  <p>gives</p>
  
  <p><a href="https://i.stack.imgur.com/tHODT.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tHODT.jpg" alt="enter image description here"></a></p>