Excelfancy #2370
Excelfancy #2370
Conversation
Conflicts: pandas/src/parse_helper.h pandas/src/parser/tokenizer.c
|
Oh that's very nice. Would you might sprinkling in some test cases? |
|
+1 |
|
cool. sure I tried to add but ./test_fast.h not sure if related to the osx build issue which was solved over weekend |
|
try building the extensions in place : |
|
Shortcut for that is |
|
thanks works wil add some tests |
What is missing is to add to the Reader the functionality to read multindex columns (pivot dumps....). Maybe a feature for the future |
|
Great, thanks. I'll go ahead and merge this-- if you get a chance to write some docs, go for it in a new PR |
|
There are test failures in this on my machine. I'll hack it to work-- just checking you ran all ~2600 tests from test_fast.sh? (or |
|
was just running nosetests -s pandas.tests.test_frame apologies This one is due to the handling of the Excel Reader when dealing with index labels : The new dump does it like the HTML dumper and offset by 1 row if an index has a label. |
…ls not in the same row as columnnames
has_index_labels: boolean, default False
True if the cols defined in index_col have an index name and are
not in the header
|
|
Thanks a ton. You can get rid of that error by upgrading to the latest development version of statsmodels |
|
great thanks all green now |
|
If you get a chance to write some documentation (look in |
|
@wesm, Looks like |
|
So there seems to be a bug in openpyxl 1.5.8 where the cell styles don't get read in correctly but they do get written correctly still. |
|
Just wanted to say that although the original posters screenshot (though missing the right border of the last column header) looks alright, it shouldn't mean that everyone else be forced to use his style preference. I would request that the default output be changed back the way it has been, and an additional to_excel parameter be added for those who wish to use this style preference. I don't want my output formatted this way. |
adds to export dataframe for excel:
- multiindex (merge cells similar to htmlformatter)
- border
- bold header
- ability to add dataframe in same sheet (startrow, startcol)
http://cl.ly/image/2r102L0E1l23
solves Issue #2294