Extra Credit 2

Due: October 29, 2025
Points: 50

In the given examples, what you type is in red and the program prints what is in black. The symbol “↵” means a carriage return (return, enter).

Your program output should look like the output in the examples, except that what you type won’t be in red.

1. (50 points) Repeat problem 1 of the homework, but this time read from the Excel spreadsheet “medical_records.xlsx” and calculate the statistics using the pandas module.

   To receive credit, you must use the pandas module.

   To turn in: Please turn in the program in the file med2.py.

Matt Bishop Office: 2209 Watershed Sciences Phone: +1 (530) 752-8060 Email: mabishop@ucdavis.edu

MHI 289I, Programming in Health Informatics Version of October 19, 2025 at 10:45PM

You can also obtain a PDF version of this.