title: Parsing year, month, day, hour, minute, second in Python
body: <p>I have a csv file with headers and they are: 
  year, month, day, hour, minute, second, firstName</p>
  
  <p>I have the following code in Python:</p>
  
  <pre><code>import pandas as pd
  from datetime import datetime
  parse = lambda x: datetime.strptime(x, '%Y-%m-%d %H:%M:%S')
  df = pd.read_csv('filename.csv',  
             parse_dates={'Date/Time': ['year', 'month', 'day', 'hour', 'minute', 'second']}, 
              index_col=0)
  df[:5]
  </code></pre>
  
  <p>When the table is shown the Date/Time column shows as</p>
  
  <p>Date/Time<br>
  2013 6 26 18 57 22  </p>
  
  <p>instead of</p>
  
  <p>Date/Time<br>
  2013-6-26 18:57:22 </p>
  
  <p>Any help would be appreciated.  Thank you.</p>