Automate Excel with Python: From manual grind to one-click workflow

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
• View the Copyright page
• View the detailed Table of Contents
• View the Index