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

34 votes152 views2 answers
Python create nested directory
Python
0 vote147 views3 answers
Discord.py get channel name from id
Python
0 vote161 views1 answer
Pyautogui color
Python
3 votes245 views2 answers
Python defaultdict(list)
Python
1 vote155 views1 answer
Build spacy custom ner model stackoverflow
Python
0 vote146 views1 answer
Load local data to django
Python
1 vote140 views1 answer
How to identify GPU with pytorch script
Python
0 vote151 views1 answer
[Solved]AttributeError: ‘numpy.ndarray’ object has no attribute ‘index’
Python
0 vote142 views1 answer
Cv2.namedwindow
Python
0 vote138 views1 answer
ImportError: /home/user/.local/lib/python3.8/site-packages/pytorch3d/_C.cpython-38-x86_64-linux-gnu.so: undefined symbol: _ZN2at5zerosEN3c108ArrayRefIlEENS0_13TensorOptionsE
Python