How to read csv file as dtype datetime64?
<p>Now I have csv file </p>

<pre><code> date
201605
201606
201607
201608
</code></pre>

<p>I wanna get dataframe like this</p>

<p>df</p>

<pre><code>      date
0  2016-05-01
1  2016-06-01
2  2016-07-01
3  2016-08-01
</code></pre>

<p>so,I would like to read csvfile as datetime64.
and add the date 1.
How can I read and transform this csvfile?</p>

<p>Maybe this answer will help you to convert your column to datetime object <a href="http://stackoverflow.com/a/26763793/5982925">http://stackoverflow.com/a/26763793/5982925</a></p>

python csv parsing datetime pandas