How do I select next row from a DataFrame based on condition?

Question

I would like to select next row when the condition is true.

In SQL, I would use:

FROM [dbo].[table1] where Num IN (select Num + 1 from table1$ where Status='start')

Does this answer your question? [How do I select rows from a DataFrame based on column values?](https://stackoverflow.com/questions/17071871/how-do-i-select-rows-from-a-dataframe-based-on-column-values) — Henry Ecker, Jun 14 '21 at 19:08

score 0 · Answer 1 · edited Jun 18 '21 at 02:13

0

To select rows where Status is equal to start:

selected_rows = df[df['Status'] == 'start]

edited Jun 18 '21 at 02:13

user3483203

answered Jun 14 '21 at 20:40

Nate Rush

1 Answers1