topic Re: Rounding issues using Python in ArcGIS Pro in ArcGIS Pro Questions

Rounding issues using Python in ArcGIS Pro

AdrianWelsh — Mon, 05 Feb 2018 16:38:15 GMT

It seems to me that ArcGIS Pro is not rounding my numbers correctly when I use Python in Calculate Field. Or my expression is incorrect.

Here is my example:

The Shape_Area of a feature is 7464.72748

My Calculate Field expression is

str(int(round(round(!Shape_Area!), -1)))‍

I would think this should result in a string value of 7470, but it gave me 7460.

Where am I going wrong? Shouldn't round(7464.72748) give me 7465 more or less?

And then round(7465, -1) give me 7470?

Re: Rounding issues using Python in ArcGIS Pro

DanPatterson_Retired — Sat, 11 Dec 2021 19:03:30 GMT

You are now in python 3... did you see the docs first? It works as expected

https://docs.python.org/3/library/functions.html#round

a = 7464.72748

round(a, 1)
7464.7

round(a, 0)
7465.0

round(a, -1)
7460.0‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

skip the round round round thing, that will get confusing

Re: Rounding issues using Python in ArcGIS Pro

AdrianWelsh — Mon, 05 Feb 2018 17:26:55 GMT

I was wondering if Python 3 had anything to do with it since when I carried out the expression in Python 2, it worked as expected.

So, to get this straight, Python no longer rounds like normal arithmetic (like Excel would do). It rounds to the nearest even number first, unless it's far down the decimal chain, then it's "surprising" as the text puts it.

The round round was due to having to join up a table in Excel that had already rounded once - it's complicated but worked better than just one round.

So, is there way to round like Excel rounds?

For another example, when Shape_Area is 2725.059761, how do I make it round to 2730 versus 2720 (like I would in Excel and normal arithmetic)?

Re: Rounding issues using Python in ArcGIS Pro

DanPatterson_Retired — Sat, 11 Dec 2021 19:03:33 GMT

dozens of ways.... time to explore, this will get you going.

import math  # which is available in arcmap and the field calculator
math.ceil(2725.059761)
2726

int(math.ceil(2725.059761 / 10.0)) * 10
2730

# or if you understand base 9 and base 10 differences

(2725.059761+9)//10 *10
2730.0‍‍‍‍‍‍‍‍‍‍‍

plus some numpy stuff.... the rest are tricks etc

Excel makes people dependent on masking the tricks that us old timers relied upon for years.

Re: Rounding issues using Python in ArcGIS Pro

AdrianWelsh — Mon, 05 Feb 2018 18:00:42 GMT

Wow, this is good stuff to explore. I'm not sure I want to use the ceiling function since I don't always want it to round up.

But, since this is really only for joining tables together to make a simple match, I can force excel to do the same. It looks like the function is this:

=CEILING.MATH(2725.059761,10) results in 2730

Base 9 and 10?!? That's a thinker. I'll play around with that some... until my head hurts!

Re: Rounding issues using Python in ArcGIS Pro

DanPatterson_Retired — Sat, 11 Dec 2021 19:03:35 GMT

Adrian.... math.floor ... homework...

besides everyone rounds to the nearest 10ish

step outside the box... go all 8's

int(math.ceil(2725.059761 / 8.0)) * 8
2728‍‍

Or make it whatever you want

a = np.array([110.1567])

np.clip(a, 108, 109)
 array([ 109.])‍‍‍‍

Re: Rounding issues using Python in ArcGIS Pro

JoshuaBixby — Mon, 05 Feb 2018 19:06:49 GMT

What’s New In Python 3.0 — Python 3.6.4 documentation :

The round() function rounding strategy and return type have changed. Exact halfway cases are now rounded to the nearest even result instead of away from zero. (For example, round(2.5) now returns 2 rather than 3.) round(x[, n]) now delegates to x.__round__() instead of always returning a float. It generally returns an integer when called with a single argument and a value of the same type as x when called with two arguments.

Re: Rounding issues using Python in ArcGIS Pro

DanPatterson_Retired — Mon, 05 Feb 2018 19:15:27 GMT

we are using 3.6 in PRO, my test environment

Re: Rounding issues using Python in ArcGIS Pro

JoshuaBixby — Mon, 05 Feb 2018 21:57:26 GMT

Not sure on your comment. Pro 2.1 does come with Python 3.6, I don't think anyone is disagreeing with that.

Re: Rounding issues using Python in ArcGIS Pro

DanPatterson_Retired — Mon, 05 Feb 2018 22:08:36 GMT

Yes... python 3.6 is distributed with PRO.

It was more to show people that the python 3.6 docs should be read and soon if they are going to be using PRO.

Besides, there are so many other ways options for 'rounding' that are available and most people haven't seen them.

Re: Rounding issues using Python in ArcGIS Pro

MarcoBoeringa — Tue, 06 Feb 2018 10:42:54 GMT

Please also have a look at the "decimal" module of Python:

https://docs.python.org/3.6/library/decimal.html

It may offer functions you need as well. You can import the module in e.g. the Calculate Field tool.

Re: Rounding issues using Python in ArcGIS Pro

AdrianWelsh — Sat, 11 Dec 2021 19:03:38 GMT

Rounding is ridiculous.

Joining up an "engineer's" spreadsheet with sorta-rounded-area numbers (integers) with a converted CAD drawing takes more effort than it should. This is what my code block Calculate Field expression had to look like to get as close as I could (though, I likely could have gotten closer with more ceilinging and flooring, but I got lazy):

import math
def ceiling(parcel, area):
    return str(parcel) + " - " + str(int(math.ceil(math.floor(area) / 10)) * 10)

__esri_field_calculator_splitter__

ceiling(!Parcel!, !Shape_Area!)‍‍‍‍‍‍‍

thanks, Dan, for all the assistance!

Re: Rounding issues using Python in ArcGIS Pro

DanPatterson_Retired — Tue, 06 Feb 2018 18:42:22 GMT

engineers??? cool! use the base 9 thing.. that will keep them going for a few hours