[Step-by-Step] How to Install TaLib Library on Linux?
TaLib is a high quality technical analysis library, originally written in C language. Thanks to its developers, there is a Python wrapper which allows us to use in Python, too. However, installing it is a bit tricky and requires more steps than simply installing it with pip. In this post, I am going to show […]
Python How To Remove Everything Except Letters & Numbers
Letters and numbers are technically called alphanumeric characters. In this article, I am going to show you how to remove everything except letters and numbers from a string in Python. So you will keep only alphanumeric characters (letters and numbers) and delete everything else. For this, we will use Python regular expression module. It is […]
[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!] Install Selenium on Linux with a Chromedriver for Python
In this article I’m going to show you how to properly install and use Python Selenium and ChromeDriver on Debian Linux.
[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 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 […]
UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x80 in position 3131: invalid start byte
When I was trying to read csv files in Python, I came across the UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x80 in position 3131: invalid start byte error. When I went up to the beginning of the error message, I saw a .DS_Store file and quickly realized the culprit. There was a hidden .DS_Store file […]
Running and Automating a Python Application on a Linux Server in 7 Easy Steps
In this post I am going to tell the steps to running and automating a python application on a linux server in detail. We will use Linode for this article, but you can use Digital Ocean or Vultr, too. We will choose Debian Linux Server on Linode, place our Python file to the server, sync […]
UNIX Timestamp to Readable Date With One Line of Code
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.