Python From Zero To Automation

A practical programming course for office workers, academics, and administrators who want to improve their productivity

What you'll learn

Automate tasks on their computer by writing simple Python programs

Programmatically generate and update Excel spreadsheets

Scrape web sites and pull information from them

Write programs that can do text pattern recognition with "regular expressions"

Write programs that send out email notifications

Programmatically control the mouse and keyboard to click and type for you

Browser Automation using selenium framework

Requirements

No programming experience is required

Downloading and installing Python is covered at the start of the course

Basic computer skills: surfing websites, running programs, saving and opening documents, etc

Description

If you're an office worker, student, administrator, or just want to become more productive with your computer, programming will allow you write code that can automate tedious tasks. Python From Zero to Automation was written for people who want to get up to speed writing small programs that do practical tasks as soon as possible. You don't need to know sorting algorithms or object-oriented programming, so this course skips all the computer science and concentrates on writing code that gets stuff done.The course is designed to take you from a complete beginner in Python to being able to automate tasks using this language. You will start with a short introduction to the basics of the Python programming language, including data types, control structures, functions, and file handling. From there, you will learn more advanced concepts such as regular expressions, web scraping, and desktop and browser automation. This course is for complete beginners and covers the popular Python programming language. You'll learn basic concepts as well as:Web scrapingAutomating Excel spreadsheetsAutomating the keyboard and mouseAutomating the browserSending emails and textsAnd several other practical topicsWe'll take you step-by-step through engaging video tutorials and teach you everything you need to know to succeed as a Python developer.By the end of this course, you'll be able to write code that not only dramatically increases your productivity, but also be able to add this new skill on your resume.

Overview

Section 1: Introduction

Lecture 1 IMPORTANT. Please read!

Lecture 2 Installing Python on Windows

Lecture 3 Installing Python on Linux and macOS

Lecture 4 Installing Visual Studio Code on Windows

Section 2: Python Fundamentals

Lecture 5 Syntax

Lecture 6 Variables

Lecture 7 Strings

Lecture 8 Numbers

Lecture 9 Booleans

Lecture 10 Constants

Lecture 11 Comments

Section 3: Operators

Lecture 12 Comparison operators

Lecture 13 Logical operators

Lecture 14 Precedence of Logical operators

Section 4: Control Flow

Lecture 15 if statement

Lecture 16 if-else statement

Lecture 17 if-elif-else statement

Lecture 18 Ternary Operator

Lecture 19 for loop

Lecture 20 while loop

Lecture 21 break statement

Lecture 22 continue statement

Lecture 23 pass statement

Section 5: Functions

Lecture 24 Introduction

Lecture 25 Default parameters

Lecture 26 Keyword arguments

Lecture 27 Recursive functions

Lecture 28 Lambda expressions

Section 6: Lists

Lecture 29 Introduction

Lecture 30 Tuples

Lecture 31 Sorting a list in place

Lecture 32 sorted() function

Lecture 33 Slice a list

Lecture 34 Unpacking a list

Lecture 35 Iterate over a list

Lecture 36 Find element in a list

Lecture 37 Iterator vs Iterable

Lecture 38 Transform a list using map()

Lecture 39 Filter list items

Lecture 40 Reduce list items to a single value

Lecture 41 List comprehension

Section 7: Strings

Lecture 42 Introduction

Lecture 43 Escape characters

Lecture 44 Raw strings

Lecture 45 Multiline strings

Lecture 46 Operators "in" and "not in"

Lecture 47 Convert and check string case

Lecture 48 The "isX()" string methods

Lecture 49 startswith() and endswith() methods

Lecture 50 Joining and splitting strings

Lecture 51 Justifying strings

Lecture 52 Removing spaces from strings

Section 8: Dictionaries

Lecture 53 Basic operations

Lecture 54 Dictionary comprehension

Section 9: Sets

Lecture 55 Introduction and basic set operations

Lecture 56 Set comprehension

Lecture 57 Union of sets

Lecture 58 Intersection of sets

Lecture 59 Difference of sets

Lecture 60 Symmetric difference of sets

Lecture 61 Subsets

Lecture 62 Supersets

Lecture 63 Disjoint sets

Section 10: Exception Handling

Lecture 64 try…except

Lecture 65 try…except…finaly

Lecture 66 try…except…else

Section 11: Regular Expressions

Lecture 67 Searching text without regular expressions

Lecture 68 Using regular expressions

Lecture 69 Groups

Lecture 70 Matching multiple patterns

Lecture 71 Optional Matching

Lecture 72 Matching Zero or More

Lecture 73 Matching One or More

Lecture 74 Matching Specific Repetitions

Lecture 75 Greedy and Non-greedy Matching

Lecture 76 Finding all occurences

Lecture 77 Character Classes

Lecture 78 Making Your Own Character Classes

Lecture 79 The caret (^) and dolar ($) characters

Lecture 80 The dot (.) character

Lecture 81 The dot-star (.*)

Lecture 82 Ignoring the case

Lecture 83 Regular Expressions symbols recap

Section 12: Modules

Lecture 84 Introduction

Lecture 85 Search path

Lecture 86 __name__ variable

Section 13: Working with files

Lecture 87 Introduction

Lecture 88 Reading text files

Lecture 89 Writting text files

Lecture 90 Checking if a file exits

Lecture 91 Reading a CSV file

Lecture 92 Writing a CSV file

Lecture 93 Renaming a file

Lecture 94 Deleting a file

Lecture 95 Working with directories

Section 14: Third-party packages, PIP and Virtual Environment

Lecture 96 The Python package index

Lecture 97 PIP

Lecture 98 Virtual environment

Section 15: Automating Spreadsheets

Lecture 99 Introduction to spreadsheets

Lecture 100 Reading spreadsheets

Lecture 101 Getting the max row and column

Lecture 102 Reading slices of data

Lecture 103 Iterating through rows and columns

Lecture 104 Creating spreadsheets

Lecture 105 Writing data to the cells

Lecture 106 Adding filter and sorting

Lecture 107 Formulas

Lecture 108 Charts

Section 16: GUI Automation

Lecture 109 Screen Resolution

Lecture 110 Moving the mouse

Lecture 111 Failsafe feature

Lecture 112 Getting mouse position

Lecture 113 Clicking the mouse

Lecture 114 Dragging the mouse

Lecture 115 Scrolling the mouse

Lecture 116 Typing text

Lecture 117 Key names

Lecture 118 Pressing Keys

Lecture 119 Using hotkeys

Lecture 120 Manipulating windows

Lecture 121 Sending messages to the user

Lecture 122 Sending emails automatically

Lecture 123 Filling forms automatically

Section 17: Browser Automation

Lecture 124 Installing Selenium

Lecture 125 Avoid seeing log messages using chromedriver

Lecture 126 Opening a page

Lecture 127 Find element by ID and NAME

Lecture 128 Find element by classname

Lecture 129 Find element by tagname

Lecture 130 Find element by link

Lecture 131 Find element by CSS selector

Lecture 132 Find element by XPATH

Lecture 133 XPATH with logical operators

Lecture 134 XPATH Functions

Lecture 135 XPATH index

Lecture 136 XPATH chained

Lecture 137 XPATH axes

Lecture 138 Finding multiple elements

Lecture 139 Waiting for elements

Lecture 140 Filling in forms

Section 18: Web Scraping

Lecture 141 Introduction

Lecture 142 Requesting a page to scrape

Lecture 143 Scrape basic page data

Lecture 144 Scrape book titles

Lecture 145 Improving scraping of book titles

Lecture 146 Scrape author, release date and book format

Lecture 147 Scrape book price

Office workers, students, small/home business workers, and administrators would want to improve their productivity,Aspiring software engineers who want to add skills to their programming toolbelt,Computer users who have heard the "learn to code" message, but want practical reasons to learn programming,Experienced Python software engineers can skip the first half of the course, but may find the later parts that cover various third-party modules helpful,While this course doesn't cover specific devops tools, this course would be useful for QA, devops, and admins who want to learn scripting in Python