Problems with converting to numeric

[EmBeck87]

This is from another project that I'm using for a base the numbers are very similar.

ID MIC1 MIC_FLOAT MIC_FOR_RANGES
1 = 0.0625 0.0625 0.0625
2 =0.5 0.5000 0.5000
3 =0.0625 0.0625 0.0625
4 =0.0625 0.0625 0.0625


MIC1= raw data values

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).