title: Extract value from column with pandas lib (data frame)
body: <p>original data frame:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Date</th>
  <th>Detail</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>31/03/22</td>
  <td>I watch Netflix at home with my family 4 hours</td>
  </tr>
  <tr>
  <td>01/04/22</td>
  <td>I walk to the market for 3km and I spent 11.54 dollar</td>
  </tr>
  <tr>
  <td>02/04/22</td>
  <td>my dog bite me, I go to hospital, spend 29.99 dollar</td>
  </tr>
  <tr>
  <td>03/04/22</td>
  <td>I bought a game on steam 7 games spen 19.23 dollar</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>result data frame:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Date</th>
  <th>Detail</th>
  <th>Cost</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>31/03/22</td>
  <td>I watch Netflix at home with my family 4 hours</td>
  <td>0</td>
  </tr>
  <tr>
  <td>01/04/22</td>
  <td>I walk to the market for 3km and I spent 11.54 dollar</td>
  <td>11.54</td>
  </tr>
  <tr>
  <td>02/04/22</td>
  <td>my dog bite me, I go to hospital, spend 29.99 dollar</td>
  <td>29.99</td>
  </tr>
  <tr>
  <td>03/04/22</td>
  <td>I bought a game on steam 7 games spen 19.23 dollar</td>
  <td>19.23</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Describe my question:</p>
  <ul>
  <li><p>If <strong>Detail</strong> Column does not contain specific string which is begin with sp.. and end with dollar
  then value in <strong>Cost col</strong> equal zero.</p>
  </li>
  <li><p>If <strong>Detail</strong> Column does contain specific string which is begin with sp.. and end with dollar,
  then value in <strong>Cost col</strong> equal <strong>value in the middle</strong> of specific string which is begin with sp..
  and end with dollar.</p>
  </li>
  </ul>
  <p>I try to use regex but it's got first int that contain in the col like</p>
  <p>| 01/04/22   | I walk to the market for 3km and I spent 11.54 dollar|  3    |</p>