title: Convert csv timestamp from UTC to Hawaiian timezone
body: <p>I have a csv of data which is time-stamped to UTC, but needs to have the local time from Hawaii (UTC-10). Ideally I'd add a new column to the csv with the Hawaiian time alongside the UTC time, followed by the data. </p>
  
  <p><a href="https://i.stack.imgur.com/t3QYp.jpg" rel="nofollow noreferrer">Here is the csv file format</a>, with the date-time on the first column. The format is a little odd as it has "year-month-date hour/minute/second" as normal but is then followed by "UTC" which I think might be causing me a problem.</p>
  
  <p>I've got some simple code to extract the time column, assign it to UTC time (as timestamps are of unknown timezone) and then convert it to UTC-10.</p>
  
  <pre><code>import pandas as pd
  import os
  from datetime import datetime
  from dateutil import tz
  
  # read the file in csv 
  K = pd.read_csv("kona_python.csv")
  
  # time series data selection
  UTCtime = K.iloc[:,0] 
  
  # access timezones:
  utc_timezome = tz.gettz('UTC')
  hawaii_timezone = tz.gettz('US/Hawaii')
  
  # feeding in the csv column data
  utc = UTCtime
  
  # set the datetime object to the UTC timezone
  utc = utc.replace(tzinfo = utc_timezome)
  
  # convert time zone to Hawaii
  hawaii = utc.astimezone(hawaii_timezone)
  </code></pre>
  
  <p>However it runs with <a href="https://i.stack.imgur.com/xiNgt.jpg" rel="nofollow noreferrer">this error</a>, where tzinfo is not expected. Am I using dateutil correctly? Or is there a simpler way to do this? Any help much appreciated! </p>
  
  <p><strong>Update</strong> - csv sample: </p>
  
  <pre><code>UTC timestamp   A   B   C   D   E   F
  2018-07-20 22:22:06 UTC 1.27    21.64   1.11    0.37    22.31   0.33
  2018-07-20 22:23:25 UTC 1.4 21.82   0.33    0.75    22.59   0.33
  2018-07-20 22:24:45 UTC 2.09    20.31   0.93    1.55    21.05   0.4
  2018-07-20 22:26:05 UTC 0.8 21.34   0.93    1.36    20.89   0.4
  2018-07-20 22:27:24 UTC 0.4 19.93   0.93    1.37    22.58   0.24
  </code></pre>