title: lookup into another dataframe and filter value
body: <p>I have dataframe named <em>df</em>  which has two columns id1 and id2</p>
  <p>I need to filter values based on some other df named as <em>meta_df</em></p>
  <p>meta_df has three columns id,name,text</p>
  <p>df</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id1</th>
  <th>id2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>12</td>
  <td>34</td>
  </tr>
  <tr>
  <td>99</td>
  <td>42</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>metadf</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>name</th>
  <th>text</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>12</td>
  <td>aa</td>
  <td>lowerend</td>
  </tr>
  <tr>
  <td>42</td>
  <td>bb</td>
  <td>upperend</td>
  </tr>
  <tr>
  <td>99</td>
  <td>cc</td>
  <td>upper limit</td>
  </tr>
  <tr>
  <td>34</td>
  <td>dd</td>
  <td>uppersome</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I need values from text  which have lower and upper in string of text. e.g 12 and 34
  I am trying the below code and stuck at getting text clumn</p>
  <pre><code>for row in df.itertuples():
      print(row.Index, row.id1, row.id2)
      print(meta_df[id['id']== row.id1])
      print(meta_df[id['id']== row.id2])
  </code></pre>
  <p>Output Expected</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id2</th>
  <th>id2</th>
  <th>flag</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>12</td>
  <td>34</td>
  <td>yes</td>
  </tr>
  <tr>
  <td>99</td>
  <td>42</td>
  <td>no</td>
  </tr>
  </tbody>
  </table>
  </div>