[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.1 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: Representing Natural Numbers

PDF

Objectives

Understand the base-10 hindu-arabic representation of numbers

• Video: Number Systems Introduction - Decimal, Binary, Octal & Hexadecimal - YouTube
• Reference: Hindu–Arabic numeral system - Wikipedia
• Reference: Decimal - Wikipedia

Understand the base-8 representation of the natural numbers

• Video: Number Systems Introduction - Decimal, Binary, Octal & Hexadecimal - YouTube
• Video: Octal to Binary Conversion | Computer Science - YouTube
• Reference: Octal - Wikipedia

Understand the base-16 representation of the natural numbers, and how base-16 can be used to create colors

• Video: Number Systems Introduction - Decimal, Binary, Octal & Hexadecimal - YouTube
• Video: How Do HEX Color Codes Work? (in 60 seconds) - YouTube
• Reference: Hexadecimal - Wikipedia
• Reference: Web colors - Wikipedia

Understand the base-2 representation of the natural numbers. Define binary applications, addition, and be able to convert between the representation forms.

• Video: Binary Numbers and Base Systems as Fast as Possible - YouTube
• Video: Binary Explained in 01100100 Seconds - YouTube
• Video: Representing Numbers and Letters with Binary: Crash Course Computer Science #4 - YouTube
• Video: How to Read and Write Binary (In 5 Minutes) - YouTube
• Video: Why Do Computers Use 1s and 0s? Binary and Transistors Explained. - YouTube
• Reference: Binary number - Wikipedia

Understand the basics of computer memory, bits and bytes, and how to translate bits into characters, integers, etc.

• Video: Memory & Storage: Crash Course Computer Science #19 - YouTube
• Video: How computer memory works - Kanawat Senanan - YouTube
• Video: CS50 2019 - Lecture 4 - Memory - YouTube
• Video: Registers and RAM: Crash Course Computer Science #6 - YouTube
• Reference: Bit - Wikipedia
• Reference: Bit array - Wikipedia
• Reference: Byte - Wikipedia
• Reference: Computer memory - Wikipedia

Prerequisites

• Understand the orgin of RGB values and what they represent from Chapter 1: "How Cameras Work" in Workbook 15

Generated 2025-12-16T09:11.