Filter Rows by Rule

import json
import re

def to_number(value):
    if isinstance(value, bool) or value is None:
        return None
    if isinstance(value, (int, float)):
        return value
    if isinstance(value, str) and re.fullmatch(r'[+-]?(\d+\.?\d*|\.\d+)', value.strip().replace(',', '')):
        return float(value.strip().replace(',', ''))
    return None

def evaluate(value, operator, operand):
    if operator == 'is_null':
        return value is None
    if operator == 'not_null':
        return value is not None
    if value is None:
        return False
    left, right = to_number(value), to_number(operand)
    both = left is not None and right is not None
    if not both:
        left, right = str(value), operand
    if operator == 'eq':
        return left == right
    if operator == 'neq':
        return left != right
    if operator == 'gt':
        return left > right
    if operator == 'gte':
        return left >= right
    if operator == 'lt':
        return left < right
    if operator == 'lte':
        return left <= right
    if operator == 'contains':
        return operand in str(value)
    return operand not in str(value)

def filter_rows(rows, conditions, combine='AND', action='keep'):
    def matches(row):
        results = [evaluate(row.get(c['column']), c['operator'], c['value']) for c in conditions]
        return all(results) if combine == 'AND' else any(results)
    return [row for row in rows if matches(row) == (action == 'keep')]

rows = [
    {'name': 'A', 'age': '20'},
    {'name': 'B', 'age': '17'},
    {'name': 'C', 'age': None},
    {'name': 'D', 'age': 'ไม่ระบุ'},
]
conditions = [{'column': 'age', 'operator': 'gte', 'value': '18'}]
print(json.dumps(filter_rows(rows, conditions), ensure_ascii=False))