search

USEPA / Phytoplankton-Data-Analysis

Phytoplankton Data Analysis
3 stars 0 forks source link

taxa = NA #38

Closed jbeaulie closed 10 years ago

jbeaulie commented 10 years ago

All observations should have data in the taxa field.

algae[is.na(algae$taxa), c("taxa", "ID", "sheet_id", "cell_per_l", "BV.um3.L")]

Returns 28 observations. I reviewed a few of the original records and the problem was obvious. Should be easy to remedy.

mjpdenver commented 10 years ago

So it appears there are a couple issues here. On spreadsheets such as Phytoplankton 201205 EFR.xlsx, the missing taxa is because the entries are totals. It is clear that these should be deleted.

For missing taxa on sheet 92rawdat.xls the taxa is deliberatedly left blank and the taxa code is listed as 999.

Unless other information exists and given the small number of records, I will censor these records.

jbeaulie commented 10 years ago

Will and Jake confirmed this approach.