title: Make another column based using some values in other column
body: <p>Table look like this and the <code>SampleID</code> and <code>Number</code> is the column names:</p>
  
  <pre><code>SampleID Number
  G2Day2   15
  G2Day4   11
  G11Day13 5
  </code></pre>
  
  <p>I want to make another column using the values in the <code>SampleID</code>, so the new table will look like this:</p>
  
  <pre><code>SampleID Group Day Number
  G2Day2   G2    2   15
  G2Day4   G2    4   11
  G11Day13 G11   13  5
  </code></pre>