Blaise ZARKA · Apr 21, 2020

Insert a panda dataframe into an InterSystems IRIS table?


Do you have any experience in inserting a panda dataframe into SQL IRIS Table?
The dataframe.to_sql method uses sqlalchemy and it seems no dialect is available for IRIS.


0 282
Discussion (4)1
Log in or sign up to continue

Thank you Eduard.
At this time, we use JDBC connection and INSERT sql command from panda but we look for a more integrated way to do that.

Offtopic but generic JDBC provider for SQLAlchemy has been discussed for years in Python community but nothing has been done.