Issue on converting the data frame into floats

[Stefhu67]

Hello,
It seems that there is still an issue in the line 14 of the class: DIC_measurements:

• df.astype('float64'): seems to take into account the indexes also and I don't really understand why when looking at the documentation.

Thanks

[ilyasst]

pydictoolkit/pydictoolkit/dic/measurements.py

Line 13 in 27b8364

dfs.dataframe[index] = df.astype('float64')

I don't think the issue is with line 13 and 14. The problem from your screenshot is that the first line of the dataset (the header with the name of columns, "X", "Y", etc...) is also considered within the dataset and it cannot be converted to a float because it's a string. The problem I believe is in function "preprocess_csv" right here:

pydictoolkit/pydictoolkit/dic/data.py

Line 30 in 27b8364

def preprocess_csv(self):

It seems like the header is not properly cleaned and still contains spaces and ' and " characters that need to be removed.
You should have a csv file that ends with _clean.csv in your folder, can you check what the header looks like for that file?