tkinter dashboard.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "6fc2c3c5",
   "metadata": {},
   "outputs": [],
   "source": [
    "import tkinter as tk\n",
    "import pandas as pd\n",
    "root = tk.Tk()\n",
    "root.config(padx=10, pady=10)\n",
    "root.title(\"KPI Dashboard\")\n",
    "def frameMaker(colour, product, r, c):\n",
    "    \"\"\" This will create simple frames\"\"\"\n",
    "    frame = tk.LabelFrame(root, width=270, height=130, text = product,\n",
    "            bg=colour, relief=tk.RAISED, borderwidth=5, cursor=\"dot\").grid(row=r, column=c)\n",
    "    return frame\n",
    "#####\n",
    "frame1 = tk.LabelFrame(root, width=270, height=130, text = 'XDSL',\n",
    "            bg=\"light sea green\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"dot\")\n",
    "frame1.grid(row=0,column=0, sticky=\"EW\")\n",
    "\n",
    "frame2 = tk.LabelFrame(root, width=270, height=130, text = 'FF',\n",
    "            bg=\"bisque\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"arrow\")\n",
    "frame2.grid(row=0,column=1, sticky=\"EW\")\n",
    "\n",
    "frame3 = tk.LabelFrame(root, width=270, height=130, text = 'Voice',\n",
    "            bg=\"RosyBrown1\",\n",
    "            # bg=\"black\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"dot\")\n",
    "frame3.grid(row=0,column=2, sticky=\"EW\")\n",
    "\n",
    "frame4 = tk.LabelFrame(root, width=270, height=130, text = 'IPTV',\n",
    "            bg=\"khaki2\",\n",
    "            relief=tk.RAISED, borderwidth=5,\n",
    "            cursor=\"arrow\")\n",
    "frame4.grid(row=0,column=3, sticky=\"EW\")\n",
    "tk.Label(frame1, text=\"DENIED\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame2, text=\"DENIED\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame3, text=\"DENIED\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame4, text=\"DENIED\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "#######\n",
    "frame5 = tk.LabelFrame(root, width=270, height=130, text = 'XDSL',\n",
    "            bg=\"light sea green\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"dot\")\n",
    "frame5.grid(row=1,column=0, sticky=\"NEWS\")\n",
    "\n",
    "frame6 = tk.LabelFrame(root, width=270, height=130, text = 'FF',\n",
    "            bg=\"bisque\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"arrow\")\n",
    "frame6.grid(row=1,column=1, sticky=\"NEWS\")\n",
    "\n",
    "frame7 = tk.LabelFrame(root, width=270, height=130, text = 'Voice',\n",
    "            bg=\"RosyBrown1\",\n",
    "            # bg=\"black\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"dot\")\n",
    "frame7.grid(row=1,column=2, sticky=\"NEWS\")\n",
    "\n",
    "frame8 = tk.LabelFrame(root, width=270, height=130, text = 'IPTV',\n",
    "            bg=\"khaki2\",\n",
    "            relief=tk.RAISED, borderwidth=5,\n",
    "            cursor=\"arrow\")\n",
    "frame8.grid(row=1,column=3, sticky=\"NEWS\")\n",
    "tk.Label(frame5, text=\"Reg\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame6, text=\"Reg\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame7, text=\"Reg\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame8, text=\"Reg\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "#######\n",
    "frame9 = tk.LabelFrame(root, width=270, height=130, text = 'XDSL',\n",
    "            bg=\"light sea green\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"dot\")\n",
    "frame9.grid(row=2,column=0, sticky='NEWS')\n",
    "\n",
    "frame10 = tk.LabelFrame(root, width=270, height=130, text = 'FF',\n",
    "            bg=\"bisque\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"arrow\")\n",
    "frame10.grid(row=2,column=1, sticky=\"NEWS\")\n",
    "\n",
    "frame11 = tk.LabelFrame(root, width=270, height=130, text = 'Voice',\n",
    "            bg=\"RosyBrown1\",\n",
    "            # bg=\"black\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"dot\")\n",
    "frame11.grid(row=2,column=2, sticky=\"NEWS\")\n",
    "\n",
    "frame12 = tk.LabelFrame(root, width=270, height=130, text = 'IPTV',\n",
    "            bg=\"khaki2\",\n",
    "            relief=tk.RAISED, borderwidth=5,\n",
    "            cursor=\"arrow\")\n",
    "frame12.grid(row=2,column=3, sticky=\"NEWS\")\n",
    "tk.Label(frame9, text=\"Repeat\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame10, text=\"Repeat\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame11, text=\"Repeat\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame12, text=\"Repeat\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "#######\n",
    "frame13 = tk.LabelFrame(root, width=270, height=130, text = 'XDSL',\n",
    "            bg=\"light sea green\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"dot\")\n",
    "frame13.grid(row=3,column=0)\n",
    "\n",
    "frame14 = tk.LabelFrame(root, width=270, height=130, text = 'FF',\n",
    "            bg=\"bisque\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"arrow\")\n",
    "frame14.grid(row=3,column=1)\n",
    "\n",
    "frame15 = tk.LabelFrame(root, width=270, height=130, text = 'Voice',\n",
    "            bg=\"RosyBrown1\",\n",
    "            # bg=\"black\",\n",
    "            relief=tk.RAISED, borderwidth=5, \n",
    "            cursor=\"dot\")\n",
    "frame15.grid(row=3,column=2)\n",
    "\n",
    "frame16 = tk.LabelFrame(root, width=270, height=130, text = 'IPTV',\n",
    "            bg=\"khaki2\",\n",
    "            relief=tk.RAISED, borderwidth=5,\n",
    "            cursor=\"arrow\")\n",
    "frame16.grid(row=3,column=3)\n",
    "tk.Label(frame13, text=\"MTTR\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame14, text=\"MTTR\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame15, text=\"MTTR\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "tk.Label(frame16, text=\"MTTR\").grid(row=0,column=0, sticky=\"NEWS\")\n",
    "#####\n",
    "redDown = tk.PhotoImage(file=\"arrows/small-red-down.png\")\n",
    "redUp = tk.PhotoImage(file=\"arrows/small-red-up.png\")\n",
    "greenDown = tk.PhotoImage(file=\"arrows/small-green-down.png\")\n",
    "greenUp = tk.PhotoImage(file=\"arrows/small-green-up.png\")\n",
    "grayArrow = tk.PhotoImage(file=\"arrows/small-gray-right.png\")\n",
    "\n",
    "deniedMain = pd.read_excel('testdata.xlsx', sheet_name='denied', index_col='Region')\n",
    "deniedArrow = deniedMain.iloc[:,1:]\n",
    "\n",
    "def arrowReg(value=0):\n",
    "    return redDown if value < -0.5 else greenUp if value > 0.5 else grayArrow\n",
    "\n",
    "def arrowDenied(value=0):\n",
    "    return greenDown if value < -0.5 else redUp if value > 0.5 else grayArrow\n",
    "\n",
    "def myRows(frameName, bgColour, table_):\n",
    "    for i, txt in enumerate(table_.index.values):\n",
    "        lbl = tk.Label(frameName, text=txt, bg=bgColour, width=10, bd=1, relief=\"raised\")\n",
    "        lbl.grid(row=i+1, column=0, sticky=\"news\")\n",
    "        \n",
    "def myColumns(frameName, bgColour, table_):\n",
    "    for i, col in enumerate(table_.columns.values):\n",
    "        lbl = tk.Label(frameName, text=col, bg=bgColour, width=10, bd=1, relief=\"raised\")\n",
    "        lbl.grid(row=0, column=i*2+1, columnspan=2, sticky=\"news\")\n",
    "        \n",
    "def myTabel(frameName, bgColour, table_):\n",
    "    for i in range(4):\n",
    "        for j in range(4):\n",
    "            value = table_.iloc[i][j]\n",
    "            tk.Label(frameName, text=value, background=bgColour).grid(row=i+1, column=j*2+1, sticky='e')\n",
    "            myimg1 = arrowDenied(value)\n",
    "            tk.Label(frameName, image=myimg1, bg=bgColour).grid(row=i+1, column=j*2+2, sticky='w')\n",
    "\n",
    "tabel = pd.read_excel('testdata.xlsx', sheet_name='denied', index_col='Region')\n",
    "# Finally Add Rows\n",
    "myRows(frame1, \"pink\", tabel)\n",
    "myRows(frame2, \"pink\", tabel)\n",
    "myRows(frame3, \"pink\", tabel)\n",
    "myRows(frame4, \"pink\", tabel)\n",
    "myRows(frame5, \"pink\", tabel)\n",
    "myRows(frame6, \"pink\", tabel)\n",
    "myRows(frame7, \"pink\", tabel)\n",
    "myRows(frame8, \"pink\", tabel)\n",
    "myRows(frame9, \"pink\", tabel)\n",
    "myRows(frame10, \"pink\", tabel)\n",
    "myRows(frame11, \"pink\", tabel)\n",
    "myRows(frame12, \"pink\", tabel)\n",
    "myRows(frame13, \"pink\", tabel)\n",
    "myRows(frame14, \"pink\", tabel)\n",
    "myRows(frame15, \"pink\", tabel)\n",
    "myRows(frame16, \"pink\", tabel)\n",
    "# Finally add columns\n",
    "myColumns(frame1, 'beige', tabel)\n",
    "myColumns(frame2, 'beige', tabel)\n",
    "myColumns(frame3, 'beige', tabel)\n",
    "myColumns(frame4, 'beige', tabel)\n",
    "myColumns(frame5, 'beige', tabel)\n",
    "myColumns(frame6, 'beige', tabel)\n",
    "myColumns(frame6, 'beige', tabel)\n",
    "myColumns(frame7, 'beige', tabel)\n",
    "myColumns(frame8, 'beige', tabel)\n",
    "myColumns(frame9, 'beige', tabel)\n",
    "myColumns(frame10, 'beige', tabel)\n",
    "myColumns(frame11, 'beige', tabel)\n",
    "myColumns(frame12, 'beige', tabel)\n",
    "myColumns(frame13, 'beige', tabel)\n",
    "myColumns(frame14, 'beige', tabel)\n",
    "myColumns(frame15, 'beige', tabel)\n",
    "myColumns(frame16, 'beige', tabel)\n",
    "#NOW FINALLY THE TABLES\n",
    "myTabel(frame1, \"light sea green\", tabel)\n",
    "myTabel(frame2, \"bisque\", tabel)\n",
    "myTabel(frame3, \"RosyBrown1\", tabel)\n",
    "myTabel(frame4, \"khaki2\", tabel)\n",
    "myTabel(frame5, \"light sea green\", tabel)\n",
    "myTabel(frame6, \"bisque\", tabel)\n",
    "myTabel(frame7, \"RosyBrown1\", tabel)\n",
    "myTabel(frame8, \"khaki2\", tabel)\n",
    "myTabel(frame9, \"light sea green\", tabel)\n",
    "myTabel(frame10, \"bisque\", tabel)\n",
    "myTabel(frame11, \"RosyBrown1\", tabel)\n",
    "myTabel(frame12, \"khaki2\", tabel)\n",
    "myTabel(frame13, \"light sea green\", tabel)\n",
    "myTabel(frame14, \"bisque\", tabel)\n",
    "myTabel(frame15, \"RosyBrown1\", tabel)\n",
    "myTabel(frame16, \"khaki2\", tabel)\n",
    "\n",
    "root.mainloop()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "5a9cac12",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NoneType"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(fr0c0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "ceb9b879",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Current</th>\n",
       "      <th>Last Month</th>\n",
       "      <th>Last Year</th>\n",
       "      <th>Target</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Region</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>North</th>\n",
       "      <td>3</td>\n",
       "      <td>-7</td>\n",
       "      <td>-10</td>\n",
       "      <td>-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South</th>\n",
       "      <td>1</td>\n",
       "      <td>-4</td>\n",
       "      <td>-8</td>\n",
       "      <td>-6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Central</th>\n",
       "      <td>-1</td>\n",
       "      <td>-8</td>\n",
       "      <td>-4</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>National</th>\n",
       "      <td>1</td>\n",
       "      <td>-7</td>\n",
       "      <td>-8</td>\n",
       "      <td>-2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Current  Last Month  Last Year  Target\n",
       "Region                                          \n",
       "North           3          -7        -10     -10\n",
       "South           1          -4         -8      -6\n",
       "Central        -1          -8         -4      10\n",
       "National        1          -7         -8      -2"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabel = pd.read_excel('testdata.xlsx', sheet_name='denied', index_col='Region')\n",
    "tabel"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "012915a7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabel.iloc[0][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "b2a9ecab",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabel.loc[0][1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "3103691b",
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "4",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "File \u001b[1;32m~\\AppData\\Roaming\\Python\\Python310\\site-packages\\pandas\\core\\indexes\\range.py:391\u001b[0m, in \u001b[0;36mRangeIndex.get_loc\u001b[1;34m(self, key, method, tolerance)\u001b[0m\n\u001b[0;32m    390\u001b[0m \u001b[38;5;28;01mtry\u001b[39;00m:\n\u001b[1;32m--> 391\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_range\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mindex\u001b[49m\u001b[43m(\u001b[49m\u001b[43mnew_key\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m    392\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mValueError\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m err:\n",
      "\u001b[1;31mValueError\u001b[0m: 4 is not in range",
      "\nThe above exception was the direct cause of the following exception:\n",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[18], line 10\u001b[0m\n\u001b[0;32m      8\u001b[0m \u001b[38;5;28;01mfor\u001b[39;00m i \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mrange\u001b[39m(\u001b[38;5;241m4\u001b[39m):\n\u001b[0;32m      9\u001b[0m     \u001b[38;5;28;01mfor\u001b[39;00m j \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mrange\u001b[39m(\u001b[38;5;241m4\u001b[39m):\n\u001b[1;32m---> 10\u001b[0m         label \u001b[38;5;241m=\u001b[39m tk\u001b[38;5;241m.\u001b[39mLabel(root, text\u001b[38;5;241m=\u001b[39m\u001b[43mtabel\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mloc\u001b[49m\u001b[43m[\u001b[49m\u001b[43mi\u001b[49m\u001b[38;5;241;43m+\u001b[39;49m\u001b[38;5;241;43m1\u001b[39;49m\u001b[43m]\u001b[49m[j])\u001b[38;5;241m.\u001b[39mgrid(row\u001b[38;5;241m=\u001b[39mr,column\u001b[38;5;241m=\u001b[39mc)\n\u001b[0;32m     11\u001b[0m     r \u001b[38;5;241m+\u001b[39m\u001b[38;5;241m=\u001b[39m \u001b[38;5;241m1\u001b[39m\n\u001b[0;32m     13\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m r \u001b[38;5;241m>\u001b[39m MAX_ROWS:\n",
      "File \u001b[1;32m~\\AppData\\Roaming\\Python\\Python310\\site-packages\\pandas\\core\\indexing.py:1073\u001b[0m, in \u001b[0;36m_LocationIndexer.__getitem__\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m   1070\u001b[0m axis \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39maxis \u001b[38;5;129;01mor\u001b[39;00m \u001b[38;5;241m0\u001b[39m\n\u001b[0;32m   1072\u001b[0m maybe_callable \u001b[38;5;241m=\u001b[39m com\u001b[38;5;241m.\u001b[39mapply_if_callable(key, \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mobj)\n\u001b[1;32m-> 1073\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_getitem_axis\u001b[49m\u001b[43m(\u001b[49m\u001b[43mmaybe_callable\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43maxis\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43maxis\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32m~\\AppData\\Roaming\\Python\\Python310\\site-packages\\pandas\\core\\indexing.py:1312\u001b[0m, in \u001b[0;36m_LocIndexer._getitem_axis\u001b[1;34m(self, key, axis)\u001b[0m\n\u001b[0;32m   1310\u001b[0m \u001b[38;5;66;03m# fall thru to straight lookup\u001b[39;00m\n\u001b[0;32m   1311\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_validate_key(key, axis)\n\u001b[1;32m-> 1312\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_get_label\u001b[49m\u001b[43m(\u001b[49m\u001b[43mkey\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43maxis\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43maxis\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32m~\\AppData\\Roaming\\Python\\Python310\\site-packages\\pandas\\core\\indexing.py:1260\u001b[0m, in \u001b[0;36m_LocIndexer._get_label\u001b[1;34m(self, label, axis)\u001b[0m\n\u001b[0;32m   1258\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21m_get_label\u001b[39m(\u001b[38;5;28mself\u001b[39m, label, axis: \u001b[38;5;28mint\u001b[39m):\n\u001b[0;32m   1259\u001b[0m     \u001b[38;5;66;03m# GH#5567 this will fail if the label is not present in the axis.\u001b[39;00m\n\u001b[1;32m-> 1260\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mobj\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mxs\u001b[49m\u001b[43m(\u001b[49m\u001b[43mlabel\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43maxis\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43maxis\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[1;32m~\\AppData\\Roaming\\Python\\Python310\\site-packages\\pandas\\core\\generic.py:4056\u001b[0m, in \u001b[0;36mNDFrame.xs\u001b[1;34m(self, key, axis, level, drop_level)\u001b[0m\n\u001b[0;32m   4054\u001b[0m             new_index \u001b[38;5;241m=\u001b[39m index[loc]\n\u001b[0;32m   4055\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m-> 4056\u001b[0m     loc \u001b[38;5;241m=\u001b[39m \u001b[43mindex\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mget_loc\u001b[49m\u001b[43m(\u001b[49m\u001b[43mkey\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m   4058\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(loc, np\u001b[38;5;241m.\u001b[39mndarray):\n\u001b[0;32m   4059\u001b[0m         \u001b[38;5;28;01mif\u001b[39;00m loc\u001b[38;5;241m.\u001b[39mdtype \u001b[38;5;241m==\u001b[39m np\u001b[38;5;241m.\u001b[39mbool_:\n",
      "File \u001b[1;32m~\\AppData\\Roaming\\Python\\Python310\\site-packages\\pandas\\core\\indexes\\range.py:393\u001b[0m, in \u001b[0;36mRangeIndex.get_loc\u001b[1;34m(self, key, method, tolerance)\u001b[0m\n\u001b[0;32m    391\u001b[0m         \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_range\u001b[38;5;241m.\u001b[39mindex(new_key)\n\u001b[0;32m    392\u001b[0m     \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mValueError\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m err:\n\u001b[1;32m--> 393\u001b[0m         \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m(key) \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01merr\u001b[39;00m\n\u001b[0;32m    394\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_check_indexing_error(key)\n\u001b[0;32m    395\u001b[0m \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m(key)\n",
      "\u001b[1;31mKeyError\u001b[0m: 4"
     ]
    }
   ],
   "source": [
    "root = tk.Tk()\n",
    "root.title(\"Named Color Chart\")\n",
    "#     app = ColorChart(root)\n",
    "MAX_ROWS = 4\n",
    "r = 0\n",
    "c = 0\n",
    "\n",
    "for i in range(4):\n",
    "    for j in range(4):\n",
    "        label = tk.Label(root, text=tabel.loc[i][j]).grid(row=r,column=c)\n",
    "#         labelwImage = tk.Label(root, text=tabel.loc[i][j]).grid(row=r,column=c)\n",
    "    r += 1\n",
    "    \n",
    "    if r > MAX_ROWS:\n",
    "        r = 0\n",
    "        c += 1\n",
    "\n",
    "root.mainloop()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "61396095",
   "metadata": {},
   "outputs": [],
   "source": [
    "root = tk.Tk()\n",
    "myimg = arrowDenied(tabel.loc[0][1])\n",
    "panel11 = tk.Label(root, image = myimg)\n",
    "panel11.grid(row=1, column=1)\n",
    "myimg15 = arrowDenied(tabel.loc[3][4])\n",
    "panel23 = tk.Label(root, image = myimg15)\n",
    "panel23.grid(row=4, column=7)\n",
    "panel23t = tk.Label(root, text=tabel.loc[3][4],borderwidth=1, relief='raised')\n",
    "panel23t.grid(row=4, column=8)\n",
    "\n",
    "\n",
    "root.mainloop()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "859b50b3",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     Region  Current  Last Month  Last Year  Target\n",
      "0     North        3          -7        -10     -10\n",
      "1     South        1          -4         -8      -6\n",
      "2   Central       -1          -8         -4      10\n",
      "3  National        1          -7         -8      -2\n"
     ]
    }
   ],
   "source": [
    "from tkinter import *\n",
    "import tkinter as tk\n",
    "from tkinter import ttk\n",
    "\n",
    "from PIL import Image, ImageTk\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "tabel = pd.read_excel('testdata.xlsx', sheet_name='denied')\n",
    "print(tabel)\n",
    "\n",
    "redDown = r\"arrows/small-red-down.png\"\n",
    "redUp = r\"arrows/small-red-up.png\"\n",
    "greenDown = r\"arrows/small-green-down.png\"\n",
    "greenUp = r\"arrows/small-green-up.png\"\n",
    "grayArrow = r\"arrows/small-gray-right.png\"\n",
    "\n",
    "root = tk.Tk()\n",
    "# create columns\n",
    "lableCurrent = Label(root, text=\"Current\", bg=\"yellow\")\n",
    "lableCurrent.grid(row=0, column=1, columnspan=2)\n",
    "lableLM = Label(root, text=\"Last Month\", bg=\"yellow\")\n",
    "lableLM.grid(row=0, column=3, columnspan=2)\n",
    "lableLY = Label(root, text=\"Last Year\", bg=\"yellow\")\n",
    "lableLY.grid(row=0, column=5, columnspan=2)\n",
    "lableTarget = Label(root, text=\"Target\", bg=\"yellow\")\n",
    "lableTarget.grid(row=0, column=7, columnspan=2)\n",
    "\n",
    "\n",
    "# row labels\n",
    "lableNorth = Label(root, text=\"North\", bg=\"pink\")\n",
    "lableNorth.grid(row=1, column=0, sticky='w', rowspan=1)\n",
    "lableSouth = Label(root, text=\"South\", bg=\"pink\")\n",
    "lableSouth.grid(row=2, column=0, sticky='w', rowspan=1)\n",
    "lableCentral = Label(root, text=\"Central\", bg=\"pink\")\n",
    "lableCentral.grid(row=3, column=0, sticky='w', rowspan=1)\n",
    "lableNational = Label(root, text=\"NATIONAL\", bg=\"pink\")\n",
    "lableNational.grid(row=4, column=0, sticky='w', rowspan=1)\n",
    "\n",
    "def arrowDenied(value=-0):\n",
    "    if value < -0.5:\n",
    "        arrow = ImageTk.PhotoImage(Image.open(greenDown))\n",
    "    elif value > 0.5:\n",
    "        arrow = ImageTk.PhotoImage(Image.open(redUp))\n",
    "    else: arrow = ImageTk.PhotoImage(Image.open(grayArrow))\n",
    "    return arrow\n",
    "\n",
    "# Arrows row 1\n",
    "myimg = arrowDenied(tabel.loc[0][1])\n",
    "panel11 = tk.Label(root, image = myimg)\n",
    "# panel11.grid(row=1, column=1)\n",
    "panel11t = tk.Label(root, text = tabel.loc[0][1])\n",
    "panel11t.grid(row=1, column=2)\n",
    "\n",
    "myimg1 = arrowDenied(tabel.loc[0][2])\n",
    "panel12 = tk.Label(root, image = myimg1)\n",
    "panel12.grid(row=1, column=3)\n",
    "panel12t = tk.Label(root, text = tabel.loc[0][2] )\n",
    "panel12t.grid(row=1, column=4)\n",
    "\n",
    "myimg2 = arrowDenied(tabel.loc[0][3])\n",
    "panel13 = tk.Label(root, image = myimg2)\n",
    "panel13.grid(row=1, column=5)\n",
    "panel13t = tk.Label(root, text = tabel.loc[0][3])\n",
    "panel13t.grid(row=1, column=6)\n",
    "\n",
    "myimg3 = arrowDenied(tabel.loc[0][4])\n",
    "panel14 = tk.Label(root, image = myimg3)\n",
    "panel14.grid(row=1, column=7)\n",
    "panel14t = tk.Label(root, text=tabel.loc[0][4])\n",
    "panel14t.grid(row=1, column=8)\n",
    "\n",
    "# Arrows row 2\n",
    "myimg4 = arrowDenied(tabel.loc[1][1])\n",
    "panel15 = tk.Label(root, image = myimg4)\n",
    "# panel15.grid(row=2, column=1)\n",
    "panel15t = tk.Label(root, text = tabel.loc[1][1])\n",
    "panel15t.grid(row=2, column=2)\n",
    "\n",
    "myimg5 = arrowDenied(tabel.loc[1][2])\n",
    "panel13 = tk.Label(root, image = myimg5)\n",
    "panel13.grid(row=2, column=3)\n",
    "panel13t = tk.Label(root, text = tabel.loc[1][2])\n",
    "panel13t.grid(row=2, column=4)\n",
    "\n",
    "myimg6 = arrowDenied(tabel.loc[1][3])\n",
    "panel14 = tk.Label(root, image = myimg6)\n",
    "panel14.grid(row=2, column=5)\n",
    "panel14t = tk.Label(root, text = tabel.loc[1][3])\n",
    "panel14t.grid(row=2, column=6)\n",
    "\n",
    "myimg7 = arrowDenied(tabel.loc[1][4])\n",
    "panel15 = tk.Label(root, image = myimg7)\n",
    "panel15.grid(row=2, column=7)\n",
    "panel15t = tk.Label(root, text=tabel.loc[1][4])\n",
    "panel15t.grid(row=2, column=8)\n",
    "\n",
    "# Arrows row 3\n",
    "myimg8 = arrowDenied(tabel.loc[2][1])\n",
    "panel16 = tk.Label(root, image = myimg8)\n",
    "# panel16.grid(row=3, column=1)\n",
    "panel16t = tk.Label(root, text = tabel.loc[2][1])\n",
    "panel16t.grid(row=3, column=2)\n",
    "\n",
    "myimg9 = arrowDenied(tabel.loc[2][2])\n",
    "panel17 = tk.Label(root, image = myimg9)\n",
    "panel17.grid(row=3, column=3)\n",
    "panel17t = tk.Label(root, text = tabel.loc[2][2])\n",
    "panel17t.grid(row=3, column=4)\n",
    "\n",
    "myimg10 = arrowDenied(tabel.loc[2][3])\n",
    "panel18 = tk.Label(root, image = myimg10)\n",
    "panel18.grid(row=3, column=5)\n",
    "panel18t = tk.Label(root, text = tabel.loc[2][3])\n",
    "panel18t.grid(row=3, column=6)\n",
    "\n",
    "myimg11 = arrowDenied(tabel.loc[2][4])\n",
    "panel19 = tk.Label(root, image = myimg11)\n",
    "panel19.grid(row=3, column=7)\n",
    "panel19t = tk.Label(root, text=tabel.loc[2][4])\n",
    "panel19t.grid(row=3, column=8)\n",
    "\n",
    "# Arrows row 4\n",
    "myimg12 = arrowDenied(tabel.loc[3][1])\n",
    "panel20 = tk.Label(root, image = myimg12)\n",
    "# panel20.grid(row=4, column=1)\n",
    "panel20t = tk.Label(root, text = tabel.loc[3][1])\n",
    "panel20t.grid(row=4, column=2)\n",
    "\n",
    "myimg13 = arrowDenied(tabel.loc[3][2])\n",
    "panel21 = tk.Label(root, image = myimg13)\n",
    "panel21.grid(row=4, column=3)\n",
    "panel21t = tk.Label(root, text = tabel.loc[3][2])\n",
    "panel21t.grid(row=4, column=4)\n",
    "\n",
    "myimg14 = arrowDenied(tabel.loc[3][3])\n",
    "panel22 = tk.Label(root, image = myimg14)\n",
    "panel22.grid(row=4, column=5)\n",
    "panel22t = tk.Label(root, text = tabel.loc[3][3])\n",
    "panel22t.grid(row=4, column=6)\n",
    "\n",
    "myimg15 = arrowDenied(tabel.loc[3][4])\n",
    "panel23 = tk.Label(root, image = myimg15)\n",
    "panel23.grid(row=4, column=7)\n",
    "panel23t = tk.Label(root, text=tabel.loc[3][4])\n",
    "panel23t.grid(row=4, column=8)\n",
    "\n",
    "root.mainloop()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "18014886",
   "metadata": {},
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "invalid syntax (691242658.py, line 1)",
     "output_type": "error",
     "traceback": [
      "\u001b[1;36m  Cell \u001b[1;32mIn[2], line 1\u001b[1;36m\u001b[0m\n\u001b[1;33m    Region\tCurrent\tLast Month\tLast Year\tTarget\u001b[0m\n\u001b[1;37m          \t^\u001b[0m\n\u001b[1;31mSyntaxError\u001b[0m\u001b[1;31m:\u001b[0m invalid syntax\n"
     ]
    }
   ],
   "source": [
    "\tRegion\tCurrent\tLast Month\tLast Year\tTarget\n",
    "0\tNorth\t3\t-7\t-10\t-10\n",
    "1\tSouth\t1\t-4\t-8\t-6\n",
    "2\tCentral\t-1\t-8\t-4\t10\n",
    "3\tNational\t1\t-7\t-8\t-"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0f460dae",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6f26790d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}