combogenomics / DuctApe

Analyze and link genomics and phenomics experiments
http://combogenomics.github.io/DuctApe
Other
9 stars 4 forks source link

dphenome biolog.py reading numbers as strings #9

Closed JPegorino closed 1 year ago

JPegorino commented 1 year ago

Hi all,

When running dphenome (dape version 0.18.2), I'm getting the error below - seems to be my input but I can't figure out why. The numeric columns (9+) of my biolog csv files contain only digit characters & decimal points ('.' characters), no quote marks. All delimiters are commas and the files do not have return carriages. See the example with specific formatting.

dExp[plate_id][org_id][replica].data[well_id].addSignal(float(lT[i]),
ValueError: could not convert string to float:

Any ideas how I can fix - I previously ran ductape using files with seemingly identifcal input formatting (to my human eyes) and did not have the problem. Same script/commads and same ductape installation. Not sure what I am missing.

Would really appreciate any advice on what might casue this?

Many thanks,

Jamie example_ductape_input.csv

JPegorino commented 1 year ago

An update that I was able to resolve this issue - I couldn't diagnose the underlying cause but it was indeed an issue with my input data.

If it helps future users: my input was originally converted from an excel spreadsheet and I was able to prevent the error by first copying the data into a brand new spreadsheet before doing any other re-formatting. I presume it was somehow related to the formatting of this original excel file.