Debian Codegraph @

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

raw
1 {
2 "cells": [
3 {
4 "cell_type": "code",
5 "execution_count": null,
6 "id": "06fb5fa1",
7 "metadata": {},
8 "outputs": [],
9 "source": [
10 "import json\n",
11 "\n",
12 "import numpy as np\n",
13 "import pandas as pd\n",
14 "from bqplot import DateScale, ColorScale\n",
15 "from py2vega.functions.type_coercing import toDate\n",
16 "from py2vega.functions.date_time import datetime\n",
17 "\n",
18 "from ipydatagrid import Expr, DataGrid, TextRenderer, BarRenderer\n",
19 "\n",
20 "n = 100\n",
21 "np.random.seed(129)\n",
22 "\n",
23 "df = pd.DataFrame(\n",
24 " {\n",
25 " \"Value 1\": np.random.randn(n),\n",
26 " \"Value 2\": np.random.randn(n),\n",
27 " \"Dates\": pd.date_range(end=pd.Timestamp(\"today\"), periods=n),\n",
28 " }\n",
29 ")\n",
30 "\n",
31 "text_renderer = TextRenderer(\n",
32 " text_color=\"black\", background_color=ColorScale(min=-5, max=5)\n",
33 ")\n",
34 "\n",
35 "\n",
36 "def bar_color(cell):\n",
37 " date = toDate(cell.value)\n",
38 " return \"green\" if date > datetime(\"2000\") else \"red\"\n",
39 "\n",
40 "\n",
41 "renderers = {\n",
42 " \"Value 1\": text_renderer,\n",
43 " \"Value 2\": text_renderer,\n",
44 " \"Dates\": BarRenderer(\n",
45 " bar_value=DateScale(),\n",
46 " bar_color=Expr(bar_color),\n",
47 " format=\"%Y/%m/%d\",\n",
48 " format_type=\"time\",\n",
49 " ),\n",
50 "}\n",
51 "\n",
52 "grid = DataGrid(df, base_row_size=30, base_column_size=300, renderers=renderers)\n",
53 "grid.transform([{\"type\": \"sort\", \"column\": \"Value 2\", \"desc\": True}])\n",
54 "grid"
55 ]
56 },
57 {
58 "cell_type": "code",
59 "execution_count": null,
60 "id": "af3b6b23",
61 "metadata": {},
62 "outputs": [],
63 "source": [
64 "grid"
65 ]
66 }
67 ],
68 "metadata": {
69 "kernelspec": {
70 "display_name": "Python 3 (ipykernel)",
71 "language": "python",
72 "name": "python3"
73 },
74 "language_info": {
75 "codemirror_mode": {
76 "name": "ipython",
77 "version": 3
78 },
79 "file_extension": ".py",
80 "mimetype": "text/x-python",
81 "name": "python",
82 "nbconvert_exporter": "python",
83 "pygments_lexer": "ipython3",
84 "version": "3.12.3"
85 }
86 },
87 "nbformat": 4,
88 "nbformat_minor": 5
89 }