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.

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

COMPAT: allow multi-indexes to be written to Excel (even they cannot be read back in) #10564

Closed
jreback opened this issue Jul 14, 2015 · 4 comments
Closed

COMPAT: allow multi-indexes to be written to Excel (even they cannot be read back in) #10564

jreback opened this issue Jul 14, 2015 · 4 comments
Labels
Compat pandas objects compatability with Numpy or Python functions IO Excel read_excel, to_excel MultiIndex
Milestone
0.17.0

Comments

@jreback
Copy link
Contributor

jreback commented Jul 14, 2015

xref #9794
@jreback jreback added IO Excel read_excel, to_excel MultiIndex Compat pandas objects compatability with Numpy or Python functions labels Jul 14, 2015
@jreback jreback added this to the 0.17.0 milestone Jul 14, 2015
@jreback
Copy link
Contributor Author

jreback commented Jul 14, 2015

cc @onesandzeroes

can you do a pull-request?

@jreback jreback mentioned this issue Jul 14, 2015
Closed
@flamingbear
Copy link
Contributor

I can see if I can. if @onesandzeroes doesn't beat me too it.

@flamingbear
Copy link
Contributor

jreback: "issue at #10564 though I think we need a argument to allow (so it can be turned on/off)"

@jreback Is the index argument not enough? What would you want it called?
We could warn, and add an argument not to warn. (particularly that the resulting xls file can't be read back by pandas)?

I'm also not seeing any tests around dataframes and to_excel.

@jreback
Copy link
Contributor Author

jreback commented Jul 14, 2015

https://github.com/pydata/pandas/blob/master/pandas/io/tests/test_excel.py#L1164

I think that a warning is appropriate here. I normally hate that but the reason for this is that this is a one-way serialization.

@flamingbear flamingbear mentioned this issue Jul 14, 2015
Merged
@ojdo ojdo mentioned this issue Aug 3, 2015
Closed
springcoil pushed a commit to springcoil/pandas that referenced this issue Aug 21, 2015
@springcoil
ENH: pickle support for Period pandas-dev#10439
7c41431 
update legacy_storage for pickles

update pickles/msgpack for 0.16.2

Added tests for ABC Types, Issue pandas-dev#10828

TST: pandas-dev#10822, skip tests on windows for odd error message in to_datetime with unicode

COMPAT:Allow multi-indexes to be written to excel.

(Even though they cannot be read back in.)

Closes pandas-dev#10564

DOC: typo

A few changes in docs
springcoil pushed a commit to springcoil/pandas that referenced this issue Aug 21, 2015
@springcoil
ENH: pickle support for Period pandas-dev#10439
822df81 
update legacy_storage for pickles

update pickles/msgpack for 0.16.2

Added tests for ABC Types, Issue pandas-dev#10828

TST: pandas-dev#10822, skip tests on windows for odd error message in to_datetime with unicode

COMPAT:Allow multi-indexes to be written to excel.

(Even though they cannot be read back in.)

Closes pandas-dev#10564

DOC: typo

ENH: pickle support for Period pandas-dev#10439

update legacy_storage for pickles

update pickles/msgpack for 0.16.2

Added tests for ABC Types, Issue pandas-dev#10828

TST: pandas-dev#10822, skip tests on windows for odd error message in to_datetime with unicode

COMPAT:Allow multi-indexes to be written to excel.

(Even though they cannot be read back in.)

Closes pandas-dev#10564

DOC: typo

A few changes in docs
springcoil pushed a commit to springcoil/pandas that referenced this issue Aug 22, 2015
@springcoil
ENH: pickle support for Period pandas-dev#10439
3072e48 
update legacy_storage for pickles

update pickles/msgpack for 0.16.2

Added tests for ABC Types, Issue pandas-dev#10828

TST: pandas-dev#10822, skip tests on windows for odd error message in to_datetime with unicode

COMPAT:Allow multi-indexes to be written to excel.

(Even though they cannot be read back in.)

Closes pandas-dev#10564

DOC: typo

A few changes in docs
springcoil pushed a commit to springcoil/pandas that referenced this issue Aug 22, 2015
@springcoil
ENH: pickle support for Period pandas-dev#10439
535fbd2 
update legacy_storage for pickles

update pickles/msgpack for 0.16.2

Added tests for ABC Types, Issue pandas-dev#10828

TST: pandas-dev#10822, skip tests on windows for odd error message in to_datetime with unicode

COMPAT:Allow multi-indexes to be written to excel.

(Even though they cannot be read back in.)

Closes pandas-dev#10564

DOC: typo

ENH: pickle support for Period pandas-dev#10439

update legacy_storage for pickles

update pickles/msgpack for 0.16.2

Added tests for ABC Types, Issue pandas-dev#10828

TST: pandas-dev#10822, skip tests on windows for odd error message in to_datetime with unicode

COMPAT:Allow multi-indexes to be written to excel.

(Even though they cannot be read back in.)

Closes pandas-dev#10564

DOC: typo

A few changes in docs
springcoil added a commit to springcoil/pandas that referenced this issue Aug 30, 2015
@springcoil
BUG: 10633 and 10800 fix
f2b1bbc 
BUG: 10633 - some last errors removed

ENH: pickle support for Period pandas-dev#10439

update legacy_storage for pickles

update pickles/msgpack for 0.16.2

Added tests for ABC Types, Issue pandas-dev#10828

TST: pandas-dev#10822, skip tests on windows for odd error message in to_datetime with unicode

COMPAT:Allow multi-indexes to be written to excel.

(Even though they cannot be read back in.)

Closes pandas-dev#10564

DOC: typo

A few changes in docs

TST: Changes in test

ENH: pickle support for Period pandas-dev#10439

update legacy_storage for pickles

update pickles/msgpack for 0.16.2

Added tests for ABC Types, Issue pandas-dev#10828

TST: pandas-dev#10822, skip tests on windows for odd error message in to_datetime with unicode

COMPAT:Allow multi-indexes to be written to excel.

(Even though they cannot be read back in.)

Closes pandas-dev#10564

DOC: typo

ENH: pickle support for Period pandas-dev#10439

update legacy_storage for pickles

update pickles/msgpack for 0.16.2

Added tests for ABC Types, Issue pandas-dev#10828

TST: pandas-dev#10822, skip tests on windows for odd error message in to_datetime with unicode

COMPAT:Allow multi-indexes to be written to excel.

(Even though they cannot be read back in.)

Closes pandas-dev#10564

DOC: typo

A few changes in docs

ERR: 10720

BUG: 10633 and 10800 fix

merging

ENH: pickle support for Period pandas-dev#10439

update legacy_storage for pickles

update pickles/msgpack for 0.16.2

Added tests for ABC Types, Issue pandas-dev#10828

TST: pandas-dev#10822, skip tests on windows for odd error message in to_datetime with unicode

COMPAT:Allow multi-indexes to be written to excel.

(Even though they cannot be read back in.)

Closes pandas-dev#10564

DOC: typo

A few changes in docs

TST: Changes in test

Fixing a slight messup

DOC:Updating consistent imports in the merging.rst file pandas-dev#9886

DOC: GH9886 Part V

DOC: GH9886 Part V - some merging issues
@chris-b1 chris-b1 mentioned this issue Sep 2, 2015
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Compat pandas objects compatability with Numpy or Python functions IO Excel read_excel, to_excel MultiIndex
Projects
None yet
Milestone
0.17.0
Development

No branches or pull requests
2 participants
@flamingbear @jreback