Problems with converting to numeric

[EmBeck87]

I will send you the actual file. That was just a mockup. I do need the coding mentioned accomplished, not just the values generated, but the objectives accomplished: MIC_FLOAT with floating format for the MIC1, and MIC_FOR_RANGES created for range comparison.
I will add the full code also.

MIC_FLOAT= floating format for the MIC1 (see code pasted in first post)

MIC_SIGN = a variable for getting rid of the '=' from MIC1 that is dropped from the dataframe.

MIC_FOR_RANGES= a variable created for the range comparison (see code past in first post).