Debian Codegraph @

ui-tests-ipw8/tests/notebooks/datagrid_nested_hierarchies.ipynb

raw
1 {
2 "cells": [
3 {
4 "cell_type": "code",
5 "execution_count": null,
6 "id": "30354eb9",
7 "metadata": {},
8 "outputs": [],
9 "source": [
10 "import numpy as np\n",
11 "import pandas as pd\n",
12 "import ipydatagrid as g\n",
13 "\n",
14 "np.random.seed(1)\n",
15 "\n",
16 "# merging of lower level row headers\n",
17 "col_top_level = [\n",
18 " \"VeryLongValueFactors\",\n",
19 " \"VeryLongValueFactors\",\n",
20 " \"Even Longer Momentum Factors\",\n",
21 " \"Even Longer Momentum Factors\",\n",
22 "]\n",
23 "col_bottom_level = [\"Factor_A\", \"Factor_B\", \"Factor_C\", \"Factor_D\"]\n",
24 "# Rows\n",
25 "row_top_level = [\"Sector 1\", \"Sector 1\", \"Sector 2\", \"Sector 2\", \"Sector 3\"]\n",
26 "row_bottom_level = [\"Security A\", \"Security B\", \"Security C\", \"Security C\", \"Security C\"]\n",
27 "\n",
28 "nested_df = pd.DataFrame(\n",
29 " np.random.randn(5, 4).round(4),\n",
30 " columns=pd.MultiIndex.from_arrays([col_top_level, col_bottom_level]),\n",
31 " index=pd.MultiIndex.from_arrays(\n",
32 " [row_top_level, row_bottom_level], names=(\"Sector\", \"Ticker\")\n",
33 " ),\n",
34 ")\n",
35 "\n",
36 "nested_grid = g.DataGrid(\n",
37 " nested_df,\n",
38 " base_column_size=80,\n",
39 " base_column_header_size=35,\n",
40 " base_row_header_size=80,\n",
41 " layout={\"height\": \"180px\"}\n",
42 ")\n",
43 "\n",
44 "nested_grid"
45 ]
46 }
47 ],
48 "metadata": {
49 "kernelspec": {
50 "display_name": "Python 3 (ipykernel)",
51 "language": "python",
52 "name": "python3"
53 },
54 "language_info": {
55 "codemirror_mode": {
56 "name": "ipython",
57 "version": 3
58 },
59 "file_extension": ".py",
60 "mimetype": "text/x-python",
61 "name": "python",
62 "nbconvert_exporter": "python",
63 "pygments_lexer": "ipython3",
64 "version": "3.12.3"
65 }
66 },
67 "nbformat": 4,
68 "nbformat_minor": 5
69 }