Skip to main content
PYSPARK ACADEMY โ€ข MODULE 14

Window Functions

Define Window specifications with partitionBy and orderBy, generate unique row numbers, calculate dense ranks, and inspect lag/lead values.

Advanced๐Ÿ“š 8 Lessonsโญ 0 / 4770 XPโณ In Progress
0 / 8 Lessons Completed (0%)
CHALLENGE CURRICULUM

Module Lessons

0 / 8 Complete
LESSON 105

๐Ÿ”“ Window Specification Foundations

โฑ 2 Mins โ€ข โญ 550 XP โ€ข Advanced

LESSON 106

๐Ÿ”’ Partitioning Data with partitionBy()

โฑ 2 Mins โ€ข โญ 560 XP โ€ข Advanced

LESSON 107

๐Ÿ”’ Chronological Ordering with orderBy()

โฑ 2 Mins โ€ข โญ 570 XP โ€ข Advanced

LESSON 108

๐Ÿ”’ Unique Row IDs with row_number()

โฑ 2 Mins โ€ข โญ 590 XP โ€ข Advanced

LESSON 109

๐Ÿ”’ Ranking with Gaps using rank()

โฑ 2 Mins โ€ข โญ 600 XP โ€ข Advanced

LESSON 110

๐Ÿ”’ Dense Ranking without Gaps with dense_rank()

โฑ 2 Mins โ€ข โญ 610 XP โ€ข Advanced

LESSON 111

๐Ÿ”’ Fetching Prior Row Values with lag()

โฑ 2 Mins โ€ข โญ 630 XP โ€ข Advanced

LESSON 112

๐Ÿ”’ Looking Ahead to Next Steps with lead()

โฑ 3 Mins โ€ข โญ 660 XP โ€ข Advanced