How to loop with pandas: 'for each row in file, for each column in row'

Question

My dataset looks like this:

and i need to loop through each day, and then each time of the day, and check whether the state is A, B or C. I tried as below, but it doesnt seem to work correctly.. thanks for the help.

for row in file.itertuples():
    for j in row:
       if j == 'A'
          *set parameters to certain values*
       if j == 'B'
          *set parameters to other values*

Your statement, "...but it doesnt seem to work correctly.", could you elaborate? To me it looks like your code should work, so what issues are you facing? — Marcus
– Marcus, Commented Oct 18, 2020 at 16:54
Please provide the expected MRE. Show where the intermediate results deviate from the ones you expect. We should be able to paste a single block of your code into file, run it, and reproduce your problem. Images of text are not acceptable, in keeping with the purpose of this site. "It doesn't seem to work correctly" is not a problem specifciation. — Prune
– Prune, Commented Oct 18, 2020 at 17:00
Please repeat on topic and how to ask from the intro tour. Any PANDAS tutorial will teach you how to iterate through the entire data frame; what are you doing differently? What effects do you see? — Prune
– Prune, Commented Oct 18, 2020 at 17:01

Mehdi Golzadeh · Accepted Answer · 2020-10-18 17:32:46Z

1

use iterrows() instead of itertuples(), also you need a : after each if.

for i,row in file.iterrows():
    for j in row:
       if j == 'A':
          *set parameters to certain values*
          file.iloc[i,'column_name'] = value #for example
       if j == 'B':
          *set parameters to other values*

edited Oct 18, 2020 at 17:32

answered Oct 18, 2020 at 17:08

Mehdi Golzadeh

2,5931 gold badge18 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

How to loop with pandas: 'for each row in file, for each column in row'

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