Conditional loop in python using pandas

Question

The below code snippet containing conditional statements is not working as expected. It's returning all 0s for usage['knozo'] where it should contain 1s as well for some rows. Can someone figure out where am I going wrong in this loop/condition?

for i in range(0,len(usage)):
    for j in range(0,len(knozo)):
        if usage['key_usage'].iloc[i] == knozo['key_knozo'].iloc[j]:
            usage['knozo'] = 1
        else:
            usage['knozo'] = 0
            break

that means the conditional you have is always false. So Id start with looking at those 2 variables independently to see whats going on. Maybe add a print statement? print("{} == {} => {}".format(a,b,a==b)) where a and b are those 2 condition parameters? — Fallenreaper
– Fallenreaper, Commented Mar 14, 2018 at 16:16

krflol · Accepted Answer · 2018-03-14 16:18:08Z

1

You could try replacing

if usage['key_usage'].iloc[i] == knozo['key_knozo'].iloc[j]:

with

if usage.at[i, 'key_usage'] == konzo.at[j, 'key_konzo']:

edit: also, doing usage['konzo'] = 0 will fill the entire series with that value, so the last condition you evaluate happens to be 0, and you're filling the entire dataframe. You need to specify which element you want to change.

answered Mar 14, 2018 at 16:18

krflol

1,1658 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Conditional loop in python using pandas

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