Insert a panda dataframe into an InterSystems IRIS table?
Hi,
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.
thanks,
Blaise
Discussion (4)1
Log in or sign up to continue
Social networks
You can use PythonGateway or IRIS Native for Python to do that.
PythonGateway can retrieve dataframe (any object really) as a JSON.
Here's a corresponding discussion on the SQL side of things.
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.
Both suggested approaches offer a tight in-process way of InterSystems IRIS - Python integration.
I will show some live examples of bidirectional InterSystems IRIS - Python integration in Best Practices for in-platform AI/ML Webinar.
Offtopic but generic JDBC provider for SQLAlchemy has been discussed for years in Python community but nothing has been done.