encoding while reading csv files

Viewed 32

I'd like to merge df1 and df2 on a 'name' column.
Each dataframe is built from a seperate csv file, respectively csv1 and csv2.
A name in df1 is 'Šarūnas Marčiulionis' and in csv1 file it is 'Ĺ arĹ«nas MarÄŤiulionis'.
In csv2 it is 'Šar?nas Marčiulionis' which gives me '\x8aar?nas Marèiulionis' in my df2.
Of course, these are the same person's names and I'd like to merge on it. Is there a way while reading csv files to get the same output in my data frames? Any general encoder that would transform names from csv into letters of only english aplhabet? Naturaly, there are more names like that in my data.

0 Answers
Related