This course guides you through the process of transforming raw financial data into a clean, trustworthy dataset using Python and pandas. You’ll begin by exploring how to load data into a notebook environment and conduct quick inspections to identify structural issues, formatting inconsistencies, unusual numeric patterns, and missing values. Building on these observations, you’ll apply essential cleaning techniques used by analysts every day—fixing data types, standardizing text categories, resolving or documenting missingness, and removing duplicates. Through guided walkthroughs, hands-on practice, and interactive reflection, you’ll develop a repeatable workflow you can apply to budgeting, forecasting, reporting, or any analysis that relies on sound financial information. By the end of the course, you’ll confidently prepare analysis-ready datasets, make informed cleaning decisions, and communicate your process clearly to colleagues and stakeholders.
What you'll learn
load data into a notebook environment
identify structural issues and formatting inconsistencies
apply cleaning techniques such as fixing data types and standardizing text categories
handle missing values and remove duplicates
Course objectives
develop a repeatable workflow for data cleaning
prepare analysis-ready datasets
communicate your data cleaning process to colleagues and stakeholders