Create Running Weighted Average
Combine ROW_NUMBER, self JOIN, and CASE WHEN for that
1 min read
Blog
Find Year-on-Year Growth Rate
This is a common interview question that you MUST nail!
The formula is (value - last_year_value) / last_year_
1 min read
Use EXISTS to check if a row is present
Need to find if records from table A can also be found in table B? EXISTS is here to help.
1 min read
The SIGN function
Use SIGN to see if a number is positive, negative, or zero.
It's as simple as it sounds.
Apply SIGN(
1 min read
4x Faster Pandas Operations with Minimal CodeΒ Change
Stop waiting on pandas operations. Parallelize them.
5 min read
Use SAFE_DIVIDE to handle division by zero.
ππΌππ_πΏππππΏπ divides two numbers while handling the case where the denominator is zero.
π Here's the syntax.
ππ΄π»π΄π²π ππ°π΅π΄_π³πΈπ
πΈπ³π΄(πππππππππ, πππππππππππ) π΅ππΎπΌ πππππππ
If the denominator is zero