Skip to content
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.

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

Reading an Excel cell range into Pandas DF does not format date columns correctly #35

Open
lvphj opened this issue Oct 26, 2019 · 0 comments
Assignees
Labels

Comments

@lvphj
Copy link
Owner

lvphj commented Oct 26, 2019

When using phjReadDataFromExcelNamedCellRange() function to read a named cell range from Excel into a Pandas dataframe, date-formatted columns are correctly identified and are displayed in the correct format in the dataframe but the dtype of the column is object rather than datetime. So, although the date appears in the correct format, it is, in fact, only stored in the dataframe as a string object.

@lvphj lvphj added the bug label Apr 28, 2021
@lvphj lvphj self-assigned this Apr 28, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant