title: how to sum multiple row data using pandas and data is excel formet
body: <p>Hi Everyone how to sum multiple row data using pandas and the data is excel format, and sum only edwin and maria data,please help me out thanks in advance.</p>
  <p><strong>excel data</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th></th>
  <th>name</th>
  <th>salary</th>
  <th>incentive</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>0</td>
  <td>john</td>
  <td>2000</td>
  <td>400</td>
  </tr>
  <tr>
  <td>1</td>
  <td>edwin</td>
  <td>3000</td>
  <td>600</td>
  </tr>
  <tr>
  <td>2</td>
  <td>maria</td>
  <td>1000</td>
  <td>200</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><strong>expected output</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th></th>
  <th>name</th>
  <th>salary</th>
  <th>incentive</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>0</td>
  <td>Total</td>
  <td>5000</td>
  <td>1000</td>
  </tr>
  <tr>
  <td>1</td>
  <td>john</td>
  <td>2000</td>
  <td>400</td>
  </tr>
  <tr>
  <td>2</td>
  <td>edwin</td>
  <td>3000</td>
  <td>600</td>
  </tr>
  <tr>
  <td>3</td>
  <td>maria</td>
  <td>1000</td>
  <td>200</td>
  </tr>
  </tbody>
  </table>
  </div>