title: Cleaning spreadsheet using regex
body: <p>I would like to remove all but the statistic in every entry of the following:</p>
  
  <pre><code>#ChangeColumnFullTimeGraduatesEmployedAtGraduation:74.3%    #ChangeColumnAverageStartingSalaryAndBonus:$134,360 3.4 #ChangeColumnFullTimeGraduatesEmployedThreeMonthsAfterGraduation:81.4%  #ChangeColumnPeerAssessmentScoreOutOf5.:4.3
  #ChangeColumnFullTimeGraduatesEmployedAtGraduation:82.0%    #ChangeColumnAverageStartingSalaryAndBonus:$127,368 3.29    #ChangeColumnFullTimeGraduatesEmployedThreeMonthsAfterGraduation:89.8%  #ChangeColumnPeerAssessmentScoreOutOf5.:4.1
  #ChangeColumnFullTimeGraduatesEmployedAtGraduation:80.7%    #ChangeColumnAverageStartingSalaryAndBonus:$123,177 3.4 #ChangeColumnFullTimeGraduatesEmployedThreeMonthsAfterGraduation:92.5%  #ChangeColumnPeerAssessmentScoreOutOf5.:4.0
  </code></pre>
  
  <p>I've been trying to use regular expressions (regex).  Based on the fact that the desired final output consists of no more than a number an a percent sign / $ sign, this is what I cobbled together:</p>
  
  <pre><code>import re
  import csv
  
  with(open('sheet.csv','rU')) as f:
  
      for row in f:
          re.sub([^0-9\$\%],'',row)
  </code></pre>
  
  <p>which returns this syntax error:</p>
  
  <pre><code>re.sub([^0-9\$\%],'',row)
  </code></pre>