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

TypeError for tab.fetch_data(headers=True) #21

Open
tgig opened this issue Feb 13, 2020 · 0 comments
Open

TypeError for tab.fetch_data(headers=True) #21

tgig opened this issue Feb 13, 2020 · 0 comments

Comments

@tgig
Copy link

tgig commented Feb 13, 2020

Hi there,

Thanks for the great library. I'm having an issue pulling tab data for a column with a header which is formatted as Date. The data looks like this:

day col1 col2
9/5/1976 1.23 2.34
12/3/1978 3.45 4.56
1/16/2020 5.67 6.78

The entire day column is formatted as Date. When I use the following command, I get the following error:

df = tab.fetch_data(headers=True)

TypeError: Mismatch exists in expected and actual data types for cell with value 'day'. Cell format is 'DATE' but cell value type is '<class 'str'>'. To correct this, in Google Sheets set the appropriate cell format or set it to Automatic

If I change the cell A1 to be a string, the dataframe loads, but the dtype is Object.

I would expect the headers=True flag to ignore the format of the value in the first row. Am I missing something?

Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant