title: Converting a string object value with M and K to million and thousand
body: <p>I'm working on a python/jupyter notebook exercise. The problem with my column values has <code>'K'</code> for thousand and <code>'M'</code> for Millions.</p>
  <p>Need help on how to do the following:</p>
  <ol>
  <li>How do I make the values with 'K' thousand values</li>
  <li>How do I make the values with 'M' million values (both for whole number and with decimal)</li>
  </ol>
  <p>note: I'm currently using jupyter notebook with pandas and numpy import</p>
  <p>I want the output to be like:</p>
  <p>450K to 450000
  9.5M to 9500000
  12M to 12000000</p>
  <p>here is the link for the datafile column under 'Value'</p>
  <p><a href="https://drive.google.com/open?id=1BOUVYiY6iRLbUdimCg7rgwtecfU6QAwS" rel="nofollow noreferrer">https://drive.google.com/open?id=1BOUVYiY6iRLbUdimCg7rgwtecfU6QAwS</a></p>
  <p>See attached file:</p>
  <p><img src="https://i.stack.imgur.com/tKz8z.png" alt="enter image description here" /></p>