Errata

Foundations for Analytics with Python

Errata for Foundations for Analytics with Python

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.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
PDF Page 27
code snippet

In the last line of the "List slices" code snippet (Output #76), there are two closing parentheses missing.

 Mark Beveridge  Feb 13, 2020 
PDF Page 33
code snippet

In the last line of the "List slices" code snippet (Output #107), there are two closing parentheses missing.

 Mark Beveridge  Feb 15, 2020 
PDF Page 33
code snippet

In the last line of the "Access a value in a dictionary" code snippet (Output #107), there are two closing parentheses missing.

 Mark Beveridge  Feb 15, 2020 
PDF Page 41
4th paragraph getMean print statement

Omitted 4th closing right parentheses in print statement

 Anonymous  Oct 11, 2018 
Printed Page 42
paragraph 4

print np.mean(my_list) does not work because '()' was missing for what should be printed. for python3, it should be:
print (np.mean(my_list))

 Xuzhen Chen  Apr 29, 2019 
Printed, PDF, ePub Page 69
1st paragraph

"With these two changes, the input file should look as shown in Figure 2-7."

The instructions fails to mention:

"Using applications like Excel or Numbers to modify the csv file, then export as csv, the cells containing commas would become enclosed by double-quotes."

This may cause confusion for beginners. I was stuck thinking if I have done something wrong for days.

 mediter  Aug 20, 2017 
Printed Page 110 111
lines 13, 20, 25 of 3excel_parsing_and write_keep_dates.py

lines 13, 20 and 25 of the code, in which row_list_output is created and values are appended to the list do not seem to be used in the final output. date_cell and non_date_cell are directly written to the output_worksheet.

 Paul Johan de Voogd  Jan 28, 2020 
Printed Page 169
Figure 4-13

[From Printed format]

The cost values in the last record of the two output blocks are mismatched.

In the 1st block (from the CSV file), '1006015.00' is displayed.
In the 2nd block (query from MySQL), '1006020.0' is displayed.

This may be due that the data type of the Cost field in MySQL is FLOAT.

I have modified the data type to DECIMAL(10, 2) and the change can solve the issue.

 Yuk Chow  Oct 15, 2017