Parse a numeric string into int or float

num_parser.py

def parse_number(x: int | float | str | None):
    """Parse a numeric string into int or float.

    Return None for empty or common null markers; leave non-string inputs unchanged.
    """
    if not isinstance(x, str):
        return x

    s = x.strip().replace(",", "")

    if not s or s.lower() in {"na", "n/a", "null", "none"}:
        return None

    try:
        return int(s)
    except ValueError:
        try:
            return float(s)
        except ValueError:
            return x