# 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](https://prof-rossetti.gitbook.io/intro-to-python/units/unit-5b) for material about relational databases

## Discussions and Notes

* Program-Data Independence
* [Machine-readable Data Formats](https://prof-rossetti.gitbook.io/intro-to-python/notes/info-systems/datastores)
* [Managing Files](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/file-management):
  * [The `os` Module](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/modules/os#file-operations) (focusing on filepath construction)
* Processing CSV Files:
  * [The `csv` Module](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/modules/csv)
  * [The `pandas` Package](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/packages/pandas)

## Activities and Exercises

* "Monthly Sales Reporting" Exercise ([Local](https://prof-rossetti.gitbook.io/intro-to-python/exercises/monthly-sales-reporting) | [Colab](https://github.com/prof-rossetti/intro-to-python/tree/d62594892fb2af99fedd4f65703b3b8a8810be5e/exercises/monthly-sales-reporting/Monthly_Sales_Reporting_Exercise.ipynb))