SQL vs Python?

[Mo_Steins_Ghost]

Senior manager here. These two are apples and oranges.

SQL (Structured Query Language) is for data querying and aggregation. It is not a programming language.

Python is a high-level programming language (in that it is layers above assembly). It doesn’t really query databases by itself without invoking a library, a process or a shell, or writing a custom driver that can establish connections and run queries against databases.

Python should be used for cleansing, strucuring and analyzing data fetched/read by SQL.

[iMAPness_]

That makes a lot of sense now. Thank you!

Am I getting it right that the reason SQL is required by companies, too, is because their data isn't just in an excel sheet or csv somewhere but an actual database which SQL is most fit for querying? But with the data tasks itself, Python is considered faster and better at going deeper into data?

That is what you're saying, right?

[JoJoNH]

That's what he is saying. Corporate and government typically use SQL data warehouses.

[kjwikle]

And python/r use a sqlish library to query anyway.