unit-5.md

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 -- don't use this
  • The pandas Package -- recommended!

Activities and Exercises

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