Rounding a number in Python but keeping ending zeros

by

As you are talking about trailing zeros, this is a question about representation as string,
you can use

>>> "%.2f" % round(2606.89579999999, 2)
'2606.90'

Or use modern style with format function:

>>> '{:.2f}'.format(round(2606.89579999999, 2))
'2606.90'

and remove point with replace or translate (_ refers to result of previous command in python console):

>>> _.translate(None, '.')
'260690'

Note that rounding is not needed here, as .2f format applyies the same rounding:

>>> "%.2f" % 2606.89579999999
'2606.90'

But as you mentioned excel, you probably would opt to roll your own rounding function, or use decimal, as float.round can lead to strange results due to float representation:

>>> round(2.675, 2)
2.67
>>> round(2606.89579999999, 2)
2606.89

With decimal use quantize:

>>> from decimal import *
>>> x = Decimal('2606.8950000000001')
# Decimal('2606.8950000000001')
>>> '{}'.format(x.quantize(Decimal('.01'), rounding=ROUND_HALF_EVEN))
'2606.90'

That, for your original task, becomes:

>>> x = Decimal('2606.8950000000001')
>>> int((x*100).quantize(1, rounding=ROUND_HALF_EVEN))
260690

And the reason of strange rounding comes to the front with Decimal:

>>> x = Decimal(2606.8950000000001)
# Decimal('2606.89499999999998181010596454143524169921875') # internal float repr

More Related Contents:

  1. Python JSON serialize a Decimal object
  2. How do you round UP a number?
  3. Limiting floats to two decimal points
  4. How to properly round-up half float numbers?
  5. How to get numbers after decimal point?
  6. round() doesn’t seem to be rounding properly
  7. Convert hex to float
  8. Pandas read csv file with float values results in weird rounding and decimal digits
  9. Add zeros to a float after the decimal point in Python
  10. rounding errors in Python floor division
  11. Clarification on the Decimal type in Python
  12. Why does the floating-point value of 4*0.1 look nice in Python 3 but 3*0.1 doesn’t?
  13. Decimal place issues with floats and decimal.Decimal
  14. How to get largest possible precision? (Python – Decimal)
  15. Round a floating-point number down to the nearest integer?
  16. Python 3.x rounding behavior
  17. How to get a random number between a float range?
  18. How to round the minute of a datetime object
  19. negative zero in python
  20. Convert Scientific Notation to Float
  21. Float values as dictionary key
  22. Comparing floats in a pandas column
  23. Python float to int conversion
  24. Convert decimal to binary in python [duplicate]
  25. How to pad a string with leading zeros in Python 3 [duplicate]
  26. What are some possible calculations with numpy or scipy that can return a NaN? [closed]
  27. In Python, what is a good way to round towards zero in integer division?
  28. How do you get the next value in the floating-point sequence? [duplicate]
  29. Print a float number in normal form, not exponential form / scientific notation [duplicate]
  30. Python “decimal” package gives wrong results

Leave a Comment