Skip to content

Issues: pandas-dev/pandas

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Clear current search query, filters, and sorts
98 Open 516 Closed
98 Open 516 Closed
Author
Filter by author
Loading
Label
Filter by label
Loading
Use alt + click/return to exclude labels
or ⇧ + click/return for logical OR
Projects
Filter by project
Loading
Milestones
Filter by milestone
Loading
Assignee
Filter by who’s assigned
Sort
Sort by
Newest Oldest Most commented Least commented Recently updated Least recently updated Best match
Most reactions
👍 👎 😄 🎉 😕 ❤️ 🚀 👀

Issues list

BUG/FEATURE REQUEST: DataFrame.to_sql() tries to create table when it exists Bug IO SQL to_sql, read_sql, read_sql_query Needs Discussion Requires discussion from core team before further action Needs Info Clarification about behavior needed to assess issue
#61418 opened May 9, 2025 by vladidobro
2 of 3 tasks
3
BUG: to_sql works only for strings Bug IO SQL to_sql, read_sql, read_sql_query Needs Info Clarification about behavior needed to assess issue
#61385 opened May 1, 2025 by pranav-ds
2 of 3 tasks
4
ENH: Functionality to aid with Database Imports Enhancement IO SQL to_sql, read_sql, read_sql_query Needs Triage Issue that has not been reviewed by a pandas team member
#61247 opened Apr 7, 2025 by mwiles217
2 of 3 tasks
3
DEPS: Revert SQLAlchemy minimum version back to 1.4.36 Dependencies Required and optional dependencies IO SQL to_sql, read_sql, read_sql_query
#60977 opened Feb 21, 2025 by snitish Loading…
5 tasks
2.3
1
14
BUG: Unknown Error - Getting from Databricks SQL Python - From PyArrow module (pyarrow.lib.ArrowException) Arrow pyarrow functionality Bug IO SQL to_sql, read_sql, read_sql_query Needs Info Clarification about behavior needed to assess issue
#60838 opened Feb 3, 2025 by Gobi2511
2 of 3 tasks
4
BUG: The .to_sql() of dtype argument does not strictly ensure the column name and datatype Bug Closing Candidate May be closeable, needs more eyeballs IO SQL to_sql, read_sql, read_sql_query
#60737 opened Jan 20, 2025 by ammarsaf
3 tasks done
1
BUG: Pandas to_sql 'Engine' object has no attribute 'cursor' Bug IO SQL to_sql, read_sql, read_sql_query Needs Info Clarification about behavior needed to assess issue
#60684 opened Jan 9, 2025 by ganbaaelmer
3 tasks done
5
TST: Make test_sql.py parallelizable good first issue IO SQL to_sql, read_sql, read_sql_query Testing pandas testing functions or related to the test suite
#60378 opened Nov 20, 2024 by WillAyd
1 of 3 tasks
1
@UmbertoFasci
9
REF: dtype_backend argument in sql module mixes lib.no_default and numpy Clean IO SQL to_sql, read_sql, read_sql_query
#60326 opened Nov 15, 2024 by WillAyd
BUG: 'Engine' object has no attribute 'cursor' Bug IO SQL to_sql, read_sql, read_sql_query Needs Info Clarification about behavior needed to assess issue
#60124 opened Oct 29, 2024 by Jagadish250803
3 tasks done
1
Fix BUG: read_sql tries to convert blob/varbinary to string with pyarrow backend Arrow pyarrow functionality IO SQL to_sql, read_sql, read_sql_query
#60105 opened Oct 25, 2024 by kastkeepitjumpinlikekangaroos Loading…
5 tasks done
1
34
BUG: to_sql with ADBC driver fails when schema exists without tables Bug IO SQL to_sql, read_sql, read_sql_query
#59841 opened Sep 19, 2024 by WillAyd
3 tasks done
@aram-cedarwood
2
BUG: read_sql tries to convert blob/varbinary to string with pyarrow backend Arrow pyarrow functionality Bug Dtype Conversions Unexpected or buggy dtype conversions IO SQL to_sql, read_sql, read_sql_query
#59242 opened Jul 13, 2024 by dbrownems
3 tasks done
1
@kastkeepitjumpinlikekangaroos
3
BUG: Dataframe's to_sql method fails while trying to persist Dataframe to Postgtres in Version 2.2.0 Bug IO SQL to_sql, read_sql, read_sql_query Needs Triage Issue that has not been reviewed by a pandas team member
#57196 opened Feb 1, 2024 by damianr13
3 tasks done
3
ENH: Not silently ignore violation of minimal required version of SQLAlchemy Dependencies Required and optional dependencies Enhancement IO SQL to_sql, read_sql, read_sql_query
#57178 opened Jan 31, 2024 by bebach
1 of 3 tasks
5
BUG: Pandas 2.2 breaks SQLAlchemy 1.4 compatibility Compat pandas objects compatability with Numpy or Python functions Dependencies Required and optional dependencies IO SQL to_sql, read_sql, read_sql_query Regression Functionality that used to work in a prior pandas version
#57049 opened Jan 24, 2024 by miraculixx
3 tasks done
2.3
1
@snitish
28
BUG: read_sql() does not handle date nor time datatypes correctly when using pyarrow (but works for datetime) Arrow pyarrow functionality Bug IO SQL to_sql, read_sql, read_sql_query Needs Triage Issue that has not been reviewed by a pandas team member
#56551 opened Dec 18, 2023 by fdcastel
3 tasks done
2
ENH: Expose PEP249 DB API "rowcount" in read_sql_query iterator Enhancement IO SQL to_sql, read_sql, read_sql_query Needs Triage Issue that has not been reviewed by a pandas team member
#55854 opened Nov 6, 2023 by gwerbin
1 of 3 tasks
ENH: add optional logging to read_sql Enhancement IO SQL to_sql, read_sql, read_sql_query Needs Triage Issue that has not been reviewed by a pandas team member
#55797 opened Nov 1, 2023 by jimenezj8
1 of 3 tasks
4
BUG: sqlalchemy.exc.InvalidRequestError: Could not reflect: requested table(s) Bug IO SQL to_sql, read_sql, read_sql_query Needs Triage Issue that has not been reviewed by a pandas team member
#55286 opened Sep 25, 2023 by djpirra
2 of 3 tasks
2
BUG: pd.to_sql fails with an ARRAY of composites Bug IO SQL to_sql, read_sql, read_sql_query Nested Data Data where the values are collections (lists, sets, dicts, objects, etc.).
#54651 opened Aug 20, 2023 by sergiykhan
3 tasks done
BUG: "table name" form of pd.read_sql() doesn't work for SQLite databases Error Reporting Incorrect or improved errors from pandas IO SQL to_sql, read_sql, read_sql_query
#54233 opened Jul 23, 2023 by kalekundert
2 of 3 tasks
4
DOC: Improvement for def psql_insert_copy(table, conn, keys, data_iter) Docs IO SQL to_sql, read_sql, read_sql_query
#53942 opened Jun 29, 2023 by try-and-succeed
1 task done
3
BUG: Errors using to_sql(), read_sql_table() when data contains percent signs Bug IO SQL to_sql, read_sql, read_sql_query
#53339 opened May 22, 2023 by philipnye
3 tasks done
4
BUG: Bug IO SQL to_sql, read_sql, read_sql_query Regression Functionality that used to work in a prior pandas version
#53028 opened May 1, 2023 by SkeptiCali
3 tasks done
5
ProTip! Follow long discussions with comments:>50.