title: Adding values of multiple different rows to one row using pandas?
body: <p>We want to add the values of several different rows into one single row. In the image you can see an example of want we want to do, on the left (column ABC) the data we have, on the right the data we want.</p>
  
  <p>We have a large dataset and thus want to write a script. Currently we have a pandas dataframe. We want to add five rows into one. </p>
  
  <p>Does anyone have a simple solution?</p>
  
  <p><a href="https://i.stack.imgur.com/mXATi.png" rel="nofollow noreferrer">Image (left what we have, right what we want)</a></p>