title: pandas column names string manipulation
body: <p>Hello I have a Pandas df with long string heavy column names, I want some numbers and a string out of the column name:</p>
  
  <pre><code>df = pd.DataFrame(
  [[1, 3, 5], [2, 4, 6]],
  columns=['Base + Trial Spot Price(X220) Settle Price S=1 [1.00] 1932', 'Base + Trial Spot Price(Y220) Settle Price S=1 [1.00] 2012', 'Base + Trial Spot Price(Y220) Settle Price S=1 [1.00] 2015'])
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/vDvgV.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>I want to strip certain values out of the column name and add them as a column level.</p>
  
  <p>So I would end up with:</p>
  
  <pre><code>X220, Y220, Y220
  1932, 2012, 2015
  </code></pre>
  
  <p>as the multilevel columns.</p>
  
  <p>I have tried split/strip inside list/dict comprehension but couldn't figure out how to chain these approaches (like you can chain replace in pandas). I played around with regex but I didn't get far.</p>
  
  <p>Thanks</p>