Work Item Type
Task    471
Name: count, dtype: int64

<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>ID</th>
      <th>Work Item Type</th>
      <th>Title</th>
      <th>Assigned To</th>
      <th>State</th>
      <th>Tags</th>
      <th>Completed Work</th>
      <th>Changed Date</th>
      <th>Story Points</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>count</th>
      <td>471.000000</td>
      <td>471</td>
      <td>471</td>
      <td>471</td>
      <td>471</td>
      <td>469</td>
      <td>471.000000</td>
      <td>471</td>
      <td>0.0</td>
    </tr>
    <tr>
      <th>unique</th>
      <td>NaN</td>
      <td>1</td>
      <td>426</td>
      <td>1</td>
      <td>3</td>
      <td>70</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>top</th>
      <td>NaN</td>
      <td>Task</td>
      <td>DSN - Dailies</td>
      <td>Deiry Navas &lt;dnavas@celerik.com&gt;</td>
      <td>Closed</td>
      <td>2023-W29</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>freq</th>
      <td>NaN</td>
      <td>471</td>
      <td>9</td>
      <td>471</td>
      <td>468</td>
      <td>18</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>mean</th>
      <td>77545.811040</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>2.757749</td>
      <td>2023-11-14 03:34:30.641188864</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>min</th>
      <td>64472.000000</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>0.000000</td>
      <td>2023-04-11 11:50:15</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>25%</th>
      <td>71381.500000</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>1.000000</td>
      <td>2023-07-31 09:57:07</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>50%</th>
      <td>75236.000000</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>2.000000</td>
      <td>2023-10-02 09:48:58</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>75%</th>
      <td>81644.000000</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>4.000000</td>
      <td>2024-01-26 14:12:49.500000</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>max</th>
      <td>99050.000000</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>15.000000</td>
      <td>2024-11-19 20:34:36</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>std</th>
      <td>9117.919577</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>2.404386</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
  </tbody>
</table>
</div>

                  ID Work Item Type          Title  \
count     471.000000            471            471   
unique           NaN              1            426   
top              NaN           Task  DSN - Dailies   
freq             NaN            471              9   
mean    77545.811040            NaN            NaN   
min     64472.000000            NaN            NaN   
25%     71381.500000            NaN            NaN   
50%     75236.000000            NaN            NaN   
75%     81644.000000            NaN            NaN   
max     99050.000000            NaN            NaN   
std      9117.919577            NaN            NaN   

                             Assigned To   State      Tags  Completed Work  \
count                                471     471       469      471.000000   
unique                                 1       3        70             NaN   
top     Deiry Navas <dnavas@celerik.com>  Closed  2023-W29             NaN   
freq                                 471     468        18             NaN   
mean                                 NaN     NaN       NaN        2.757749   
min                                  NaN     NaN       NaN        0.000000   
25%                                  NaN     NaN       NaN        1.000000   
50%                                  NaN     NaN       NaN        2.000000   
75%                                  NaN     NaN       NaN        4.000000   
max                                  NaN     NaN       NaN       15.000000   
std                                  NaN     NaN       NaN        2.404386   

                         Changed Date  Story Points  
count                             471           0.0  
unique                            NaN           NaN  
top                               NaN           NaN  
freq                              NaN           NaN  
mean    2023-11-14 03:34:30.641188864           NaN  
min               2023-04-11 11:50:15           NaN  
25%               2023-07-31 09:57:07           NaN  
50%               2023-10-02 09:48:58           NaN  
75%        2024-01-26 14:12:49.500000           NaN  
max               2024-11-19 20:34:36           NaN  
std                               NaN           NaN  

Analysis of Common Work Item Types

What are the most common work item types?

Can you visualize the `Completed Work` by day?

Can you visualize the Completed Work by `Changed Date` ?

Can you provide a summary of the dataset?

What are the most common work item types?

Can you visualize the Completed Work by day?

Can you visualize the Completed Work by Changed Date ?

Can you provide a summary of the dataset?

Can you visualize the `Completed Work` by day?

Can you visualize the Completed Work by `Changed Date` ?