Checks on Level 2 data before marking as “ready for submission” to ESS-DIVE

Created October 21, 2022 | Stephanie Pennington

Last ran: 2023-01-17

Checks/formatting we need to do:

  1. Arrange by Kit ID
  2. Check file name structure
  3. Check for duplicate Kit IDs
  4. Check where each flagged value falls

Are file names in the correct structure?

[Campaign]_[Sample Type]_[Analyte]_Level2.csv

x
ec1_sediment_ghg_L2.csv
ec1_sediment_gwc_L2.csv
ec1_sediment_loi_L2.csv
ec1_sediment_oxygendrawdown_L2.csv
ec1_soil_bd_L2.csv
ec1_soil_ghg_L2.csv
ec1_soil_gwc_L2.csv
ec1_soil_loi_L2.csv
ec1_soil_oxygendrawdown_L2.csv
ec1_soil_phcond_L2.csv
ec1_water_tss_L2.csv
ec1_water_waterquality_L2.csv

Are there duplicate kit IDs?

Are there nas in any column?

Have the files passed checks?