title: Group by numerical columns with a threshold of error
body: <p>I have this dataframe,</p>
  <p><strong>input</strong>:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">DishID(string)</th>
  <th style="text-align: center;">Recipe(string)</th>
  <th style="text-align: right;">Pct(float)</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">One</td>
  <td style="text-align: center;">chicken</td>
  <td style="text-align: right;">0.5</td>
  </tr>
  <tr>
  <td style="text-align: left;">One</td>
  <td style="text-align: center;">rice</td>
  <td style="text-align: right;">0.3</td>
  </tr>
  <tr>
  <td style="text-align: left;">One</td>
  <td style="text-align: center;">tomatoes</td>
  <td style="text-align: right;">0.2</td>
  </tr>
  <tr>
  <td style="text-align: left;">two</td>
  <td style="text-align: center;">chicken</td>
  <td style="text-align: right;">0.501</td>
  </tr>
  <tr>
  <td style="text-align: left;">two</td>
  <td style="text-align: center;">rice</td>
  <td style="text-align: right;">0.3003</td>
  </tr>
  <tr>
  <td style="text-align: left;">two</td>
  <td style="text-align: center;">tomatoes</td>
  <td style="text-align: right;">0.1999</td>
  </tr>
  <tr>
  <td style="text-align: left;">three</td>
  <td style="text-align: center;">beef</td>
  <td style="text-align: right;">0.5</td>
  </tr>
  <tr>
  <td style="text-align: left;">three</td>
  <td style="text-align: center;">rice</td>
  <td style="text-align: right;">0.4999</td>
  </tr>
  <tr>
  <td style="text-align: left;">four</td>
  <td style="text-align: center;">beef</td>
  <td style="text-align: right;">0.5001</td>
  </tr>
  <tr>
  <td style="text-align: left;">four</td>
  <td style="text-align: center;">rice</td>
  <td style="text-align: right;">0.499</td>
  </tr>
  <tr>
  <td style="text-align: left;">five</td>
  <td style="text-align: center;">egg</td>
  <td style="text-align: right;">0.300</td>
  </tr>
  <tr>
  <td style="text-align: left;">five</td>
  <td style="text-align: center;">tomatoes</td>
  <td style="text-align: right;">0.700</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><code>Def Find_matching_recipe(Threshold = 0.01): </code></p>
  <p><strong>output desired</strong>:
  <code>[[One,Two],[Three,four],[Five]] </code></p>
  <p>With a threshold of error , group the <em>similar</em> dish according their recipe and the percentage corresponding.</p>
  <p>I know how to do it for percentage that are exactly the same(Threshold=0), but I have no clue how to do it with a threshold of error.</p>
  <p>It can be in SQL or pandas python.</p>
  <p>Thank you for your help,
  Don't hesitate if you have any question</p>