[6 Lines Of Code] How To Connect Oracle Database In Python
Oracle is generous to give everyone a full cloud database for free. I am frequently using this database because Oracle SQL is really a powerful tool for data analysis. Currently, I create many CSV files, from webscraping, financial data from APIs, etc.. So, a connection between Python and Oracle database is an absolute requirement for […]
[Easy] Remove Duplicates but Keep One Row With Maximum Value in Another Column
I am using an API to download all crypto OHLCV data on a periodical basis using multiple timeframes. But there is a bug in the API: it downloads previous timeframe’s data along with the current one, a glitch which raises the duplication issue in the data. Duplicate data in a dataset is not uncommon and […]
How to Fix “sqlldr: not found” Problem
I was trying to set a cron job which would load a Pandas dataframe to Oracle table once in an hour. When I run the Python code, the code works without any issues, however when I set the cron job it threw the following error. The problem stems from the fact that when you are […]
How to install Sql Loader on Linux
You are able to load data from an external source into a table in the database using SQL*Loader. It is capable of reading and understanding a wide variety of delimited file types, including CSV, or any other type of delimited files. In this post, I am going to show how to install SQL Loader on Linux. […]
How to Install Oracle Client on Linux Easily
In this article, we will show you how to easily “install Oracle Client on Linux” and configure it, so that you can connect to your Oracle database. Whether you are using a local Linux machine or a cloud server with a Linux version installed on it, you may need to connect to a remote Oracle […]
Easily Load Data from a Text File to Oracle
SQL Loader Utility is super fast and robust data loading mechanism for Oracle Databases. In this post, we’ll load our data into Oracle database using the SQL Loader.