agenda.md

Unit 4 Agenda

Objectives

Learn how to use Python to process CSV files.

Discussions and Notes

• Datastores, Databases, and CSV Files
• Python Language:
  • Text File Management
  • The csv Module

Ungraded Exercises

• CSV Processing - (a.k.a Monthly Sales Reporting)

Projects

• Inventory Management App - (a.k.a "CRUD" App)

Further Exploration (Advanced)

If you know SQL and you are familiar with MySQL or PostgreSQL, you can use one of the following packages to execute SQL queries against a relational database:

• Third-party Python Packages:
  • The PyMySQL Package
  • The psycopg2 Package

There will be an opportunity to further explore these packages later in the semester, if desired.