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

3 votes340 views2 answers
Numpy stdev
Python
0 vote336 views1 answer
Tensorboard 2.1.0 has requirement grpcio>=1.24.3, but you'll have grpcio 1.15.0 which is incompatible
Python
3 votes332 views3 answers
Convert list to string separated by comma python
Python
4 votes400 views2 answers
Flask get variable from url
Python Flask
1 vote341 views1 answer
How to make a complex calculator in python
Python
-1 vote354 views1 answer
Python tkinter focus on entry
Python
0 vote322 views1 answer
Custom-field-list_display
Python
0 vote352 views1 answer
Pandas dataframe from tsv
Python
0 vote385 views1 answer
Send message if user is banned discord.py
Python
1 vote339 views2 answers
How to add numbers in python using for loop
Python