title: How to convert cells in a pandas data frame with multiple values to multiple rows?
body: <p>I am facing an issue while developing a piece of code for the below function. I have a dataframe with the below values</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Date</th>
  <th>Name</th>
  <th>UserId</th>
  <th>task</th>
  <th>Client</th>
  <th>duration</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1/2/2022</td>
  <td>'Alex, J'</td>
  <td>101</td>
  <td>'C'</td>
  <td>QAT</td>
  <td>8</td>
  </tr>
  <tr>
  <td>2/2/2022</td>
  <td>'Alex, J'</td>
  <td>101</td>
  <td>'C'</td>
  <td>QAT</td>
  <td>8</td>
  </tr>
  <tr>
  <td>1/2/2022</td>
  <td>'Marc, B' 'Marc, B'</td>
  <td>102 102</td>
  <td>'A' 'B'</td>
  <td>App Dev</td>
  <td>8</td>
  </tr>
  <tr>
  <td>2/2/2022</td>
  <td>'Marc, B' 'Marc, B'</td>
  <td>102 102</td>
  <td>'A' 'B'</td>
  <td>App Dev</td>
  <td>8</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Now, I want to convert to the below dataframe.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Date</th>
  <th>Name</th>
  <th>UserId</th>
  <th>task</th>
  <th>Client</th>
  <th>duration</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1/2/2022</td>
  <td>'Alex, J'</td>
  <td>101</td>
  <td>'C'</td>
  <td>QAT</td>
  <td>8</td>
  </tr>
  <tr>
  <td>2/2/2022</td>
  <td>'Alex, J'</td>
  <td>101</td>
  <td>'A'</td>
  <td>QAT</td>
  <td>8</td>
  </tr>
  <tr>
  <td>1/2/2022</td>
  <td>'Marc, B'</td>
  <td>102</td>
  <td>'A'</td>
  <td>App</td>
  <td>4</td>
  </tr>
  <tr>
  <td>1/2/2022</td>
  <td>'Marc, B'</td>
  <td>102</td>
  <td>'B'</td>
  <td>Dev</td>
  <td>4</td>
  </tr>
  <tr>
  <td>2/2/2022</td>
  <td>'Marc, B'</td>
  <td>102</td>
  <td>'A'</td>
  <td>App</td>
  <td>4</td>
  </tr>
  <tr>
  <td>2/2/2022</td>
  <td>'Marc, B'</td>
  <td>102</td>
  <td>'B'</td>
  <td>Dev</td>
  <td>4</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to separate out the values in Name, UserId, task and Client column and want to divide the duration by the number of tasks for a particular day.</p>
  <p>For example, I had 2 tasks here i.e A and B for the same day(1/2/2022). So i divided the duration of 8 by 2 and got 4 for each A and B.</p>
  <p>I would request you to please help me in this. Thanks alot.</p>