K and M to int in pandas

In [31]: df.Val = (df.Val.replace(r'[KM]+$', '', regex=True).astype(float) * \
   ....:           df.Val.str.extract(r'[\d\.]+([KM]+)', expand=False)
   ....:             .fillna(1)
   ....:             .replace(['K','M'], [10**3, 10**6]).astype(int))

In [32]: df
Out[32]:
         Date        Val
0  2016-09-23      100.0
1  2016-09-22  9600000.0
2  2016-09-21    54200.0
3  2016-09-20   115300.0
4  2016-09-19    18900.0
5  2016-09-16   176100.0
6  2016-09-15    31600.0
7  2016-09-14    10000.0
8  2016-09-13  3200000.0

Source: stackoverflow.com

Similar codes

1 vote356 views1 answer
Python number divisible by two other numbers
Python
1 vote387 views2 answers
Incognito selenium
Python
0 vote351 views1 answer
Set select group of columns to numeric pandas
Python
0 vote337 views1 answer
How to read backslash slash python
Python
1 vote357 views1 answer
Multirow np.rand.randint
Python
1 vote304 views2 answers
Delete the node at a given position 2 in a linked list and return a reference to the head node. The head is at position 0. The list may be empty after you delete the node. In that case, return a null value.
Python
115 votes340 views6 answers
Pip install python
Python
0 vote367 views2 answers
Django APIView Pagination
Python Django
2 votes372 views2 answers
Install wxPython
Python
1 vote349 views1 answer
How to count post by category django
Python