raw_data = {'NAME': ['José L. da Silva',
'Ricardo Proença',
'Antônio de Morais']}
df = pd.DataFrame(raw_data, columns = ['NAME'])
How to make NAME column names into:
You can use the apply() function of objects of type Series . With it you can apply any function that returns something. So you can define a correction function and apply it. For example:
def corrigir_nomes(nome):
nome = nome.replace('.', '').replace('ç', 'c').replace('ô', 'o').replace('é', 'e')
return nome
And then apply the column you want:
df['NAME'] = df['NAME'].apply(corrigir_nomes)
The result will look something like:
0 Jose L da Silva
1 Ricardo Proenca
2 Antonio de Morais
Name: NAME, dtype: object