title: Filter rows based on a series pandas
body: <p>I've been facing a problem to filter out values in a column. I have a dataframe (data) which looks like the one below.</p>
  
  <pre><code> Index                                                            Value
  2019-11-22 00:00:00                                                0.0  
  2019-11-22 00:05:00                                                1.0  
  2019-11-22 00:10:00                                                2.0  
  2019-11-22 00:15:00                                                3.0  
  2019-11-22 00:20:00                                                4.0  
  2019-11-22 00:25:00                                                5.0  
  2019-11-22 00:30:00                                                6.0  
  2019-11-22 00:35:00                                                7.0  
  2019-11-22 00:40:00                                                8.0  
  2019-11-22 00:45:00                                                0.0  
  2019-11-22 00:50:00                                                0.0  
  2019-11-22 00:55:00                                                1.0  
  2019-11-22 01:00:00                                                2.0  
  2019-11-22 01:05:00                                                3.0  
  2019-11-22 01:10:00                                                4.0  
  2019-11-22 01:15:00                                                5.0  
  </code></pre>
  
  <p>I want to keep the series of values which go above 5 and want to assign all others as zero. For example, if the values are from 1-5, all the previous values before 5 should be set to zero and if there are eight rows with values from 1-8, the code should keep them as it is.The final output should be the following.</p>
  
  <pre><code> Index                                                            Value
  2019-11-22 00:00:00                                                0.0  
  2019-11-22 00:05:00                                                1.0  
  2019-11-22 00:10:00                                                2.0  
  2019-11-22 00:15:00                                                3.0  
  2019-11-22 00:20:00                                                4.0  
  2019-11-22 00:25:00                                                5.0  
  2019-11-22 00:30:00                                                6.0  
  2019-11-22 00:35:00                                                7.0  
  2019-11-22 00:40:00                                                8.0  
  2019-11-22 00:45:00                                                0.0  
  2019-11-22 00:50:00                                                0.0  
  2019-11-22 00:55:00                                                0.0  
  2019-11-22 01:00:00                                                0.0  
  2019-11-22 01:05:00                                                0.0  
  2019-11-22 01:10:00                                                0.0  
  2019-11-22 01:15:00                                                0.0  
  </code></pre>
  
  <p>When I try</p>
  
  <pre><code>    data[data&lt;5]=0
  </code></pre>
  
  <p>It just returns the values higher than 5. Any help will be great on this.</p>