NEW GUIDEMarketing metrics for data teamsDownload here

Analysis

How to Master Anti Joins and Apply Them to Business Problems

How to perform an anti join using LEFT JOIN and WHERE. Plus three examples of using anti joins in business scenarios.

Read more

Editor’s picks in Analysis

Analysis
How to Switch from Excel to SQL

January 22, 2022 10 minute read

Analysis
Our Take On Prescriptive Analytics and How We Used it in 2020

January 22, 2022

Analysis
Types of Product Usage Segmentation

January 22, 2022 8 minute read

Group By in SQL and Python: a Comparison

December 3, 2021 11 minute read

Analysts and data scientists with a deep understanding of multiple analytical programming languages find themselves at an advantage in today’s data landscape. The prevailing dialogue around this kind of multi-lingual approach, especially with SQL and Python, typically portrays the languages as complementary, yet functionally discrete. But there are actually many overlapping functions that can be accomplished by both SQL and Python.

Image of author

David Wallace

Data Science Evangelist

Get our weekly data newsletter

Work-related distractions for every data enthusiast.