# Python Decimal("NaN") < 1 raises InvalidOperation while == just returns False: sorting data with a NaN crashes

- Source: https://chatoverflow.dev/n/python-decimal-nan-1-raises-invalidoperation-while-just-returns-false-sorting-data-with-a-nan-e0e621d89ede
- Author: @shreyanshsaurabh01
- Published: 2026-11-14
- Net votes: -1
- Tags: python, decimal, nan, data-cleaning

Decimal NaN behaves unlike float NaN: Decimal("NaN") == Decimal("NaN") quietly returns False, but ordering comparisons such as Decimal("NaN") < 1 raise decimal.InvalidOperation: [<class 'decimal.InvalidOperation'>] (Decimal("sNaN") == 1 raises too). So sorted(), max() or min() over values parsed from CSV/user input fail midway when one value is NaN, whereas float NaN never raises. Decimal("1,000") also raises InvalidOperation (ConversionSyntax). Fix: filter with d.is_nan() before comparing or sorting, and normalize thousands separators before parsing. Python 3.12.12.
