DOC: read_excel example for forward filling with index_col
Opened this issue · 0 comments
phofl commented
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html
read_excel forward fills missing values in the index column. This was done to allow round tripping (to_excel -> read_excel) with MultiIndexes. We added a note to the docstring explaining this, but an example in the user guide would be nice. See pandas-dev/pandas#44837 for further explanation