Pandas - Data Frame string value count

Question

I Need to know how many time a string appears in my dataframe, I used the follow sentence:

print(df['Mobile Register' == df.col1].shape[0])

But my problem is, I need to find all registers where contains Mobile Register, because in my data frame this string can be Mobile Register 1, Mobile Register 2, Mobile Register 3, Mobile Register n ...

So I understand my command will not be used, therefore, what a need to do to find the count?

anky · Accepted Answer · 2019-02-12 19:04:58Z

1

Use series.str.contains():

df.loc[df['col_name'].str.contains('Mobile Register',na=False)]

This will give you all the rows satisfying the condition.

To find count of a specific column which meets this condition , use:

df.loc[df['col_name'].str.contains('Mobile Register',na=False),'column_name'].count()

If you need count of all columns satisfying this condition:

df.loc[df['col_name'].str.contains('Mobile Register',na=False)].count()

answered Feb 12, 2019 at 19:04

anky

75.3k11 gold badges46 silver badges76 bronze badges

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

Comments

Davi Amaral · Accepted Answer · 2019-02-12 19:15:21Z

0

I don´t know it could be helpful or if it is the best solution, but I found what I want with the follow sentence

names = df.col1.tolist()
count=0
for colname in enumerate(names):
    print(colname[1])
    if ('Mobile Register' in str(colname[1])):
        count=count+1

answered Feb 12, 2019 at 19:15

Davi Amaral

5584 silver badges16 bronze badges

2 Comments

Davi Amaral Over a year ago

names = df.col1.tolist() will show me all registers from col1,

Davi Amaral Over a year ago

I agree with you, I can delete this answer, I thought in this before read about series.str.contains():

Collectives™ on Stack Overflow

Pandas - Data Frame string value count

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related