title: Python Script, Pandas Special Characters
body: <p>I am using this script to geocode addresses. The script works fine, however the output file converts special characters such as <code>中央区</code> and <code>Athénée</code> to gibberish. i.e.</p>
  
  <p><code>中央区</code> -> <code>ä¸­å¤®åŒº</code></p>
  
  <p><code>Athénée</code> -> <code>AthÃ©nÃ©e</code></p>
  
  <p>The input file is a UTF-8 .CSV saved in MAC excel. The script is using Pandas to process data. How could I support special characters such as the above?</p>
  
  <p>The code for the full script can be found here: 
  <a href="https://github.com/shanealynn/python_batch_geocode/blob/master/python_batch_geocoding.py" rel="nofollow noreferrer">https://github.com/shanealynn/python_batch_geocode/blob/master/python_batch_geocoding.py</a></p>
  
  <pre><code> import pandas as pd
      import requests
      import logging
      import time
  
      #------------------ CONFIGURATION -------------------------------
  
      # Set your output file name here.
      output_filename = '/Users/_Library/Python/geobatch/res1000_output.csv'
      # Set your input file here
      input_filename = "/Users/_Library/Python/geobatch/res1000.csv"
      # Specify the column name in your input data that contains addresses here
      address_column_name = "Address"
      # Return Full Google Results? If True, full JSON results from Google are included in output
      RETURN_FULL_RESULTS = False
  
      #------------------ DATA LOADING --------------------------------
  
      # Read the data to a Pandas Dataframe
      data = pd.read_csv(input_filename, encoding='utf8')
  
      addresses = data[address_column_name].tolist()
  
  
      # All done
      logger.info("Finished geocoding all addresses")
      # Write the full results to csv using the pandas library.
      pd.DataFrame(results).to_csv(output_filename, encoding='utf8')
  </code></pre>