title: Convert number to date format using Python
body: <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>