https://community.esri.com/t5/python-questions/pandas-styler-and-borders/m-p/1279042#M67427 <P>Hello,</P><P>I would like to add borders to specific cells and when adjacent, border the group without internal borders.&nbsp; Here is my code so far...</P><P>&nbsp;</P><LI-CODE lang="python">import pandas as pd df = pd.DataFrame({"TransNo":[29, 32, 34, 45, 68, 71, 72, 73, 81], "Type":["Fee", "Sale", "Fee", "Fee", "Sale", "Sale", "Sale", "Sale", "Fee"], "Amount": [1.2, 10.2, 2.1, 3.1, 15.3, 19.2, 100.5, 97.3, 2.2]}) def border(cell_value): if cell_value == "Sale": return "border: solid thin" df.style.applymap(border)</LI-CODE><P>&nbsp;</P><P>and here is the output...</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TylerT_0-1681583278221.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/68100i3AC7A4B4D7CB30F6/image-size/medium?v=v2&amp;px=400" role="button" title="TylerT_0-1681583278221.png" alt="TylerT_0-1681583278221.png" /></span></P><P>&nbsp;</P><P>and here is the markup of the desired output....</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TylerT_1-1681583415694.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/68101iDB0B26C05C0F7E01/image-size/medium?v=v2&amp;px=400" role="button" title="TylerT_1-1681583415694.png" alt="TylerT_1-1681583415694.png" /></span></P><P>The red markup indicating the deletion of internal lines.&nbsp; Any pointers would be appreciated.&nbsp; Thank you.&nbsp;&nbsp;</P><P>Tyler</P> Sat, 15 Apr 2023 21:31:49 GMT TylerT 2023-04-15T21:31:49Z https://community.esri.com/t5/python-questions/pandas-styler-and-borders/m-p/1279042#M67427 <P>Hello,</P><P>I would like to add borders to specific cells and when adjacent, border the group without internal borders.&nbsp; Here is my code so far...</P><P>&nbsp;</P><LI-CODE lang="python">import pandas as pd df = pd.DataFrame({"TransNo":[29, 32, 34, 45, 68, 71, 72, 73, 81], "Type":["Fee", "Sale", "Fee", "Fee", "Sale", "Sale", "Sale", "Sale", "Fee"], "Amount": [1.2, 10.2, 2.1, 3.1, 15.3, 19.2, 100.5, 97.3, 2.2]}) def border(cell_value): if cell_value == "Sale": return "border: solid thin" df.style.applymap(border)</LI-CODE><P>&nbsp;</P><P>and here is the output...</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TylerT_0-1681583278221.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/68100i3AC7A4B4D7CB30F6/image-size/medium?v=v2&amp;px=400" role="button" title="TylerT_0-1681583278221.png" alt="TylerT_0-1681583278221.png" /></span></P><P>&nbsp;</P><P>and here is the markup of the desired output....</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TylerT_1-1681583415694.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/68101iDB0B26C05C0F7E01/image-size/medium?v=v2&amp;px=400" role="button" title="TylerT_1-1681583415694.png" alt="TylerT_1-1681583415694.png" /></span></P><P>The red markup indicating the deletion of internal lines.&nbsp; Any pointers would be appreciated.&nbsp; Thank you.&nbsp;&nbsp;</P><P>Tyler</P> Sat, 15 Apr 2023 21:31:49 GMT https://community.esri.com/t5/python-questions/pandas-styler-and-borders/m-p/1279042#M67427 TylerT 2023-04-15T21:31:49Z