title: How to read csv file with date as one of the data?
body: <p>These are my data both in excel and in csv files:</p>
  
  <p>Date,Time,Product_Type
  2015-01-02,02:29:45 PM,Cards</p>
  
  <p>I've tried this code below and it works well with the excel file but not in CSV file.</p>
  
  <pre><code>import numpy as np
  import pandas as pd
  
  df = pd.read_excel('file.xlsx')
  print(df.head())
  </code></pre>
  
  <p>My code in reading the csv file is almost same from the above code but I am getting an error. Please help.</p>
  
  <pre><code>import numpy as np
  import pandas as pd
  import datetime
  
  df = pd.read_csv('file.csv', index_col='Date', parse_dates=True)
  print(df.head())
  </code></pre>
  
  <p>ERROR Message: 
  UnicodeDecodeError: 'utf-8' codec can't decode byte 0xa4 in position 2: invalid start byte</p>