python pandas dates not plotting correctly
<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>