Results for "Unpivot"

4 / 4 posts

Search: Unpivot
SQLPythonPySparkMachine learningPower BIData WorldNumPyADF

Filter by Category

DATA
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
DATA
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
DATA
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
DATA
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

SQLDataDev footer

SQLDataDev

Practical SQL, Python, analytics, and data engineering tutorials for builders who learn by shipping.

Browse practical tutorials for SQL, Python, analytics, and data engineering with crawlable internal links that help readers discover related articles quickly.

Explore

  • SQL
  • Python
  • PySpark
  • Machine learning
  • Power BI
  • Data World

Categories

  • Data Science
  • Database maintenance

Tools

  • SQL Formatter
  • All Tools

Search & Indexing

  • Homepage
  • About
  • Main Sitemap
  • Post Archive
  • Contact Us
  • Robots Rules

Copyright 2026 SQLDataDev. Practical tutorials for data builders.

Everything's organized so you can discover exactly what you're looking for β€” browse by category, search the archive, or explore related posts.