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

writing pandas dataframe fails if index also a column #334

Closed
simonm3 opened this Issue Dec 23, 2015 · 1 comment

Comments

Projects
None yet
2 participants
@simonm3

simonm3 commented Dec 23, 2015

if you do df=df.set_index(df.col1) then you have an index of col1 and a column col1 which is still a valid pandas dataframe.

Range("A1").value = df now fails with "cannot insert col1 already exists as it resets the index before writing. Would be better to output index then columns rather than failing.

@fzumstein fzumstein added the bug label Dec 23, 2015

@fzumstein fzumstein added this to the v0.6.4 milestone Dec 23, 2015

@fzumstein fzumstein closed this in 16ee9d8 Dec 23, 2015

@fzumstein

This comment has been minimized.

Member

fzumstein commented Dec 23, 2015

Fixed, until the next release just use Range('A1', index=False).value = df

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment