<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Date (Start)</th>
      <th>Date (End)</th>
      <th>First name (legal)</th>
      <th>Last name (legal)</th>
      <th>Headcount</th>
      <th>Status</th>
      <th>Legal Entity</th>
      <th>Department</th>
      <th>Team</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>2023-10-01 00:59:39</td>
      <td>2023-10-30 23:59:39</td>
      <td>Matthew</td>
      <td>Adams</td>
      <td>1</td>
      <td>Active</td>
      <td>NaN</td>
      <td>HR</td>
      <td>(Deleted)</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2023-10-01 00:59:39</td>
      <td>2023-10-30 23:59:39</td>
      <td>Hailey</td>
      <td>Allen</td>
      <td>1</td>
      <td>Active</td>
      <td>NaN</td>
      <td>Finance</td>
      <td>(Deleted)</td>
    </tr>
    <tr>
      <th>2</th>
      <td>2023-10-01 00:59:39</td>
      <td>2023-10-30 23:59:39</td>
      <td>Maria</td>
      <td>Burton</td>
      <td>1</td>
      <td>Active</td>
      <td>NaN</td>
      <td>HR</td>
      <td>(Deleted)</td>
    </tr>
    <tr>
      <th>3</th>
      <td>2023-10-01 00:59:39</td>
      <td>2023-10-30 23:59:39</td>
      <td>Susa</td>
      <td>Christi</td>
      <td>1</td>
      <td>Active</td>
      <td>NaN</td>
      <td>IT</td>
      <td>(Deleted)</td>
    </tr>
    <tr>
      <th>4</th>
      <td>2023-10-01 00:59:39</td>
      <td>2023-10-30 23:59:39</td>
      <td>Petra</td>
      <td>Davidson</td>
      <td>1</td>
      <td>Active</td>
      <td>NaN</td>
      <td>IT</td>
      <td>(Deleted)</td>
    </tr>
  </tbody>
</table>
</div>

         Date (Start)          Date (End) First name (legal)  \
0 2023-10-01 00:59:39 2023-10-30 23:59:39            Matthew   
1 2023-10-01 00:59:39 2023-10-30 23:59:39             Hailey   
2 2023-10-01 00:59:39 2023-10-30 23:59:39              Maria   
3 2023-10-01 00:59:39 2023-10-30 23:59:39               Susa   
4 2023-10-01 00:59:39 2023-10-30 23:59:39              Petra   

  Last name (legal)  Headcount  Status  Legal Entity Department       Team  
0             Adams          1  Active           NaN         HR  (Deleted)  
1             Allen          1  Active           NaN    Finance  (Deleted)  
2            Burton          1  Active           NaN         HR  (Deleted)  
3           Christi          1  Active           NaN         IT  (Deleted)  
4          Davidson          1  Active           NaN         IT  (Deleted)  

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Department</th>
      <th>Headcount</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>Customer Service</td>
      <td>4</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Finance</td>
      <td>4</td>
    </tr>
    <tr>
      <th>2</th>
      <td>HR</td>
      <td>6</td>
    </tr>
    <tr>
      <th>3</th>
      <td>IT</td>
      <td>7</td>
    </tr>
    <tr>
      <th>4</th>
      <td>Management</td>
      <td>1</td>
    </tr>
    <tr>
      <th>5</th>
      <td>Marketing and Sales</td>
      <td>11</td>
    </tr>
  </tbody>
</table>
</div>

            Department  Headcount
0     Customer Service          4
1              Finance          4
2                   HR          6
3                   IT          7
4           Management          1
5  Marketing and Sales         11

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Status</th>
      <th>Headcount</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>Active</td>
      <td>34</td>
    </tr>
  </tbody>
</table>
</div>

   Status  Headcount
0  Active         34

Analysis of Total Headcount by Department

What is the total headcount by department?

chnage to bar chart

Can you break down the headcount by status?

Can you show the headcount distribution by department in a pie chart?

Department	Headcount
Customer Service	4
Finance	4
HR	6
IT	7
Management	1
Marketing and Sales	11