According to Microsoft, “Floating-point arithmetic overflow or division by zero never throws an exception, because floating-point types are based on IEEE 754 and so have provisions for representing infinity and NaN (Not a Number).” More on this here.
Java’s float and double types, like pretty much any other language out there (and pretty much any hardware FP unit), implement the IEEE 754 standard for floating point math, which mandates division by zero to return a special “infinity” value. Throwing an exception would actually violate that standard. Integer arithmetic (implemented as two’s complement representation … Read more
You can disable the warning with numpy.seterr. Put this before the possible division by zero: np.seterr(divide=”ignore”) That’ll disable zero division warnings globally. If you just want to disable them for a little bit, you can use numpy.errstate in a with clause: with np.errstate(divide=”ignore”): # some code here For a zero by zero division (undetermined, results … Read more
C++ does not have a “Division by Zero” Exception to catch. The behavior you’re observing is the result of Compiler optimizations: The compiler assumes Undefined Behavior doesn’t happen Division by Zero in C++ is undefined behavior Therefore, code which can cause a Division by Zero is presumed to not do so. And, code which must … Read more
Floating point division by zero is well defined by IEEE and gives infinity (either positive or negative according to the value of the numerator (or NaN for ±0) ). For integers, there is no way to represent infinity and the language defines the operation to have undefined behaviour so the compiler helpfully tries to steer … Read more
Wrap your formula with IFERROR. =IFERROR(yourformula)
Inspired by some of the comments I got rid of the branch on my Pentium and gcc compiler using int f (int x, int y) { y += y == 0; return x/y; } The compiler basically recognizes that it can use a condition flag of the test in the addition. As per request the … Read more
You can use NULLIF function e.g. something/NULLIF(column_name,0) If the value of column_name is 0 – result of entire expression will be NULL
In numpy v1.7+, you can take advantage of the “where” option for ufuncs. You can do things in one line and you don’t have to deal with the errstate context manager. >>> a = np.array([-1, 0, 1, 2, 3], dtype=float) >>> b = np.array([ 0, 0, 0, 2, 2], dtype=float) # If you don’t pass … Read more
It seems that your configuration is using the print option for numpy.seterr: >>> import numpy as np >>> np.array([1])/0 #’warn’ mode __main__:1: RuntimeWarning: divide by zero encountered in divide array([0]) >>> np.seterr(all=”print”) {‘over’: ‘warn’, ‘divide’: ‘warn’, ‘invalid’: ‘warn’, ‘under’: ‘ignore’} >>> np.array([1])/0 #’print’ mode Warning: divide by zero encountered in divide array([0]) This means that … Read more