Open indeedhat opened 2 years ago
This problem is due to the ReadCSV function converting the "NA" string to "NaN" before we assign a data type to the column, it should be tagged as a bug.
I'm trying to make a patch for this issue.
Much appreciated, i look forward to this being merged :)
Issue
It doesn't seem to matter what the column type is in the data frame NA will always get converted to NaN.
Expected Behavior
NA would only be converted to NaN in
int
andfloat
columnsActual Behaviour
NA is converted to NaN regardless of the type
Example
Take this modified version of some data from the README
which produces the following output
In both colums:
Region
with an implicit string typeAge
where i have explicitly set the type to stringThe string value NA is converted