Removing duplicate data

Dealing with duplicates is important to ensure the accuracy and quality of your data. Removing duplicates ensures that the dataset is free from redundant information that could impact the integrity of your analysis.

Your boss warned of some duplicate data in this analysis due to how the survey results were compiled. There should only be one survey per patient. In this exercise, it will be up to you to assess for and remove any duplicate entries.

If you lost any progress, load the 2_3_removing_duplicate_data.xlsx workbook from the Exercises folder and open the Power Query editor.