Skip to content

Unable to register a pandas.DataFrame with string columns in pandas 3 #278

@ADBond

Description

@ADBond

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?

  • Yes, I have

Did you include all relevant configuration to reproduce the issue?

  • Yes, I have

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions