You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The parse method in the ExcelFile class does not pass the argument keep_default_na to the TextParser from pandas.io.parsers. There is no clean way to override the default na values when parsing excel files with the current code.
My specific problem involves "NA" as a typical value for "North America" in excel files.
The text was updated successfully, but these errors were encountered:
@jtratner This fixes the problem perfectly and other potential kwds missing from upstream functions. I'm extremely impressed with the quick commits. On another note, I noticed that because this doesn't specifically add the keyword argument, the feature is not as visible through ipython tab completion and introspection. However from my perspective, the main issue is closed. Maybe I'll tackle those niceties myself. Thanks.
@davidshinn Especially now that ipython offers tab completion on keyword arguments, I agree. The sole issue with doing this is that it adds a little overhead to making sure that the default arguments of TextParser and ExcelFile.parse match up later on.
davidshinn
added a commit
to davidshinn/pandas
that referenced
this issue
Jul 7, 2013
1bd8f57resolvespandas-dev#4131 without
updating docstrings in relevant functions. No way to know that keep_default_na
and verbose are valid keyword arguments without inspecting the parsers.py code
and documentation
The parse method in the ExcelFile class does not pass the argument keep_default_na to the TextParser from pandas.io.parsers. There is no clean way to override the default na values when parsing excel files with the current code.
My specific problem involves "NA" as a typical value for "North America" in excel files.
The text was updated successfully, but these errors were encountered: