I have a column with currency type like $1.2K, $1.45M, etc as an Object dtype. I need to convert it to float value and create a new column Y. How can it be done using pandas?
Asked
Active
Viewed 23 times
0
-
how looks floats from data in question? `1.2, 1.45` ? Or `1200, 1450000` ? – jezrael Nov 18 '21 at 07:43
-
The linked answer is only about removing the $ not about converting K to thoussands and M to millions. – Borut Flis Nov 18 '21 at 07:56
-
Yes, I would like to remove $ sign as well need to convert K to Thousands and M to Millions – Sandy24 Nov 19 '21 at 09:57