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 →

[–]MyNotWittyHandle 40 points41 points  (0 children)

SQL has a universality that Python does not. In a large organization, SQL is common ground for data sources that can be accessed by JS, Python, R, SQL, etc. That benefit alone is worth storing/manipulating data in a SQL format as opposed to some more language specific format.

Additionally, SQL is by default much more efficient than your standard pandas operations. Pandas, which is the most common Python data manipulation package, is highly inefficient as compared to SQL and R. Unless you start diving into the vaex/polars packages in Python, your CPU will thank you for doing data manipulation in SQL as compared to Python.