'I'm using Pandas to fix an email list on a column using .replace() but isn't working

I'm trying to fix truncated email addresses using Pandas replace() method, I followed several online tutorials, but the results I am getting aren't what I want. this is my first try

filtered_users_emails = pd.read_csv('list_users.csv')
filtered_users_emails_replaced = filtered_users_emails.replace({
                                                              '.c': '.com',
                                                              '.co': '.com'
                                                             })

and the second one using Regex gave me unexpected results


filtered_users_emails = pd.read_csv('list_users.csv')
filtered_users_emails_replaced = filtered_users_emails.replace({
                                                              '.c': '.com',
                                                              '.co': '.com'
                                                             },
                                                             regex=True)

From the above you can see I am trying to replace truncated emails ending in .c and .co, to end as expected in .com

python-3.x pandas

Solution 1:^[1]

this worked for me:

filtered_users_emails['email'] = filtered_users_emails['email'].str.replace('.com*','.c', regex=True) filtered_users_emails['email'] = filtered_users_emails['email'].str.replace('.c','.com', regex=True)

Solution 2:^[2]

try this one :

filtered_users_emails ['email'] = filtered_users_emails ['email'].str.replace('.co','.com')

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Gajraj Singh
Solution 2	TheTwo

'I'm using Pandas to fix an email list on a column using .replace() but isn't working

Solution 1:[1]

Solution 2:[2]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]