title: Pandas - How to get sum of column with positive and negative values?
body: <p>I am summing a column of data using pandas that includes positive and negative values. </p>
  
  <p>I first clean the data by removing the $ sign and parenthesis. Then format as a float.</p>
  
  <p>How can I sum the whole column and subtract by the negative numbers?</p>
  
  <p>Example:</p>
  
  <pre><code>    $1000
      ($200)
      $300
      $1250
      ($100)
  </code></pre>
  
  <p>I want the answer to be 2250 not 2550.</p>
  
  <p>Thanks in advance!</p>