title: How to turn multiple value within a period in a pandas df into their corresponding "weight" for that period?
body: <p>So I have a pandas table like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>DateTime</th>
  <th>Score</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Day 1 - Time 1</td>
  <td>4</td>
  </tr>
  <tr>
  <td>Day 1 - Time 2</td>
  <td>3</td>
  </tr>
  <tr>
  <td>Day 1 - Time 3</td>
  <td>3</td>
  </tr>
  <tr>
  <td>Day 2 - Time 1</td>
  <td>10</td>
  </tr>
  <tr>
  <td>Day 2 - Time 2</td>
  <td>10</td>
  </tr>
  <tr>
  <td>Day 3 - Time 1</td>
  <td>184</td>
  </tr>
  <tr>
  <td>Day 4 ...</td>
  <td>...</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to turn it into this</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>DateTime</th>
  <th>Score</th>
  <th>DailyScoreWeight</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Day 1 - Time 1</td>
  <td>4</td>
  <td>0.4</td>
  </tr>
  <tr>
  <td>Day 1 - Time 2</td>
  <td>3</td>
  <td>0.3</td>
  </tr>
  <tr>
  <td>Day 1 - Time 3</td>
  <td>3</td>
  <td>0.3</td>
  </tr>
  <tr>
  <td>Day 2 - Time 1</td>
  <td>10</td>
  <td>0.5</td>
  </tr>
  <tr>
  <td>Day 2 - Time 2</td>
  <td>10</td>
  <td>0.5</td>
  </tr>
  <tr>
  <td>Day 3 - Time 1</td>
  <td>184</td>
  <td>1.0</td>
  </tr>
  <tr>
  <td>Day 4 ...</td>
  <td>...</td>
  <td>...</td>
  </tr>
  </tbody>
  </table>
  </div>