Python自动化：从新手到解决枯燥任务

5星 · 超过95%的资源需积分: 9 49 浏览量更新于2024-07-19 1 收藏 16.16MB PDF 举报

"《自动化无聊琐事：Python编程实战指南》（Automate the Boring Stuff with Python）是一本由Al Sweigart撰写的实践性编程教材，专为初学者设计，旨在帮助读者掌握如何利用Python语言自动化日常生活中或工作中那些繁琐的任务。这本书在2017年10月24日出版，版权属于Al Sweigart，强调所有内容未经版权所有者和出版社事先书面许可，不得以任何形式复制或传输。作者通过本书深入浅出地讲解了如何使用Python来执行各种实用任务，包括但不限于文件操作、数据处理、网络爬虫、Web自动化等，让编程不再局限于理论，而是切实解决实际问题。书中提供了大量的实例和案例，使读者能够通过动手实践快速掌握编程技巧。本书的特点在于其实用性，强调将Python编程与日常生活场景相结合，适合对编程感兴趣但没有专业背景的读者学习。它不仅教会读者编写代码，还教授了如何利用Python简化重复性的任务，提升工作效率。此外，该书遵循严格的版权规定，确保合法发行和传播。本书的第二版可能包含了更新的内容和技术，如新的库和技术应用，以及对Python 3版本的支持，进一步增强了其作为现代编程入门教程的价值。无论是为了提升个人技能，还是为了寻求工作中的自动化解决方案，这本《自动化无聊琐事：Python编程实战》都是一个理想的选择。阅读这本书不仅能让你掌握基础的Python编程知识，还能让你学会如何将其应用于日常生活和工作中，从而真正实现编程服务于人，提升生活和工作的智能化水平。"

xvi Contents in Detail

Summary ...................................................... 261

Practice Questions

................................................ 261

Practice Projects.................................................. 262

Command Line Emailer

...................................... 262

Image Site Downloader ...................................... 263

2048................................................... 263

Link Verification

........................................... 263

WORKING WITH EXCEL SPREADSHEETS 265

Excel Documents ................................................. 266

Installing the openpyxl Module

....................................... 266

Reading Excel Documents ........................................... 266

Opening Excel Documents with OpenPyXL ......................... 267

Getting Sheets from the Workbook

.............................. 268

Getting Cells from the Sheets

.................................. 268

Converting Between Column Letters and Numbers.................... 270

Getting Rows and Columns from the Sheets

........................ 270

Workbooks, Sheets, Cells

.................................... 272

Project: Reading Data from a Spreadsheet

............................... 272

Step 1: Read the Spreadsheet Data.............................. 273

Step 2: Populate the Data Structure .............................. 274

Step 3: Write the Results to a File

............................... 275

Ideas for Similar Programs .................................... 276

Writing Excel Documents

........................................... 277

Creating and Saving Excel Documents............................ 277

Creating and Removing Sheets ................................. 278

Writing Values to Cells

...................................... 278

Project: Updating a Spreadsheet

...................................... 279

Step 1: Set Up a Data Structure with the Update Information

............ 280

Step 2: Check All Rows and Update Incorrect Prices

.................. 281

Ideas for Similar Programs .................................... 281

Setting the Font Style of Cells......................................... 282

Font Objects

.................................................... 282

Formulas ....................................................... 284

Adjusting Rows and Columns

........................................ 285

Setting Row Height and Column Width

........................... 285

Merging and Unmerging Cells

................................. 286

Freeze Panes

............................................. 287

Charts

........................................................ 288

Summary

...................................................... 290

Practice Questions

................................................ 291

Practice Projects.................................................. 291

Multiplication Table Maker.................................... 291

Blank Row Inserter.......................................... 292

Spreadsheet Cell Inverter ..................................... 292

Text Files to Spreadsheet

..................................... 293

Spreadsheet to Text Files ..................................... 293

Contents in Detail xvii

WORKING WITH PDF AND WORD DOCUMENTS 295

PDF Documents .................................................. 295

Extracting Text from PDFs ..................................... 296

Decrypting PDFs

........................................... 297

Creating PDFs............................................. 298

Project: Combining Select Pages from Many PDFs

.......................... 303

Step 1: Find All PDF Files ..................................... 304

Step 2: Open Each PDF ...................................... 304

Step 3: Add Each Page ...................................... 305

Step 4: Save the Results ...................................... 305

Ideas for Similar Programs .................................... 306

Word Documents ................................................. 306

Reading Word Documents .................................... 307

Getting the Full Text from a

.docx File ............................ 308

Styling Paragraph and Run Objects.............................. 309

Creating Word Documents with Nondefault Styles

................... 310

Run Attributes ............................................. 311

Writing Word Documents

.................................... 312

Adding Headings

.......................................... 314

Adding Line and Page Breaks.................................. 315

Adding Pictures............................................ 315

Summary

...................................................... 316

Practice Questions

................................................ 316

Practice Projects.................................................. 317

PDF Paranoia ............................................. 317

Custom Invitations as Word Documents

. . . . . . . . . . . . . . . . . . . . . . . . . . . 317

Brute-Force PDF Password Breaker............................... 318

WORKING WITH CSV FILES AND JSON DATA 319

The csv Module .................................................. 320

Reader Objects............................................ 321

Reading Data from Reader Objects in a for Loop

.................... 322

Writer Objects

............................................ 322

The delimiter and lineterminator Keyword Arguments.................. 323

Project: Removing the Header from CSV Files

............................. 324

Step 1: Loop Through Each CSV File ............................. 325

Step 2: Read in the CSV File

.................................. 325

Step 3: Write Out the CSV File Without the First Row

................. 326

Ideas for Similar Programs .................................... 327

JSON and APIs

.................................................. 327

The json Module

................................................. 328

Reading JSON with the loads() Function

.......................... 328

Writing JSON with the dumps() Function

.......................... 329

Project: Fetching Current Weather Data

................................. 329

Step 1: Get Location from the Command Line Argument................ 330

Step 2: Download the JSON Data............................... 330

Step 3: Load JSON Data and Print Weather........................ 331

Ideas for Similar Programs .................................... 332

Summary

...................................................... 333

xviii Contents in Detail

Practice Questions ................................................ 333

Practice Project

.................................................. 333

Excel-to-CSV Converter

...................................... 333

KEEPING TIME, SCHEDULING TASKS,

AND LAUNCHING PROGRAMS 335

The time Module ................................................. 336

The time

.time() Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 336

The time

.sleep() Function ..................................... 337

Rounding Numbers

............................................... 338

Project: Super Stopwatch

........................................... 338

Step 1: Set Up the Program to Track Times......................... 339

Step 2: Track and Print Lap Times ............................... 339

Ideas for Similar Programs .................................... 340

The datetime Module

.............................................. 341

The timedelta Data Type

..................................... 342

Pausing Until a Specific Date

.................................. 344

Converting datetime Objects into Strings

.......................... 344

Converting Strings into datetime Objects

.......................... 345

Review of Python’s Time Functions

..................................... 346

Multithreading ................................................... 347

Passing Arguments to the Thread’s Target Function

................... 348

Concurrency Issues

......................................... 349

Project: Multithreaded XKCD Downloader ................................ 350

Step 1: Modify the Program to Use a Function

...................... 350

Step 2: Create and Start Threads

............................... 351

Step 3: Wait for All Threads to End.............................. 352

Launching Other Programs from Python.................................. 352

Passing Command Line Arguments to Popen()....................... 354

Task Scheduler, launchd, and cron

.............................. 354

Opening Websites with Python................................. 355

Running Other Python Scripts

.................................. 355

Opening Files with Default Applications........................... 355

Project: Simple Countdown Program.................................... 357

Step 1: Count Down

........................................ 357

Step 2: Play the Sound File.................................... 357

Ideas for Similar Programs .................................... 358

Summary

...................................................... 358

Practice Questions

................................................ 359

Practice Projects.................................................. 359

Prettified Stopwatch......................................... 360

Scheduled Web Comic Downloader

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 360

SENDING

EMAIL AND TEXT MESSAGES 361

SMTP ......................................................... 362

Sending Email ................................................... 362

Connecting to an SMTP Server ................................. 363

Sending the SMTP “Hello” Message ............................. 364

Contents in Detail xix

Starting TLS Encryption

...................................... 364

Logging in to the SMTP Server

................................. 364

Sending an Email

.......................................... 365

Disconnecting from the SMTP Server

............................. 366

IMAP

......................................................... 366

Retrieving and Deleting Emails with IMAP ................................ 366

Connecting to an IMAP Server

................................. 367

Logging in to the IMAP Server

................................. 368

Searching for Email......................................... 368

Fetching an Email and Marking It As Read......................... 372

Getting Email Addresses from a Raw Message ...................... 373

Getting the Body from a Raw Message

........................... 374

Deleting Emails ............................................ 375

Disconnecting from the IMAP Server

............................. 375

Project: Sending Member Dues Reminder Emails

........................... 376

Step 1: Open the Excel File

................................... 376

Step 2: Find All Unpaid Members ............................... 378

Step 3: Send Customized Email Reminders......................... 378

Sending Text Messages with Twilio

.................................... 380

Signing Up for a Twilio Account ................................ 380

Sending Text Messages ...................................... 381

Project: “Just Text Me” Module........................................ 383

Summary

...................................................... 384

Practice Questions

................................................ 384

Practice Projects.................................................. 385

Random Chore Assignment Emailer.............................. 385

Umbrella Reminder

......................................... 385

Auto Unsubscriber.......................................... 385

Controlling Your Computer Through Email

......................... 386

MANIPULATING IMAGES 387

Computer Image Fundamentals ....................................... 388

Colors and RGBA Values ..................................... 388

Coordinates and Box Tuples................................... 389

Manipulating Images with Pillow

...................................... 390

Working with the Image Data Type .............................. 392

Cropping Images

.......................................... 393

Copying and Pasting Images onto Other Images..................... 394

Resizing an Image.......................................... 397

Rotating and Flipping Images .................................. 398

Changing Individual Pixels .................................... 400

Project: Adding a Logo ............................................. 401

Step 1: Open the Logo Image.................................. 401

Step 2: Loop Over All Files and Open Images

...................... 402

Step 3: Resize the Images

.................................... 403

Step 4: Add the Logo and Save the Changes ....................... 404

Ideas for Similar Programs .................................... 406

Drawing on Images

............................................... 406

Drawing Shapes ........................................... 406

Drawing Text ............................................. 408

xx Contents in Detail

Summary ...................................................... 410

Practice Questions

................................................ 410

Practice Projects.................................................. 411

Extending and Fixing the Chapter Project Programs................... 411

Identifying Photo Folders on the Hard Drive

........................ 411

Custom Seating Cards ....................................... 412

CONTROLLING THE KEYBOARD AND MOUSE

WITH GUI AUTOMATION 413

Installing the pyautogui Module ....................................... 414

Staying on Track

................................................. 414

Shutting Down Everything by Logging Out

......................... 414

Pauses and Fail-Safes

....................................... 415

Controlling Mouse Movement

........................................ 415

Moving the Mouse

......................................... 416

Getting the Mouse Position.................................... 417

Project: “Where Is the Mouse Right Now?” ............................... 417

Step 1: Import the Module

.................................... 418

Step 2: Set Up the Quit Code and Infinite Loop...................... 418

Step 3: Get and Print the Mouse Coordinates ....................... 418

Controlling Mouse Interaction

........................................ 419

Clicking the Mouse

......................................... 420

Dragging the Mouse

........................................ 420

Scrolling the Mouse......................................... 422

Working with the Screen............................................ 423

Getting a Screenshot ........................................ 423

Analyzing the Screenshot..................................... 424

Project: Extending the mouseNow Program ............................... 424

Image Recognition ................................................ 425

Controlling the Keyboard

........................................... 426

Sending a String from the Keyboard

............................. 426

Key Names

.............................................. 427

Pressing and Releasing the Keyboard

............................ 428

Hotkey Combinations

....................................... 429

Review of the PyAutoGUI Functions

.................................... 430

Project: Automatic Form Filler

........................................ 430

Step 1: Figure Out the Steps................................... 432

Step 2: Set Up Coordinates

................................... 432

Step 3: Start Typing Data..................................... 434

Step 4: Handle Select Lists and Radio Buttons....................... 435

Step 5: Submit the Form and Wait

.............................. 436

Summary

...................................................... 437

Practice Questions

................................................ 438

Practice Projects.................................................. 438

Looking Busy

............................................. 438

Instant Messenger Bot

....................................... 438

Game-Playing Bot Tutorial .................................... 439

剩余504页未读，继续阅读

shuafen_bdxl_1

粉丝: 3
资源: 59

Python自动化：从新手到解决枯燥任务

Python自动化编程实践指南

Python自动化项目解决方案：ATBS项目实践指南

Python编程：从入门到实践

Automate the boring stuff with python

automate the boring stuff with python

Automate the Boring Stuff with Python mobi

Automate the Boring Stuff with Python.zip

Automate the Boring Stuff with Python 2nd Ed_python_

Automate the Boring Stuff with Python 原版PDF by Sweigart

Automate the Boring Stuff with Python Practical Programming for Total Beginners

最新资源