Pandas version checks
Reproducible Example
import pandas as pd
df = pd.DataFrame({"A": [1., 2.], "B": [3., 4.]})
styler1 = df.style.format(precision=2)
styler2 = df.agg(["sum"]).style
styler3 = df.agg(["prod"]).style
print(styler1.concat(styler2).concat(styler3).to_string())Issue Description
The new style.concat option can be used to add styled dataframes to each other.
A user might want to add several dataframes in this manner.
The natural way to do it is styler1.concat(styler2).concat(styler3). However in this case, styler2 is silently discarded.
A workaround that give the expected output is to use styler1.concat(styler2.concat(styler3)). I think that this method is not obvious, and can get ugly when the code is longer.
>>> print(styler1.concat(styler2.concat(styler3)).to_string()) # gets expected output
A B
0 1.00 3.00
1 2.00 4.00
sum 3.000000 7.000000
prod 2.000000 12.000000
>>> print(styler.concat(styler2).concat(styler3).to_string()) # styler2 is dropped
A B
0 1.00 3.00
1 2.00 4.00
prod 2.000000 12.000000
Expected Behavior
>>> print(styler.concat(styler2).concat(styler3).to_string())
A B
0 1.00 3.00
1 2.00 4.00
sum 3.000000 7.000000
prod 2.000000 12.000000
Installed Versions
Details
INSTALLED VERSIONS
commit : fe93a83
python : 3.8.13.final.0
python-bits : 64
OS : Linux
OS-release : 4.4.0-19041-Microsoft
Version : #1237-Microsoft Sat Sep 11 14:32:00 PST 2021
machine : x86_64
processor : x86_64
byteorder : little
LC_ALL : None
LANG : en_US.UTF-8
LOCALE : en_US.UTF-8
pandas : 1.0.0rc0+8877.gfe93a83950
numpy : 1.23.4
pytz : 2022.5
dateutil : 2.8.2
setuptools : 65.5.0
pip : 22.3
Cython : 0.29.32
pytest : 7.1.3
hypothesis : 6.56.3
sphinx : 4.5.0
blosc : None
feather : None
xlsxwriter : 3.0.3
lxml.etree : 4.9.1
html5lib : 1.1
pymysql : 1.0.2
psycopg2 : 2.9.3
jinja2 : 3.0.3
IPython : 8.5.0
pandas_datareader: 0.10.0
bs4 : 4.11.1
bottleneck : 1.3.5
brotli :
fastparquet : 0.8.3
fsspec : 2021.11.0
gcsfs : 2021.11.0
matplotlib : 3.6.1
numba : 0.56.3
numexpr : 2.8.3
odfpy : None
openpyxl : 3.0.10
pandas_gbq : 0.17.9
pyarrow : 9.0.0
pyreadstat : 1.1.9
pyxlsb : 1.0.10
s3fs : 2021.11.0
scipy : 1.9.2
snappy :
sqlalchemy : 1.4.42
tables : 3.7.0
tabulate : 0.9.0
xarray : 2022.10.0
xlrd : 2.0.1
xlwt : 1.3.0
zstandard : 0.18.0
tzdata : None
Pandas version checks
I have checked that this issue has not already been reported.
I have confirmed this bug exists on the latest version of pandas.
I have confirmed this bug exists on the main branch of pandas.
Reproducible Example
Issue Description
The new
style.concatoption can be used to add styled dataframes to each other.A user might want to add several dataframes in this manner.
The natural way to do it is
styler1.concat(styler2).concat(styler3). However in this case, styler2 is silently discarded.A workaround that give the expected output is to use
styler1.concat(styler2.concat(styler3)). I think that this method is not obvious, and can get ugly when the code is longer.Expected Behavior
>>> print(styler.concat(styler2).concat(styler3).to_string()) A B 0 1.00 3.00 1 2.00 4.00 sum 3.000000 7.000000 prod 2.000000 12.000000Installed Versions
Details
INSTALLED VERSIONS
commit : fe93a83
python : 3.8.13.final.0
python-bits : 64
OS : Linux
OS-release : 4.4.0-19041-Microsoft
Version : #1237-Microsoft Sat Sep 11 14:32:00 PST 2021
machine : x86_64
processor : x86_64
byteorder : little
LC_ALL : None
LANG : en_US.UTF-8
LOCALE : en_US.UTF-8
pandas : 1.0.0rc0+8877.gfe93a83950
numpy : 1.23.4
pytz : 2022.5
dateutil : 2.8.2
setuptools : 65.5.0
pip : 22.3
Cython : 0.29.32
pytest : 7.1.3
hypothesis : 6.56.3
sphinx : 4.5.0
blosc : None
feather : None
xlsxwriter : 3.0.3
lxml.etree : 4.9.1
html5lib : 1.1
pymysql : 1.0.2
psycopg2 : 2.9.3
jinja2 : 3.0.3
IPython : 8.5.0
pandas_datareader: 0.10.0
bs4 : 4.11.1
bottleneck : 1.3.5
brotli :
fastparquet : 0.8.3
fsspec : 2021.11.0
gcsfs : 2021.11.0
matplotlib : 3.6.1
numba : 0.56.3
numexpr : 2.8.3
odfpy : None
openpyxl : 3.0.10
pandas_gbq : 0.17.9
pyarrow : 9.0.0
pyreadstat : 1.1.9
pyxlsb : 1.0.10
s3fs : 2021.11.0
scipy : 1.9.2
snappy :
sqlalchemy : 1.4.42
tables : 3.7.0
tabulate : 0.9.0
xarray : 2022.10.0
xlrd : 2.0.1
xlwt : 1.3.0
zstandard : 0.18.0
tzdata : None