MODULE 03
Working with accounting tables
8 submodules. Work through them in order; each one includes guided practice.
3.1Turn familiar records into a first table
- What pandas is for
3.2Read rows, columns and types
- Creating and reading a DataFrame
- Selecting columns and rows
3.3Prepare values without erasing uncertainty
- Cleaning names and data types
3.4Filter and flag the full population
- Filtering rows and review flags
3.5Investigate repeated records
- Sorting and finding duplicates
3.6Reconcile summaries
- Grouping and summarizing
3.7Join reference data without multiplying amounts
- Merging two tables
3.8Choose checks that can disagree
- Check your understanding