Debian Codegraph @

ui-tests-ipw7/tests/notebooks/conditional_formatting.ipynb

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