AppMillers

Project 11 - Leap year with functions

Project 12 - Gross pay with overtime using function

Project 13 - Warm, Cold and Hot

Project 14 - Maximum of Three Numbers

Goals what you will learn

Understanding the List

For Loops

Updating Variables

Coding Exercise 17 - Highest Score

Solution to Highest Score

Find Integer Numbers

Solution to Find Integers Numbers

Sum of Above Average Scores

Solution to Sum of Above Average Scores

Loop Over Custom Function

Using Range() Function with Loop

Coding Exercise 20: Adding Odd Numbers

Solution to Adding Odd Numbers

Coding Exercise 21: Adding Even Numbers in ANY Range

Solution to Adding Even Numbers

For Loop in Practice

While loop

While Loop in Practice - Hurdle 2

Coding Exercise 22: Check Username

Solution to Check Username

While Loop in Practice - Hurdle 3

While Loop in Practice - Hurdle 4

Continue and Break

Coding Exercise 23: Numbers Divisible by 5 Until 130

Solution to Numbers Divisible

Coding Exercise 24: Factorial using Loop

Solution to Factorial using loop

Coding Exercise 25: Sum, Count and Average of Entered Numbers

Solution to Sum, Count and Average

Coding Exercise 26: Maximum and Minimum of Input Numbers

Solution to Minimum and Maximum Input

Goals what you will learn

What is String

Coding Exercise 27: Sum of Digits of 2 Digit Number

Solution to Sum of two digits

String Traversal

Coding Exercise 28: Backward Traversal

Solution to Backward Traversal

Coding Exercise 29: Sum of Digits

Solution to Sum of Digits

Coding Exercise 30: Count Characters in a String

Solution to Count Characters in a String

String Operators

Coding Exercise 32: First and Last 2 Characters

Solution to First and Last 2 characters

Coding Exercise 33: Replace Character in a String

Solution Replace Character

String Methods

String Parsing

Escape sequences

String Formatting

Coding Exercise 34: Format a String

Solution to Format String

Solution to Print Pattern

Project 20 - String Formatting

Goals what you will learn

More on Lists

Coding Exercise 35: Square Of Items

Solution to Square of Items

Index out of range

List Operations

Coding Exercise 36: Reverse a List using Slice Operator

Solution to Reverse a List using Slice Operator

List methods

Coding Exercise 37: Update the First Occurrence

Solution to Update the First Occurrence

Coding Exercise 38: First and Last Characters

Solution to First and Last Character

Functions with Python List

Coding Exercise 39: Create a List from Two Lists

Solution to Create a List from Two Lists

Coding Exercise 40: Remove and Add

Solution to Remove and Add

Coding Exercise 41: Three Equal Chunks

Solution to Three Chunks

Strings and Lists

Coding Exercise 42: Format List

List format

Nested List

Coding Exercise 43: Add Item in Nested List

Solution to Add Item in Nested List

Coding Exercise 44: Extend Nested List

Solution to Extend Nested List

Objects and Values

Coding Exercise 45: List Addition with Function

Solution to List Addition with Function

Coding Exercise 46: Concatenate Two Lists in One List Item Wise

Project 21 - Bill Roullette

Project 22 - Golden Star

Project 23 - Maze

Project 24 - Encrypt Function

Project 24 - Encrypt Function Debug

Project 24 - Decrypt Function

Project 24 - Decrypt Function Debug

Project 24 - Combine Together

Project 24 - Optimize functions

Dividing into Steps

Step 1 - Sentence Maker

Step 2 - create loop

Step 3 Putting everything together. mp4

Project 26 - Hangman how it looks like

Project 26 - Hangman Flowchart

Project 26 - Hangman Step1

Project 26 - Hangman Step2

Project 26 - Hangman Step3

Project 26 - Hangman Step4

Optimize the Program

Goals what you will learn

What is a dictionary?

Create Dictionary in Python

Insert/Update Element in Dictionary

Coding Exercise 47 - Generate Dictionary

Solution to Generate dictionary

Traverse/Search Element in Dictionary

Coding Exercise 48 - Multiply Dictionary Items

Solution to Multiply Dictionary Items

Coding Exercise 49 - Student Grades

Solution to Student Grade

Remove Elements from Dictionary

Coding Exercise 50 - Rename Key

Solution to Rename Key

IN / NOT IN Operators with Dictionary

Coding Exercise 51 - Count Characters in a Word

Solution to Count Characters in a Word

Nested Dictionary

Coding Exercise 52 - Nesting Dictionary Exercise

Solution to Nested Dictionary Exercise

Handling Missing Keys - get() and setdefaults() methods

Dictionary Keys Methods - fromkeys() and keys() methods

Coding Exercise 53 - Group Value Types

Solution to Group Value Types

Dictionary items() Method

Coding Exercise 54 - Length of Dictionary Values

Solution to Length of Dictionary Values

Dictionary update() Method

Coding Exercise 55 - Concatenate Three Dictionaries

Solution to Concatenate Three Dictionaries

Dictionary values() Method

Coding Exercise 56 - Remove Empty Items

Solution to Remove Empty Items

Reference to Dictionary - copy() Method

Coding Exercise 57 - Merge Two Dictionary

Solution to Merge Two Dictionary

Deep Copy

Coding Exercise 58 - Custom Deep Copy for List Values

Solution to Custom Deep Copy for List Values

Dictionary Operations and Built in Functions

Dictionary vs List

Project 27 - Calculate Price

Blind Auction Flowchart

Blind Auction Implementation

Find Highest Bid

Bug Fix

How does it work? Flowchart

Create Questions Dictionary

APP Implementation

Check Players Answer

Switch Players

Find Winner

Show Correct Answers

Optimize the Program

Goals: What You Will Learn

What is Tuple?

Why Typle?

Unpacking Tuples

Coding Exercise 59 - Sum Tuple Elements using Unpack

Solution to Sum Tuple Elements using Unpack

Traverse Tuple - Enumerate()

Coding Exercise 60 - Even Index with Enumerate

Solution to Even Index with Enumerate

Search in Tuple

Tuple Operations / Functions

Coding Exercise 61 - Find Most Frequent Item

Solution to Find Most Frequent Item

Nested Tuples

Nested Tuple Indexing

Coding Exercise 62 - Nested Tuple Indexing

Solution to Nested Indexing

Tuple vs List

Coding Exercise 63 - Convert Tuple to Dictionary

Solution to Convert Tuple to Dictionary

Coding Exercise 64 - Comparing Tuples

Solution to Comparing Tuples

How does it work

The flowchart

Separate Integers from Beginning of the Word

Separate Integers from Ending of the Word

Translate to Pig latin

Complete Project

Refactor the Code

Bug Fix

Complete Project

Flowchart

Create Nested Tuple

Print Logo and Playlist

Choose a song and play

Finalize the Project

Goals: what you will learn in this section

What is Set?

Sets in Python

Set Membership

Adding Members to Set

Coding Exercise 65 - Adding Members from List

Solution to Adding elements from List

Coding Exercise 66 - Remove Duplicates

Solution to Remove Duplicates

Deleting Items from Set

Coding Exercise 67 - Delete Restricted Items

Solution to Delete Restricted items

Delete Restricted items Remove method

Union Sets in Python

Coding Exercise 68 - Combine Sets

Solution to Combine Sets

Coding Exercise 69 - Union List of Sets

Solution to Union List of Sets

Set Intersection

Coding Exercise 70 - Find Numbers Divisible by 3 and 4

Solution to Numbers Divisible by 3 and 4

Coding Exercise 71 - Find Preposition

Solution to Find Preposition

Subtraction of Sets

Coding Exercise 72 - Difference of More than two Sets

Solution to Difference of More than two Sets

Symmetric Difference

Modifying the Set

Subsets and Supersets

Powerball Lottery

Powerball Lottery Step 1

Powerball Lottery Step 2

Powerball Lottery Step 3

Powerball Lottery Step 4

Project 32 - Powerball Lottery Final

What is Recursion?

Why Do We Need Recursion?

The Logic Behind Recursion

Recursive vs Iterative Solutions

Recursion in 3 Steps

Fibonacci Numbers using Recursion

Coding Exercise 73 - Sum of List using Recursion

Solution to Sum of List Elements

Coding Exercise 74 - 'a' to the power 'b' - using Recursion

Solution to a to power b

Coding Exercise 75 - Sum of Positive Integers

Solution to Sum of Positive Integers

When to Use / Avoid Recursion?

The Complete Project

bext Module in Python

Step1 - Get New Board

Step2 - Display the Board

Step 3 - Ask for Player Move

Step 4 - Check for Win

Global vs Local Scope

Block Scope in Python

Modify Global Variable

Python Constants and Global Scope

The Complete Project

BlackJack Program Requirements

Step 1 - Set the Constants

Step 2 - Get Bet

Step 3 - Get Deck

Step 4 - Display Cards

Step 5 - Get Hand Values

Step 6 - Display Hands

Step 7 - Get Move

Final Step - Complete Project

Identify the problem

Reproduce the Bug

Analyse Each Line

Fix Errors - IDE Messages

Using print() in Debugging

Debugger Tools

Syntax Errors

Runtime Errors

Logical Errors

Debugging the Code 1

Debugging the Code 2

Debugging the Code 3

Handling the Errors

Handling Exceptions - Challenge 1

Raise Your Own Exceptions

Handling Exceptions - Challenge 2

What is Regular Expression?

Coding Exercise 76 - Find Three Consecutive Digits

Solution to Three Consecutive digits

Metacharacters

Groups and Alteration

Repetition in Regular Expressions Patterns

Coding Exercise 77 - Repetition EX1

Solution to Repetition EX1

Coding Exercise 78 - Repetition EX2

Solution to Repetition EX2

Coding Exercise 79 - Repetition EX3

Solution to Repetition EX3

Greedy and Non Greedy Matches

Character Classes

Coding Exercise 80 - Character Class EX1

Solution to Character Classes Ex1

Coding Exercise 81 - Character Class EX2

Solution to Character Classes Ex2

Custom Character Class

Coding Exercise 82 - Character Class EX3

Solution to Character Class EX3

Coding Exercise 83 - Character Class EX4

Solution to Character Class EX4

Coding Exercise 84 - Character Class EX5

Solution to Character Class EX5

Caret Dollar Dot / Dot - Star

Coding Exercise 85 - Regex Pattern EX6

Solution to Regex Pattern EX6

Coding Exercise 86 - Regex Pattern EX7

Solution to Regex Pattern EX7

Coding Exercise 87 - Regex Pattern EX8

Solution to Regex Pattern EX8

Anchors

Coding Exercise 88 - Anchors

Solution to Anchors

Grouping Constructs

Coding Exercise 89 - is Decimal

Solution to is Decimal

Backreferences

More on Grouping Constructs

Regex Matching with Flags

re Searching functions

re Substitution functions

Coding Exercise 90 - Regex Substitution EX1

Solution to Regex Substitution EX1

re Utility Functions

What we will make

TODO 1 - Phone Regex Pattern

TODO 2, 3 and 4

Installing Python

Download PyCharm

Installing pyCharm on Mac

Installing pyCharm on Windows

Common Features of PyCharm

What we will develop

Strong Password Checker Implementation

File systems

Terminal on Mac and Command Prompt on Windows

Absolute and Relative File Paths

Navigating File System using OS Module

Get File Details using OS Module

More on OS Module

Number of Files in Current Directory

List All Files in Directory Recursively

Filename Matching with globe Module

Pathlib Module

Operating System Differences

Last Modified File using Pathlib

Project 38 - Display a Directory Tree

Project 39 - Rename file TODO 1

Project 39 - Rename file TODO 2

Open and Read Files - Text Files

File Cursor, Readline and Readlines

Searching Through a File

Reading File Challenge

Parsing Text File

Coding Exercise 92 - Reading File

Solutiont to Reading File Exercise

Coding Exercise 93 - Number of Characters

Solution to Number of Characters

File Modes

Writing Files

Printing a Text to File

Time Table Challenge

Binary Files

Writing and Reading to Binary File

Shelve Module

Data Manipulation with Shelve

More on Shelve

Copying Moving Files Folders

Deleting Files

Project Overview

Step1 and Step2 - Parse Data

Step3 - Question Files

Step4 - Answer Files

Step5 - Write Content

Step6 - Delete Files

What is OOP

Object Oriented Thinking

OOP Concepts - Classes, Objects, Attributes and Methods

Construct Objects access attributes

BlackJack OOP

BlackJack OOP Solution Part 1

BlackJack OOP Solution Part 2

Create Your Own Class

Class Attributes

Class Methods

OOP Challenge 1

OOP Challenge 2

OOP Challenge 3

Checking Instance Types

Encapsulation

Getters and Setters

Getters and Setters challenge

Inheritance

Inhetirance with Parameters

Inhetirance Challenge

Override methods

Override methods challenge

Abstraction

Project Overview

TODO 1, 2 and 3

TODO 4 and 5

TODO 6

TODO 7, 8 and 9

TODO 10, 11 and 12

Challenge Solution

Introduction - Advantages and Use Cases of Openpyxl

Reading Excel Files

Iterate Through Excel

Columns, Rows and Cells

Manipulate Excel Data

Project Overview

Step 1 - Reading Data From Excel

Step 2 - Manipulate Data using DS

Step 3 - Write Output to the File

Create Spreadsheet , Sheets and Update Cells

Manage Rows and Columns

Generate Random Excel Data - Challenge

Excel Formulas

Cell Styles

Conditional Formatting

Charts

Line Charts Challenge

Project Objective

Steps for Completing the Project

Introduction

Extract PDF Metadata and Text

Create, Merge and Copy PDFs

Split, Rotate and Overlay

Encrypt and Decrypt

Project Solution ToDo 1, 2 and 3

What is Web Scraping?

HTML Basics

Parsing HTML with Beautiful soup

Find and Select Specific Elements

Steps for Web Scraping a Real Website

Do All Websites Allow Webscraping

Project Objective

Steps for Completing the Project

Why Selenium

Selenium Setup

Finding elements

Scrap Data using Selenium

Clicking Buttons and Filling Text Fields

Special keys and browser buttons

Project Objective

Steps to Complete Project

What is GUI automation? Installing PYAUTOGUI

Mouse Movement

Mouse Interaction

Mouse Drag Challenge

Screenshot and Image Recognition

Keyboard and Show messages

Project Objective

Project Objective

Steps To Complete the Project

Reading CSV

Data Types and Basic statistics

Pandas Series

Accessing Elements of Series

Pandas DataFrame

Accessing Elements of DataFrame

Querying Data

Grouping Data

Write to CSV

CSV Pandas Challenge

Introduction to Turtle Graphics

Move Turtle

Challenge 1 - Drawing a Shape

Drawing and Filling Present shapes

Draw Polygon

Draw Dashed Shapes

RGB in Turtle

Screen and Turtle Properties

Random Walk Challenge

How to create game in turtle

Write method - default values

Project Objective

Steps to Complete the Project

Project Objective

Steps to Complete the Project

Project Objective

What you will make

Project Objective

Step 1 - Setup Screen

Step 2 - Setup Turtle

Step 3 - Move Turtles Randomly

Step 4 - Define the Winner and Show Message

Solution

What you will make by the end of section

Steps to Complete the Project

Step 1 - Create Game Screen and a Snake

Step 2 - Moving Snake on the Screen

Step 3 - Change the Direction of the Snake

Step 4 - Create Snake Class

Step 5 - Control Snake with Keys

Step 6 - Create and Detect Food

Step 7 - Create a Scoreboard

Step 8 - Detect Collision with Wall

Step 9 - Detect collision with Tail

Introduction to Tkinter

Creating Widgets

args and kwargs

Widget Placement

Event Handler

Label Widgets

Button Widget

Check and Radio button

Entry Widget

Combobox and spinbox

Progressbar and scale

Frame Widget

Top Level window

Paned Window Widget

Notebook Widget - tabs

Text Widget

Text Widget tag mark

Treeview

Addinng Columns Treeview

Adding Menus

Draw Line on canvas

Complex Shapes on Canvas

Scrollbar

Widget Styling

MessagBox

Pack Geomerty Manager

Grid Geomerty Manager

Place Geomerty Manager

Command Callbacks

Keyboard Events

Mouse events

Virtual Events

__name__ and __main__

Execution Modes

What you will make

Step 1 - Design the Form

Step 2 - Creating Widgets

Step 3 - Place widgets

Step 4 - Biding events

Step 5 - GUI style

What you will make by the end of the section

Step 1 - Design the Length Converter and Create Widgets

Step 2 - Place Widgets

Step 3 - Create Method / Bind Events / Setup Layout

What you will make

Step 1 - Design the Text Editor and Creating Widgets

Step 2 - Place the Widgets

Step 3 - Create Methods and Bind Events

What is database?

Relational databases

Non relational Databases

Python database API

What is SQL

What is SQLite?

Connect SQLite with Python

SQLite Browser

Create Table in SQLite

What is cursor?

Insert Into - Adding Data to a Table in SQLLite

Insert Data from CSV to SQLite

SELECT - Retreive Data

WHERE - Filter Data

UPDATE - Change Data

Delete - Remove Data

Join Tables - Access Tables Together

What you will make

Step 1 - Design Layout and Create Widgets

Step 2 - Place widgets on Screen

Step 3 - Develop Backend

Step 4 - Connecting Backend with Frontend

What is SQLalchemy?

Connect DB and Create Table using SQlalchemy CORE

Insert Data to SQLite using SQLalchemy Core

Retreive Data from SQLite using SQLalchemy Core

Update Data using SQLalchemy Core

Delete Data using SQLalchemy Core

Join Tables using SQLalchemy Core

Overview

Password manager sqlalchemy

Connect DB and Create Tables using SQlalchemy ORM

Insert Data to DB using SQlalchemy ORM

Query Data from DB using SQlalchemy ORM

Filter Operations using SQlalchemy ORM

Update Data using SQlalchemy ORM

Delete Data from DB using SQlalchemy ORM

Building Relationship using SQlalchemy ORM

Join Tables using SQlalchemy ORM

What is MySQL

Installing MySQL on Mac

Installing MySQL Workbench

Create database and tables

Connecting Mysql using Python

MySQL Operations using Python

Pythonic Application SQLAlchemy ORM - MySQL

Insert retrieve data Mysql orm

MySQL challenge

Import data Csv to Mysql

Import data using Pandas MySQL

What is PostgreSQL

Install PostgreSQL on Mac

Create postgresql db

Create insert select

Interacting with PostgreSQL SQLAlchemyCore

Interacting with PostgreSQL SQLAlchemy ORM

Call Stored Procedure

What is List comprehension

Square exercise

Conditional List Comprehension

Apply List Comprehension

Dictionary Comprehension

Dictionary Comprehension exercise

Walrus operator

What is Lambda

Create Lambda Function

Lambda function with Sort method

Lambda function with Filter and Map

What are generators

Generator Expressions

Advance Generator Functions

Generator Piplines

Functions

What are decorators

Arguments and Return

What is API

API Endpoints

API Response, Exceptio Json

API Parameters

API Auth

API Post Request

Environmental Variables

PUT and PATCH

Whats is REST

Getting started with Flask

Create API test with Postman

Return JSON

HTTP Codes in Flask

API Parameters

API Variables

Adding ORM

Database Models

Flask CLI

Retrieve Data from DB

Marshmellow

Retrieve Single Data

POST Route

POST Route JSON

Patch Route

Delete Route

New Version get patch post