What happens?
Pandas 3 introduced str datatypes. However trying to register() a pandas DataFrame that has such a column leads to a NotImplementedException
To Reproduce
import duckdb
import pandas as pd
df = pd.DataFrame({"str_col": ["alfred", "beatrix", "cranbrook", "deirdre"]})
print(df["str_col"])
con = duckdb.connect()
con.register("tab", df)
results in _duckdb.NotImplementedException: Not implemented Error: Data type 'str' not recognized.
OS:
MacOS
DuckDB Package Version:
1.4.3 (and 1.5.0.dev166)
Python Version:
3.13.3
Full Name:
Andrew Bond
Affiliation:
Ministry of Justice (UK)
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a nightly build
Did you include all relevant data sets for reproducing the issue?
Yes
Did you include all code required to reproduce the issue?
Did you include all relevant configuration to reproduce the issue?
What happens?
Pandas 3 introduced
strdatatypes. However trying toregister()a pandasDataFramethat has such a column leads to aNotImplementedExceptionTo Reproduce
results in
_duckdb.NotImplementedException: Not implemented Error: Data type 'str' not recognized.OS:
MacOS
DuckDB Package Version:
1.4.3 (and 1.5.0.dev166)
Python Version:
3.13.3
Full Name:
Andrew Bond
Affiliation:
Ministry of Justice (UK)
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a nightly build
Did you include all relevant data sets for reproducing the issue?
Yes
Did you include all code required to reproduce the issue?
Did you include all relevant configuration to reproduce the issue?