将字符串值的一部分转换为数字并连接。

I have some data below as follows. As you can see the $MarketCap column contains both a string and numeric component. I want to replace all B's with 10^9 and M's with 10^6, of course concatenated with the existing numeric values. I have some data below as follows. As you can s