I am using DataFrames to work with a CVS file. However, the file includes both numbers and characters.
Then DataFrames defined the columns that have only Number to be “Float64” type, and the columns that have both Numbers and Characters to be “String”.
The sample of the column as the attached figure.
I need to convert the column assigned as “String” to be “Float64”, but parse(Float64, “String”) does not work.
I have two questions:
How can I remove the row contain text “#VALUE!” in the column, and then convert the remain to Foat64?
Is it possible to replace the text “#VALUE!” by the “number” in the closest row? If it is possible, please teach me how to do?
Thanks you very much!