[SOLVED!] How to convert frame.append() to pandas.concat()?
I was using frame.append method to add rows to a dataframe, yet it is deprecated and going to be removed from pandas. So, in this article, I will tell you how to convert DataFrame.append() to pandas.concat(). It’s easy. This is my original code with append method. With this code, I was appending a dataframe to b dataframe. […]
How to Get Rid of the “e Notation” in Pandas Dataframe?
I’m now going to show you how to get rid of this “e letter” or “e notation” in your pandas dataframe, with using one line of code. So easy. Just add one line of code: All sorted.
[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.
VS Code : Automatically Push after Commit
If you want to automatically push to a GitHub repository after commit, Gitlens extension in VS Code has a setting to make this possible. You just change the git.postCommitCommand setting and then when you commit and it pushes simultaneously. Open GitLens Extension Settings. Search for git.postCommitCommand . click on the dropdown menu and change none […]
[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 Access Localhost of a Remote Server
In this article, we will show how to access localhost of a remote server. Localhost corresponds to the hostname of the device that currently runs your application. It is the DNS name for the local loop back address, which is 127.0.0.1 . So, instead of 127.0.0.1 , you type localhost. We use the localhost to […]
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 […]
Sql Developer Export to Excel With One Line of Code
Sometimes you may need to get the results of the SQL query to a .csv file or an Excel file. Perhaps you want to open it in Excel and make some alterations or some calculations as Excel still offers more convenience compared to SQL, particularly for relatively smaller datasets, or may be you want to […]
cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “libclntsh.so: cannot open shared object file: No such file or directory”
I have Python script which inserts certain data to an Oracle Autonomous Database. I order to connect to the Oracle Database, I am using cx_Oracle module. When I run this script directly, there is no problem. However, when I tried to run a crontab it threw this error: A similar question is asked here. The […]
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. […]