How to partially split string elements of a dataframe in python? [duplicate]

Question

I have a dataframe of email addresses, and I want to search which are the most used email providers (eg. gmail.com, yahoo.com etc). I used the following code

dfEmail=Ecom['Email']

I have the following data

0                    [email protected]

1                   [email protected]

2       [email protected]

3          [email protected]

4          [email protected]

...              

9995            [email protected]

9996                [email protected]

9997                 [email protected]

9998           [email protected]

9999             [email protected]

Name: Email, Length: 10000, dtype: object

I want to split these email addresses at "@" and get only names of email providers.

I tried the following

dfEmailSplit=dfEmail.str.split('@')
dfEmailSplit[500][1]

this gave me the following result:

'gmail.com'

How do i do this for all the email addresses?

for accessing indexes of a list, you can use pandas str accessor: dfEmail.str.split('@').str[1] — anky
– anky, Commented Aug 22, 2020 at 8:21
@SeyiDaniel No problem :) However it is a dupe hence commented — anky
– anky, Commented Aug 22, 2020 at 10:33

Seyi Daniel · Accepted Answer · 2020-08-22 08:51:58Z

1

import pandas as pd     
df = pd.DataFrame() 
data = {'email':['[email protected]', '[email protected]', 'amymiller@morales- harrison.com']} 
df = pd.DataFrame(data) 
tlds = {'tlds': [x.split('@')[1] for x in df['email']]}
df = pd.DataFrame(tlds)  
print(df)

answered Aug 22, 2020 at 8:51

Seyi Daniel

2,3902 gold badges10 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mark Rotteveel Over a year ago

Please don't post only code as answer, but also provide an explanation what your code does and how it solves the problem of the question. Answers with an explanation are usually more helpful and of better quality, and are more likely to attract upvotes.

Seyi Daniel Over a year ago

@MarkRotteveel: Noted. Thanks.

Collectives™ on Stack Overflow

How to partially split string elements of a dataframe in python? [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related