Digital Revolver

What Will You Learn? What Benefits You Get From Taking This Course?

How to Install Python 3 on Windows

How to Install Python 3 on macOS

Installing Python 3 on Windows, Linux and MacOS

The Python Interpreter & IDLE in Windows

The Python Interpreter & IDLE in macOS

Python 3 Basics - Scripts in Windows

Python 3 Basics - Scripts in macOS

Python 3 - Reasons for the 'No such file or directory' error (or similar)

Python 3 Basics - User Input

Notebook - User Input

Python 3 User Input - Quiz

Python 3 Basics - Variables

Notebook - Variables

Python 3 Basics - Keywords

Python 3 - Data Types

Python 3 Basics - Quiz

Why learn about each of Python's data types?

Python 3 Strings - Introduction

Python 3 Strings - Methods

Python 3 Strings - Operators & Formatting

Python 3 Strings - Formatting Using F-strings

Python 3 Strings - Slices

Python 3 Strings - Slicing Using a Step

Notebook - Strings

Strings - Quiz

Python 3 Numbers - Math Operators

Notebook - Numbers and Math Operators

Numbers - Quiz

Python 3 Booleans - Logical Operators

Notebook - Booleans and Logical Operators

Booleans - Quiz

Python 3 Lists - Introduction

Python 3 Lists - Methods

Python 3 Lists - Slices

Notebook - Lists

Lists - Quiz

Python 3 Sets - Introduction

Python 3 Sets - Methods

Python 3 Sets - Frozensets

Notebook - Sets and Frozensets

Sets - Quiz

Python 3 Tuples - Introduction

Python 3 Tuples - Tuples vs. Lists

Python 3 Tuples - Methods

Notebook - Tuples

Tuples - Quiz

Python 3 Ranges - Introduction

Python 3 Ranges - Methods

Notebook - Ranges

Ranges - Quiz

Python 3 Dictionaries - Introduction

Python 3 Dictionaries - Methods

Python 3 Dictionaries - Updates in v3.6 and v3.7

Python 3 - Conversions Between Data Types

Notebook - Dictionaries and Conversions Between Data Types

Dictionaries - Quiz

Python 3 Dictionaries - Updates in v3.6 and v3.7

Python 3 Conditionals - If / Elif / Else

Notebook - If / Elif / Else Conditionals

Python 3 Loops - For / For-Else

Notebook - For / For-Else Loops

Python 3 Loops - While / While-Else

Notebook - While / While-Else Loops

Python 3 Nesting - If / For / While

Notebook - Nesting

Python 3 - Break / Continue / Pass

Notebook - Break / Continue / Pass

Python 3 - Exceptions

Python 3 - Try / Except / Else / Finally

Notebook - Try / Except / Else / Finally

Conditionals and Loops - Quiz

Python 3 - Fixing Syntax Errors

Python 3 - Fixing Exceptions

Handling Errors and Exceptions - Quiz

Python 3 Functions - Basics

Python 3 Functions - Arguments

Notebook - Functions - Basics

Python 3 Functions - Namespaces

Python 3 Modules - Importing

Python 3 Modules - Helpful Functions: dir() and help()

Notebook - Modules and Importing

Python 3 Modules - Installing a Non-Default Module in Windows

Python 3 Modules - Installing a Non-Default Module in macOS

Functions - Quiz

Python 3 Files - Opening & Reading

Python 3 Files - Quick Note for Windows Users

Python 3 Files - Additional Way of Avoiding the Unicode Error

Python 3 Files - Writing & Appending

Python 3 Files - Closing. The "with" Method

Python 3 Files - Deleting File Contents

Python 3 Files - Access Modes Summary

Notebook - File Operations

File Operations - Quiz

Python 3 Regex - match() & search()

Python 3 Regex - findall() & sub()

Python 3 Regex - Regular Expressions Summary

Notebook - Regular Expressions

Regular Expressions - Quiz

Python 3 Classes - Objects

Python 3 Classes - Inheritance

Notebook - Classes and Objects

Classes - Quiz

Python 3 - List / Set / Dictionary Comprehensions

Notebook - List / Set / Dictionary Comprehensions

Python 3 - Lambda Functions

Notebook - Lambda Functions

Python 3 - map() and filter()

Notebook - map() and filter()

Python 3 - Iterators and Generators

Notebook - Iterators and Generators

Python 3 - Itertools

Notebook - Itertools

Python 3 - Decorators

Notebook - Decorators

Python 3 - Threading Basics

Notebook - Threading Basics

Python 3 - Coding Best Practices

Advanced Concepts - Quiz

Python 3 - Cheat Sheet

Python 3 - 200+ Pages E-book

Planning the Application

Designing and Building the User Menu

Implementing Addition, Subtraction, Multiplication, Division

Implementing Modulo, Raising to a Power, Square Root, Logarithm

Implementing Trigonometric Functions: sin, cos, tan

Testing Each Function of the Application

Download the Code - Interactive Scientific Calculator

Creating Executable Files (.exe) from Python Scripts (.py)

Setting Up the Working Environment

Loading an Excel Workbook In Python and Creating/Removing Sheets

Notebook - Handling Workbooks

Getting General Information About a Sheet

Notebook - Sheet Information

Working with Sheet Cells Using Python

Working with Cell Styles Using Python

Notebook - Cell Styles

Notebook - Cell Information

Download the Excel-Python Cheat Sheet

APPLICATION - Migrating Records from a Text File to an Excel Workbook

Download the Code - Excel Application

Automate Excel Tasks with Python 3 - Quiz

Installing the Database Server Software

Downloading and Installing PostgreSQL on Windows, Linux, MacOS

Installing the Necessary Python Module

Creating a New Database, Schema and User

Notebook - Creating a New Database, Schema and User

Connecting Python to the Database

Notebook - Connecting Python to the Database

Creating Database Tables with Python

Notebook - Creating Database Tables with Python

Inserting Records Into a Table with Python

Notebook - Inserting Records Into a Table with Python

Updating Records Into a Table with Python

Notebook - Updating Records Into a Table with Python

Deleting Records From a Table with Python

Notebook - Deleting Records From a Table with Python

Querying the Database with Python

Notebook - Querying the Database with Python

Fetching Information From the Database with Python

Notebook - Fetching Information From the Database with Python

Committing and Rolling Back Transactions with Python

Notebook - Committing and Rolling Back Transactions

Download the PostgreSQL Syntax Cheat Sheet

Download the PostgreSQL-Python Cheat Sheet

APPLICATION - Migrating Records from a Text File to the Database

Download the Code - Database Application

Automate Database Tasks with Python 3 - Quiz

Network Setup Overview

Installing the Virtualization Software

Installing the Virtualization Software on Windows, Linux, MacOS

Downloading & Installing the Network Device VM

Signing Up to the Arista Software Download Portal

Importing the VM & Tweaking the VM Settings

Connecting the Local PC to the Devices in Windows

Connecting the Local PC to the Devices in macOS

Checking the SSH Configuration and Testing the Connectivity

Necessary Switch/Router Configuration

Any Connection Issues? Check Out This Troubleshooting Checklist!

Planning the Application

Checking IP File Validity

Notebook - Checking IP File Validity

Checking IP Address Validity

Notebook - Checking IP Address Validity

Checking IP Address Reachability

Notebook - Checking IP Address Reachability

Note about pinging in Windows vs. Mac OS / Linux

Checking Username/Password File Validity

Notebook - Checking Username/Password File Validity

Checking Command File Validity

Notebook - Checking Command File Validity

Establishing the SSH Connection

Notebook - Establishing the SSH Connection

Enabling Simultaneous SSH Connections

Notebook - Enabling Simultaneous SSH Connections

Putting Everything Together

Download the Code - Network Application and Modules

Reading Device Configuration

Extracting Network Parameters

Configuring Multiple Devices Simultaneously

Automate Network Tasks with Python 3 - Quiz

Running Python Code - The Next Level: IPython and Jupyter Notebook

Notebook - IPython and Jupyter Notebook

Introduction to Pandas - Basic Operations

Notebook - Introduction to Pandas

Handling Files with Pandas - TXT, CSV, JSON, XLSX

Download the Sample Files

Notebook - Handling TXT, CSV, JSON, XLSX Files with Pandas

Reading HTML Content from URLs and HTML Files with Pandas

Notebook - Reading HTML Content with Pandas

Indexing and Slicing Tables with Pandas

Notebook - Indexing and Slicing Tables with Pandas

Adding, Updating, Deleting Table Rows and Columns

Notebook - Adding, Updating, Deleting Table Rows and Columns

APPLICATION - Reading and Writing Data in PostgreSQL Databases Using Pandas

Download the Code - SQL Data Analysis Application

Introduction to Bokeh

Bookmark These 3 Important Documentation Links

Creating a Basic Line Plot Based on Python Lists

Notebook - Creating a Basic Line Plot Based on Python Lists

Creating a Bar Plot Based on Excel Data

Notebook - Creating a Bar Plot Based on Excel Data

Creating a Pie Chart Based on CSV Data

Notebook - Creating a Pie Chart Based on CSV Data

Plotting Multiple Stock Prices Simultaneously

Notebook - Plotting Multiple Stock Prices Simultaneously

Plotting Bitcoin Prices as an Interactive Plot with a Range Tool

Notebook - Plotting Bitcoin Prices as an Interactive Plot with a Range Tool

Plotting Bitcoin Prices as an Interactive Plot with Candlesticks

Notebook - Plotting Bitcoin Prices as an Interactive Plot with Candlesticks

Installing pytest and Writing Your First Test

Notebook - Introduction to pytest

Running Multiple Tests. Test Discovery Rules in Action

Notebook - Running Multiple Tests

Testing a Basic Script - Preparing the Test Bed

Download the Code for Testing

Fixture Functions

Notebook - Fixture Functions

Sharing a Fixture Instance & Fixture Finalization

Notebook - Sharing a Fixture Instance & Fixture Finalization

Parametrizing Fixtures

Notebook - Parametrizing Fixtures

Marking Test Functions Using Attributes

Notebook - Marking Test Functions Using Attributes

Marking Test Functions Using Custom Markers

Notebook - Marking Test Functions Using Custom Markers

Automate Unit Testing with Python 3 - Quiz

Installing the Necessary Modules

Notebook - Installing the Necessary Modules

Extracting and Parsing Web Content

Notebook - Extracting and Parsing Web Content

Tags, Names and Attributes

Notebook - Tags, Names and Attributes

Searching the Tree of HTML Tags: find() and find_all()

Notebook - Searching the Tree of HTML Tags: find() and find_all()

APPLICATION - Extracting the Product Names, Links and Prices. Saving to Excel

Download the Code - Scraping Web Data and Saving to Excel

APPLICATION - Handling Website Pagination When Extracting Data

Download the Code - Handling Website Pagination When Extracting Data

Automate Web Scraping with Python 3 - Quiz

Comparing File Contents (difflib)

Notebook - Comparing File Contents (difflib)

Argument Passing with sys.argv

Notebook - Argument Passing with sys.argv

Putting Your Skills to Work - Part 1

Putting Your Skills to Work - Part 2

Download the Presentation