title: How to replace non-ASCII by ASCII in pandas data frame
body: <p>I have a pandas Data Frame from a Excel File as Input in my program.</p>
  
  <p>I would like to replace some non ASCII characters in the pandas Data Frame.</p>
  
  <pre><code>import pandas as pd
  XList=['Meßi','Ürik']
  YList=['01.01.1970','01.01.1990']
  
  df = pd.DataFrame({'X':XList,
                     'Y':YList})
  
        X           Y
  0  Meßi  01.01.1970 
  1  Ürik  01.01.1990
  </code></pre>
  
  <p>I would like to create some replace rules: eg. ß->ss and Ü->UE</p>
  
  <p>and get this:</p>
  
  <pre><code>       X           Y
  0  Messi  01.01.1970 
  1  UErik  01.01.1990
  </code></pre>
  
  <p>Note: Im using Python 2.7</p>
  
  <p><strong>UPDATE:</strong></p>
  
  <p>Solved using the answer below and setting up by Eclipse following:</p>
  
  <p>1°: Changing Text file encoding in Eclipe to UTF-8.</p>
  
  <p>How to:
  <a href="https://stackoverflow.com/questions/200691/how-to-use-special-chars-in-java-eclipse">How to use Special Chars in Java/Eclipse</a></p>
  
  <p>2°: Adding to the first line command</p>
  
  <pre><code># -*- coding: UTF-8 -*- 
  </code></pre>
  
  <p><a href="http://www.vogella.com/tutorials/Python/article.html" rel="nofollow noreferrer">http://www.vogella.com/tutorials/Python/article.html</a></p>