## Description of changes - 7df3fa3 fixes type mismatches caused by [new, default string datatype](https://pandas.pydata.org/docs/user_guide/migration-3-strings.html) (sample statistic: reduced DuckDB backend failures from 61 to 26) - a264955 ignores `Pandas4Warning`s due to the copy keyword being deprecated since pandas 3.0 (sample statistics: reduced ClickHouse backend from 1179 failures and 609 errors to 19 failures and 0 errors, reduced PySpark local backend from 597 failures and 589 errors to 28 failures and 0 errors, reduced PySpark remote backend from 552 failures and 588 errors to 17 failures and 0 errors) - In many places, assert `dtype == pd.Series(dtype="str").dtype` instead of `dtype == object`, for pandas-version-agnostic tests - [`pd.api.types.is_string_dtype(dtype)`](https://pandas.pydata.org/docs/reference/api/pandas.api.types.is_string_dtype.html#pandas.api.types.is_string_dtype) also provides a sanctioned way to write pandas 2/3-compatible code, but I haven't updated this in order to more specifically expect `pd.StringDtype(na_value=np.nan)` (and not `pd.Series(dtype="string").dtype`, or `pd.StringDtype(na_value=pd.NA)`) - In many places, make the default timestamp resolution conditional, because that changed in pandas 3 (from ns to us) ## Status | Backend | Failure Count | Note | | - | - | - | | athena | 12 | The same failures occur using Python 3.9? | | bigquery | ✅ | | | clickhouse | ✅ | | | databricks | ❌ | [Incompatible](databricks/databricks-sql-python#732) | | datafusion | ✅ | | | druid | ✅ | | | duckdb | ✅ | | | exasol | 26 | | | flink | ✅ | No pandas 3-enabled builds | | impala | 12 | | | materialize | ✅ | | | mssql | 18 | | | mysql | 18 | | | oracle | 15 | | | polars | ✅ | | | postgres | 2 | | | pyspark | 12 (local), 1 (remote) | | risingwave | 11 | | | singlestoredb | 19 | | | snowflake | ❓ | | | sqlite | ✅ | | | trino | 14 | | --------- Co-authored-by: Claude Opus 4.5 <noreply@anthropic.com> Co-authored-by: Phillip Cloud <417981+cpcloud@users.noreply.github.com>

Add support for pandas 3.0.0 #732

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions