title: Find 'M' and multiply number by 1 million then find 'B' and multiply number by 1 billion
body: <p>I am downloading financial data and I have a few columns with data points that look like this: </p>
  
  <pre><code>34.60B
  18.66M
  </code></pre>
  
  <p>This occurs in column number 6, which has a header of 'Market Cap'.  It also occurs in column number 41, which has a header named 'Avg Volume'.  How can I find the cells with an 'M' and multiply these values by a million, and likewise, find the cells with a 'B' and multiply these values by a billion, and finally multiply values with 'K' by a thousand?  I'm trying to convert everything to numeric so I don't have text and number mixed together.</p>
  
  <p>Here is a sample of the data that I am referring to:</p>
  
  <pre><code>                                 Industry Country Market Cap     P/E    PEG
  0         Medical Laboratories &amp; Research     USA     22.29B   19.94   1.88   
  1                                Aluminum     USA      4.07B    0.00   0.00   
  2                    Exchange Traded Fund     USA          0    0.00   0.00   
  3                        Asset Management     USA     34.60B    0.00   0.00   
  4             Specialized Health Services     USA     18.66M    0.00   0.00   
  5                    Exchange Traded Fund     USA          0    0.00   0.00   
  6                          Major Airlines     USA     14.96B   10.83   0.75
  </code></pre>
  
  <p>Here is the code that I'm using.</p>
  
  <pre><code>import pandas  as pd
  from pandas import read_csv
  from sklearn.ensemble import ExtraTreesClassifier
  # load data
  
  df = pd.read_csv('C:\\path_here\\stocks.csv')
  print(df)
  
  for index, row in df.head(n=2).iterrows():
       print(index, row)
  </code></pre>