Question: You get an Excel spreadsheet that has two worksheets, patient info and records Each worksheet has data and visualizations and formulas Each row in each

You get an Excel spreadsheet that has two worksheets, "patient info" and "records" Each worksheet has data and visualizations and formulas Each row in each worksheet represents information associated with a single person.. Worksheet "patient info" has a "patient id" column; Worksheet "records" has a "p_id" column The "patient id" values in "patient info" tab are the same variable as "p_id" in "records". Some people have information on both sheets, while other people have information only on one sheet. Use openpyxl to copy information about patients from "records" to "patient info". Submit a notebook that reads the Excel spreadsheet and produces a separate Excel file with the following modifications: For each patient identified by "p_id" listed in the "records" sheet that don't exist in "patient info," create a new row in "patient info". The row from "records" should be copied to the row in "patient info." For each patient listed in the "records" sheet where "p_id" appears "patient info" under "patient id," copy the data in the row from records to "patient info" sheet Make no changes to the visualizations that exist in each worksheet Make no changes to the data in the "records" sheet Write your changes to a new .xlsx file (don't overwrite the original) Observations: "patient info" worksheet will have new columns (because those new columns exist in the "records" worksheet) "patient info" worksheet will have new rows (one new row per patient) There will be empty cells in "patient info" worksheet Use a programmatic (rather than manual) approach to identify which patients appear in both worksheets Some cells in both worksheets contain formulas. Copy only values from "records" to "patient info"

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!