16
edits
Excel Data Quality Toolkit: Difference between revisions
→Missing Latitudes/Longitudes
| Line 120: | Line 120: | ||
'''Solution:''' | '''Solution:''' | ||
Missing latitude and longitude values can be identified using a filter when at least one of the two values is present in a dataset. | |||
To find missing latitude values: | |||
# Open your dataset in Excel and highlight Row 1. | |||
# From the Data toolbar, click "Filter". | |||
# Navigate to the column containing your latitude values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:decimallatitude decimalLatitude]) and select the arrow icon next to the column header indicating that this column can now be filtered on. | |||
# At the bottom of the pop-up window, deselect "Select All", scroll down, and then only check the "Blanks" box (you may need to scroll down in the pop-up window to locate it). | |||
# Navigate to the column containing your longitude values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:decimallongitude decimalLongitude]) and select the arrow icon next to the column header indicating that this column can now be filtered on. | |||
# At the bottom of the pop-up window, deselect the "Blanks" box (you may need to scroll down in the pop-up window to locate it). | |||
# The remaining visible rows contain records with missing latitude values. Proceed to correct these records as appropriate in your collections management system. | |||
To find missing longitude values: | |||
# Open your dataset in Excel and highlight Row 1. | |||
# From the Data toolbar, click "Filter". | |||
# Navigate to the column containing your longitude values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:decimallongitude decimalLongitude]) and select the arrow icon next to the column header indicating that this column can now be filtered on. | |||
# At the bottom of the pop-up window, deselect "Select All", scroll down, and then only check the "Blanks" box (you may need to scroll down in the pop-up window to locate it). | |||
# Navigate to the column containing your latitude values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:decimallatitude decimalLatitude]) and select the arrow icon next to the column header indicating that this column can now be filtered on. | |||
# At the bottom of the pop-up window, deselect the "Blanks" box (you may need to scroll down in the pop-up window to locate it). | |||
# The remaining visible rows contain records with missing longitude values. Proceed to correct these records as appropriate in your collections management system. | |||
=== Misspelled Geographic Unit Names === | === Misspelled Geographic Unit Names === | ||