Negative NaN (-nan) in CSV input treated as object #5952
Labels
API Design
IO CSV
read_csv, to_csv
Numeric Operations
Arithmetic, Comparison, and Logical operations
Milestone
The value "-nan" (yes, this is a valid type of NaN!) in a CSV input file causes that column to be treated as 'object' instead of float64.
When the file is sufficiently large, the following error is generated:
If the string "-nan" is replaced with "nan" all is well. I don't really need to distinguish negative NaN from NaN but would like to be able to read my data files w/o having to pre-process them to scrub all the '-nan's.
The text was updated successfully, but these errors were encountered: