title: Pandas how to transpose the data and add the column name
body: <p>In Pandas I'm transposing the data and want to name the column. </p>
  
  <p>My current data is:</p>
  
  <pre><code>    alpha   bravo    charlie
  0   public  private  public
  1   prodA   prodB    prodB
  2   100     200      300
  </code></pre>
  
  <p>After transposing and renaming the columns, the output is: </p>
  
  <pre><code>df.transpose()
  df.columns = ["category", "product", "price"]
  
      category    product price
  alpha   public  prodA   100
  bravo   private prodB   200
  charlie public  prodB   300
  </code></pre>
  
  <p>How can I have the expected output like:</p>
  
  <pre><code>company category product price
  alpha   public   prodA   100
  bravo   private  prodB   200
  charlie public   prodB   300
  </code></pre>