title: Create new dataframe from two other dataframes conditional on each row value
body: <p>I have 2 data frames</p>
  
  <pre><code>Name1    Value
  A1         1
  A2         2
  A3         0
  A4        -3
  
  Name2    Value
  B1         1
  B2        -1
  B3       -10
  B4         4
  </code></pre>
  
  <p>Now I want a third data frame, that picks the rows of the two data frames above, subject to a condition, in particular: "Pick the row with the smaller value"</p>
  
  <pre><code>Desired Output
  A1         1         # &lt;- What happens when tied?
  B2        -1
  B3       -10
  A4        -3
  </code></pre>
  
  <p>The next question is what happens if there are ties? Actually, I would be open to take the first one for instance, or randomly picked, whatever is easier.</p>