title: Python read comma separated txt file having thousands separator
body: <p>My comma separated txt file contains data in the following format (of course, there are more columns and rows).</p>
  
  <pre><code>1977,PA,2017-08-07,55,New Firms,327.0
  1978,NY,2017-08-07,45,New Firms,$30,127
  1978,NY,2017-08-07,$10,000,New Firms,1,000
  </code></pre>
  
  <p>As you can see, some data contain thousands separator and I read like this:</p>
  
  <pre><code>df=pd.read_csv("data.txt", thousands=r',')
  df.head()
  </code></pre>
  
  <p>This gives an error message</p>
  
  <pre><code>ParserError: Error tokenizing data. C error: Expected 13 fields in line 102996, saw 14
  </code></pre>
  
  <p>I think the error occurs because some data contain thousands separators.</p>
  
  <p>Any suggestions?</p>