Debian Codegraph @

examples/Nested Hierarchies.ipynb

raw
1 {
2 "cells": [
3 {
4 "cell_type": "markdown",
5 "id": "individual-dubai",
6 "metadata": {},
7 "source": [
8 "### `ipydatagrid` support nested columns/rows out of the box. \n",
9 "#### Just pass a MultiIndex pandas DataFrame and you're set!"
10 ]
11 },
12 {
13 "cell_type": "code",
14 "execution_count": null,
15 "id": "ultimate-supply",
16 "metadata": {},
17 "outputs": [],
18 "source": [
19 "import ipydatagrid as ipg\n",
20 "import pandas as pd\n",
21 "import numpy as np\n",
22 "\n",
23 "# Columns\n",
24 "col_top_level = [\n",
25 " \"VeryLongValueFactors\",\n",
26 " \"VeryLongValueFactors\",\n",
27 " \"Even Longer Momentum Factors\",\n",
28 " \"Even Longer Momentum Factors\",\n",
29 "]\n",
30 "col_bottom_level = [\"Factor_A\", \"Factor_B\", \"Factor_C\", \"Factor_D\"]\n",
31 "\n",
32 "# Rows\n",
33 "row_top_level = [\"Sector 1\", \"Sector 1\", \"Sector 2\", \"Sector 2\"]\n",
34 "row_bottom_level = [\"Security A\", \"Security B\", \"Security C\", \"Security D\"]\n",
35 "\n",
36 "header_renderer = ipg.TextRenderer(\n",
37 " background_color=\"moccasin\",\n",
38 " text_color=\"navy\",\n",
39 " vertical_alignment=\"top\",\n",
40 " horizontal_alignment=\"center\",\n",
41 ")\n",
42 "\n",
43 "default_renderer = ipg.TextRenderer(\n",
44 " text_color=ipg.VegaExpr(\"cell.value <= 0 ? 'purple' : 'green'\")\n",
45 ")\n",
46 "\n",
47 "nested_df = pd.DataFrame(\n",
48 " np.random.randn(4, 4).round(4),\n",
49 " columns=pd.MultiIndex.from_arrays([col_top_level, col_bottom_level]),\n",
50 " index=pd.MultiIndex.from_arrays(\n",
51 " [row_top_level, row_bottom_level], names=(\"Sector\", \"Ticker\")\n",
52 " ),\n",
53 ")\n",
54 "\n",
55 "nested_grid = ipg.DataGrid(\n",
56 " nested_df,\n",
57 " base_column_size=80,\n",
58 " base_column_header_size=35,\n",
59 " base_row_header_size=80,\n",
60 " layout={\"height\": \"180px\"},\n",
61 " header_renderer=header_renderer,\n",
62 " default_renderer=default_renderer,\n",
63 ")\n",
64 "\n",
65 "nested_grid"
66 ]
67 },
68 {
69 "cell_type": "code",
70 "execution_count": null,
71 "id": "23f007f4-bcce-4ecd-b68c-aa9b96c82f82",
72 "metadata": {},
73 "outputs": [],
74 "source": []
75 }
76 ],
77 "metadata": {
78 "kernelspec": {
79 "display_name": "Python 3 (ipykernel)",
80 "language": "python",
81 "name": "python3"
82 },
83 "language_info": {
84 "codemirror_mode": {
85 "name": "ipython",
86 "version": 3
87 },
88 "file_extension": ".py",
89 "mimetype": "text/x-python",
90 "name": "python",
91 "nbconvert_exporter": "python",
92 "pygments_lexer": "ipython3",
93 "version": "3.12.3"
94 }
95 },
96 "nbformat": 4,
97 "nbformat_minor": 5
98 }