Window functions are very powerful in the SQL world. However, there isn’t a well written and consolidated place of Pandas equivalents. Basics of writing SQL-like code in pandas covered in excellent detail on the Pandas site. However, the Pandas guide lacks good comparisons of analytical applications of SQL and their Pandas equivalents.

In this post, I’ll go through some SQL equivalents of window functions and take you through the anatomy of window function in pandas.

#sql #analytics #data #programming #pandas