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

0 vote185 views1 answer
Compare lists element wise python
Python
29 votes207 views3 answers
For x in range(1,100, 10): print(x)
Python
0 vote183 views1 answer
Https://stackoverflow.com/questions/55861077/hackerrank-lists-problem-standard-test-case-works-but-others-dont
Python
10 votes219 views3 answers
Python iterate through files
Python
2 votes188 views3 answers
Get queryset
Python
1 vote205 views2 answers
How to get user id django
Python
0 vote154 views1 answer
Python index strings
Python
1 vote191 views1 answer
Fastest sort python
Python
2 votes213 views1 answer
Timeout exception in selenium python
Python
0 vote195 views1 answer
How to get rid of an instance variable python
Python