Problems with converting to numeric

[deanhystad]

This doesn't make sense. There appears to be 8 column headers, but 9 columns in the data

SUBJID SAMPLEID BENCH WHO MIC1 BMD1 POS_CTRL1 NEG_CTRL3
MC_RUN_001 7308 Clinical Lefamulin LMU 0.25 . POS NEG
MC_RUN_006 20490 Challenge Lefamulin LMU 0.125 . POS NEG
MC_RUN_006 20581 Challenge Lefamulin LMU <=0.015625 . POS NEG

This gives a mapping of values to columns that is this:

SUBJID = MC_RUN_001
SAMPLEID = 7308
BENCH = Clinical
WHO = Lefamulin
MIC1 = LMU
MBD1 = 0.25
POS_CTRL_1 = .    <-- What is this period doing here?
NEG_CTRL_3 = POS
??? = NEG  <-- No columns left

And then you have this:

MC_RUN_006 20581 Challenge Lefamulin LMU <=0.015625 . POS NEG

What is "<=0.015625"? I know it is an inequality, but I don't think there is a type for that. How should it appear in the dataframe?

You need to describe the information you have coming in, and what you want it to look like after it is processed. Do not post any more code. Describe what is supposed to happen.