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
- Load a CSV into a pandas DataFrame and filter, group and merge it
- Write vectorised NumPy code instead of slow Python loops
- Join and aggregate tables in SQL using GROUP BY and window functions
- Use Jupyter notebooks with virtual environments for reproducible work
- Plot a distribution with matplotlib or seaborn
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.
Other units in this stage
Back to the full Data Science roadmap