[Easy] Remove Duplicates but Keep One Row With Maximum Value in Another Column

Remove Duplicates in Data

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 Install Oracle Client on Linux Easily

install oracle instant client to a linux server

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 […]

UNIX Timestamp to Readable Date With One Line of Code

UNIX Timestamp to Readable Date

Pandas library’s to_datetime method easily converts UNIX timestamp to readable date format in Python. Epoch, also known as Unix timestamps, is the number of seconds (not milliseconds!) that have elapsed since January 1, 1970 at 00:00:00 GMT.

Best Practices for Cloning a Github Repo to Local Macbook

Cloning a Github Repo to Local Macbook

In this post, I am going to show you best (and easy) practices for cloning a Github repo to your local macbook computer and create a virtual environment to contain your work. Cloning a Github repo means that we are create a copy of a Github repo in our local computer. All the files including […]

Remove TIME from DATETIME value in Python

remove time from date in python

In this article, I am going to show you how to remove time from datetime value in Python. It is possible to remove time from datetime value in Python with just a few lines of code..But it can be tricky if you don’t follow the necessary steps. This is what we want to achieve: Here, […]

How To Fix “cx_oracle Database Error ORA-12547: TNS: Lost Contact”

ORA-12547: TNS: Lost Contact Oracle Autonomous Database Python

cx_Oracle is a Python extension module that provides access to Oracle Database from your Python application. You can connect your Python application to an Oracle Database. However, I’ve recently encountered ORA-12547: TNS: lost contact error while connecting to Oracle Autonomous Database. In this post, I’m going to show you how to fix ORA-12547: TNS: lost contact […]