title: Extract value from data frame column based on another column?
body: <p>I have a data frame </p>
  
  <pre><code>Name  score1  score2  Total
  john   5       15      20
  doe    10      20      30
  </code></pre>
  
  <p>I know we can get the score 1 using frame$score1 but can i query based on another column.</p>
  
  <p>I want to get where <code>total &gt; 25 and score2 &gt; 15</code> and get <code>score1</code></p>
  
  <p>Result:</p>
  
  <pre><code>score1
    10
  </code></pre>