Hi,

I'm trying to round my float total to the nearest .05 cents.

12.01 should produce 12.00
0.14 should produce 0.10
2.28 " 2.25
703.81 " 703.80

"%.02f"%100.0099 produces 100.01 (which I know is right)
No combination of round and/or "%.02f" works for me.

What's the best way to get there? Should I write a function to manage my
rounding or is there a simpler/better way?

TIA
T

tertius wrote:[color=blue]
> Hi,
>
> I'm trying to round my float total to the nearest .05 cents.[/color]

If you want the *nearest* .05, this works:[color=blue][color=green][color=darkred]
>>> def fivecents(f):[/color][/color][/color]
.... return round(f*2.0, 1) / 2.0
....[color=blue][color=green][color=darkred]
>>> for f in [ 12.01, 0.14, 2.28, 703.81]:[/color][/color][/color]
.... print f, fivecents(f)
....
12.01 12.0
0.14 0.15
2.28 2.3
703.81 703.8
[color=blue]
> 12.01 should produce 12.00
> 0.14 should produce 0.10
> 2.28 " 2.25
> 703.81 " 703.80[/color]

Your example seems to be rounding down always, not what I would call
nearest. Here is one that always rounds toward zero:[color=blue][color=green][color=darkred]
>>> def lowerfivecents(f):[/color][/color][/color]
.... return int(f*20) / 20.0
....[color=blue][color=green][color=darkred]
>>> for f in [ 12.01, 0.14, 2.28, 703.81]:[/color][/color][/color]
.... print f, lowerfivecents(f)
....
12.01 12.0
0.14 0.1
2.28 2.25
703.81 703.8

If you want to always round toward more negative, use math.floor()
instead of int().

Kent[color=blue]
>
> "%.02f"%100.0099 produces 100.01 (which I know is right)
> No combination of round and/or "%.02f" works for me.
>
> What's the best way to get there? Should I write a function to manage my
> rounding or is there a simpler/better way?
>
> TIA
> T[/color]

On Mon, 15 Nov 2004 22:52:42 +0200, tertius <terti@mighty.co.za> wrote:
[color=blue]
>Hi,
>
>I'm trying to round my float total to the nearest .05 cents.[/color]
Nearest which way? IWT 2.28 is nearer 2.30 than 2.25 ;-)
ISTM you are rounding _down_ to the nearest nickel. So you want to
drop fractional nickels. Which int will do if you calculate the number
of nickels. Then you can divide by 20. to get dollars again[color=blue]
>
>12.01 should produce 12.00
> 0.14 should produce 0.10
> 2.28 " 2.25
>703.81 " 703.80
>
>"%.02f"%100.0099 produces 100.01 (which I know is right)
>No combination of round and/or "%.02f" works for me.
>
>What's the best way to get there? Should I write a function to manage my
>rounding or is there a simpler/better way?[/color]

One way, just to play with subclassing float for constrained initial value:
[color=blue][color=green][color=darkred]
>>> values = [12.01, 0.14, 2.28, 703.81]
>>> class Nickels(float):[/color][/color][/color]
... def __new__(cls, val):
... return float.__new__(cls, int(val*20.0)/20.)
... def __repr__(self): return '<Nickels %.2f>'%float(self)
...[color=blue][color=green][color=darkred]
>>> [Nickels(v) for v in values][/color][/color][/color]
[<Nickels 12.00>, <Nickels 0.10>, <Nickels 2.25>, <Nickels 703.80>][color=blue][color=green][color=darkred]
>>> for value in values: print '%8.2f => %8.2f'%(value,Nickels(value))[/color][/color][/color]
...
12.01 => 12.00
0.14 => 0.10
2.28 => 2.25
703.81 => 703.80

but it's probably silly compared to
[color=blue][color=green][color=darkred]
>>> def roundnickel(dollars): return int(dollars*20.0)/20.0[/color][/color][/color]
...[color=blue][color=green][color=darkred]
>>> for value in values: print '%8.2f => %8.2f'%(value, roundnickel(value))[/color][/color][/color]
...
12.01 => 12.00
0.14 => 0.10
2.28 => 2.25
703.81 => 703.80

What do you want to do for negative numbers? int "rounds" towards zero.
[color=blue][color=green][color=darkred]
>>> for value in -.01,.01,-.09,.09: print '%8.2f => %8.2f'%(value, roundnickel(value))[/color][/color][/color]
...
-0.01 => 0.00
0.01 => 0.00
-0.09 => -0.05
0.09 => 0.05

BTW, if you wanted to use the class with all float operators, you'd have
to define the methods one way or another (there's some sneaky ways, but I think
the class is just a side trip ;-)
[color=blue][color=green][color=darkred]
>>> Nickels(.09)[/color][/color][/color]
<Nickels 0.05>[color=blue][color=green][color=darkred]
>>> Nickels(.09) + .01[/color][/color][/color]
0.060000000000000005

Being a subclass of float, python figured out how to coerce Nickels
to float for the addition. If we add an adding method, we get
[color=blue][color=green][color=darkred]
>>> Nickels.__add__ = lambda self,other: Nickels(float(self)+ float(other))
>>> Nickels(.09) + .01[/color][/color][/color]
<Nickels 0.05>[color=blue][color=green][color=darkred]
>>> Nickels(.09) + .06[/color][/color][/color]
<Nickels 0.10>

too much work ;-)

Regards,
Bengt Richter

> What's the best way to get there? Should I write a function to manage my[color=blue]
> rounding or is there a simpler/better way?[/color]

Others have pointed out how to achieve the rounding - I just want to add
that using floats for currency values isn't the best choice. Depending on
your version of python, check out these links:

http://fixedpoint.sourceforge.net/
http://www.python.org/peps/pep-0327.html


--
Regards,

Diez B. Roggisch

tertius wrote:[color=blue]
> Hi,
>
> I'm trying to round my float total to the nearest .05 cents.
>
> 12.01 should produce 12.00
> 0.14 should produce 0.10
> 2.28 " 2.25
> 703.81 " 703.80
>
> "%.02f"%100.0099 produces 100.01 (which I know is right)
> No combination of round and/or "%.02f" works for me.
>
> What's the best way to get there? Should I write a function to manage my
> rounding or is there a simpler/better way?
>
> TIA
> T[/color]

Thanks for all the help!
I meant nearest towards zero.

chrs
T