title: How to read utf-8 csv Chinese file in python
body: <p>I have a csv file which the content is all in Chinese (except for headers). Since I want to read the file as dictionary (where col headers are keys), I did the following:</p>
  
  <pre><code>import csv
  d = csv.DictReader(open('file.csv', 'rU')
  
  final = []
  for row in d:
      final.append(row)
  </code></pre>
  
  <p>But when I try to access the values, the values are all broken and shows up like this:</p>
  
  <pre><code>'\xe4\xb8\x8a\xe6\xb5\xb7\xe5\xba\xb7\xe8\xa1\x8d\xe6\x8a\xa4\xe7\x90\x86\xe7\xab\x99'
  </code></pre>
  
  <p>So the <code>file.csv</code> is a UTF-8 csv file (originally made in Excel and saved as xlsx but later saved as csv file). How can I read this file in python 2.7?</p>