Skip to content

"NA" value from Excel read by Pandas as nan #11839

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
fitsoft opened this issue Dec 14, 2015 · 1 comment
Closed

"NA" value from Excel read by Pandas as nan #11839

fitsoft opened this issue Dec 14, 2015 · 1 comment
Labels
IO Excel read_excel, to_excel Missing-data np.nan, pd.NaT, pd.NA, dropna, isnull, interpolate Usage Question

Comments

@fitsoft
Copy link

fitsoft commented Dec 14, 2015

When doing a:
df = pd.read_excel('cb2.xlsx') in the column 'Zone', in which there are strings like "APAC", "EUR", "NA"
Surprisingly, the value "NA" is interpreted by pandas as nan

cb2.xlsx
@jreback
Copy link
Contributor

jreback commented Dec 14, 2015

see the docs here and in the doc-string. NA is by default treated as missing.

@jreback jreback closed this as completed Dec 14, 2015
@jreback jreback added Missing-data np.nan, pd.NaT, pd.NA, dropna, isnull, interpolate Usage Question IO Excel read_excel, to_excel labels Dec 14, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
IO Excel read_excel, to_excel Missing-data np.nan, pd.NaT, pd.NA, dropna, isnull, interpolate Usage Question
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jreback @fitsoft