title: pandas: How to convert a string to datetime?
body: <p>I have a <a href="https://dl.dropboxusercontent.com/s/tb4yc3lm3gg3j22/out.csv" rel="nofollow">CSV file</a> in which I am trying to convert the <code>date</code> column to <code>dd/mm/yyyy</code> format using the below code but I am still struggling with <code>unconverted data remains</code>.</p>
  
  <p>A few sample data-records from the <code>CSV</code>-file
      hotel,author,review,date,Overall,Value,Rooms,Location,Cleanliness,Check in/front desk,Service,Business,r9
      in,everywhereman2 ,Old seattle getaway This was Old World Excellence at it's best.THIS is the place to stay at when visiting the historical area of Seattle. Your right on the water front near the ferry's and great sea food restrauntsand still with'in walking distance for great blues and jazz music. The staff for this hotel are excellentthey make you feel right at home. The breakfast was great.We did'nt have to travel far to have a good cup of JOE and a light meal to start our adventurous day off into one of the most beautifull city's in america. This hotel is in an area that makes it easy to get to any place you want to go and still find your way back I highly recomend this hotel for your next visit to seattle.   ,Jan 6 2009 ,5,5,5,5,5,5,5,5,<br>
      in,RW53 ,Location! Location?       view from room of nearby freeway   ,Dec 26 2008 ,3,4,3,2,4,3,-1,-1,  </p>
  
  <p>Can you, please, help me to point out my mistake?</p>
  
  <p>I am reading the file in RSS and then:</p>
  
  <pre><code>import time 
  for end_date in rss['date']:
      end_date     = end_date.split(" ")
      end_date[-1] = end_date[-1][:4]
      end_date     = " ".join(end_date)
      conv         = time.strptime( end_date,"%b %d %Y" )
      time.strftime( "%d/%m/%Y", conv )
  rss['date']
  </code></pre>
  
  <p>Thank you in advance.</p>