Pandas - Convert String type to Float

Question

I have the following column in a DF. How could I convert this column into a float(13,5) with 5 decimals.String length is always 18 characters. As a workaround , I have used string split function and joined return values.

df=pd.DataFrame(['+00000030454360000','-00000030734250000','-00000004643685000'],columns=['qty'])
print df.qty.str[:13]+'.'+df.qty.str[13:]

Expected Output

                    0
0  +304543.6
1  -307342.5
2  -46436.85

in the question you stated that you need float(13,5), but in the desired data set you have strings. So do you need modified strings or floats? — MaxU - stand with Ukraine
– MaxU - stand with Ukraine, Commented Feb 6, 2017 at 18:30

MaxU - stand with Ukraine · Accepted Answer · 2017-02-06 18:33:55Z

1

Try this:

In [23]: pd.to_numeric(df.qty, errors='coerce') / 10**5
Out[23]:
0    304543.60
1   -307342.50
2    -46436.85
Name: qty, dtype: float64

answered Feb 6, 2017 at 18:33

MaxU - stand with Ukraine

212k37 gold badges402 silver badges437 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shijo Over a year ago

Thanks @MaxU.. I was expecting an answer from you

MaxU - stand with Ukraine Over a year ago

@Shijo, glad i could help :-)

Collectives™ on Stack Overflow

Pandas - Convert String type to Float

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related