pandas string to float

Question

I have an array.

array(['+$35.00', '="-$5.00"', '+$42.24', '+$10.56', '="-$20.00"',`
       '+$60.00', '="-$10.00"', '+$21.00', '+$18.50', '+$10.00',
       '+$19.00', '+$34.40', 0], dtype=object)

I know this has been covered many times but I cant seem to convert column in pandas to a float.

Where does this array come from? Maybe you can begin to convert it better already at an earlier stage? What's the original input? And what do = in this data mean? — ramslök
– ramslök, Commented Jul 20, 2022 at 9:00

mozway · Accepted Answer · 2022-07-20 09:03:47Z

1

Assuming a the array, you can use:

# convert the array to Series
s = pd.Series(a)
# extract float representation from strings, convert to numeric
# fill with values that were already floats
s = pd.to_numeric(s.str.extract(r'(\d+(?:\.\d+)?)', expand=False)).fillna(s)

output:

0     35.00
1      5.00
2     42.24
3     10.56
4     20.00
5     60.00
6     10.00
7     21.00
8     18.50
9     10.00
10    19.00
11    34.40
12     0.00
dtype: float64

answered Jul 20, 2022 at 9:03

mozway

267k13 gold badges56 silver badges106 bronze badges

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

Collectives™ on Stack Overflow

pandas string to float

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related