| Mon | 8/17 | - Unit 1: Getting Started with Jupyter Notebooks
- VS Code
- Google Colab
- Jupyter Notebooks
| | |
| Wed | 8/19 | - Unit 2: NumPy
- The Data Analytics Ecosystem
- NumPy ndarrays
- NumPy Statistical Functions
| | |
| Fri | 8/21 | - Unit 2: NumPy
- Basic Indexing and Slicing
- Importing Data Into NumPy Arrays
| | |
| Mon | 8/24 | - Unit 3: Pandas
- Reading CSV Files
- Pandas DataFrames
| | |
| Wed | 8/26 | - Unit 3: Pandas
- Reading Excel Files
- Bringing Code into Notebooks
- uv - Python Package Manager
| | |
| Fri | 8/28 | - Lab Day (working session)
- Work on Lab 1 & Group Presentation
| | Ex 1.1
Ex 2.1
Ex 3.1
Ex 3.2 |
| Mon | 8/31 | - Unit 3: Pandas
- Summary Stats of a DataFrame
- Min, Mean, Sum, and Describe Methods
- Create Custom Datasets
- Git - Version Control
| | Lab 1 |
| Wed | 9/2 | - Unit 3: Pandas
- Filtering DataFrames
- Filtering: query()
- Operators
- Checking Filter with unique()
| | |
| Fri | 9/4 | - Lab Day (working session)
- Work on Lab 2 & Group Presentation
| | Ex 3.3
Ex 3.4 |
| Mon | 9/7 | Labor Day - No Class | Lab 2 |
| Wed | 9/9 | - Unit 3: Pandas
- Sorting a DataFrame
- Changing Data Types
- Top & Bottom N with iloc[]
| | |
| Fri | 9/11 | - Lab Day (working session)
- Work on Lab 3 & Group Presentation
| | Ex 3.5 |
| Mon | 9/14 | - Unit 3: Pandas
- Groupby Operations - One Column
- Adding New Columns to DataFrames
| | Lab 3 |
| Wed | 9/16 | - Unit 3: Pandas
- Groupby Operations - Two Columns
| | |
| Fri | 9/18 | - Lab Day (working session)
- Work on Lab 4 & Group Presentation
| | Ex 3.6
Ex 3.7 |
| Mon | 9/21 | - Unit 3: Pandas
- Screenscraping
- Data Cleansing
| | Lab 4 |
| Wed | 9/23 | - Unit 3: Pandas
- Dealing with Missing Data
| | |
| Fri | 9/25 | - Professional Development Conference
- No Class
| | Ex 3.8
Ex 3.9 |
| Mon | 9/28 | - Unit 3: Pandas
- Data Cleansing II
- Handling Inconsistent Data
- Building an MCP Server for Claude Desktop
| | |
| Wed | 9/30 | - Unit 3: Pandas
- Reading Tables From a Relational Database
- Reading Data From a URL
| | |
| Fri | 10/2 | - Lab Day (working session)
- Work on Lab 5 & Group Presentation
| | Ex 3.10
Ex 3.11 |
| Mon | 10/5 | - Unit 4: Visualizing Data with Python
- Simple Plots with Matplotlib
- DataFrame Plots with Seaborn
| | Lab 5 |
| Wed | 10/7 | - Unit 4: Visualizing Data with Python
- Integrating Structurally Different Data Sets Into a Single DataFrame
| | |
| Fri | 10/9 | - No Class
- Have a restful and relaxing Fall Break!
| | Ex 4.1
Ex 4.2 |