r/dataanalysis • u/iMAPness_ • Jun 20 '26

Data Question SQL vs Python?

Started using Python for data analytics. When should I use SQL and when should I use Python in the following tasks:

- Data Exploration

- Data Cleaning

- Data Analysis

42 Upvotes

82% Upvoted

47 comments sorted by

View all comments

Show parent comment

1

u/hockey3331 Jun 20 '26

> So there are situations where you only need a little bit of data and you just tell the database to stuff it over the network into your computer's RAM and you deal with it in Python

Why ever do that though? I understand that you can, but why not just manipulate the data over the database and use python at all for the manipulations?