English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 133 Lessons (22h 39m) | 2.76 GB
This course will turn you into an automation wizard that can automate away all the boring, annoying parts of your work and life. You’ll learn by being hands-on and building 11 automation projects using Python and AI. All from scratch. No coding experience required.
We guarantee you that this is the best, most comprehensive, and up-to-date course to learn automation. You’ll not only learn the fundamental building blocks, but you’ll also learn advanced topics, tools, and tricks that most courses don’t cover!
WHAT YOU’LL LEARN
- Automate file and folder operations to streamline data organization and management
- Use Python to automate pattern matching with Regular Expressions, enhancing text processing capabilities
- Automate Excel and Google Spreadsheets for quicker and more efficient data manipulation tasks
- Automate email sending and processing to improve communication workflows
- Interact with various APIs to enable the integration of different services and data sources
- Leverage AI with the OpenAI API, including building intelligent chatbots
- Understand fundamental Python programming concepts such as data structures, conditional logic, and loops
- Develop practical chatbot applications, specifically a ‘Celebrity Chatbot’ and ‘BrunoBot’, to enhance AI-driven conversations
Table of Contents
1 The Automation Bootcamp Zero to Mastery
2 Course Introduction
3 What is Programming
4 Introducing the Replit Editor
5 Values and Types
6 Functions
7 Expressions
8 Expressions in Python
9 Variables
10 Naming Variables
11 Errors
12 F Strings
13 Objects, Attributes, and Methods
14 Scripts
15 Comments
16 Lists
17 Tuples
18 Dictionaries I
19 Dictionaries II
20 If Statements I
21 If Statements II
22 Else and Elif
23 And and Or
24 While Loops
25 Validating Input with While Loops
26 For Loops
27 Looping Through Lists and Tuples
28 Looping Through Dictionaries
29 Modules, Libraries, and Classes
30 Introduction
31 Introduction to PyCharm
32 Plaintext Files
33 Opening, Reading, and Closing Files
34 Readlines and the With Statement
35 Writing to Plaintext Files
36 CSV Files
37 Reading from CSV Files
38 Writing to CSV Files
39 Transferring in Text Files
40 Product Sales Tracker Project – Introduction
41 Project – Walkthrough
42 Understanding Paths
43 Handling Paths with Pathlib
44 Pathlib Methods
45 Iterating Over File Paths
46 Accessing File and Folder Properties
47 Creating Folders
48 Copying Files
49 Copying Folders
50 Moving Files and Folders
51 Renaming Files and Folders
52 Deleting Files and Folders
53 Clean Sweeper Project – Introduction
54 Another Way to Create Paths
55 Project – Solution
56 Introducing Regular Expressions
57 Regex Syntax Basics
58 Special Characters
59 Matching Multiple Characters
60 Quantifiers
61 Custom Quantifiers
62 Anchors
63 Regular Expressions in Python I
64 Regular Expressions in Python II
65 Findall
66 The Sub Method
67 SSN Masker Mini-Project – Introduction
68 Mini-Project – Solution
69 Alternation
70 Compilation Flags
71 Contact Info Extractor Project – Introduction
72 Project – Solution Part 1
73 Project – Solution Part 2
74 The Compile Method
75 Introduction
76 Introducing openpyxl
77 Introducing gspread
78 Automating Excel 101
79 Automating Google Sheets 101
80 Automating Worksheet Operations Part 1 – Excel
81 Automating Worksheet Operations Part 2 – Excel
82 Automating Sheet Operations Part 1 – Google Sheets
83 Automating Sheet Operations Part 2 – Google Sheets
84 Working with Cells – Excel
85 Working with Cells – Google Sheets
86 Working with Ranges – Excel
87 Writing Data to Excel Ranges
88 Working with Ranges – Google Sheets
89 Automating Formulas Part 1 – Excel
90 Automating Formulas Part 2 – Excel
91 Automating Formulas Part 1 – Google Sheets
92 Automating Formulas Part 2 – Google Sheets
93 Working with Cell Styles – Excel
94 Working With Cell Styles – Google Sheets
95 Diff Analyzer Project – Introduction
96 Excel Project – Solution Part 1
97 Excel Project – Solution Part 2
98 Excel Project – Solution Part 3
99 Google Sheets Project – Solution Part 1
100 Google Sheets Project – Solution Part 2
101 Google Sheets Project – Solution Part 3
102 Exercise Imposter Syndrome
103 How Email Works
104 Sending Your First Email with Python
105 Enhanced Emails with the Email Module – Part 1
106 Enhanced Emails with the Email Module – Part 2
107 Sending Emails to Multiple Recipients
108 Sending Emails with Attachments
109 Customer Feedback Alert System Project – Introduction
110 Project – Solution
111 Introduction to APIs
112 HTTP 101
113 Making HTTP Requests with Python
114 Requesting JSON with Python
115 Adding Parameters to Requests
116 Request Parameters in Python
117 Tech Trivia Fetcher Project – Introduction
118 Project Solution – Part 1
119 Project Solution – Part 2
120 Introducing ChatGPT
121 Exploring ChatGPT’s Capabilities
122 API Authentication
123 The OpenAI Playground
124 Managing the API Key
125 Our First API Call
126 The max_tokens Parameter
127 Understanding GPT Models
128 The temperature Parameter
129 Building a Celebrity ChatBot – Part 1
130 Building a Celebrity ChatBot – Part 2
131 BrunoBot Project – Introduction
132 Project – Solution
133 Thank You!
Resolve the captcha to access the links!