Introducing Visual Explorer, a new tool for data visualization.Learn more

Analysis

Group By in SQL and Python: a Comparison

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.

Read more

Editor’s picks in Analysis

Analysis
Types of Product Usage Segmentation

September 22, 2022

Analysis
Facebook's "Aha" Moment Was Simpler Than You Think

September 22, 2022

Analysis
How to Demystify Skewed Data and Deliver Analysis

September 22, 2022

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.