Exercise 3

Data management

Taking the role of one of the volunteers with advanced computer skills, imagine you have been assigned the responsibility for data quality issues. Your main task is to reduce the amount of data that is currently discarded (around a 15%) before processing due to errors and inconsistencies. You have received a dataset as the raw product of the digitization effort.

  1. Download UC2-LS-3-ForCleaning.xlsx. (44 KB)

  2. Evaluate the dataset and identify which types of errors are present.

  3. Identify possible ways to correct those issues, and perform those corrections for as many of the errors present as you can.

  4. Use the exercise sheet to provide your answers and submit the spreadsheet.

← Exercise 2 | ↑ Use Case II - Lepidoptera sightings | ⌂ Home | Exercise 4 →