Convert number to date format using Python
<p>I am reading data from a text file with more that 14000 rows and there is a column which has eight (08) digit numbers in it. The format for some of the rows are like:</p>

<ul>
<li>01021943 </li>
<li>02031944 </li>
<li>00041945 </li>
<li>00001946</li>
</ul>

<p>The problem is that when I use to_date function it converts the datatype of the date from object to int64 but I want it to be datetime. Second by using the to_datetime function the dates like </p>

<ul>
<li>00041945 becomes 41945 </li>
<li>00001946 becomes 1946 and hence I cannot properly format them</li>
</ul>