How I can count the total of numbers with python if statement?

Question

I want to count the total occurrence of the number 5 in my dataframe df with 4 lists inside it (there are 3 numbers 5 in my df). But in my code bellow the if statement stops when it encounters the first False return and does not count the third 5 in the last list in df. How I can resolve this?

df = [[1,3,5,7,9],[1,2,3,4,5],[2,4,6,8,10],[2,5,6,8,10]]
n,m,counter=0,5,0

for i in range(4):
    if df[n].count(m):
        print('ok')
        counter=counter+1
        n=n+1
    else:
        print('NO')
print(counter)

you're not iterating properly. instead of using for i in range(4) use something like this: — n1c9
– n1c9, Commented Apr 15, 2016 at 21:14
for l in df: for item in l: if item==5: print('ok') counter += 1 else: print('NO') print counter — n1c9
– n1c9, Commented Apr 15, 2016 at 21:14
Thanks n1c9!! "Learning, and perhaps even helping others!" I understandig, I had to do two iterations. My final code is: for l in df: for item in l: if item == m: counter += 1 print counter — João Alexandre Silveira
– João Alexandre Silveira, Commented Apr 16, 2016 at 12:05

Mike Müller · Accepted Answer · 2016-04-15 21:15:28Z

3

You need to index with i not with n here:

if df[n].count(m):

Better:

if df[i].count(m):

Shorter way:

sum(x.count(5) for x in df)

answered Apr 15, 2016 at 21:15

Mike Müller

86k21 gold badges174 silver badges165 bronze badges

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

1 Comment

João Alexandre Silveira Over a year ago

Thanks Mike Müller! Your shorter way is a very good solution!

DevLounge · Accepted Answer · 2016-04-15 21:18:59Z

1

I approached the problem a bit differently, but here is the code I would use to solve this problem:

df = [[1,3,5,7,9],[1,2,3,4,5],[2,4,6,8,10],[2,5,6,8,10]]

m=5
counter = 0
for sublist in df:
    counter += sublist.count(m)
print(counter)

Rather than creating multiple variables and having a 'for loop', I set up a for loop to iterate through each list in the original list.

edited Apr 15, 2016 at 21:18

DevLounge

8,4633 gold badges33 silver badges44 bronze badges

answered Apr 15, 2016 at 21:16

J. Roibal - BlockchainEng

1246 bronze badges

1 Comment

João Alexandre Silveira Over a year ago

Thanks Apero! Your approach is another interesting way to do that.

Sam · Accepted Answer · 2016-04-15 21:15:48Z

0

You aren't getting to look at every list because you are only incrementing n if you do find a '5' in the list. But you only try 4 times, so you are effectively looking at [2,4,6,8,10] twice and then running out of range.

answered Apr 15, 2016 at 21:15

Sam

3402 gold badges4 silver badges11 bronze badges

1 Comment

João Alexandre Silveira Over a year ago

Thanks Sam! You are right, I understood my mistake.

Collectives™ on Stack Overflow

How I can count the total of numbers with python if statement?

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related