title: Python3 CSV encoding problems
body: <p>I'm trying to add some information to a row in a CSV-file, but in the updated CSV-file the special characters (², ±) aren't encoded well. Let me clarify:</p>
  
  <p>So basically I have a CSV-file with the following example row:</p>
  
  <pre><code>row = ["Some info", "Cell with special characters (², ±)", "Some more info"]
  </code></pre>
  
  <p>I'm trying to add some text to the second column, so I wrote the following code</p>
  
  <pre><code>import csv
  new_rows = []
  
  # Open CSV file
  with open('file_1.csv', 'r', encoding='UTF-8') as f1
      reader =  csv.reader(f1, delimiter=',')
      for row in reader:
          # Add text to cell, save row to memory
          row[1] = row[1] + " is causing trouble"
          new_rows.append(row)
  
  # Write rows in new CSV-file
  with open('file_2.csv', 'w', encoding='UTF-8', newline='') as of:
      writer =  csv.writer(of, delimiter=',')
      writer.writerows(new_rows)
  </code></pre>
  
  <p>The output in the second column I expected would be as follows:</p>
  
  <pre><code>"Cell with special characters (², ±) is causing troubles"
  </code></pre>
  
  <p>But instead I get the following output:</p>
  
  <pre><code>"Cell with special characters (??, ??) is causing troubles"
  </code></pre>
  
  <p>I tried to solve the problem by changing the encoding to Latin-1, or even by not mentioning the encoding in the code at all, but nothing seems to work! </p>
  
  <p>What am I missing or doing wrong here? </p>