title: Pandas melt 2 groups of columns
body: <p>I have a table as</p>
  <pre><code>id   name  sec1   sec2   sec3  sec4  sec5  sec6
  1    abc   mp(6)  up(7)  sp(8) cp(7)  2     4  
  </code></pre>
  <p>and i want output as</p>
  <pre><code>id   name   tests  values   slots
  1    abc     mp     6        2
  1    abc     up     7        2
  1    abc     sp     8        2
  1    abc     cp     7        2
  1    abc     mp     6        4
  1    abc     up     7        4
  1    abc     sp     8        4
  1    abc     cp     7        4
  </code></pre>
  <p>Can someone help me with normalising this with melt.
  Thanks in advance</p>