DataFrame.unstack() with list of levels ignores fill_value #30740
Description
Code Sample, a copy-pastable example if possible
>>> import pandas as pd >>> df = ( ... pd.DataFrame( ... { ... "name": ["Alice", "Bob"], ... "score": [9.5, 8], ... "employed": [False, True], ... "kids": [0, 0], ... "gender": ["female", "male"], ... } ... ) ... .set_index(["name", "employed", "kids", "gender"]) ... .unstack(["gender"], fill_value=0) ... ) >>> df.unstack(["employed", "kids"], fill_value=0) score gender female male employed False True False True kids 0 0 0 0 name Alice 9.5 NaN 0.0 NaN Bob NaN 0.0 NaN 8.0Problem description
when unstacking with a list of levels on a DataFrame that already has a columns MultiIndex, fill_value is ignored.
Expected Output
>>> df.unstack("employed", fill_value=0).unstack("kids", fill_value=0) score gender female male employed False True False True kids 0 0 0 0 name Alice 9.5 0.0 0.0 0.0 Bob 0.0 0.0 0.0 8.0 >>>Output of pd.show_versions()
INSTALLED VERSIONS
commit : 4206fd4
python : 3.7.5.final.0
python-bits : 64
OS : Windows
OS-release : 10
machine : AMD64
processor : Intel64 Family 6 Model 58 Stepping 9, GenuineIntel
byteorder : little
LC_ALL : None
LANG : en_GB.UTF-8
LOCALE : None.None
pandas : 0.26.0.dev0+1622.g4206fd42c
numpy : 1.17.2
pytz : 2019.3
dateutil : 2.8.0
pip : 19.3.1
setuptools : 41.6.0.post20191030
Cython : 0.29.13
pytest : 5.2.2
hypothesis : 4.36.2
sphinx : 2.2.1
blosc : None
feather : None
xlsxwriter : 1.2.2
lxml.etree : 4.4.1
html5lib : 1.0.1
pymysql : None
psycopg2 : None
jinja2 : 2.10.3
IPython : 7.9.0
pandas_datareader: None
bs4 : 4.7.1
bottleneck : 1.2.1
fastparquet : 0.3.2
gcsfs : None
lxml.etree : 4.4.1
matplotlib : 3.1.1
numexpr : 2.7.0
odfpy : None
openpyxl : 3.0.0
pandas_gbq : None
pyarrow : 0.15.1
pytables : None
pytest : 5.2.2
s3fs : 0.3.4
scipy : 1.3.1
sqlalchemy : 1.3.10
tables : 3.5.1
tabulate : None
xarray : 0.13.0
xlrd : 1.2.0
xlwt : 1.3.0
xlsxwriter : 1.2.2
numba : 0.46.0