Pandas Basic Commands

Introduction In this blogpost, we will see some of the Python's pandas library basic commands and its operations. For running below commands, here, I have used Azure Databricks Notebook with python language. Via magic commands(%python), we can use the same below commands under other language connected notebooks as well. Basic pandas commands 1. Importing pandas library… Continue reading Pandas Basic Commands

Alternatives · Basic Logics · Data Analysis · Data Management · Real Scenario Logic's · String Manipulation

SuperTrim Function in SQL Server

December 16, 2019December 16, 2019 Arulmouzhi E4 Comments

After Reading my Article - To Remove Multiple and Duplicate Spaces to Single Space in SQL Server, I received the email where one of my friend is asking for the below requirements- To Remove Invisible TAB, Carriage Return, Line Feed characters, White Spaces, Non-Breaking Spaces etc., Leading and Trailing spaces need to remove.Further, contiguous occurrences… Continue reading SuperTrim Function in SQL Server

Basic Logics · Data Analysis · Data Management · Data Migrations · Real Scenario Logic's

To Find Fill Rate in a Table on both AZURE and On-Premise – Key Metric in Data Analysis

November 22, 2019November 22, 2019 Arulmouzhi E4 Comments

Introduction Knowing Fill Rate is one of the essential tasks in Data Analysis/Management and Migration Processes. It helps us to take Business Decisions effectively. In this post, will see how to find the Fill rate in a table using SQL Queries that is Applicable for both AZURE and On-Premises... What is meant by Fill Rate?… Continue reading To Find Fill Rate in a Table on both AZURE and On-Premise – Key Metric in Data Analysis