Week 7, Python and pandas for Accounting Data

Nearly every Excel move you know has a Python line. The lab writes them as twelve small functions and ends with your Week 3 aging rebuilt in pandas, landing on the same number your SQL did. The homework hands you a notebook someone else wrote, has you fix the error that breaks it, and ends with a duplicate-payment control test. Oct 5 to 11, then Fall Break.

This week

• Lecture 7, Python and pandas for Accounting Data
  What Python is, and the Excel-to-Python bridge for each move, with the Ask AI tutor built in. The one live session this week is Wednesday, October 7; there is no Monday session.
• Lab 7 notebook, in Colab
  Open it, then File, then Save a copy in Drive, and work in your copy. Upload it as <uID>_lab_07.ipynb by Monday, October 19, 11:59 PM MT.
• Lab 7 reference page
  Every Lab 7 function's specification in one place, with the code in color. Keep it open beside the notebook.
• Homework 7 notebook, in Colab
  The inherited payables notebook. Work all four parts first, then answer the Homework 7 quiz and upload the notebook as <uID>_hw_07.ipynb before you click Submit. The quiz is one attempt.

Interactive practice

• Week 7 trainers
  Optional pages where you type real Python and run it in your browser, no install, each with an AI tutor that can read your code and the error it raised. If Python is new to you, do types, conditionals and functions before the lab, and column types and cleaning before the homework.