Data Engineering · Data Management · Pandas · Python

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

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

SuperTrim Function in SQL Server

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

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