title: pandas long to wide: melt + transposing
body: <p>I have this dataframe:</p>
  
  <pre><code>np.random.seed(0)
  df = pd.DataFrame({"Status": np.random.choice(["Married", "Single", "Single", "Single", "Widow"], 10000),
                 "Genre": np.random.choice(["Masculine", "Masculine", "Masculine", "Femenine"], 10000),
                 "Count": 1}).groupby(["Status", "Genre"]).agg("sum").reset_index()
  df
  
  
      Status  Genre       Count
  0   Married Femenine    485
  1   Married Masculine   1520
  2   Single  Femenine    1493
  3   Single  Masculine   4552
  4   Widow   Femenine    520
  5   Widow   Masculine   1430
  </code></pre>
  
  <p>I'm looking to change it where the columns are the <code>Genre</code> values, and an index with the <code>Status</code> values, like:</p>
  
  <pre><code>            Single  Married  Widow  
  Masculine   4552    1520     1430
  Femenine    1493    485      520
  </code></pre>
  
  <p>I have tried with a mix of <code>melt()</code> and <code>.T</code>, but still isn't working. I'm looking for a general approach, as I have 5 <code>Genre</code> values and 20 <code>Status</code> values.</p>