parse_float_or_none.py

def parse_float_or_none(s):
    """
    Attempts to convert a string to a float, handling various decimal and thousands separators.

    Recognizes comma (','), dot ('.'), and space (' ') as potential separators.
    Interprets:
      - "1 234,56" as 1234.56
      - "1.234,56" as 1234.56
      - "1,234.56" as 1234.56
      - "1234,56" as 1234.56

    Args:
        s (str): The input string representing a number.

    Returns:
        float or None: The converted float, or None if conversion fails.
    """
    try:
        s = s.strip().replace(' ', '')
        if ',' in s and '.' in s:
            if s.rfind(',') > s.rfind('.'):
                s = s.replace('.', '').replace(',', '.')
            else:
                s = s.replace(',', '')
        elif ',' in s:
            s = s.replace(',', '.')
        return float(s)
    except ValueError:
        return None