Aug-28-2019, 03:59 AM
Hi there,
i am pretty new to python and i have a dataframe with object types (see image below). Those are supposed to be prices of financial assets, and (e.g.) are in the form of 13,754.34 . At the moment they are object but i need to convert into float otherwise can’t do any operation with it (i mainly need to plot those series and calculate correlation).
I tried astype , i tried to_numeric and so on but none of those work.
Can anybody help me to fix it please? Many thank in advance.
![[Image: a6ce1be1585a0ed193aa5220ea5c77d7f9d8c018_2_1380x794.png]](https://aws1.discourse-cdn.com/business6/uploads/github_atom/optimized/3X/a/6/a6ce1be1585a0ed193aa5220ea5c77d7f9d8c018_2_1380x794.png)
i am pretty new to python and i have a dataframe with object types (see image below). Those are supposed to be prices of financial assets, and (e.g.) are in the form of 13,754.34 . At the moment they are object but i need to convert into float otherwise can’t do any operation with it (i mainly need to plot those series and calculate correlation).
I tried astype , i tried to_numeric and so on but none of those work.
Can anybody help me to fix it please? Many thank in advance.