from textwrap import dedent
|
|
import pytest
|
|
from pandas import (
|
DataFrame,
|
IndexSlice,
|
)
|
|
pytest.importorskip("jinja2")
|
|
from pandas.io.formats.style import Styler
|
|
|
@pytest.fixture
|
def df():
|
return DataFrame(
|
[[1, 2, 3], [4, 5, 6], [7, 8, 9]],
|
index=["i", "j", "j"],
|
columns=["c", "d", "d"],
|
dtype=float,
|
)
|
|
|
@pytest.fixture
|
def styler(df):
|
return Styler(df, uuid_len=0)
|
|
|
def test_format_non_unique(df):
|
# GH 41269
|
|
# test dict
|
html = df.style.format({"d": "{:.1f}"}).to_html()
|
for val in ["1.000000<", "4.000000<", "7.000000<"]:
|
assert val in html
|
for val in ["2.0<", "3.0<", "5.0<", "6.0<", "8.0<", "9.0<"]:
|
assert val in html
|
|
# test subset
|
html = df.style.format(precision=1, subset=IndexSlice["j", "d"]).to_html()
|
for val in ["1.000000<", "4.000000<", "7.000000<", "2.000000<", "3.000000<"]:
|
assert val in html
|
for val in ["5.0<", "6.0<", "8.0<", "9.0<"]:
|
assert val in html
|
|
|
@pytest.mark.parametrize("func", ["apply", "applymap"])
|
def test_apply_applymap_non_unique_raises(df, func):
|
# GH 41269
|
if func == "apply":
|
op = lambda s: ["color: red;"] * len(s)
|
else:
|
op = lambda v: "color: red;"
|
|
with pytest.raises(KeyError, match="`Styler.apply` and `.applymap` are not"):
|
getattr(df.style, func)(op)._compute()
|
|
|
def test_table_styles_dict_non_unique_index(styler):
|
styles = styler.set_table_styles(
|
{"j": [{"selector": "td", "props": "a: v;"}]}, axis=1
|
).table_styles
|
assert styles == [
|
{"selector": "td.row1", "props": [("a", "v")]},
|
{"selector": "td.row2", "props": [("a", "v")]},
|
]
|
|
|
def test_table_styles_dict_non_unique_columns(styler):
|
styles = styler.set_table_styles(
|
{"d": [{"selector": "td", "props": "a: v;"}]}, axis=0
|
).table_styles
|
assert styles == [
|
{"selector": "td.col1", "props": [("a", "v")]},
|
{"selector": "td.col2", "props": [("a", "v")]},
|
]
|
|
|
def test_tooltips_non_unique_raises(styler):
|
# ttips has unique keys
|
ttips = DataFrame([["1", "2"], ["3", "4"]], columns=["c", "d"], index=["a", "b"])
|
styler.set_tooltips(ttips=ttips) # OK
|
|
# ttips has non-unique columns
|
ttips = DataFrame([["1", "2"], ["3", "4"]], columns=["c", "c"], index=["a", "b"])
|
with pytest.raises(KeyError, match="Tooltips render only if `ttips` has unique"):
|
styler.set_tooltips(ttips=ttips)
|
|
# ttips has non-unique index
|
ttips = DataFrame([["1", "2"], ["3", "4"]], columns=["c", "d"], index=["a", "a"])
|
with pytest.raises(KeyError, match="Tooltips render only if `ttips` has unique"):
|
styler.set_tooltips(ttips=ttips)
|
|
|
def test_set_td_classes_non_unique_raises(styler):
|
# classes has unique keys
|
classes = DataFrame([["1", "2"], ["3", "4"]], columns=["c", "d"], index=["a", "b"])
|
styler.set_td_classes(classes=classes) # OK
|
|
# classes has non-unique columns
|
classes = DataFrame([["1", "2"], ["3", "4"]], columns=["c", "c"], index=["a", "b"])
|
with pytest.raises(KeyError, match="Classes render only if `classes` has unique"):
|
styler.set_td_classes(classes=classes)
|
|
# classes has non-unique index
|
classes = DataFrame([["1", "2"], ["3", "4"]], columns=["c", "d"], index=["a", "a"])
|
with pytest.raises(KeyError, match="Classes render only if `classes` has unique"):
|
styler.set_td_classes(classes=classes)
|
|
|
def test_hide_columns_non_unique(styler):
|
ctx = styler.hide(["d"], axis="columns")._translate(True, True)
|
|
assert ctx["head"][0][1]["display_value"] == "c"
|
assert ctx["head"][0][1]["is_visible"] is True
|
|
assert ctx["head"][0][2]["display_value"] == "d"
|
assert ctx["head"][0][2]["is_visible"] is False
|
|
assert ctx["head"][0][3]["display_value"] == "d"
|
assert ctx["head"][0][3]["is_visible"] is False
|
|
assert ctx["body"][0][1]["is_visible"] is True
|
assert ctx["body"][0][2]["is_visible"] is False
|
assert ctx["body"][0][3]["is_visible"] is False
|
|
|
def test_latex_non_unique(styler):
|
result = styler.to_latex()
|
assert result == dedent(
|
"""\
|
\\begin{tabular}{lrrr}
|
& c & d & d \\\\
|
i & 1.000000 & 2.000000 & 3.000000 \\\\
|
j & 4.000000 & 5.000000 & 6.000000 \\\\
|
j & 7.000000 & 8.000000 & 9.000000 \\\\
|
\\end{tabular}
|
"""
|
)
|
