Skip to content

Add option to disable empty string -> NA in file readers #1450

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
wesm opened this issue Jun 12, 2012 · 5 comments
Closed

Add option to disable empty string -> NA in file readers #1450

wesm opened this issue Jun 12, 2012 · 5 comments
Labels
Docs Enhancement IO Data IO issues that don't fit into a more specific label
Milestone
0.8.0

Comments

@wesm
Copy link
Member

wesm commented Jun 12, 2012

http://stackoverflow.com/questions/10867028/get-pandas-read-csv-to-read-empty-values-as-empty-string-instead-of-nan
@changhiskhan changhiskhan mentioned this issue Jun 24, 2012
Closed
@wesm
Copy link
Member Author

wesm commented Jun 25, 2012

We should document this somewhere?

wesm added a commit that referenced this issue Jun 25, 2012
@wesm
DOC: small doc for #1450
462c731
@wesm
Copy link
Member Author

wesm commented Jun 25, 2012

added a small note

@wesm wesm closed this as completed Jun 25, 2012
yarikoptic added a commit to neurodebian/pandas that referenced this issue Jun 30, 2012
@yarikoptic
Merge commit 'v0.8.0rc2-26-g76c6351' into debian-0.8
1f2b250 
* commit 'v0.8.0rc2-26-g76c6351': (42 commits)
  BUG/TST: typo caused read_csv to lose index name pandas-dev#1536
  BUG: incorrect tick label positions pandas-dev#1531 (zooming is still wrong)
  ENH: register converters with matplotlib for better datetime convesion
  ENH: handle datetime.date in Period constructor
  DOC: small doc for pandas-dev#1450
  BUG: repr of pre-1900 datetime64 values in a DataFrame column close pandas-dev#1518
  BUG: workaround vstack/concat bug in numpy 1.6 pandas-dev#1518
  DOC: lreshape docstring, release note
  ENH: experimental lreshape function
  BUG: plotting DataFrame with freq with offset
  BUG: DataFrame plotting with inferred freq
  BUG: timedelta.total_seconds only in 2.7 and 3.2
  DOC: release notes
  ENH: Add raise on conflict keyword to update
  DOC: release notes re: pandas-dev#921
  overload header keyword instead of extra col_aliases keyword
  ENH: column aliases for to_csv/to_excel pandas-dev#921
  ENH: handle weekly resampling via daily
  BUG: plot mixed frequencies pandas-dev#1517
  BUG/TST: plot irregular and reg freq on same subplot
  ...
@cauebs
Copy link

cauebs commented Jan 25, 2017 •
edited
Loading

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!

@jreback
Copy link
Contributor

jreback commented Jan 25, 2017

http://pandas-docs.github.io/pandas-docs-travis/io.html#na-values

@nealmcb
Copy link
Contributor

nealmcb commented May 7, 2017

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

@jorisvandenbossche jorisvandenbossche mentioned this issue Oct 9, 2017
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Docs Enhancement IO Data IO issues that don't fit into a more specific label
Projects
None yet
Milestone
0.8.0
Development

No branches or pull requests
4 participants
@nealmcb @wesm @jreback @cauebs