Results for "Unpivot"
4 / 4 posts
Search: Unpivot
Filter by Category
PySpark
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…
pivot Unpivot PySpark
Match in titleMatch in tagsMatch in content
Mar 19, 2026 2 min read
SQL
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…
database mysql pivot
Match in titleMatch in tagsMatch in content
Mar 19, 2026 6 min read
SQL
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...
comma saparate database excel
Match in content
Mar 19, 2026 3 min read
Pandas
Pandas Data Manipulation: The Complete Guide (Part 2 — Indexing, GroupBy, Merge & Reshape)
Master Pandas data manipulation — loc/iloc, boolean filtering, GroupBy, merge/join, pivot tables, melt, string ops, and apply functions with real examples.
pandas groupby pandas merge pandas pivot table
Match in content
Apr 15, 2026 24 min read