Open daltare opened 3 months ago
Some files have extra data / blank rows:
Example 3K06046_NTA_533_EDD_Rev1.csv
(extra data - bottom of column D)Example 4K00000_NTA_533_EDD.csv
(extra data / blank lines - re-starts at row 2060)Example Well List_9 wells.csv
(extra data / blank lines - re-starts at row 3829)In the NTA files, there's a discrepancy between the example files and the PowerPoint list:
LabID
, but the PowerPoint list says Lab_Sample_ID
Lab_Sample_ID
, but the PowerPoint list says Sample_ID
PS_Code CA1010007_204_204
is in both well list files (but with different information).
Field Names
Make sure names are consistent across files where possible. In general, use underscores to replace any spaces, and use consistent capitalization. In particular, these field names could be fixed:
Sample ID
toSample_ID
(underscore)#"Lab_ELAP_CertID"
PS Code
toPS_Code
(underscore)Collection Date
Collection Time
Sample Type
Analyte Name
PS_code
toPS_Code
(lowercase to uppercase "C")PS_Code
ValuesMake sure they use consistent formatting. Assuming the well list file is correct (e.g.
CA3610009_007_007
), then:CA
Other Questions
Lab_Sample_ID
values across the two different files - is that expected?YYYY-MM-DD
format?Turbidity_Measure
be a numeric value?