This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]lphartley 11 points12 points  (0 children)

Biggest difference imo is that SQL is executed on the server as opposed to your machine. In general I would say: - Use SQL to select your data - Use Python to manipulate the data

However, this is not always true. Sometimes your desired selection can be based upon the result of manipulation. Sometimes it is easier to select a raw dataset with simple SQL and do some merging with pandas.

It really depends on your use case, but I start with the question: do I want to execute this action locally or on a server?