Quite possibly one of the most beloved topics in this forum …
I have searched the forum and cannot find simple answers, or the answers are (literally) years old.
My csv file has strings and floats which might be missing but i want to substitute “” and 0.0. Is it possible to get CSV to do that automagically ?
I have not found a way reading through the CSV documentation.
Assuming that the automagic conversion can’t be done, then, if you are reading into a DataFrame, you can use dropmissing to get rid of rows where the offending column has a missing value. That is actually good enough most of the time, but now i have an instance where that’s not good enough.
So it looks like the best way to handle the situation is to use replace on the dataframe replacing values of missing with the desired value ? is that right ?