Pandsa to Excel conversion issue

[EK Esawi]

Hi All--


I am using Pandas to read an excel file which is very "dirty" and needs cleaning. I read the file via pandas and did not setup dtypes or converters hoping i can do so later.. When i run my code, most columns did come out as strings but i cannot convert them to float or integer using astype or pandas.to numeric method. Every time i tried, i get the same error listed below



Here is my code

import pandas as pd
import numpy as np

MyFile='C:/Users/Temp.xlsx'
df=pd.read_excel(io=MyFile, nrows=100)


The error message i get when i tried to convert a string like '22.3' via astype or pd.to_numeric is below


Unable to parse string "22." at position 0


Thanks in advance


EK