Convert "%" str to float

[Andrsays1]

I am trying to write a program to calibrate the CIR model and when I was reading some data from a csv file and define a calculation, I get the error "could not convert string to float".However, the data in my csv file is presented in the form of "%".Like this:

Coupon
0.00%
0.00%
1.00%
2.25%
1.38%
1.63%
1.00%
1.00%
1.63%

I try to change the original data to number format, but it turns out the same error too.

Then I was stuck.Is there anyone who knows how to solve this problem?Thanks in advance for any help!

[Larz60+]

what does the code look like?
show what you've tried so far

[nilamo]

[float(item.replace("%", "")) for item in data] should work. But if you prefer something a little more rad, here's a regex:

>>> import re
>>> data = '''Coupon
... 0.00%
... 0.00%
... 1.00%
... 2.25%
... 1.38%
... 1.63%
... 1.00%
... 1.00%
... 1.63%'''.split("\n")
>>> data
['Coupon', '0.00%', '0.00%', '1.00%', '2.25%', '1.38%', '1.63%', '1.00%', '1.00%', '1.63%']
>>> for row in data:
...   row = re.sub(r"[^\d\.]", "", row)
...   if row:
...     print(float(row))
...
0.0
0.0
1.0
2.25
1.38
1.63
1.0
1.0
1.63