title: pandas time shift from utc to local
body: <p>I am trying to convert utc time to local time. This is what I had before</p>
  
  <pre><code>df_combined_features['timestamp'][1:10]
  2013-01-24   2013-01-24 11:00:00
  2013-04-25   2013-04-25 10:00:00
  2013-07-25   2013-07-25 10:00:00
  2013-10-24   2013-10-24 10:00:00
  2014-01-30   2014-01-30 11:00:00
  2014-04-24   2014-04-24 10:00:00
  2014-07-24   2014-07-24 10:00:00
  2014-10-23   2014-10-23 10:00:00
  2015-01-27   2015-01-27 11:00:00
  </code></pre>
  
  <p>This is what I did</p>
  
  <pre><code>df_combined_features['time_stamp'].tz_localize('US/Central')[1:10]
  2013-01-24 00:00:00-06:00   2013-01-24 11:00:00
  2013-04-25 00:00:00-05:00   2013-04-25 10:00:00
  2013-07-25 00:00:00-05:00   2013-07-25 10:00:00
  2013-10-24 00:00:00-05:00   2013-10-24 10:00:00
  2014-01-30 00:00:00-06:00   2014-01-30 11:00:00
  2014-04-24 00:00:00-05:00   2014-04-24 10:00:00
  2014-07-24 00:00:00-05:00   2014-07-24 10:00:00
  2014-10-23 00:00:00-05:00   2014-10-23 10:00:00
  2015-01-27 00:00:00-06:00   2015-01-27 11:00:00
  </code></pre>
  
  <p>I think it did the right thing, but I dont understand the output format. In particular</p>
  
  <p>1) Why do the converted cols appear as the new index?</p>
  
  <p>2) I understand that -06:00 (in the last row) is an hour shift, so the time is 6:00 am, how do I retrieve that information, the exact local time?</p>
  
  <p>Desired output, I want the exact time to be posted, including the offset from utc.
       local time              utc time</p>
  
  <pre><code>    2013-01-24 05:00:00   2013-01-24 11:00:00
      2013-04-25 05:00:00   2013-04-25 10:00:00
      2013-07-25 05:00:00   2013-07-25 10:00:00
      2013-10-24 05:00:00   2013-10-24 10:00:00
      2014-01-30 05:00:00   2014-01-30 11:00:00
      2014-04-24 05:00:00   2014-04-24 10:00:00
      2014-07-24 05:00:00   2014-07-24 10:00:00
      2014-10-23 05:00:00   2014-10-23 10:00:00
      2015-01-27 05:00:00   2015-01-27 11:00:00
  </code></pre>