We should document this somewhere?
added a small note
Why was this issue closed? This behavior hasn't changed yet.
Why not have it read empty cells as None instead?
My problem with NaN is that it returns True when cast to boolean.
Is there a good reason for this?
Btw, sorry to necrobump this over four years later
Edit: just realized that if you specify keep_default_na=False it reads empty cells as empty strings!
Thanks for the tip, @cauebs! The way that na_values and keep_default_na work is explained in more detail at:
More consistent na_values handling in read_csv 路 Issue #1657
Most helpful comment
Why was this issue closed? This behavior hasn't changed yet.
Why not have it read empty cells as
Noneinstead?My problem with
NaNis that it returnsTruewhen cast to boolean.Is there a good reason for this?
Btw, sorry to necrobump this over four years later
Edit: just realized that if you specify
keep_default_na=Falseit reads empty cells as empty strings!