Results for "pivot"
6 / 18 posts
Filter by Category
PySpark Pivot and Unpivot DataFrame
✅ What is Pivot and Unpivot? Pivot = Convert rows into columns Unpivot = Convert columns into rows 🌀 Sample DataFrame Let’s start with a small DataFrame t…
Pandas Data Manipulation: The Complete Guide (Part 2 — Indexing, GroupBy, Merge & Reshape)
...ulation — loc/iloc, boolean filtering, GroupBy, merge/join, pivot tables, melt, string ops, and apply functions with real examples.
Pivoting and Unpivoting Data in SQL
Pivoting Data : Pivoting is the process of converting rows of data into columns, effectively changing the orientation of your data. It's useful when you ha…
Advanced Pandas: Performance, Time Series, ML Pipelines & Interview Questions (Part 3)
Master advanced Pandas — MultiIndex, time series resampling, rolling windows, memory optimization, Pandas 2.x features, ML pipelines, and 30+ interview Q&A.
Use of Apply(Cross and Outer) operator in SQL server
APPLY operator joins two table expressions. Also, I'll show how it differs from regular JOINs. Operator: CROSS APPLY Similar: INNER JOIN When to Use: Use a C...
Added columns in a table by dynamic ways
IF OBJECT_ID('AddedDynamicColumn','P') IS NOT NULL BEGIN DROP PROC AddedDynamicColumn END GO CREATE PROCEDURE AddedDynamicColumn AS BEGIN SELECT ED.empid,ED....