Database
Undergraduate course introducing Python programming for business analytics, covering data collection, processing, statistical analyses, and machine learning fundamentals.
Related Posts
Project Updates
-
pandas Basic
A practical guide to window functions—ranking, aggregation, and offset operations computed over a sliding frame—demonstrated side-by-side in SQL and Python's pandas library.
-
pandas merge and groupby
-
Time Series Operations in Pandas
A collection of useful pandas snippets for time series analysis, including date filtering, period conversion, and merging by nearest match.
-
Cleaner pandas: Beyond Redundant Boolean Indexing
Stop repeating your DataFrame name! A guide to using .query() and lambda functions for more readable, efficient, and 'fluent' pandas code.
-
LeetCode 1204: Last Person to Fit in the Bus
Solving the 'Last Person to Fit in the Bus' problem using window functions in both SQL and pandas. A perfect application of running totals to real-world scenarios.
-
Window Functions in SQL and Pandas
A practical guide to window functions—ranking, aggregation, and offset operations computed over a sliding frame—demonstrated side-by-side in SQL and Python's pandas library.