1. Welcome FREE CHAPTER

• Course Introduction

2. Getting Started with Python

• Section Introduction
• Installing Python and the IDE
• Creating and Running a Python Program
• What (Surprisingly) Is Python?

3. The Basics: Data Types

• Section Introduction
• Variables -Why and How to Use Variables
• Python Interactive Shell
• Terminal
• Simple Types: Integers, Strings, and Floats
• List Types
• Ranges
• Data Type Attributes
• How to Find Out What Code You Need
• Dictionary Types
• What Makes a Programmer a Programmer?
• Tuples
• How to Use Datatypes in the Real World

4. The Basics: Operations with Data Types

• Section Introduction
• Tip: Better Error Messages in Python 3.10
• More Operations with Lists
• Accessing List Items
• Accessing List Slices
• Accessing Items and Slices with Negative Indexes
• Accessing Characters and Slices in Strings
• Accessing Items in Dictionaries

5. The Basics: Functions and Conditionals

• Section Introduction
• Creating Your Own Functions
• Print or Return?
• Introduction to Conditionals
• If Conditional Example
• Conditional Explained Line by Line
• More on Conditionals
• Elif Conditionals
• White Space

6. The Basics: Processing User Input

• Section Introduction
• User Input
• String Formatting
• String Formatting with Multiple Variables

7. The Basics: Loops

• Section Introduction
• For Loops: How and Why
• Looping Through a Dictionary
• While Loops: How and Why
• While Loop Example with User Input
• While Loops with Break and Continue

8. Putting the Pieces Together: Building a Program

• Section Introduction
• Problem Statement
• Approaching the Problem
• Building the Maker Function
• Constructing the Loop
• Making the Output User-Friendly

9. List Comprehensions

• Section Introduction
• Simple List Comprehension
• List Comprehension with If Conditional
• List Comprehension with If-Else Conditional

10. More about Functions

• Section Introduction
• Functions with Multiple Arguments
• Default and Non-Default Parameters and Keyword and Non-Keyword Arguments
• Functions with an Arbitrary Number of Non-Keyword Arguments
• Functions with an Arbitrary Number of Keyword Arguments

11. File Processing

• Section Introduction
• Processing Files with Python
• Reading Text from a File
• File Cursor
• Closing a File
• Opening Files Using "with"
• Different File paths
• Writing Text to a File
• Appending Text to an Existing File

12. Modules

• Section Introduction
• Built-In Modules
• Standard Python Modules
• Third-Party Modules
• Third-Party Module Example

13. Using Python with CSV, JSON, and Excel Files

• Section Introduction
• The "pandas" Data Analysis Library
• Getting Started with Pandas
• Getting Started with Jupyter
• Loading CSV Files
• Loading Excel Files
• Loading Data from Plain Text Files
• Set Table Header Row
• Set Column Names
• Set Index Column
• Filtering Data from a Pandas Data Frame
• Deleting Columns and Rows
• Updating and Adding New Columns and Rows
• Data Analysis Example: Converting Addresses to Coordinates

14. Numerical and Scientific Computing with Python and NumPy

• What Is NumPy?
• Convert Images to NumPy Arrays
• Indexing, Slicing, and Iterating NumPy Arrays
• Stacking and Splitting NumPy Arrays

15. App 1: Web Mapping with Python: Interactive Mapping of Population and Volcanoes

• Demo of the Web Map
• Creating an HTML Map with Python
• Adding a Marker to the Map
• Practicing "for-loops" by Adding Multiple Markers
• Practicing File Processing by Adding Markers from Files
• Practicing String Manipulation by Adding Text to the Map Popup Window
• Practicing Functions by Creating a Color Generation Function for Markers
• Solution: Add and Stylize Markers
• Exploring the Population JSON Data
• Practicing JSON Data by Adding a Population Map Layer from the Data
• Stylizing the Population Layer
• Adding a Layer Control Panel

16. App 2: Building an English Thesaurus

• Demo of the Interactive English Dictionary
• Know Your Dataset
• Loading JSON Data
• Returning the Definition of a Word
• Existing Words
• Dealing with Case-Sensitive Words
• Calculating the Similarity Between Words
• Best Matches Out of a List of Words
• Finding the Most Similar Word from a Group of Words
• Getting Confirmation from the User
• Optimizing the Final output

17. Fixing Programming Errors

• Syntax Errors
• Runtime Errors
• How to Fix Difficult Errors
• How to Ask a Good Programming Question
• Making the Code Handle Errors by Itself

18. Image and Video Processing with Python

• Introduction
• Loading, Displaying, Resizing, and Creating Images
• Solution Further Explained
• Detecting Faces in Images
• Capturing Video with Python

19. App 3: Controlling the Webcam and Detecting Objects

• Demo of the Webcam Motion Detector App
• Detecting Moving Objects from the Webcam
• Storing Object Detection Timestamps in a CSV File

20. Interactive Data Visualization with Python and Bokeh

• Introduction to Bokeh
• Your First Bokeh Plot
• Using Bokeh with Pandas
• Creating a Time-Series Plot
• More Visualization Examples with Bokeh
• Plotting Time Intervals from the Data Generated by the Webcam App
• Implementing a Hover Feature

21. App 4 (Part 1): Data Analysis and Visualization with Pandas and Matplotlib

• Preview of the End Results
• Exploring the Dataset with Python and Pandas
• Selecting Data
• Filtering the Dataset
• Time-Based Filtering
• Turning Data into Information
• Aggregating and Plotting Average Ratings by Day
• Down-sampling and Plotting Average Ratings by Week
• Down-Sampling and Plotting Average Ratings by Month
• Average Ratings by Course by Month
• What Day of the Week Are People the Happiest?
• Other Types of Plots

22. App 4 (Part 2): Data Analysis and Visualization - in-Browser Interactive Plots

• Introduction to the Interactive Visualization Section
• Making a Simple Web App
• Making a Data Visualization Web App
• Changing Graph Labels in the Web App
• Adding a Time-Series Graph to the Web App
• Multiple Time-Series Plots
• Multiple Time-Series Streamgraph
• Adding a Pie Chart to the Web App

23. App 5: Web Development with Flask - Build a Personal Website

• Demo of the Personal Website
• Building Your First Website
• Preparing HTML Templates
• Adding a Website Navigation Menu
• Improving the Website Frontend with CSS
• Creating a Python Virtual Environment
• How to Use the PythonAnywhere Service
• Deploying the Flask App on PythonAnywhere

24. Building Desktop Graphical User Interfaces (GUI) with Python

• Introduction to the Tkinter Library
• Creating a GUI Window and Adding Widgets
• Connecting GUI Widgets with Functions

25. Interacting with Databases

• How Python Interacts with Databases #sql
• Connecting to a SQLite Database with Python
• (SQLite) Selecting, Inserting, Deleting, and Updating SQL Records
• PostgreSQL Database with Python
• (PostgreSQL) Selecting, Inserting, Deleting, and Updating SQL Records

26. App 6: GUI Apps and SQL: Build a Book Inventory Desktop GUI Database App

• Demo of the Book Inventory App
• Designing the User Interface
• Coding the Frontend Interface
• Coding the Backend
• Connecting the Frontend with the Backend, Part 1
• Connecting the Frontend with the Backend, Part 2
• Creating .exe and .app Executables from the Python Script

27. Object-Oriented Programming (OOP)

• What Is Object-Oriented Programming (OOP)?
• Using OOP in a Program, Part 1
• Using OOP in a Program, Part 2
• Creating a Bank Account Class
• Creating Classes Through Inheritance
• OOP Glossary

28. App 7: Mobile App Development: Build a Feel-Good App

• Demo of the Mobile App
• Creating a User Login Page
• Creating a User Sign-Up Page
• Capturing User Input
• Processing User Signups
• Creating a Sign-Up Success Page
• Switching Between Pages
• Processing User Login Credentials
• Displaying Output to the User
• Stylizing the Login Page
• Stylizing the Sign-Up Page
• Making the Buttons Interactive
• Making a Scrollable Area

29. Making an Android APK File from the Kivy App

• Preparing the Environment for Deploying the App to an Android Phone
• Creating an APK file for Android
• Installing the APK file on Android

30. Web Scraping with Python and Beautiful Soup

• Section Introduction
• How Web Scraping Works
• Web Scraping Example with Python

31. App 7: Web Scraping - Scraping Properties for Sale from the Web

• Demo of the Web Scraping App
• Loading the Webpage in Python
• Extracting "div" Elements
• Scraping the Addresses of the Properties
• Scraping Special Elements
• Saving the Extracted Data in CSV Files
• Crawling Through Multiple Webpages

32. App 9: Django and Bootstrap Blog and Translator App

• A Comparison of Python Web Frameworks
• Setting Up a Virtual Environment
• Creating a Django Project
• Creating a Superuser for the Project
• Setting Up an Empty Django Blog App
• Creating a Database Model for the Blog App
• Overview of the Web App Architecture
• HTML Templates
• Django Views
• URL Patterns
• Creating Admin Interface Views
• Creating a Homepage
• Creating an "About" Page
• Listing Blog Posts on the Homepage
• Creating Links
• Adding Bootstrap to Django
• Django Template Filters
• Template Inheritance
• Applying Bootstrap Styling to the Navigation Menu
• Demo of the Django Translation App
• The Steps of Django App Development
• Creating an Empty App Structure of the Translator
• Creating an HTML Form in Django
• Configuring the URLs
• Creating a Form
• Getting and Processing User Input Through a Form
• Completing the Translator App

33. App 10: Build a Geography Web App with Flask and Pandas

• Demo of the Geography Web App
• Solution, Part 1
• Solution, Part 2