title: How to delete a row in a dataframe based on a column event with consecutive same value
body: <p>For example, the below is a data frame:</p>
  <pre><code>   Index      Name       Action
      0          result    pass
      1          result    fail
      2          result    fail
      3          result    pass
      4          result    fail
      5          result    pass
      6          result    pass
      7          result    pass
  </code></pre>
  <p>Here we are taking reference of &quot;Action&quot; column, consecutive 'pass' or 'fail' will result only last one of the row to be present.</p>
  <p>so expected output will be as below:</p>
  <pre><code>   Index      Name       Action
      0          result    pass
      2          result    fail
      3          result    pass
      4          result    fail
      7          result    pass
  </code></pre>