Automating Tasks with Python and AI

Data Types in Python

Operators for Performing Operations on Variables and Values

How to Talk to a Computer (Input and Output)

Various Ways to Output Values with the print Function

Escaping Special Characters

Converting Between Strings and Numbers

Reserved Words with Special Meaning, Keywords

What is Indentation and Why is it Important?

The Crossroads of Logical Flow, Conditional Statements

Using Comparison Operators in Conditional Statements

Conditions within Conditions, Nested Conditionals

Combining Conditions for More Powerful Decisions

Filling in Gaps with the pass Keyword

Fill-in-the-blank quiz

Using Loops to Execute Code Multiple Times

Repeating a Specific Number of Times with a for Loop

Controlling Loops with the while Statement

Loop within a Loop, Nested Loops

Using break to Stop Loops

Skip Iteration with continue

Multiple-choice quiz

Coding Quiz - Python Temperature Converter

Managing Multiple Items with a List

Smart Ways to Utilize Lists

Adding/Removing Values to/from a List

Using Loops with Lists

Creating Lists Concisely Using List Comprehension

Fill-in-the-blank quiz

Immutable Collection of Values, Tuple

Representative Ways to Use Tuples

A Data Structure Comprising Keys and Values (Dictionary)

Efficiently Handling Dictionary Data

How to Use Dictionaries?

Multiple-choice quiz

Coding Quiz - Sorting a List

Code Blocks Performing Specific Tasks, Functions

Components of a Function

What Does It Mean to Call a Function?

Keyword Arguments and Variable Scope

Simplifying Functions with Lambda Functions

Fill-in-the-blank quiz

Introduction to Files and Basic Input/Output

How to Read File Contents

How to Write Data to a File

Exception Handling for Writing Safe Code

Enhancing Code Reusability and Efficiency with Modules

How to Create Your Own Python Modules

What Are Packages and How to Use Them?

Multiple-choice quiz

Coding Quiz - Sum of Even Numbers

What is Object-Oriented Programming?

Defining the Beginning, End, and Behavior of Objects

Extending Class Functionality Through Inheritance

Encapsulation and Polymorphism, Core Concepts of Object-Oriented Programming

Fill-in-the-blank quiz

Data Structures for Systematic Data Management

Piling Up Like Plates(Stack)

Standing in Line, Queue

Dynamically Connecting Data with Linked Lists

Managing Data with Keys and Values using a Hash Table

What is a Tree?

Multiple-choice quiz

What is an Algorithm?

Fast and Efficient Search Method, Binary Search

Coding Quiz - Implementing Binary Search Algorithm

How to Automate Repetitive Office Tasks

Introduction to Python Libraries for Office Automation

Python Library for Data Processing, Pandas

Manipulating Data with DataFrames

Calculate Summary Statistics with Pandas

Analyze Monthly Sales by Product Using Pandas

Fill-in-the-blank quiz

Automate Excel Tasks with Python

Exploring Key Methods of openpyxl

Efficiently Enter Data into an Excel File

How to Modify Cell Values Using Python Code

Formatting Fonts, Background Colors, and Borders

Adjusting Cell Width and Height

Formatting Columns

Visualizing Data with Charts

How to Use pandas and openpyxl Together

Multiple-choice quiz

Pandas and openpyxl Wrap-up

How to Automate Repetitive PowerPoint Tasks

Adding Text Box and Text to Slides

Changing Font, Size, and Color of Text Formatting

Inserting and Adjusting Images on a Slide

Creating and Managing Tables in Slides

Inserting Excel Data into a Slide as a Table

Creating Charts and Visualizing Data with Python

Fill-in-the-blank quiz

Create Word Documents with Python Code

Adding and Formatting Paragraphs

Creating Lists

How to Create Tables with Python Code

Inserting and Styling Images in Your Document

Adjusting Document Page Layout

Read Excel with openpyxl & Write to Word

Multiple-choice quiz

Challenge Yourself! Creating a Simple Table with python-docx

Repeated Data Collection with Web Crawling

Considerations When Conducting Web Crawling

Essential HTML Knowledge for Web Crawling

Essential CSS Knowledge for Web Crawling

Essential HTTP Knowledge for Web Crawling

Collecting Web Page Data with the requests Package

Parsing HTML with BeautifulSoup

Key Methods and Usage of BeautifulSoup

Regular Expressions for Web Crawling

Extracting Desired Information from Wikipedia

Fill-in-the-blank quiz

JavaScript and Dynamic Web Crawling

Basic Selenium Methods and Usage

Frequently Used Selenium Methods

Practical Examples of Using Selenium

Crawling US Stock Index with Selenium

Multiple-choice quiz

Coding Quiz - Web Scraping with Selenium

The Technical Principles of Email Communication

Why Do We Need Email Automation?

Email Message Format and MIME

How to Send an Email Using Python Code

Fill-in-the-blank quiz

Sending Emails with Attachments

Sending Data from Excel via Email

How to Send Periodic Emails

Sending Weather Information via Email After Web Crawling

Multiple-choice quiz

Summary of Email Automation

Definition of AI and Major Generative AI Models

How Generative AI Works

What Does It Mean When AI Learns?

What is a Prompt and How Does AI Understand It?

Components of a Prompt

Fill-in-the-blank quiz

Prompt Engineering for Optimal AI Responses

How to Use Delimiters to Structure Prompts

Mistakes in Generative AI, Hallucination

The Unit of Understanding Prompts in Generative AI (Token)

4 Key Tips for Writing Great Prompts

Multiple-choice quiz

Zero Shot Prompting (Asking without Examples)

Few Shot Prompting with Examples

A Journey of a Thousand Miles Begins with a Single Step - Chain of Thought Prompting

Enhancing Responses with Generated Knowledge Prompting

Get Smarter with Role Prompts

Fill-in-the-blank quiz

Prompting for Python Code Generation

Writing Prompts for Debugging Python Code

Characteristics of Good Code and How to Improve Python Code

Coding Quiz - Basic Arithmetic Calculator

Automatically Generate Multiple Slides Using a Certificate PPT Template

Loading a PPT Template

Creating Certificate Slides from Excel Data

Importing Sales Performance Excel Data into Python

Automating Sales Data to Word Document

Analyzing Sales Data to Derive Insights

Converting Project Progress Excel Data to PPTX Slides

Visualize Project Status with PowerPoint

Automatically Calculating Project Deadline D-DAY

Extracting Article Titles from BBC News

Saving Extracted Article Data to a CSV File

Real-Time Stock Data Collection from Yahoo Finance

Extracting S&P 500 Index Data in Real-Time

Saving Extracted Data as a CSV File with Selenium

Automating Data Research with Web Scraping

Saving Collected Data as a CSV File

Analyze Monthly Sales Data and Send Reports via Email

Analyzing Sales Reports with Python and Sending Emails

Sending Data Scraped from Wikipedia via Email

Sending Data Scraped from Wikipedia via Email

A Comprehensive Summary of Python for Business Automation

Conclusion