How to convert strings of decimal values from excel to float

Question

The system of notation of decimal numbers in the Excel files I am dealing with is (I think) the European system (like French and German). So I have numbers like:

'23,4588'
'78,056888'

Note that they are in the form of strings. When I try to convert them to float python raises an exception:

>>> float('78,056888')
Traceback (most recent call last):
   File "<stdin>", line 1, in <module>
ValueError: could not convert string to float: '78,056888'

Here's how I solve the problem:

 try:
     decim = int(excel_value)
 except ValueError:
     remap = {ord(','): '.'}
     decim = float(excel_value.translate(remap))

It seems to work as I want.

So my question is: is there a more appropriate python method for solving these kinds of problems?

this one looks interesting: https://stackoverflow.com/a/7106835/11610186 (and the one below, in case if you specifically deal with ```pandas```) — Grzegorz Skibinski, Oct 11 '19 at 21:24

score 2 · Answer 1 · edited Oct 11 '19 at 21:40

2

You can do this more succinctly with str.replace:

decim = float(excel_value.replace(',', '.'))

edited Oct 11 '19 at 21:40

Kevin

16,549
8
60
74

answered Oct 11 '19 at 21:20

Rafael Castillo

21
1
2

This throws an error. You forgot a closing parenthesis at the end. – JavierCastro Oct 11 '19 at 21:23
You're right, thanks – Rafael Castillo Oct 11 '19 at 21:28

How to convert strings of decimal values ​from excel to float

1 Answers1

How to convert strings of decimal values from excel to float