Debian Codegraph @

examples/ConditionalFormatting.ipynb

raw
1 {
2 "cells": [
3 {
4 "cell_type": "markdown",
5 "metadata": {},
6 "source": [
7 "# Conditional formatting based on other column values"
8 ]
9 },
10 {
11 "cell_type": "markdown",
12 "metadata": {},
13 "source": [
14 "## Compound cell values"
15 ]
16 },
17 {
18 "cell_type": "code",
19 "execution_count": null,
20 "metadata": {},
21 "outputs": [],
22 "source": [
23 "import pandas as pd\n",
24 "from ipydatagrid import DataGrid, TextRenderer, VegaExpr\n",
25 "\n",
26 "df = pd.DataFrame(\n",
27 " {\n",
28 " \"column 1\": [{\"key\": 11}, [\"berry\", \"apple\", \"cherry\"]],\n",
29 " \"column 2\": [[\"berry\", \"berry\", \"cherry\"], {\"key\": 10}],\n",
30 " }\n",
31 ")\n",
32 "\n",
33 "renderer = TextRenderer(\n",
34 " background_color=VegaExpr(\n",
35 " \"cell.value[1] == 'berry' && cell.metadata.data['column 1']['key'] == 11 ? 'limegreen' : 'pink'\"\n",
36 " )\n",
37 ")\n",
38 "\n",
39 "DataGrid(\n",
40 " df,\n",
41 " layout={\"height\": \"100px\"},\n",
42 " base_column_size=150,\n",
43 " default_renderer=renderer,\n",
44 ")"
45 ]
46 },
47 {
48 "cell_type": "code",
49 "execution_count": null,
50 "metadata": {},
51 "outputs": [],
52 "source": [
53 "import pandas as pd\n",
54 "from ipydatagrid import DataGrid, TextRenderer, VegaExpr\n",
55 "\n",
56 "df = pd.DataFrame(\n",
57 " {\n",
58 " \"column 1\": [{\"key\": {\"nestedKey\": 11}}, [\"berry\", \"apple\", \"cherry\"]],\n",
59 " \"column 2\": [[\"berry\", \"berry\", \"cherry\"], {\"key\": 10}],\n",
60 " }\n",
61 ")\n",
62 "\n",
63 "renderer = TextRenderer(\n",
64 " background_color=VegaExpr(\n",
65 " \"cell.value[1] == 'berry' && \\\n",
66 " cell.metadata.data['column 1']['key']['nestedKey'] == 11 ? 'magenta' : 'dodgerblue'\"\n",
67 " )\n",
68 ")\n",
69 "\n",
70 "DataGrid(\n",
71 " df,\n",
72 " layout={\"height\": \"100px\"},\n",
73 " base_column_size=150,\n",
74 " default_renderer=renderer,\n",
75 ")"
76 ]
77 },
78 {
79 "cell_type": "code",
80 "execution_count": null,
81 "metadata": {},
82 "outputs": [],
83 "source": [
84 "import pandas as pd\n",
85 "from ipydatagrid import DataGrid, TextRenderer, VegaExpr\n",
86 "\n",
87 "df = pd.DataFrame(\n",
88 " {\n",
89 " \"column 1\": [[\"one\", [\"two\"]], [\"berry\", \"apple\", \"cherry\"]],\n",
90 " \"column 2\": [[\"berry\", \"berry\", \"cherry\"], [\"one\", [\"two\"]]],\n",
91 " }\n",
92 ")\n",
93 "\n",
94 "renderer = TextRenderer(\n",
95 " background_color=VegaExpr(\n",
96 " \"cell.value[1] == 'berry' && \\\n",
97 " cell.metadata.data['column 1'][1][0] == 'two' ? 'pink' : 'teal'\"\n",
98 " )\n",
99 ")\n",
100 "\n",
101 "DataGrid(\n",
102 " df,\n",
103 " layout={\"height\": \"100px\"},\n",
104 " base_column_size=150,\n",
105 " default_renderer=renderer,\n",
106 ")"
107 ]
108 },
109 {
110 "cell_type": "code",
111 "execution_count": null,
112 "metadata": {},
113 "outputs": [],
114 "source": [
115 "import pandas as pd\n",
116 "from ipydatagrid import DataGrid, TextRenderer, VegaExpr\n",
117 "\n",
118 "df = pd.DataFrame(\n",
119 " {\n",
120 " \"column 1\": [[\"one\", [\"two\"]], [\"berry\", \"apple\", \"cherry\"]],\n",
121 " \"column 2\": [[\"berry\", \"berry\", \"cherry\"], [\"one\", [\"two\"]]],\n",
122 " }\n",
123 ")\n",
124 "\n",
125 "renderer = TextRenderer(\n",
126 " background_color=VegaExpr(\"cell.value[1] == 'berry' ? 'pink' : 'teal'\")\n",
127 ")\n",
128 "\n",
129 "DataGrid(\n",
130 " df,\n",
131 " layout={\"height\": \"100px\"},\n",
132 " base_column_size=150,\n",
133 " default_renderer=renderer,\n",
134 ")"
135 ]
136 },
137 {
138 "cell_type": "markdown",
139 "metadata": {},
140 "source": [
141 "## Normal column names"
142 ]
143 },
144 {
145 "cell_type": "code",
146 "execution_count": null,
147 "metadata": {
148 "scrolled": false
149 },
150 "outputs": [],
151 "source": [
152 "# Imports\n",
153 "import json\n",
154 "import numpy as np\n",
155 "import pandas as pd\n",
156 "from bqplot import DateScale, ColorScale\n",
157 "from py2vega.functions.type_coercing import toDate\n",
158 "from py2vega.functions.date_time import datetime\n",
159 "from ipydatagrid import Expr, DataGrid, TextRenderer\n",
160 "\n",
161 "# Random data\n",
162 "n = 10\n",
163 "np.random.seed(0)\n",
164 "df = pd.DataFrame(\n",
165 " {\n",
166 " \"Column 0\": np.random.randn(n),\n",
167 " \"Column 1\": np.random.randn(n),\n",
168 " \"Column 2\": np.random.randn(n),\n",
169 " }\n",
170 ")\n",
171 "\n",
172 "# Formatting the values in column 1 based on the value of the sibling row in column 2\n",
173 "def format_based_on_other_column(cell):\n",
174 " return \"green\" if cell.metadata.data[\"Column 2\"] > 0.0 else \"yellow\"\n",
175 "\n",
176 "\n",
177 "column1_formatting = TextRenderer(\n",
178 " text_color=\"black\",\n",
179 " background_color=Expr(format_based_on_other_column),\n",
180 ")\n",
181 "\n",
182 "renderers = {\n",
183 " \"Column 1\": column1_formatting,\n",
184 "}\n",
185 "\n",
186 "grid = DataGrid(\n",
187 " df,\n",
188 " base_row_size=30,\n",
189 " base_column_size=300,\n",
190 " renderers=renderers,\n",
191 " layout={\"height\": \"350px\"},\n",
192 ")\n",
193 "grid"
194 ]
195 },
196 {
197 "cell_type": "markdown",
198 "metadata": {},
199 "source": [
200 "## Example with nested columns"
201 ]
202 },
203 {
204 "cell_type": "code",
205 "execution_count": null,
206 "metadata": {},
207 "outputs": [],
208 "source": [
209 "import ipydatagrid as ipg\n",
210 "import pandas as pd\n",
211 "import numpy as np\n",
212 "\n",
213 "top_level = [\n",
214 " \"Value Factors\",\n",
215 " \"Value Factors\",\n",
216 " \"Momentum Factors\",\n",
217 " \"Momentum Factors\",\n",
218 "]\n",
219 "bottom_level = [\"Factor A\", \"Factor B\", \"Factor C\", \"Factor D\"]\n",
220 "\n",
221 "nested_df = pd.DataFrame(\n",
222 " np.random.randn(4, 4).round(2),\n",
223 " columns=pd.MultiIndex.from_arrays([top_level, bottom_level]),\n",
224 " index=pd.Index(\n",
225 " [\"Security {}\".format(x) for x in [\"A\", \"B\", \"C\", \"D\"]], name=\"Ticker\"\n",
226 " ),\n",
227 ")\n",
228 "\n",
229 "# Formatting Factor B rows based on their siblings in the Factor C column\n",
230 "def format_based_on_other_column(cell):\n",
231 " return (\n",
232 " \"green\"\n",
233 " if cell.value > -0\n",
234 " and cell.metadata.data[\"('Value Factors', 'Factor B')\"] > 0.0\n",
235 " else \"yellow\"\n",
236 " )\n",
237 "\n",
238 "\n",
239 "nested_grid = ipg.DataGrid(\n",
240 " nested_df,\n",
241 " base_column_size=90,\n",
242 " layout={\"height\": \"140px\"},\n",
243 " default_renderer=ipg.TextRenderer(\n",
244 " horizontal_alignment=\"right\",\n",
245 " background_color=Expr(format_based_on_other_column),\n",
246 " ),\n",
247 ")\n",
248 "\n",
249 "nested_grid"
250 ]
251 },
252 {
253 "cell_type": "code",
254 "execution_count": null,
255 "metadata": {},
256 "outputs": [],
257 "source": [
258 "def format_based_on_other_column(cell):\n",
259 " return (\n",
260 " \"green\"\n",
261 " if cell.column == 0 and cell.metadata.data[\"Signal\"] == \"Buy\"\n",
262 " else \"red\"\n",
263 " )\n",
264 "\n",
265 "\n",
266 "signal_column_formatting = TextRenderer(\n",
267 " text_color=\"white\",\n",
268 " background_color=Expr(format_based_on_other_column),\n",
269 ")\n",
270 "\n",
271 "renderers = {\n",
272 " \"Stock\": signal_column_formatting,\n",
273 "}\n",
274 "\n",
275 "grid = DataGrid(\n",
276 " pd.DataFrame(\n",
277 " {\"Stock\": \"A B C D\".split(), \"Signal\": [\"Buy\", \"Sell\", \"Buy\", \"Sell\"]}\n",
278 " ),\n",
279 " base_row_size=30,\n",
280 " base_column_size=300,\n",
281 " renderers=renderers,\n",
282 " layout={\"height\": \"150px\"},\n",
283 ")\n",
284 "grid"
285 ]
286 },
287 {
288 "cell_type": "markdown",
289 "metadata": {},
290 "source": [
291 "## Comparing dates"
292 ]
293 },
294 {
295 "cell_type": "code",
296 "execution_count": null,
297 "metadata": {},
298 "outputs": [],
299 "source": [
300 "import json\n",
301 "\n",
302 "import numpy as np\n",
303 "import pandas as pd\n",
304 "from bqplot import DateScale, ColorScale\n",
305 "from py2vega.functions.type_coercing import toDate\n",
306 "from py2vega.functions.date_time import datetime\n",
307 "\n",
308 "from ipydatagrid import Expr, DataGrid, TextRenderer, BarRenderer\n",
309 "\n",
310 "n = 10\n",
311 "np.random.seed(0)\n",
312 "\n",
313 "\n",
314 "def format_based_on_date(cell):\n",
315 " return (\n",
316 " \"magenta\"\n",
317 " if cell.column == 0 and cell.metadata.data[\"Dates\"] >= \"2020-10-21\"\n",
318 " else \"yellow\"\n",
319 " )\n",
320 "\n",
321 "\n",
322 "df = pd.DataFrame(\n",
323 " {\n",
324 " \"Value 1\": np.random.randn(n),\n",
325 " \"Value 2\": np.random.randn(n),\n",
326 " \"Dates\": pd.date_range(end=pd.Timestamp(\"2020-10-25\"), periods=n),\n",
327 " }\n",
328 ")\n",
329 "\n",
330 "text_renderer = TextRenderer(\n",
331 " text_color=\"black\", background_color=Expr(format_based_on_date)\n",
332 ")\n",
333 "\n",
334 "\n",
335 "def bar_color(cell):\n",
336 " date = toDate(cell.value)\n",
337 " return \"green\" if date > datetime(\"2000\") else \"red\"\n",
338 "\n",
339 "\n",
340 "renderers = {\n",
341 " \"Value 1\": text_renderer,\n",
342 " \"Dates\": BarRenderer(\n",
343 " bar_value=DateScale(),\n",
344 " bar_color=Expr(bar_color),\n",
345 " format=\"%Y/%m/%d\",\n",
346 " format_type=\"time\",\n",
347 " ),\n",
348 "}\n",
349 "\n",
350 "grid = DataGrid(\n",
351 " df,\n",
352 " base_row_size=30,\n",
353 " base_column_size=300,\n",
354 " renderers=renderers,\n",
355 " layout={\"height\": \"350px\"},\n",
356 ")\n",
357 "grid"
358 ]
359 }
360 ],
361 "metadata": {
362 "kernelspec": {
363 "display_name": "Python 3",
364 "language": "python",
365 "name": "python3"
366 },
367 "language_info": {
368 "codemirror_mode": {
369 "name": "ipython",
370 "version": 3
371 },
372 "file_extension": ".py",
373 "mimetype": "text/x-python",
374 "name": "python",
375 "nbconvert_exporter": "python",
376 "pygments_lexer": "ipython3",
377 "version": "3.8.5"
378 }
379 },
380 "nbformat": 4,
381 "nbformat_minor": 4
382 }