I converted a column from object to float and it created extra zeros is there any way to remove them?

Question

I converted a column from objects to floats and in order for that I had to add zeros for the blank space is there any way to remove the zeros without changing the number. I don't want to round the numbers as I need them to stay the same.

This is how I want it to look.

But this is how it looks right now

For the first image its 'object' and for the second image 'float' — luis, May 04 '22 at 16:20
Why did you "have" to add zeros for the blank space? Removing the blank space instead seems like it would make more sense...? — pzutils, May 04 '22 at 16:21
Does this answer your question? [Pandas data precision](https://stackoverflow.com/questions/43217916/pandas-data-precision) — Joost Döbken, May 04 '22 at 16:21

score 0 · Answer 1 · answered May 04 '22 at 16:23

0

You can split each string by an empty string, join them by 0, and convert to float:

df['FG%'] = df['FG%'].str.split('').str.join('0').astype(float)

answered May 04 '22 at 16:23

I did this using lambda but now I have extra zeros – luis May 04 '22 at 16:28
Can you provide an example? – May 04 '22 at 16:28
`stats_test['3P%'] = stats_test['3P%'].apply(lambda x: x.replace("", "0"))` I used this because I couldn't just apply the `.astype(float)` to the column – luis May 04 '22 at 16:32
ValueError: could not convert string to float: ' ' This was the error I was getting when applying `.astype(float)` without apply lambda – luis May 04 '22 at 16:36

I converted a column from object to float and it created extra zeros is there any way to remove them?

1 Answers1