title: Column Mapping in Same Dataframe
body: <pre><code>Students  Score1  Students  Score2  Students  Score3
     A        50       B        88       A        48
     B        40       A        76       C        47
     C        28       C        74       B        40
  </code></pre>
  
  <p>How do I turn the above dataframe into the format below:</p>
  
  <pre><code>Students  Score1  Score2  Score3
     A        50      76      48
     B        40      88      40
     C        28      74      47
  </code></pre>
  
  <p>The only approach I'm aware is by applying iloc onto them into separate dataframe and then join them together or is there a one way method to do so?
  *Python read the duplicated columns as Students, Students.1, Students.2 and so on.</p>