Skip to main content

Programming for Data Sciences

Programming for data science means using Python and SQL as daily tools: pandas and NumPy for tables and arrays, and SQL for pulling and aggregating data from databases. This foundations unit gives you the working fluency that every later step, from cleaning to modelling, depends on.

Stage: Foundations · Part of the Data Science roadmap · Last reviewed 19 November 2026

What to learn in Programming

Programming interview questions

Why prefer vectorised pandas operations over looping through rows?

Vectorised operations run in compiled code across whole columns at once, so they are often orders of magnitude faster than a Python loop over rows. They are also shorter and easier to read, which lowers the chance of indexing mistakes.

What is the difference between WHERE and HAVING in SQL?

WHERE filters individual rows before grouping happens, while HAVING filters groups after aggregation. So you use WHERE to drop rows with a date outside the range, and HAVING to keep only customers whose total spend exceeds a threshold.

Where Programming fits in the Data Science roadmap

Programming belongs to the Foundations stage (beginner level), which takes about 6 hours. Programming, SQL and statistics.

Back to the full Data Science roadmap