5. Processing Multiple Workbooks¶
The previous sections in this chapter demonstrated how to filter for specific rows and columns in a single worksheet, all worksheets in a workbook, and a set of worksheets in a workbook. These techniques for processing a workbook are extremely useful; however, sometimes you need to process many workbooks. In these situations, Python is exciting because it enables you toautomate and scale your data processing above and beyond what you could handle manually.
This section reintroduces Python’s built-in glob module, and builds on some of the examples shown earlier in this chapter to demonstrate how to process multiple workbooks.
In order to work with multiple workbooks, we need to create multiple workbooks. Let’s create two more Excel workbooks to work with, for a total of three workbooks. However, remember that the techniques shown here can scale to as many files as your computer can handle.