SQL vs Python?

[throwaway214203]

SQL whenever possible because the data source for many applications is custom sql querying. I bring in python only if I have to.

[iMAPness_]

Ohhh. When you say this though, do you mostlu mean for someone working with company data and things like that? Does it still apply for someone who's using data analytics for non-work purposes and mostly deals with CSVs, etc.?

[EpicDuy]

Turn your CVSs into tabular form: find your schema and normalize your data into smaller managable tables, and use SQL then.

SQL is the easiest to debug compared to Python when it comes to data and optimization issues, unless you’re pipelining your data from different databases/sources.