Python Fundamentals for Analysis

What you'll learn

• Explain when an analysis outgrows a spreadsheet and what Python adds in repeatability, volume and auditability
• Use variables, types, lists, dictionaries, indexing, loops, conditionals and functions to build a working script
• Apply the load, inspect, clean, transform, summarise and export sequence to a CSV file using a dataframe
• Replace row-by-row loops with vectorised column operations and handle missing values deliberately
• Group and aggregate data, report counts alongside averages, and plot a quick chart to sanity-check results
• Read a traceback bottom-up to debug calmly, and work reproducibly with version control, relative paths and pinned environments

Curriculum

Progress through each competency level in order.