title: How to process large CSV file in powershell
body: <p>I am trying to find the number of rows in a csv file that have above a certain value. The code I have goes something like </p>
  
  <pre><code>$T6=Import-Csv $file | Where-Object {$_."Value" -ge 0.6 } | Measure-Object
  </code></pre>
  
  <p>This works well for smaller files but for large csv files(1 GB or more) it will run forever. Is there any better way to parse csv files like this in powershell?</p>