In [60]: df['Country'].str.normalize('NFKD').str.encode('ascii', errors='ignore').str.decode('utf-8') Out[60]: 0 Aland Islands 1 Aland Islands 2 Albania 3 Albania 4 Albania Name: Country, dtype: object
df['Country'] = df['Country'].str.replace(u"Å", "A") df['City'] = df['City'].str.replace(u"ë", "e")
