search

SCCWRP / CSCI

CSCI Calculation Package
http://sccwrp.github.io/CSCI/
GNU Lesser General Public License v3.0
6 stars 2 forks source link

Blank rows getting imported for an unknown reason #8

Open r7butler opened 4 years ago

r7butler commented 4 years ago

Some blank rows were getting imported for an unknown reason when running CSCI. The original context of the issue is an email from Nathan Mack

Hi Rafi Doug and Marco, I hope all are well. I have an error returning when running CSCI:

Error in BMIMetrics::BMI(object@bugdata) : The following FinalID/LifeStageCode combinations did not match with the internal database:

I checked that the final IDs along with their life stage codes match the SWAMP lookup lists - all had values. My next guess would be that there is a difference in acceptable life stage codes between SWAMP and the CSCI internal database. That seems unlikely though. Does anyone have an insights? I will try running each site individually to narrow down the culprits. Thanks,

Nathan Mack

Rafi responded to that email with a photo of the data and "Your bugs data has two blank rows getting imported for some reason. It reads this as FinalID == NA, which isn’t recognized."

Report_BenthicResult.xlsx

r7butler commented 4 years ago

@raphaelmazor I had a hard time finding the original email, and for some reason, I didn't include all the text from it here, which was the entire point of me putting this thing on github.........

Anyways, what we wanted to do here was ignore the blank rows? Can we talk a bit about this issue?