I prepared a Python dataframe using Pandas in Jupyther like this: enter image description here
In the next step, I delete the '€' sign with:
df = analyzed_df['Value'] = analyzed_df['Value'].str[1:]
And then I replace the rest of the unnecessary characters:
df = analyzed_df['Value'].replace(regex={'M': '00000','K': '000'})
I have:
As we can see, I have 2 problems:
- I have an unnecessary period ('.')
- I have a dtype as an object
I want to remove the problematic '.' And change dtype to int. I will be very grateful for tips on how to solve the problem.