creating a small model of a health records system, complete with Patients, Doctors, Diseases, and Treatments.

For the first part of the project, I am supplying a spreadsheet of data, and it is your job to write a python program to load and store this data in a way that will be easy to retrieve and manipulate easily.

Click to download data (there are 4 sheets in the file, do not miss them)



Additionally, I want you to print the following data to show you have created/ entered it in properly:

  1. All patients, sorted backwards Alphabetically
  2. Primary care doctors (only)
  3. Each Patient’s primary care doctor
  4. The grand total cost of all the treatments listed

Numbers 3 and 4 might take a bit of research and thought to properly calculate and display. Also, please format the output so it it is clear and readable what is being printed (not just a long line of names/words).


We will be doing more with the data in part 2. We will also be adding diseases and treatments records for the patients themselves, so make sure to keep in mind how you will be doing that when you create this program.


As before, you will be submitting one *.py file, and a screenshot of your program output.

Extra help


find the cost of your paper

Critical analysis of Change4Life Campaign

Use Subheadings– but do not use more subheadings than listed below Introduction ● Signpost reader to the contents of your essay Campaign Overview ● Identify the campaign you are focusing….

position in the Apple Valley School district-describes the work of two learning theorists and how you might apply the work of each theorist to the position you are seekin

You are applying for a position in the Apple Valley School district and know that there are several other applicants vying for the position. The district prides itself on employing….

Novel CoronaVirus – COVID-19

-Who is more Susceptible to Corona virus focus on the elderly and how it affect the elderly. -Why the elderly are at the higher risk? – How and why it….