我最近把pandas从.20更新到.23,现在一个将pandas数据帧插入sql(mssqlserver)的脚本失败了。这个框架和以前一样(它是用pandas read_sql_table从sql中读取的,然后写回去,只是作为测试,以确保一切正常运行)。我没有更改任何驱动程序,例如odbc,并且在更新之前测试了一些对我有用的驱动程序。失败后,我更新了sqlalchemy,但这没有帮助。在
我得到这个错误:(pyodbc.ProgrammingError) ('The SQL contains 6039 parameter markers, but 137111 parameters were supplied', 'HY000') [SQL: 'INSERT INTO dbo.test_python_drop_write_append (various column names here) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?