Good day!
read_excelheader and index_col handling rules I see:
in all cases of header:
cells (header, outside of index_col) are used as df.columns.
if header is a integer/one-item list:
df.columns.name is untouched,cells (greater than max(header), index_col) are used for df.index,
cells (header, index_col) are used for df.index.name.
else (i.e., header is a (2-up-items) list):
according to BUG: read_excel issue - 3 (header is a list, index_col is not range(N)) #34765 index_col should be None or 0 or range(0, max_index_col+1, 1).
if row max(header)+1 is empty except columns index_col:
cells (greater than max(header)+1, index_col) are used for df.index,
cells (max(header)+1, index_col) are used for df.index.names,
else:
cells (greater than max(header), index_col) are used for df.index,
df.index.names is not set .cells (header, max(index_col)) are used for df.columns.names.
non-max columns of index_col aren't used for df.index/df.columns.
Other observations:
rows above min(header) are omitted.
header is 0-based or skiprows-1-based?
So,
Isn't it too complicated, is it?
Is each this rule is documented?
Is each this rule is tested?
demo_suite.zip
Any thoughts? Thanks!
/cc @TomAugspurger @jreback
Good day!
read_excel'sheaderandindex_colhandling rules I see:header:(header, outside of index_col)are used asdf.columns.headeris a integer/one-item list:df.columns.nameis untouched,(greater than max(header), index_col)are used fordf.index,(header, index_col)are used fordf.index.name.headeris a (2-up-items) list):headeris a list,index_colis notrange(N)) #34765,index_colshould beNoneor0orrange(0, max_index_col+1, 1).max(header)+1is empty except columnsindex_col:(greater than max(header)+1, index_col)are used fordf.index,(max(header)+1, index_col)are used fordf.index.names,(greater than max(header), index_col)are used fordf.index,df.index.namesis not set.(header, max(index_col))are used fordf.columns.names.maxcolumns ofindex_colaren't used fordf.index/df.columns.Other observations:
min(header)are omitted.headeris 0-based orskiprows-1-based?So,
demo_suite.zip
Any thoughts? Thanks!
/cc @TomAugspurger @jreback