How to iterate over rows of a single column based on value of another column?

Question

This is the dataset I am working on right now.

I want to find the maximum value of the cycle column for a single value of the id column. For ex, I want to find out the max cycle value for id-1, id-2 and so on but I can't really figure out the loop logic. How do I get the code to ouptut maximum cycle value for particular id? My dataset has id values from 1-100 so the code should give me a 100 max cycle values.

can you give some example data? Also, use pandas split-apply-combine: http://pandas.pydata.org/pandas-docs/stable/groupby.html — Nico Albers, Apr 02 '18 at 18:03
@NicoAlbers sorry for not being able to provide the data. I worked around with the solution provided by Wen and got the answer. Thank you for the SAC reference though — Viraj Mehta, Apr 04 '18 at 14:14

score -1 · Answer 1 · answered Apr 02 '18 at 19:24

-1

it's not a loop. you can use a pivot table to find your answer:

https://pandas.pydata.org/pandas-docs/stable/reshaping.html

answered Apr 02 '18 at 19:24

Emiliano Isaza Villamizar

347
2
14

How to iterate over rows of a single column based on value of another column?

1 Answers1