Image by author

Analyzing raw data: SQL vs Python

Maw Ferrari
Dev Genius
Published in
8 min readAug 28, 2022

--

When we need to analyze raw data, we have many options. In this post, I want to focus on the pros and cons of using SQL and Python.

· Introduction
· SQL
Data set size: how many rows and columns?
Data set visualization
Column Cardinalities, missing values, stats
Business-focused insights
· Python
Data set visualization & size: how many rows and columns?
Column Cardinalities, missing

--

--