Unit 5: Processing CSV Data

Learning Objectives

In this unit, we'll learn how to use Python to process machine-readable data stored in Comma-Separated Values (CSV) format.

NOTE: for extra optional bonus material, see also Unit 5-B for material about relational databases

Discussions and Notes

• Program-Data Independence

• Machine-readable Data Formats

• Managing Files:

  • The os Module (focusing on filepath construction)

• Processing CSV Files:

  • The csv Module

  • The pandas Package

Activities and Exercises

• "Monthly Sales Reporting" Exercise (Local | Colab)