Automate Excel with Python : A Practical Guide for Nonprogrammers

個数：

予約

Automate Excel with Python : A Practical Guide for Nonprogrammers

Wengler, John

ウェブストア価格 ¥10,557（本体¥9,598）
No Starch Press,US（2026/05発売）
外貨定価 US$ 49.99
ポイント 95pt

現在予約受付中です。出版後の入荷・発送となります。
（重要：表示されている発売日は予定となり、発売が延期、中止、生産限定品で商品確保ができないなどの理由により、ご注文をお取消しさせていただく場合がございます。予めご了承ください。）

●3Dセキュア導入とクレジットカードによるお支払いについて

【入荷遅延について】
世界情勢の影響により、海外からお取り寄せとなる洋書・洋古書の入荷が、表示している標準的な納期よりも遅延する場合がございます。
おそれいりますが、あらかじめご了承くださいますようお願い申し上げます。

◆画像の表紙や帯等は実物とは異なる場合があります。

◆ウェブストアでの洋書販売価格は、弊社店舗等での販売価格とは異なります。
また、洋書販売価格は、ご注文確定時点での日本円価格となります。
ご注文確定後に、同じ洋書の販売価格が変動しても、それは反映されません。

製本 Paperback:紙装版/ペーパーバック版／ページ数 272 p.
言語 ENG
商品コード 9781718504646

Full Description

Automate the Excel Stuff with Python bridges the gap between Excel expertise and Python programming without forcing you to start from scratch. Unlike other programming guides, it's specifically designed for Excel users who need more power and automation, not for professional programmers. This book focuses on enhancing your existing Excel skills rather than replacing them. You'll learn how Python's dataframes work like virtual spreadsheets, extending what you already know while automating repetitive tasks. You'll be able to import and export data seamlessly between Excel and Python to integrate coding into your current workflow. Concise, practical examples throughout will get you up and running quickly. Each topic addresses real problems Excel users face, with solutions you can implement immediately. The structure is deliberately flexible. Chapters progress logically but stand independently, so you can jump to exactly what you need without reading everything that came before. This makes it perfect for solving urgent problems or learning at your own pace. You'll apply the techniques you learn to automate reports, clean messy data, perform complex calculations, and handle large datasets that would overwhelm Excel alone-all while leveraging your existing spreadsheet knowledge.

Introduction

Part I: From Spreadsheets to Dataframes
Chapter 1: Getting Started with Python
Chapter 2: Displaying Data and Understanding Data Types
Chapter 3: Creating and Manipulating Dataframes and Lists
Chapter 4: Adding, Modifying, and Calculating Column Data
Chapter 5: Accessing and Transforming Individual Cell Values
Chapter 6: Filtering and Displaying Dataframes

Part II: Tools to Replicate Excel Functionality
Chapter 7: Counting and Summing Values
Chapter 8: Combining Dataframes
Chapter 9: Formatting and Calculating Dates and Times

Part III: Workflow Techniques
Chapter 10: Reading Excel Files into Dataframes
Chapter 11: Saving Dataframes to Excel
Chapter 12: There and Back Again: An Excel-Python-Excel Workflow

Appendix A: Working with Folders, Files, and Pathnames
Appendix B: Cleaning Up a Messy Spreadsheet
Appendix C: The Ducks Module
Python Quick Reference
Index