title: Read CSV Transpose pandas
body: <p>I have a dataset that looks as follows: </p>
  
  <pre><code>Name  : joe
  Job   : Crazy Consultant
  Hired : 4/12/2011 3:38:55 AM
  Stats : crazy, bald head
  Pay   : $5000 Monthly
  
  Name  : Matt
  Job   : Crazy Receptionist
  Hired : 4/12/2014 3:38:55 PM
  Stats : crazy, Lots of hair
  
  Name  : Adam
  Job   : Crazy Drinker
  Hired : 4/12/2017 3:38:55 AM
  Stats : crazy, unknown
  Term  : 4/12/2017 3:38:55 PM
  </code></pre>
  
  <p>I read in and get the data as follows: </p>
  
  <pre><code>df = pd.read_csv(r"pathtomycsv.csv", encoding="UTF-16", delimiter='\s+:').transpose()
  </code></pre>
  
  <p>Output of above: (just as an example)</p>
  
  <pre><code>Name      Job                Hired                 Stats                Name      Job                Hired                 Stats
  Joe       Crazy Consultant   4/12/2011 3:38:55 AM  crazy, bald head     Matt      Crazy Consultant   4/12/2011 3:38:55 AM  crazy, bald head
  </code></pre>
  
  <p>Ultimately, I would like to take my dataset from above, and transform it into a dataset like below by combining all headers together like below: </p>
  
  <pre><code>Name      Job                Hired                 Stats                Pay            Term
  Joe       Crazy Consultant   4/12/2011 3:38:55 AM  crazy, bald head     $5000 Monthly  N/A
  Matt      Crazy Receptionist 4/12/2014 3:38:55 PM  crazy, Lots of hair  N/A            N/A
  Adam      Crazy Drinker      4/12/2017 3:38:55 AM  crazy, unknown       N/A            4/12/2017 3:38:55 PM
  </code></pre>