Re: [sqlalchemy] Deleting rows from a table where row elements are found in a pandas.DataFrame

I sorted this problem out and, as you predicted, it turned out to be layers upon layers of problems. If you do not mind having a quick look at how I resolved this, I would really appreciate some feedback and a second opinion... I actually missed the main problem initially. It had to do with the

Re: [sqlalchemy] Deleting rows from a table where row elements are found in a pandas.DataFrame

It is a list of dictionaries indeed. I will investigate this issue tomorrow. If something useful comes out or if I have any more questions, I will write back here. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please

Re: [sqlalchemy] Deleting rows from a table where row elements are found in a pandas.DataFrame

On Wed, Jan 3, 2018 at 12:30 PM, Jevgenij Kusakovskij wrote: > Thank you for such a quick response! > > Tried your suggestions, but still getting the same error. > > And could it be caused by some data in the DataFrame being 'odd'? E.g. > Timestamp('2012-05-22 00:00:00')

Re: [sqlalchemy] Deleting rows from a table where row elements are found in a pandas.DataFrame

Thank you for such a quick response! Tried your suggestions, but still getting the same error. And could it be caused by some data in the DataFrame being 'odd'? E.g. Timestamp('2012-05-22 00:00:00') assigned to col2. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper

Re: [sqlalchemy] Deleting rows from a table where row elements are found in a pandas.DataFrame

On Wed, Jan 3, 2018 at 11:21 AM, Jevgenij Kusakovskij wrote: > I feel bad bugging you with questions everyday, but it seems that I get them > answered here... Hope I am not abusing your hospitality. > > I would like to delete multiple rows from a table on a MS SQL Server. The >

[sqlalchemy] Deleting rows from a table where row elements are found in a pandas.DataFrame

I feel bad bugging you with questions everyday, but it seems that I get them answered here... Hope I am not abusing your hospitality. I would like to delete multiple rows from a table on a MS SQL Server. The rows to be deleted are given in a `pandas.DataFrame` object and there can be thousands