Chapter 1: Business System Automation

Warming Up 01 Installing Python and Setting Up a Basic Environment
Warming Up 02 Learning Essential Python Grammar
Project 01: Creating a Quiz Generator
Project 02: Pretend to work from home with automatic mouse movements
Project 03 Automatically Generating QR Codes
Project 04 Extracting Internet Wi-Fi Passwords
Automatically translate Project 05 documents
Project 06 Creating a File Search Program
Project 07 Creating fake data
Project 08 Automatically Classifying Scanned Files
Project 09: Creating a Stopwatch Program
Project 10: Creating a Number Guessing Game
Automatically back up important data in Project 11

Chapter 2 Application Automation

Project 12: Bulk Download YouTube Videos
Download all Project 13 YouTube Shorts videos
Automatically compress and decompress Project 14 7zip files
Project 15 Converting Word Documents to PDF Files
Project 16: Automatically writing in Notepad++
Resizing Project 17 Images
Inserting a Watermark into Project 18 Images
Project 19 Extracting Text from Images (OCR Function)
Separating Project 20 Excel Workbook Sheets into Files
Converting Project 21 Excel Workbook Sheets to PDF Files
Project 22 Splitting a PDF file into individual PDF files
Merge Project 23 PDF files into one
Project 24: Merging Multiple Excel Workbooks into One
Decrypting a Project 25 Excel Workbook Password
Project 26 Merging Multiple CSV Files into One
Analyzing Data from Project 27's Integrated CSV File
Visualizing Project 28 CSV File Data
Project 29 Converting Text to Speech
Project 30: Create Your Own Voice Recognition Assistant, Jarvis

Chapter 3 Internet Automation

Project 31: Extracting Naver News Headlines and Organizing Them in Excel
Project 32: Extracting Naver Weather Information
Project 33: Extracting All Naver Stock Information
Project 34: Extract best-selling book information and save it to Excel.
Project 35: Extracting Recruitment Information from Employment Companies
Project 36: Extracting Job Opening Information from Job Seeking Companies
Extracting Project 37 Hot Deal Product Information
Project 38 Extracting exchange rate information and saving it as an Excel file
Project 39: Extracting Real-Time Search Term Information
Extracting the title and address information of Project 40 popular products
Extracting Rating Information for Project 41 Companies
Project 42: Extracting Company Rating Information Using Input Keywords
Project 43: Get the Top 200 E-Commerce Products
Project 44: Get the Top 500 E-Commerce Products
Extracting Project 45 eCommerce Ranking Products into an Excel File
Project 46: Crawling and saving desired images
Project 47: Crawling and Saving High-Quality Images
Project 48: Automatically sending Naver emails
Project 49: Handling Gmail Automatic Sending
Project 50: Extracting information from the national marketplace and sending automatic emails

supplement

[1] Using ChatGPT
[2] Using Microsoft Copilot
[3] Using Gemini

In modern society, repetitive tasks are an unavoidable reality.
Organizing Excel data, managing files, gathering web information, and automatically sending emails are all tasks that take up our precious time.
We aim to automate routine tasks using Python to increase work efficiency and help you focus on more creative work.
All 50 projects in this book are practical examples that can be directly applied in real-world situations.
It is explained step-by-step so that even beginners can easily follow, and each project can be executed independently, so you can selectively learn only the parts you need.
We sincerely hope that this book will help readers increase their work efficiency and become a valuable companion on their journey to discover the joy of programming.

A word from the author

The most significant feature of this book is that it provides all the practical code in complete form.
Even coding beginners can copy and run it without worry, and detailed comments for each line of code help them understand the functions.
Under the motto “Practice over theory,” you can learn programming through actually working code.
Of particular note is the synergy effect that can be achieved when combined with artificial intelligence tools such as ChatGPT.
By leveraging the Python automation techniques learned in this book with AI tools, you can shorten code writing time and quickly find solutions to complex problems. AI will significantly shorten your learning curve by assisting with initial code writing, error correction, and code optimization suggestions.
The combination of Python automation and AI will not simply result in 1+1=2, but will lead to exponential improvements in work efficiency.
If coding feels unfamiliar to you, don't worry.
Python is one of the easiest programming languages ​​to learn, thanks to its intuitive syntax and rich libraries.
I hope that through this book, you will discover the joy of programming and experience how to increase the efficiency of your daily work.