Marge subsequent rows pandas

Question

Hay I have this series:

Now I want to Marge all the subsequent rows and take the first row(that start the sequence)

For the example above I want the outcome be this:

There is a sample way to that instade of iterate the all series and search for sequences?

Thanks

score 0 · Answer 1 · answered Jun 07 '20 at 11:04

0

Use boolean indexing wit compare shifted values by Series.shift with not equal by Series.ne:

df = df[df['col'].ne(df['col'].shift())]
print (df)

    col
0  3274
2  2374
4  2375
5  2374
7  3275

answered Jun 07 '20 at 11:04

jezrael

1 Answers1