title: Python Dataframe: a str has numbers and letters, I want to remove the letters and multiply the remaining numbers by 1,000,000
body: <p>I have a dataframe that contains values like:</p>
  <pre><code>|column a|
  ---------
  |3.5M+   |
  |100,000 |
  |214,123 |
  |1.25M+  |
  </code></pre>
  <p>I want to convert values like 3.5M+ to 3,500,000</p>
  <p>I've tried:</p>
  <pre><code>regex1 = r'.+M+'
  for i in df.a:
      b = re.match(regex1, i)
      if b is not None:
          i = int(np.double(b.string.removesuffix('M+'))*1000000)
      else:
          i = i.replace(',','')
  </code></pre>
  <p>if I add print statements through out, it looks like it's iterating correctly. Unforunately, the changes are not saved to the dataframe.</p>