Using filter in dataframe

Question

I had a question where i needed to find how many people have the word "Chief" in their jobtitle? i was using the below two approaches but both of them give different answers, kindly let me know what's the difference and which should i use.

Approach 1:

len(sal[sal.JobTitle.str.contains("Chief", case=True, na=False)])

This gives output as 423

Approach 2:

count = 0
for job in sal['JobTitle']:
    for j in job.split():
        if j.lower() =='chief':
            count+=1
            print(count)

This gives the correct output 477.

Use case=False in the first code. Also, you might have rows with multiple occurrences of "chief" in the same string, you count them in the second approach, not the first — mozway
– mozway, Commented Jul 28, 2022 at 5:15

Alireza75 · Accepted Answer · 2022-07-28 05:06:19Z

2

It is because of your approach 1 count 'Chief' but approach 2 first lower and thencount 'chief'. It is possible to there were some records with lowercase in job title and approach 1 can not count them

answered Jul 28, 2022 at 5:06

Alireza75

5011 gold badge5 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Using filter in dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related