Course Schedule

Mon: (Jan 22)

No class

Wed: Introduction (Jan 24)

• Class overview
• Resources for getting help

Read: Syllabus
Link to slides
Student Information Survey
Python3 (Anaconda3) installation:

• Windows
• MAC
  

Assigned:

• Lab-P1
• P1

Fri: Pseudocode (Jan 26)

• Flow of execution
• State

Read: Python for Everybody, Ch. 1
Link to worksheet: pdf, docx
Link to worksheet solutions: pdf

Mon: Operators (Jan 29)

• Syntax, parsing, print
• Values and types
• Operator precedence
• Boolean logic
• Strings, escape characters
• Comments

Read: Downey Ch 1
Read: Python for Everybody, Ch. 2
Additional Reading: Computer terminology
Link to worksheet: pdf, docx
Link to worksheet solutions: pdf
Louis's Lecture: code
Mike's Lecture:

• code
  
• video
  

Wed: Vars and Exprs (Jan 31)

• Naming rules
• Assignment statements
• Types of errors

Read: Downey Ch 2 and Appendix A
Read: Python for Everybody, Ch. 3
Louis's Lecture: code
Mike's Lecture: code
Due: P1
Assigned:

• Quiz 1 (5:00 pm)
  
• Lab-P2
• P2

Fri: Using Functions (Feb 02)

• Functions
• Arguments, return values
• input, print, type cast functions: int, float, str, bool
• Importing modules
• math Module

Read: Downey Ch 3 ("Function Calls" to "Composition")
Read: Python for Everybody, 5.1 - 5.4
Due: Student Information Survey
Due: Quiz 1 (11:59:00 pm)
Louis's Lecture: code
Mike's Lecture: code

Mon: Creating Functions (Feb 05)

• Blocks
• Positional arguments
• Keyword arguments
• default arguments
• return

Read: Downey Ch 3 ("Adding New Functions" to "Flow of Execution" and "Fruitful and Void Functions")
Read: Python for Everybody, 5.5 - 5.10
Read: Creating Fruitful Functions
Interactive Exercises
Link to worksheet: pdf, docx
Link to worksheet solutions: pdf
Louis's Lecture: code
Mike's Lecture: code

Wed: Function Scope (Feb 07)

• Local vs. global
• Argument passing
• Frames
• Stack diagrams

Read: Downey Ch 3 ("Parameters and Arguments" to end)
Read: Python for Everybody, 5.11 - 5.16
Interactive Exercises
Mike's Lecture: code
Due: P2
Assigned:

• Quiz 2 (5:00 pm)
  
• Lab-P3
• P3

Fri: Conditionals 1 (Feb 09)

• Boolean logic
• if, elif, else
• Blocks of code

Read: Downey Ch 5 ("Floor Division and Modulus" to "Nested Conditionals" and "Keyboard Input" to end) and Ch 6 ("Return Values" to "Boolean Functions")
Read: Python for Everybody, 4.1 - 4.5
Optional: Downey Ch 4
Interactive Exercises
Link to worksheet: pdf, docx
Link to worksheet solutions: pdf
Louis's Lecture: code
Mike's Lecture: code
Due: Quiz 2 (11:59:00 pm)

Mon: Conditionals 2 (Feb 12)

• Nesting
• Refactoring

Read: Python for Everybody, 4.6 - end (skip 4.7)
Interactive Exercises
Link to slides
Louis's Lecture: code
Mike's Lecture: code

Wed: Iteration 1 (Feb 14)

• While Loop
• Loop Control Variable
• Infinite Iteration
• for i in range

Read: Downey Ch 7
Read: Python for Everybody, 6.1 - 6.3
Link to slides
Louis's Lecture: code
Mike's Lecture: code
Due: P3
Assigned:

• Quiz 3 (5:00 pm)
  
• Lab-P4
• P4

Fri: Iteration 2 (Feb 16)

• Nested Loops
• Break
• Continue

Read: Python for Everybody, 6.4
Read (Optional): Sweigart Ch 2
Interactive Exercises
Link to worksheet: pdf, docx
Louis's Lecture: code
Mike's Lecture: code
Due: Quiz 3 (11:59:00 pm)

Mon: Iteration Practice (Feb 19)

• for loops
• Count, min, max, filtering
• Nested loop tracing

Read: Python for Everybody, 6.5 - end
Link to worksheet: pdf
Louis's Lecture: code
Mike's Lecture: code

Wed: Exam 1 review in lecture (Feb 21)

• Regular exam: 5:45 to 7:15 pm
• McBurney exam: 5:30 to 8:30 pm

Due: P4
Assigned:

• Lab-P5
• P5

Fri: Strings (Feb 23)

• Comparison
• String methods
• Strings are Sequences
• Indexing & Slicing
• For Loop, range()

Read: Downey Ch 8
Read: Python for Everybody, Ch. 7
Optional: Downey Ch 9
Link to worksheet: pdf, docx
Louis's Lecture: code
Mike's Lecture: code

Mon: Lists (Feb 26)

• Lists are Sequences
• Indexing & Slicing
• Lists are Mutable
• List Methods

Read: Downey Ch 10
Read: Python for Everybody, Ch. 9
Louis's Lecture: code
Mike's Lecture: code

Wed: CSV Files (Feb 28)

• Comparison to Spreadsheets
• Format
• Headers
• Lists of lists

Read: Sweigart Ch 16 (through "Reading Data from Reader Objects in a for Loop")
Louis's Lecture: code
Mike's Lecture: code
Due: P5
Assigned:

• Quiz 4 (5:00 pm)
  
• Lab-P6
• P6

Fri: List Practice (Mar 01)

• Coding Demos

Link to worksheet: pdf, docx
Louis's Lecture: code
Mike's Lecture: code
Due: Quiz 4 (11:59:00 pm)

Mon: Dictionaries 1 (Mar 04)

• Syntax
• Lookup
• Insert
• Pop

Read: Downey Ch 11 ("A Dictionary is a Mapping" through "Looping and Dictionaries")
Read: Python for Everybody, 10.1 - 10.7
Interactive Exercises
Louis's Lecture: code
Mike's Lecture: code

Wed: Dictionaries 2 (Mar 06)

• Nesting
• dict of lists
• list of dicts
• dict of dicts

Read: Downey Ch 11 ("Dictionaries and Lists" and "Global Variables" to end)
Louis's Lecture: code
Mike's Lecture: code
Due: P6
Assigned:

• Quiz 5 (5:00 pm)
  
• Lab-P7
• P7
  

Fri: JSON (Mar 08)

• Deserialization
• Serialization
• Python/JSON dfferences

Read: Sweigart Ch 16
Link to worksheet: pdf, docx
Louis's Lecture: code
Mike's Lecture: code
Due: Quiz 5 (11:59:00 pm)

Mon: Objects & Tuples (Mar 11)

• Mutability
• References
• tuple
• namedtuple

Read: Downey Ch 10 ("Objects and Values" and "Aliasing") and Ch 12
Read: Python for Everybody, 11.1 - 11.7
Interactive Exercises
Louis's Lecture: code
Mike's Lecture: code

Wed: Copying (Mar 13)

• References
• Shallow Copy
• Deep Copy

Read: Sweigart Ch 4 ("References" through the end)
Interactive Exercises
Link to worksheet: pdf, docx
Link to worksheet solutions: pdf
Louis's Lecture: code
Mike's Lecture: code

• Quiz 6 (5:00 pm)
  
• Lab-P8
• P8
  

Fri: Recursive Functions (Mar 15)

• Base/Recursive Cases
• Lists of Lists
• More Stack Diagrams
• Stack Overflow

Read: Downey Ch 5 ("Recursion" through "Infinite Recursion"), Ch 6 ("More Recursion" through end)
Interactive Exercises
Louis's Lecture: code
Mike's Lecture: code
Due: Quiz 6 (11:59:00 pm)

Mon: Function References (Mar 18)

• functions as objects
• sort
• lambda

Read: Python for Everybody, 10.8
Louis's Lecture: code
Mike's Lecture: code

Wed: Comprehensions (Mar 20)

• review sorting
• list comprehensions
• dict comprehensions

Read: Downey Ch 19.2, 12.3
Link to worksheet: pdf, docx
Link to worksheet solutions: pdf
Louis's Lecture: code
Mike's Lecture: code
Due: P8
Assigned:

• Quiz 7 (5:00 pm)
  
• Lab-P9
• P9

• Quiz 7 (5:00 pm)
  
• Lab-P9
• P9
  

Fri: Error Handling (Mar 22)

• Assert Statements
• Catching Exceptions
• Throwing Exceptions

Read: Sweigart Ch 11 (beginning through "Assertions")
Interactive Exercises
Link to worksheet: pdf, docx
Louis's Lecture: code
Mike's Lecture: code
Due: Quiz 7 (11:59:00 pm)

Mon: No Class (Mar 25)

• Spring Break

Wed: No Class (Mar 27)

• Spring Break

Fri: No Class (Mar 29)

• Spring Break

Mon: Files and Directories (Apr 01)

• Reading
• Writing
• os module

Read: Downey Ch 14
Louis's Lecture: code
Mike's Lecture: code

Wed: Exam 2 review in lecture (Apr 03)

• Regular exam: 5:45 to 7:15 pm
• McBurney exam: 5:30 to 8:30 pm

Due: P9
Assigned:

• Lab-P10
• P10
  

Fri: Pandas 1 (Apr 05)

• Series
• element-wise operations
• mean, median, mode, quantiles

Required Reading: Pandas Intro Notebook (HTML or pandas-intro.ipynb)
Louis's Lecture: code
Mike's Lecture: code

Mon: Pandas 2 (Apr 08)

• DataFrame
• reading CSVs

Louis's Lecture: code
Mike's Lecture: code

Wed: Web 1 (Apr 10)

• requests module
• get
• status code
• text files
• json files

Read: Sweigart Ch 12
Louis's Lecture: code
Mike's Lecture: code
Due: P10
Due: CS319 Project part 1: proposal (Not applicable to CS220 students)
Assigned:

• Quiz 8 (5:00 pm)
  
• Lab-P11
• P11
  

Fri: Web 2 (Apr 12)

• Intro to HTML
• Generating HTML list
• Generating HTML hyperlink
• Generating HTML table

Louis's Lecture: code
Mike's Lecture: code
Due: Quiz 8 (11:59:00 pm)

Mon: Web 3 (Apr 15)

• Document Object Model
• Parsing HTML
• beautifulsoup

Louis's Lecture: code
Mike's Lecture: code

Wed: Database 1 (Apr 17)

• why use a database?
• sqlite3 module
• querying from Pandas
• basic query structure

Louis's Lecture: code
Mike's Lecture: code
Due: P11
Due: CS319 Project part 2: data set (Not applicable to CS220 students)
Assigned:

• Quiz 9 (5:00 pm)
  
• Lab-P12
• P12
  

Fri: Database 2 (Apr 19)

• min, max, sum, avg
• count, distinct
• group by
• having

Louis's Lecture: code
Mike's Lecture: code
Due: Quiz 9 (11:59:00 pm)

Mon: Plotting 1 (Apr 22)

• bar plots
• customizing plots
• setting the index
• making a bar for 'other'

Read: Matplotlib Intro (HTML or matplotlib-intro.ipynb and data)
Louis's Lecture: code
Mike's Lecture: code

Wed: Plotting 2 (Apr 24)

• scatter plots
• correlation

Read: Line and Advanced Bar Plots (HTML, line-and-bar.ipynb and data)
Louis's Lecture: code
Mike's Lecture: code
Due: P12
Due: CS319 Project part 3: initial questions (Not applicable to CS220 students)
Assigned:

• Quiz 10 (5:00 pm)
  
• Lab-P13
• P13
  

Fri: Database 3 (Apr 26)

• Worksheet
• Pandas <--> SQL

Link to worksheet: pdf, docx
Link to worksheet solution (partial): pdf
Louis's Lecture: code
Mike's Lecture: code
Due: Quiz 10 (11:59:00 pm)

Mon: Advanced Pandas Topics (Apr 29)

• np.NAN, isna, dropna, fillna
• set_index
• replace, apply
• groupby
• SQL vs pandas

Louis's Lecture: code
Mike's Lecture: code

Wed: Plotting 3 (May 01)

• line plots
• multiple line plots
• multiple bar plots

Read: same as for "Plotting 2"
Louis's Lecture: code
Mike's Lecture: code
Lab: Fall 2023 Final Exam Practice (Optional)
Due: P13
Due: CS319 Project part 4: final project (Not applicable to CS220 students)

Fri: Review/Catchup (May 03)

• Bring Questions
• No work accepted after today. No late days or extensions may be used.
• Lab Project Survey

Louis's Lecture: Fall 23 Final Exam Practice Notebook

Thursday: Final Exam (May 9)

Regular final exam: 5/9/2024 12:25 pm - 2:25 pm
McBurney final exam: 5/9/2024 12:20 pm - 4:30 pm
Alternate exam: 5/9/2024 3:20 pm - 5:30 pm
Lab Project Survey