Skip to content

Re: DataFrame.to_csv(quoting=csv.QUOTE_NONNUMERIC) quotes numeric values #14195

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
k-dahl opened this issue Sep 9, 2016 · 0 comments · Fixed by #14228
Closed

Re: DataFrame.to_csv(quoting=csv.QUOTE_NONNUMERIC) quotes numeric values #14195

k-dahl opened this issue Sep 9, 2016 · 0 comments · Fixed by #14228
Labels
Docs IO CSV read_csv, to_csv Output-Formatting __repr__ of pandas objects, to_string
Milestone
0.19.1

Comments

@k-dahl
Copy link

k-dahl commented Sep 9, 2016

As per the issue outlined in #12922, applying a float_format or having a NaN value with a float would continue to treat the value as non-numeric when quoting=csv.QUOTE_NONNUMERIC is used. The format string resulting in the float treated like a string should be documented as per @jreback in #12922.
@jreback jreback added Docs Output-Formatting __repr__ of pandas objects, to_string IO CSV read_csv, to_csv labels Sep 9, 2016
@jreback jreback added this to the Next Major Release milestone Sep 9, 2016
@tom-bird tom-bird mentioned this issue Sep 15, 2016
Merged
2 tasks
@jreback jreback modified the milestones: 0.19.1, Next Major Release Oct 6, 2016
jorisvandenbossche pushed a commit that referenced this issue Oct 6, 2016
@tom-bird @jorisvandenbossche
DOC: to_csv warns regarding quoting behaviour for floats #14195 (#14228)
ee374ee 
Added a small warning that if `float_format` is set then floats will be quoted even if csv.QUOTE_NONNUMERIC is set
yarikoptic added a commit to neurodebian/pandas that referenced this issue Oct 13, 2016
@yarikoptic
Merge commit 'v0.19.0-14-ga40e185' into debian
7481c30 
* commit 'v0.19.0-14-ga40e185': (37 commits)
  BUG: Bug in localizing an ambiguous timezone when a boolean is passed
  Convert readthedocs links for their .org -> .io migration for hosted projects (pandas-dev#14406)
  DOC: formatting in basics.rst
  BLD/CI: cython cache pxd files (pandas-dev#14363)
  BUG: set_levels set illegal levels. (pandas-dev#14236)
  DOC: add whitespace to v0.19.1 bug fix section
  change impl details slightly for pandas-dev#14292
  BUG: Fix concat key name
  DOC: add 0.19.1 whatsnew file (pandas-dev#14366)
  DOC: to_csv warns regarding quoting behaviour for floats pandas-dev#14195 (pandas-dev#14228)
  DOC: fix formatting issue with msgpack table
  TST: pandas-dev#14345 fixes TestDatetimeIndexOps test_nat AssertionErrors on 32-bit
  docs: Remove old warning from dsintro.rst (pandas-dev#14365)
  DOC: minor v0.19.0 whatsnew corrections
  RLS: v0.19.0
  DOC: update release notes
  DOC: Latest fixes for whatsnew file
  to_latex encoding follows the documentation (py2 ascii, py3 utf8) (pandas-dev#14329)
  DOC: fix some sphinx build issues (pandas-dev#14332)
  TST: fix period tests for numpy 1.9.3 (GH14183) (pandas-dev#14331)
  ...
tworec pushed a commit to RTBHOUSE/pandas that referenced this issue Oct 21, 2016
@tom-bird
DOC: to_csv warns regarding quoting behaviour for floats pandas-dev#1…
aa70a66 
…4195 (pandas-dev#14228)

Added a small warning that if `float_format` is set then floats will be quoted even if csv.QUOTE_NONNUMERIC is set
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Docs IO CSV read_csv, to_csv Output-Formatting __repr__ of pandas objects, to_string
Projects
None yet
Milestone
0.19.1
Development

Successfully merging a pull request may close this issue.

DOC: #14195. to_csv warns regarding quoting behaviour for floats
2 participants
@jreback @k-dahl