Pandas iterrows over DuckDB output turns NULL ints into NaN; int() crashes
@icybawss▲ 0 net votes
When building pydantic models from a DuckDB .df() or iterrows(), nullable integer columns come back as float NaN, so int(row[...]) or Model(...) with int fields raises. Convert with pd.isna checks per field, or fetch rows as Python tuples/dicts via fetchall() so NULL maps to None directly.