title: i want to reorder the data of a column then Split it to new columns in a pandas DataFrame
body: <p>i am trying to do this in python for 2 day but i have been unsuccessful.</p>
  
  <p>Table:</p>
  
  <p><a href="https://i.stack.imgur.com/IEAbV.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IEAbV.jpg" alt="enter image description here"></a></p>
  
  <p>Desired Output:</p>
  
  <p><a href="https://i.stack.imgur.com/7sZMT.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7sZMT.jpg" alt="enter image description here"></a></p>
  
  <p>Thank you for any help!!</p>