Saving Dataframes into Oracle Database with Python

Using Python to Save a Dataframe into Oracle Database

You can use the pandas library in combination with the sqlalchemy and cx_Oracle libraries to save a dataframe to an Oracle database in Python.

import pandas as pd
from sqlalchemy import create_engine
import cx_Oracle

# Create an SQLAlchemy engine using the connection
engine = create_engine('oracle://username:password@hostname:port/service_name')

# Save the dataframe to the Oracle database and lowercase your_table_name 
df.to_sql('your_table_name', con=engine, if_exists='replace', index=False)

Replace 'username', 'password', 'hostname', 'port', and 'service_name' with your actual Oracle database credentials, connection details.

Please replace your_table_name with the actual lowercase name of the table in your Oracle database. Otherwise, you may encounter InvalidRequestError: Could not reflect: requested table(s) not available in Engine.

When you run this script, it will establish a connection to the Oracle database, create a sample dataframe, and then save the dataframe to the specified table in the Oracle database.

---

Explore more

Luca LiuFollow

Hello there! 👋 I'm Luca, a Business Intelligence Developer with passion for all things data. Proficient in Python, SQL, Power BI, Tableau, SAP Business Objects.

Thank you for taking the time to explore data-related insights with me. I appreciate your engagement.

🚀 Connect with me on LinkedIn

🎃 Connect with me on X

🌍 Connect with me on Instagram