For loop in python 3 (multiple Iteration)

Question

I read a csv file named df, which has 4 columns(id, skill,..) and 30 rows, I want the program to check each id and if the id is "A035755" then print its related skill (j). I wrote the following program it almost works but the problem is it iterates more than once so instead of 30 results I have more than 100!
I think my indexing might be the problem but not sure how to fix it.

Thanks J

df=pd.read_csv('location')
for i in df.id[0:len(df)]:  #id is one of the columns
    for j in df.skill:       #skill another column
        if i == "A035755":
            print(j)
        else:
            print("Not Found")

Gennady Kandaurov · Accepted Answer · 2016-11-24 09:18:58Z

1

If I understand correctly, df's attributes (df.id, df.skill) represent columns and indexes in the lists (df.id[1..n]) represent rows, then proper way is following:

df = pd.read_csv('location')
for index, rec_id in enumerate(df.id):  #id is one of the columns
    if rec_id == "A035755":
        print(df.skill[index])

edited Nov 24, 2016 at 9:18

answered Nov 24, 2016 at 8:04

Gennady Kandaurov

1,9741 gold badge15 silver badges21 bronze badges

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

Comments

harshil9968 · Accepted Answer · 2016-11-24 08:10:12Z

0

So you can iterate and refrence the index. Like this

for index,value in df.id.items():  #id is one of the columns
        if value == "A035755":
            print(df.skill[index])
        else:
            print("Not Found")

Or you can iterate on records

for record in df:
    if record.id == "A035755":
        print(record.skill)
    else:
        print("Not Found")

answered Nov 24, 2016 at 8:10

harshil9968

3,2441 gold badge18 silver badges27 bronze badges

2 Comments

S. 16 Over a year ago

Thanks, But none of the solution works. Actually what the program does, is printing skill column 3 times and then one time "Not found"

harshil9968 Over a year ago

can you add present output and expected output to the question?

Collectives™ on Stack Overflow

For loop in python 3 (multiple Iteration)

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