title: Double Condition Merge using Pandas
body: <p>I am trying to merge the following tables using the <code>pandas</code> library in python. I have tried to do this with variation of <code>merge_as_of</code> and <code>merge</code> with no success.</p>
  <p>Master Data:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Asset ID</th>
  <th>Size (mm)</th>
  <th>Depth (m)</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>100</td>
  <td>1.5</td>
  </tr>
  <tr>
  <td>2</td>
  <td>400</td>
  <td>1</td>
  </tr>
  <tr>
  <td>3</td>
  <td>500</td>
  <td>4.5</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Condition Table:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>&lt; Size (mm)</th>
  <th>&lt; Depth (m)</th>
  <th>Estimated Repair Time (days)</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>300</td>
  <td>2</td>
  <td>1</td>
  </tr>
  <tr>
  <td>300</td>
  <td>4</td>
  <td>1.5</td>
  </tr>
  <tr>
  <td>300</td>
  <td>6</td>
  <td>2</td>
  </tr>
  <tr>
  <td>600</td>
  <td>2</td>
  <td>1.5</td>
  </tr>
  <tr>
  <td>600</td>
  <td>4</td>
  <td>2</td>
  </tr>
  <tr>
  <td>600</td>
  <td>6</td>
  <td>3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>To achieve the following table:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Asset ID</th>
  <th>Size (mm)</th>
  <th>Depth (m)</th>
  <th>Estimated Repair Time</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>100</td>
  <td>1.5</td>
  <td>1</td>
  </tr>
  <tr>
  <td>2</td>
  <td>400</td>
  <td>1</td>
  <td>1.5</td>
  </tr>
  <tr>
  <td>3</td>
  <td>400</td>
  <td>4.5</td>
  <td>3</td>
  </tr>
  </tbody>
  </table>
  </div>