title: Cleanse survey data and sum the responses to be in a python dataframe
body: <p>Columns of my dataframe are the survey questions and the rows are the responses. The unique response choices were (1 - Strong Disagree, 2 - Disagree, 3 - Neutral, 4- Agree, 5- Strongly Agree). The rows have all the respondents selections and I ideally would like the columns to be the unique response choices with a sum of how many people selected that response per question and the rows to be each question. </p>
  
  <p>Not sure how to get that - any suggestions?</p>
  
  <p>My original data
  <img src="https://i.stack.imgur.com/QJxtt.png" alt="My original data"></p>
  
  <p>Tried to transpose which successfully made the questions rows but now I have 100s of unique "rows" for each response
  <img src="https://i.stack.imgur.com/KlNrE.png" alt="Tried to transpose which successfully made the questions rows but now I have 100s of unique &quot;rows&quot; for each response"></p>
  
  <p>Ultimate goal would be to group-by the questions and have the response choices under each question with the columns as a sum for each response
  <img src="https://i.stack.imgur.com/RUf9g.png" alt="Ultimate goal would be to group-by the questions and have the response choices under each question with the columns as a sum for each response"></p>