[Top]

Workbook 24

Chapter 1: Data Tables and pandas

PDF

Downloads

• Book data for questions 2 - 5 on quiz
• Practice workbook python file for reading bikes.csv
• CSV file on bikes for workbook examples.

Objectives

Understand how to use pandas to parse a CSV file in python

• Video: NumPy vs Pandas - YouTube
• Video: What is Pandas? Why and How to Use Pandas in Python - YouTube
• Reference: pandas (software) - Wikipedia
• Reference: pandas documentation — pandas 2.3.3 documentation

Prerequisites

• Be able to program in python. This holistic overview includes writing lines of code, creating variables, understand basic file structure, up to advanced data structures and simulation libraries. from Chapter 1: "Falling Bodies" in Workbook 07

Chapter 2: Data tables in SQL

PDF

Downloads

• A workbook example of a bikes database.
• Data for the quiz questions 1-5 for parsing through books.

Objectives

Understand how to parse tables in sql.

• Video: SQL Explained in 100 Seconds - YouTube
• Video: MySQL - The Basics // Learn SQL in 23 Easy Steps - YouTube
• Video: CS50x 2025 - Lecture 7 - SQL - YouTube
• Video: CS50 SQL - Lecture 0 - Querying - YouTube
• Reference: SQLite - Wikipedia
• Reference: SQLite Documentation
• Reference: SQL Tutorial

Chapter 3: Diodes, Rectifiers, and Photovoltaics

PDF

Generated 2026-02-02T11:00.