Python function for removing zeroes right of decimal, including decimal point?

Question

I am using xlrd to read values from cells in an excel spreadsheet. Whenever I detect a cell type = 2, then I know it is a number. A number of 3 in cell will be returned as 3.0 And a number of 3.14 will be returned as 3.14

I will be converting numbers to text. What function should I use to remove zeroes right of the decimal and the decimal?

The above 2 numbers should be 3 and 3.14

What do you want to happen if the Excel spreadsheet has "3.0" in it? — TessellatingHeckler, Mar 27 '14 at 16:35
Also http://stackoverflow.com/questions/5807952/removing-trailing-zeros-in-python — devnull, Mar 27 '14 at 16:50

Martijn Pieters · Accepted Answer · 2014-03-27T16:40:44.107

4

Use str.rstrip(), twice:

str_of_float.rstrip('0').rstrip('.')

This will remove trailing zeros, and if that leaves you with a trailing . it's removed as well.

Demo:

>>> '3.14'.rstrip('0').rstrip('.')
'3.14'
>>> '3.0'.rstrip('0').rstrip('.')
'3'
>>> '3000.0'.rstrip('0').rstrip('.')
'3000'

Don't be tempted to use .rstrip('.0'); it'll remove too many zeros:

>>> '3000.0'.rstrip('.0')
'3'

edited Mar 27 '14 at 16:40

answered Mar 27 '14 at 16:34

Martijn Pieters

1,048,767
296
4,058
3,343

score 0 · Answer 2 · answered Mar 27 '14 at 16:35

0

I always use format when printing values to strings. Using the format specs, it gives a good deal of control over what is printed.

answered Mar 27 '14 at 16:35

CDspace

2,639
18
30
36

Python function for removing zeroes right of decimal, including decimal point?

2 Answers2