title: Pandas dataframe amount value with dollar symbol
body: <p>I have a pandas dataframe with below columns. Column_1 is string/text and not integer or decimal. Couple of rows have string value as well like Names (refer row no 6)</p>
  
  <pre><code>S.No.  Column_1
  1      256
  2      1
  3      $300.54672
  4      756
  5      $292.34333
  6      Andrew
  </code></pre>
  
  <p>I want to convert all values in column_1 to numbers/int, except the dollar values and rows with Names. I require the dollar symbol to be retained but the amount should be rounded to 2 digits after decimal point.</p>
  
  <p>Expected output:</p>
  
  <pre><code>S.No.  Column_1
  1           256
  2             1
  3       $300.55
  4           756
  5       $292.34
  6       Andrew
  </code></pre>
  
  <p>I converted entire column to numeric using pd.to_numeric() with errors='coerce' but the amount values became blank (or) null as it was an error. </p>
  
  <p>Any suggestions/help on this would be highly appreciated. 
  Thank you.</p>