Python for Excel

Errata for Python for Excel

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date Submitted Date Corrected
Page Chapter 9
Chapter 9

Very small typo: # First, let's import the packages that we"ll use in this chapter *we'll

Note from the Author or Editor:
This is correct. Replace double-quote with single-quote.

Anonymous  May 05, 2021 
Safari Books Online
Chapter 1, Why Python for Excel, Python For Excel, Modern Language Features, 2nd to last sentence of 1st paragraph

The sentence 'As an example, error handling in VBA has come of age.' exhibits a sentiment that I think was unintended. From the surrounding context it sounds like the author intended to disparage VBA error handling, but 'come of age' means 'the attainment of prominence, respectability, recognition, or maturity' (Merriam Webster). It's a generally positive phrase, with the result being that the meaning of this sentence is something like 'We've been waiting for good error handling in VBA, and at last it's here!' which I don't think was the intention. I believe a phrase more like 'showing its age' carries the negative connotation intended, along with the meaning of old and past its prime. The revised sentence would be 'As an example, error handling in VBA is really showing its age.'

Note from the Author or Editor:
Thanks for pointing this out! I'll make sure to let the copy editor know so this will be fixed in the final version of the book.

Anonymous  Jan 18, 2021  Mar 04, 2021
Page 61
Second to last paragraph

The last sentence before `In [94]` it states "You can enumArate in a loop like this:"

Note from the Author or Editor:
Correct: should be "enumerate" instead of "enumarate".

IvenBach  May 27, 2021 
Page 62
2nd to last paragraph

***Even though you state on xii the book is intended for those that "have a basic understanding of programming" there will be those like my past self who use your book to grow beyond what they presently know. Language change: "You skip the remainder of a loop with the `continue` statement, which means that execution continues with a new loop and the next element:" feels off. Wording "skip the remainder of a loop" and "new loop" may lead some to understand when the condition is fulfilled execution no longer continues and a separate loop is started. Modified wording from the documentation ( "The continue statement ---, also borrowed from C,--- continues with the next iteration of the loop:" Also on pg63 Augmented Assignment - the inclusion of a note about creating an infinite loop if someone edits `n += 1` to `n -= 1` would prevent some users from creating one.

Note from the Author or Editor:
Agreed with respect to both remarks!

IvenBach  May 29, 2021 
Page 87
1st paragraph example code `In [3]`

Consider changing the variable name from `data` to `source`, or any other non-identical name, to have distinct names. Having the variable/argument name the same as the parameter name may look strange and possibly confuse some readers. With non identical names `pd.DataFrame(data=source, ...)` it is clearer that `source` is the argument for `data`. Since it is common to use the same names and you already defined keyword arguments on pg 66 is defined, you can refer the reader back back to this section. Sample explanation: "You may find instances when a variable is named the same as the parameter. When this occurs `data` on the right of the equals sign is the variable we just defined. It is argument that is assigned to the parameter on the left side of the equals sign." *A rose by any other name: Python calls them keyword arguments, VBA calls them [named argument](

Note from the Author or Editor:
Agreed that these suggestions will improve the content.

IvenBach  Jun 01, 2021 
Page 127-128
Beginning on In[6]

The second line of output for `` displays "RangeIndex: 8622 entries, 0 to 8621", while In [10] displays "DatetimeIndex: 8622 entries, 1986-03-13 to 2020-05-27". I initially only saw the difference in columns and missed the importance in the difference of indexes until it was mentioned on page 128 1st paragraph. Explicitly stating line 2 of the output for `` and calling attention to the start and end values of the index should help readers make this connection: "As ++the second line of output for `info` reveals, what was an index of 0 to 8621 is now 1986-03-13 to 2020-05-27++, you are now ..."

Note from the Author or Editor:
Agreed that this makes it clearer.

IvenBach  Jun 02, 2021