search

USEPA / Phytoplankton-Data-Analysis

Phytoplankton Data Analysis
3 stars 0 forks source link

Algae taxa reported without sheet_id, cell_per_l, or BV.um3.L #35

Closed jbeaulie closed 10 years ago

jbeaulie commented 10 years ago

226 observations. See code below. I think all observations should have sheet_id and either cell_per_l or BV.um3.L

algae[with(algae, is.na(sheet_id) & is.na(cell_per_l) & is.na(BV.um3.L) & !is.na(taxa)), c("taxa", "sheet_id", "cell_per_l", "BV.um3.L")]

mjpdenver commented 10 years ago

I cannot replicate this issue. Can you verify you are using the May 9th file?

algae <- read.delim("processed_data/cleaned_algae_20140509.txt", as.is=TRUE, header = TRUE)

algae[with(algae, is.na(sheet_id) & is.na(cell_per_l) & is.na(BV.um3.L) & !is.na(taxa)),

  • c("taxa", "sheet_id", "cell_per_l", "BV.um3.L")] [1] taxa sheet_id cell_per_l BV.um3.L <0 rows> (or 0-length row.names)

subset(algae, is.na(sheet_id) ) [1] ID lake station depth_ft date taxa cell_per_l BV.um3.L class hab sheet_id
[12] qual_replicate

<0 rows> (or 0-length row.names) subset(algae, is.na(cell_per_l)) [1] ID lake station depth_ft date taxa cell_per_l BV.um3.L class hab sheet_id [12] qual_replicate <0 rows> (or 0-length row.names)
jbeaulie commented 10 years ago

Huh, sorry about that. I can't replicate the problem either.