Skip to content

Add 'null' in lower case to na_values defaults in pandas.read_csv #16471

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
OlegShteynbuk opened this issue May 24, 2017 · 1 comment · Fixed by #16534
Closed

Add 'null' in lower case to na_values defaults in pandas.read_csv #16471

OlegShteynbuk opened this issue May 24, 2017 · 1 comment · Fixed by #16534
Labels
IO CSV read_csv, to_csv Missing-data np.nan, pd.NaT, pd.NA, dropna, isnull, interpolate
Milestone
0.21.0

Comments

@OlegShteynbuk
Copy link
Contributor

Docs to read_csv says that by default 'NULL' in upper case is interpreted as NaN but not in lower case.
It became an issue with the latest yahoo change that affected pandas-datareader, see
Exception downloading yahoo historical data with adjust_price=True on fix-yahoo branch
pydata/pandas-datareader#342
@OlegShteynbuk OlegShteynbuk mentioned this issue May 24, 2017
Closed
@TomAugspurger TomAugspurger added IO CSV read_csv, to_csv Missing-data np.nan, pd.NaT, pd.NA, dropna, isnull, interpolate labels May 24, 2017
@TomAugspurger TomAugspurger added this to the Next Major Release milestone May 24, 2017
@OlegShteynbuk OlegShteynbuk mentioned this issue May 29, 2017
Merged
@OlegShteynbuk
Copy link
Contributor Author

OlegShteynbuk commented May 29, 2017 •
edited
Loading

fixed, made a pull request
#16534

@jreback jreback modified the milestones: 0.21.0, Next Major Release May 30, 2017
@OlegShteynbuk OlegShteynbuk mentioned this issue Jun 5, 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
IO CSV read_csv, to_csv Missing-data np.nan, pd.NaT, pd.NA, dropna, isnull, interpolate
Projects
None yet
Milestone
0.21.0
Development

Successfully merging a pull request may close this issue.

make null lowercase a missing value OlegShteynbuk/pandas
3 participants
@jreback @TomAugspurger @OlegShteynbuk