title: Dropping rows based on multiple column conditions in R
body: <p>I want to subset rows based on different column conditions across several columns. For example, in the attached picture, I want my script to remove all rows that meet the following conditions:</p>
  <p>In any of the columns (One through Five), remove rows where no valid entry is made in any of the five columns (valid entries are: poor, good, very_good, excellent). In essence, remove rows with invalid entries (invalid entries are: &quot;NULL&quot;, &quot;''&quot; or contains &quot;@&quot;)</p>
  <p>In this example, only Chris will be excluded and others will be retained since they contain at least one valid entry across the 5 columns.<a href="https://i.stack.imgur.com/N8RF6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N8RF6.png" alt="enter image description here" /></a></p>
  <p>Data:</p>
  <pre><code>df &lt;-
    tibble(
      Name = c(&quot;John&quot;, &quot;Peter&quot;, &quot;Paul&quot;, &quot;Joy&quot;, &quot;Mike&quot;, &quot;Vinc&quot;, &quot;Ben&quot;, &quot;Chris&quot;),
      One = c(&quot;NULL&quot;, &quot;@gmail&quot;, &quot;NULL&quot;, &quot;good&quot;, &quot;''&quot;, &quot;very_good&quot;, &quot;excellent&quot;, &quot;NULL&quot;),
      Two = c(&quot;@yahoo&quot;, &quot;''&quot;, &quot;good&quot;, &quot;good&quot;, &quot;good&quot;, &quot;excellent&quot;, &quot;NULL&quot;, &quot;''&quot;),
      Three = c(&quot;''&quot;, &quot;good&quot;, &quot;very good&quot;, &quot;poor&quot;, &quot;excellent&quot;, &quot;NULL&quot;, &quot;NULL&quot;, &quot;@gmai&quot;),
      Four = c(&quot;good&quot;, &quot;good&quot;, &quot;good&quot;, &quot;NULL&quot;, &quot;good&quot;, &quot;good&quot;, &quot;good&quot;, &quot;NULL&quot;),
      Five = c(&quot;@gmail&quot;, &quot;very good&quot;, &quot;excellent&quot;, &quot;poor&quot;, &quot;NULL&quot;, &quot;NULL&quot;, &quot;NULL&quot;, &quot;NULL&quot;)
    )
  </code></pre>