minor project.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np # linear algebra\n",
    "import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "characters_df = pd.read_csv(\"./characters_stats.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Name</th>\n",
       "      <th>Alignment</th>\n",
       "      <th>Intelligence</th>\n",
       "      <th>Strength</th>\n",
       "      <th>Speed</th>\n",
       "      <th>Durability</th>\n",
       "      <th>Power</th>\n",
       "      <th>Combat</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>A-Bomb</td>\n",
       "      <td>good</td>\n",
       "      <td>38</td>\n",
       "      <td>100</td>\n",
       "      <td>17</td>\n",
       "      <td>80</td>\n",
       "      <td>17</td>\n",
       "      <td>64</td>\n",
       "      <td>316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Adam Strange</td>\n",
       "      <td>good</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Agent  13</td>\n",
       "      <td>good</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Agent Zero</td>\n",
       "      <td>good</td>\n",
       "      <td>75</td>\n",
       "      <td>28</td>\n",
       "      <td>38</td>\n",
       "      <td>80</td>\n",
       "      <td>72</td>\n",
       "      <td>95</td>\n",
       "      <td>388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Alan Scott</td>\n",
       "      <td>good</td>\n",
       "      <td>63</td>\n",
       "      <td>80</td>\n",
       "      <td>23</td>\n",
       "      <td>90</td>\n",
       "      <td>98</td>\n",
       "      <td>32</td>\n",
       "      <td>386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>188</td>\n",
       "      <td>Winter Soldier</td>\n",
       "      <td>good</td>\n",
       "      <td>56</td>\n",
       "      <td>32</td>\n",
       "      <td>35</td>\n",
       "      <td>65</td>\n",
       "      <td>60</td>\n",
       "      <td>84</td>\n",
       "      <td>332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>189</td>\n",
       "      <td>Wolverine</td>\n",
       "      <td>good</td>\n",
       "      <td>55</td>\n",
       "      <td>32</td>\n",
       "      <td>38</td>\n",
       "      <td>100</td>\n",
       "      <td>44</td>\n",
       "      <td>100</td>\n",
       "      <td>369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>190</td>\n",
       "      <td>Wonder Woman</td>\n",
       "      <td>good</td>\n",
       "      <td>88</td>\n",
       "      <td>100</td>\n",
       "      <td>50</td>\n",
       "      <td>100</td>\n",
       "      <td>42</td>\n",
       "      <td>100</td>\n",
       "      <td>480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>191</td>\n",
       "      <td>Yellowjacket</td>\n",
       "      <td>good</td>\n",
       "      <td>88</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>192</td>\n",
       "      <td>y</td>\n",
       "      <td>good</td>\n",
       "      <td>75</td>\n",
       "      <td>10</td>\n",
       "      <td>23</td>\n",
       "      <td>28</td>\n",
       "      <td>100</td>\n",
       "      <td>56</td>\n",
       "      <td>292</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>193 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Name Alignment  Intelligence  Strength  Speed  Durability  \\\n",
       "0            A-Bomb      good            38       100     17          80   \n",
       "1      Adam Strange      good             1         1      1           1   \n",
       "2         Agent  13      good             1         1      1           1   \n",
       "3        Agent Zero      good            75        28     38          80   \n",
       "4        Alan Scott      good            63        80     23          90   \n",
       "..              ...       ...           ...       ...    ...         ...   \n",
       "188  Winter Soldier      good            56        32     35          65   \n",
       "189       Wolverine      good            55        32     38         100   \n",
       "190    Wonder Woman      good            88       100     50         100   \n",
       "191    Yellowjacket      good            88        10     12          28   \n",
       "192               y      good            75        10     23          28   \n",
       "\n",
       "     Power  Combat  Total  \n",
       "0       17      64    316  \n",
       "1        0       1      5  \n",
       "2        0       1      5  \n",
       "3       72      95    388  \n",
       "4       98      32    386  \n",
       "..     ...     ...    ...  \n",
       "188     60      84    332  \n",
       "189     44     100    369  \n",
       "190     42     100    480  \n",
       "191     12      14    164  \n",
       "192    100      56    292  \n",
       "\n",
       "[193 rows x 9 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "characters_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Name</th>\n",
       "      <th>Alignment</th>\n",
       "      <th>Intelligence</th>\n",
       "      <th>Strength</th>\n",
       "      <th>Speed</th>\n",
       "      <th>Durability</th>\n",
       "      <th>Power</th>\n",
       "      <th>Combat</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>A-Bomb</td>\n",
       "      <td>good</td>\n",
       "      <td>38</td>\n",
       "      <td>100</td>\n",
       "      <td>17</td>\n",
       "      <td>80</td>\n",
       "      <td>17</td>\n",
       "      <td>64</td>\n",
       "      <td>316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Adam Strange</td>\n",
       "      <td>good</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Agent  13</td>\n",
       "      <td>good</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Agent Zero</td>\n",
       "      <td>good</td>\n",
       "      <td>75</td>\n",
       "      <td>28</td>\n",
       "      <td>38</td>\n",
       "      <td>80</td>\n",
       "      <td>72</td>\n",
       "      <td>95</td>\n",
       "      <td>388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Alan Scott</td>\n",
       "      <td>good</td>\n",
       "      <td>63</td>\n",
       "      <td>80</td>\n",
       "      <td>23</td>\n",
       "      <td>90</td>\n",
       "      <td>98</td>\n",
       "      <td>32</td>\n",
       "      <td>386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>188</td>\n",
       "      <td>Winter Soldier</td>\n",
       "      <td>good</td>\n",
       "      <td>56</td>\n",
       "      <td>32</td>\n",
       "      <td>35</td>\n",
       "      <td>65</td>\n",
       "      <td>60</td>\n",
       "      <td>84</td>\n",
       "      <td>332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>189</td>\n",
       "      <td>Wolverine</td>\n",
       "      <td>good</td>\n",
       "      <td>55</td>\n",
       "      <td>32</td>\n",
       "      <td>38</td>\n",
       "      <td>100</td>\n",
       "      <td>44</td>\n",
       "      <td>100</td>\n",
       "      <td>369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>190</td>\n",
       "      <td>Wonder Woman</td>\n",
       "      <td>good</td>\n",
       "      <td>88</td>\n",
       "      <td>100</td>\n",
       "      <td>50</td>\n",
       "      <td>100</td>\n",
       "      <td>42</td>\n",
       "      <td>100</td>\n",
       "      <td>480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>191</td>\n",
       "      <td>Yellowjacket</td>\n",
       "      <td>good</td>\n",
       "      <td>88</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>192</td>\n",
       "      <td>y</td>\n",
       "      <td>good</td>\n",
       "      <td>75</td>\n",
       "      <td>10</td>\n",
       "      <td>23</td>\n",
       "      <td>28</td>\n",
       "      <td>100</td>\n",
       "      <td>56</td>\n",
       "      <td>292</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>193 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Name Alignment  Intelligence  Strength  Speed  Durability  \\\n",
       "0            A-Bomb      good            38       100     17          80   \n",
       "1      Adam Strange      good             1         1      1           1   \n",
       "2         Agent  13      good             1         1      1           1   \n",
       "3        Agent Zero      good            75        28     38          80   \n",
       "4        Alan Scott      good            63        80     23          90   \n",
       "..              ...       ...           ...       ...    ...         ...   \n",
       "188  Winter Soldier      good            56        32     35          65   \n",
       "189       Wolverine      good            55        32     38         100   \n",
       "190    Wonder Woman      good            88       100     50         100   \n",
       "191    Yellowjacket      good            88        10     12          28   \n",
       "192               y      good            75        10     23          28   \n",
       "\n",
       "     Power  Combat  Total  \n",
       "0       17      64    316  \n",
       "1        0       1      5  \n",
       "2        0       1      5  \n",
       "3       72      95    388  \n",
       "4       98      32    386  \n",
       "..     ...     ...    ...  \n",
       "188     60      84    332  \n",
       "189     44     100    369  \n",
       "190     42     100    480  \n",
       "191     12      14    164  \n",
       "192    100      56    292  \n",
       "\n",
       "[193 rows x 9 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# characters_df.shape[0]\n",
    "characters_df.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# df1 = characters_df['Name'].str.contains(\"Zatanna\")\n",
    "# type(df1)\n",
    "# df = characters_df['Name']=='Zatanna'\n",
    "# type(df)\n",
    "\n",
    "def hero_exists(hero_name):\n",
    "    flag = False\n",
    "    for name in characters_df['Name']:\n",
    "        if name==hero_name:\n",
    "            return True\n",
    "    else:\n",
    "        return False\n",
    "hero_exists(\"Yellowjacket\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "194"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "characters_df.index[characters_df['Name'] == \"x\"].tolist()[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = pd.DataFrame({\"Name\":[name.get(),], \"Alignment\":[alignment.get(),], \"Intelligence\":[intelligence.get(),], \"Strength\":[strength.get(),], \"Speed\":[speed.get(),], \"Durability\":[durability.get(),], \"Power\":[power.get(),], \"Combat\":[combat.get(),], \"Total\":[intelligence.get()+strength.get()+speed.get()+durability.get()+power.get()+combat.get()]})\n",
    "\n",
    "characters_df = characters_df.append(df1, ignore_index = True) \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "name_arr=[]\n",
    "for val in characters_arr:\n",
    "    name_arr.append(val[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "len(characters_arr)\n",
    "name_arr = characters_arr[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['A-Bomb', 'good', 38, 100, 17, 80, 17, 64, 316], dtype=object)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "name_arr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Exception in Tkinter callback\n",
      "Traceback (most recent call last):\n",
      "  File \"C:\\ProgramData\\Anaconda3\\lib\\tkinter\\__init__.py\", line 1705, in __call__\n",
      "    return self.func(*args)\n",
      "  File \"<ipython-input-4-1d269dc64cad>\", line 180, in delRec\n",
      "    characters_df.to_csv('./characters_stats.csv')\n",
      "  File \"C:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\core\\generic.py\", line 3228, in to_csv\n",
      "    formatter.save()\n",
      "  File \"C:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\formats\\csvs.py\", line 183, in save\n",
      "    compression=self.compression,\n",
      "  File \"C:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\common.py\", line 399, in _get_handle\n",
      "    f = open(path_or_buf, mode, encoding=encoding, newline=\"\")\n",
      "PermissionError: [Errno 13] Permission denied: './characters_stats.csv'\n"
     ]
    }
   ],
   "source": [
    "import tkinter as tk\n",
    "from tkinter import ttk\n",
    "from tkinter import messagebox\n",
    "form = tk.Tk()\n",
    "form.title(\"SUPER HEROES\")\n",
    "# form.geometory(\"1024*768\")\n",
    "form.resizable(True, True)\n",
    "\n",
    "tab_parent = ttk.Notebook(form)\n",
    "tab_parent.pack(expand = 1, fill='both')\n",
    "\n",
    "tab1 = tk.Frame(tab_parent)\n",
    "tab2 = tk.Frame(tab_parent)\n",
    "\n",
    "tab_parent.add(tab1, text = \"TAB1\")\n",
    "tab_parent.add(tab2, text = \"TAB2\")\n",
    "\n",
    "\n",
    "label_name = tk.Label(tab1, text = \"NAME\", font=(\"cambria\",13,\"bold\"), bg=\"black\",fg=\"white\", width = 20, anchor = 'c')\n",
    "label_name.grid(column = 0, row = 0, padx = 8, pady = 4)\n",
    "name = tk.StringVar()\n",
    "nameEntered = tk.Entry(tab1, textvariable = name, width = 45, font=(\"arial black\",13),bg=\"orange\")\n",
    "nameEntered.grid(column = 1, row = 0, columnspan=3)\n",
    "\n",
    "label_alignment = tk.Label(tab1, text = \"ALIGNMENT\", font=(\"cambria\",13,\"bold\"), bg=\"black\",fg=\"white\", width = 20, anchor = 'c')\n",
    "label_alignment.grid(column = 0, row = 1, padx = 8, pady = 4)\n",
    "alignment = tk.StringVar()\n",
    "alignmentEntered = tk.Entry(tab1, textvariable = alignment, font=(\"arial black\",13),bg=\"orange\")\n",
    "alignmentEntered.grid(column = 1, row = 1, columnspan=3)\n",
    "\n",
    "label_intelligence = tk.Label(tab1, text = \"INTELLIGENCE\", font=(\"cambria\",13,\"bold\"), bg=\"black\",fg=\"white\", width = 20, anchor = 'c')\n",
    "label_intelligence.grid(column = 0, row = 2, padx = 8, pady = 4)\n",
    "intelligence = tk.IntVar()\n",
    "intelligenceEntered = tk.Entry(tab1, textvariable = intelligence, font=(\"arial black\",13),bg=\"orange\")\n",
    "intelligenceEntered.grid(column = 1, row = 2, columnspan=3)\n",
    "\n",
    "label_strength = tk.Label(tab1, text = \"STRENGTH\", font=(\"cambria\",13,\"bold\"), bg=\"black\",fg=\"white\", width = 20, anchor = 'c')\n",
    "label_strength.grid(column = 0, row = 3, padx = 8, pady = 4)\n",
    "strength = tk.IntVar()\n",
    "strengthEntered = tk.Entry(tab1, textvariable = strength, font=(\"arial black\",13),bg=\"orange\")\n",
    "strengthEntered.grid(column = 1, row = 3, columnspan=3)\n",
    "\n",
    "label_speed = tk.Label(tab1, text = \"SPEED\", font=(\"cambria\",13,\"bold\"), bg=\"black\",fg=\"white\", width = 20, anchor = 'c')\n",
    "label_speed.grid(column = 0, row = 4, padx = 8, pady = 4)\n",
    "speed = tk.IntVar()\n",
    "speedEntered = tk.Entry(tab1, textvariable = speed, font=(\"arial black\",13),bg=\"orange\")\n",
    "speedEntered.grid(column = 1, row = 4, columnspan=3)\n",
    "\n",
    "label_durability = tk.Label(tab1, text = \"DURABILITY\", font=(\"cambria\",13,\"bold\"), bg=\"black\",fg=\"white\", width = 20, anchor = 'c')\n",
    "label_durability.grid(column = 0, row = 5, padx = 8, pady = 4)\n",
    "durability = tk.IntVar()\n",
    "durabilityEntered = tk.Entry(tab1, textvariable = durability, font=(\"arial black\",13),bg=\"orange\")\n",
    "durabilityEntered.grid(column = 1, row = 5, columnspan=3)\n",
    "\n",
    "label_power = tk.Label(tab1, text = \"POWER\", font=(\"cambria\",13,\"bold\"), bg=\"black\",fg=\"white\", width = 20, anchor = 'c')\n",
    "label_power.grid(column = 0, row = 6, padx = 8, pady = 4)\n",
    "power = tk.IntVar()\n",
    "powerEntered = tk.Entry(tab1, textvariable = power, font=(\"arial black\",13),bg=\"orange\")\n",
    "powerEntered.grid(column = 1, row = 6, columnspan=3)\n",
    "\n",
    "label_combat = tk.Label(tab1, text = \"COMBAT\", font=(\"cambria\",13,\"bold\"), bg=\"black\",fg=\"white\", width = 20, anchor = 'c')\n",
    "label_combat.grid(column = 0, row = 7, padx = 8, pady = 4)\n",
    "combat = tk.IntVar()\n",
    "combatEntered = tk.Entry(tab1, textvariable = combat, font=(\"arial black\",13),bg=\"orange\")\n",
    "combatEntered.grid(column = 1, row = 7, columnspan=3)\n",
    "\n",
    "label_total = tk.Label(tab1, text = \"TOTAL\", font=(\"cambria\",13,\"bold\"), bg=\"black\",fg=\"white\", width = 20, anchor = 'c')\n",
    "label_total.grid(column = 0, row = 8, padx = 8, pady = 4)\n",
    "total = tk.IntVar()\n",
    "totalEntered = tk.Entry(tab1, textvariable = total, font=(\"arial black\",13),bg=\"orange\",  state='disabled')\n",
    "totalEntered.grid(column = 1, row = 8, columnspan=3)\n",
    "\n",
    "count = 0\n",
    "tot_rec = characters_df.shape[0]\n",
    "\n",
    "def firstRec():\n",
    "    global count\n",
    "    global tot_rec\n",
    "    count = 0\n",
    "    tot_rec = characters_df.shape[0]\n",
    "    name.set(characters_df.at[count, \"Name\"])\n",
    "    alignment.set(characters_df.at[count, \"Alignment\"])\n",
    "    intelligence.set(characters_df.at[count, \"Intelligence\"])\n",
    "    strength.set(characters_df.at[count, \"Strength\"])\n",
    "    speed.set(characters_df.at[count, \"Speed\"])\n",
    "    durability.set(characters_df.at[count, \"Durability\"])\n",
    "    power.set(characters_df.at[count, \"Power\"])\n",
    "    combat.set(characters_df.at[count, \"Combat\"])\n",
    "    total.set(characters_df.at[count, \"Total\"])\n",
    "    l5.configure(text=str(count+1)+\"/\"+str(tot_rec))\n",
    "def preRec():\n",
    "    global count\n",
    "    global tot_rec\n",
    "    if count == 0:\n",
    "         tk.messagebox.showinfo(\"WARNING\", \"Already on first record\")\n",
    "    else:\n",
    "        count -= 1\n",
    "        tot_rec = characters_df.shape[0]\n",
    "        name.set(characters_df.at[count, \"Name\"])\n",
    "        alignment.set(characters_df.at[count, \"Alignment\"])\n",
    "        intelligence.set(characters_df.at[count, \"Intelligence\"])\n",
    "        strength.set(characters_df.at[count, \"Strength\"])\n",
    "        speed.set(characters_df.at[count, \"Speed\"])\n",
    "        durability.set(characters_df.at[count, \"Durability\"])\n",
    "        power.set(characters_df.at[count, \"Power\"])\n",
    "        combat.set(characters_df.at[count, \"Combat\"])\n",
    "        total.set(characters_df.at[count, \"Total\"])\n",
    "        l5.configure(text=str(count+1)+\"/\"+str(tot_rec))\n",
    "def nextRec():\n",
    "    global count\n",
    "    global tot_rec\n",
    "    if count == tot_rec-1:\n",
    "         tk.messagebox.showinfo(\"WARNING\", \"Already on last record\")\n",
    "    else:\n",
    "        count += 1\n",
    "        tot_rec = characters_df.shape[0]\n",
    "        name.set(characters_df.at[count, \"Name\"])\n",
    "        alignment.set(characters_df.at[count, \"Alignment\"])\n",
    "        intelligence.set(characters_df.at[count, \"Intelligence\"])\n",
    "        strength.set(characters_df.at[count, \"Strength\"])\n",
    "        speed.set(characters_df.at[count, \"Speed\"])\n",
    "        durability.set(characters_df.at[count, \"Durability\"])\n",
    "        power.set(characters_df.at[count, \"Power\"])\n",
    "        combat.set(characters_df.at[count, \"Combat\"])\n",
    "        total.set(characters_df.at[count, \"Total\"])\n",
    "        l5.configure(text=str(count+1)+\"/\"+str(tot_rec))\n",
    "def lastRec():\n",
    "    global count\n",
    "    global tot_rec\n",
    "    tot_rec = characters_df.shape[0]\n",
    "    count = characters_df.shape[0] - 1\n",
    "    name.set(characters_df.at[count, \"Name\"])\n",
    "    alignment.set(characters_df.at[count, \"Alignment\"])\n",
    "    intelligence.set(characters_df.at[count, \"Intelligence\"])\n",
    "    strength.set(characters_df.at[count, \"Strength\"])\n",
    "    speed.set(characters_df.at[count, \"Speed\"])\n",
    "    durability.set(characters_df.at[count, \"Durability\"])\n",
    "    power.set(characters_df.at[count, \"Power\"])\n",
    "    combat.set(characters_df.at[count, \"Combat\"])\n",
    "    total.set(characters_df.at[count, \"Total\"])\n",
    "    \n",
    "    l5.configure(text=str(count+1)+\"/\"+str(tot_rec))\n",
    "    \n",
    "def hero_exists(hero_name):\n",
    "    flag = False\n",
    "    for name in characters_df['Name']:\n",
    "        if name==hero_name:\n",
    "            return True\n",
    "    else:\n",
    "        return False\n",
    "            \n",
    "def addRec():\n",
    "    global count\n",
    "    global characters_df\n",
    "    global total_rec\n",
    "    flag = False\n",
    "    if hero_exists(name.get()) == True:\n",
    "        messagebox.showinfo(\"MESSAGE\", \"SuperHero already exists\")\n",
    "    else:\n",
    "        df1 = pd.DataFrame({\"Name\":[name.get(),], \"Alignment\":[alignment.get(),], \"Intelligence\":[intelligence.get(),], \"Strength\":[strength.get(),], \"Speed\":[speed.get(),], \"Durability\":[durability.get(),], \"Power\":[power.get(),], \"Combat\":[combat.get(),], \"Total\":[intelligence.get()+strength.get()+speed.get()+durability.get()+power.get()+combat.get()]})\n",
    "        total.set(intelligence.get()+strength.get()+speed.get()+durability.get()+power.get()+combat.get())\n",
    "        characters_df = characters_df.append(df1, ignore_index = True) \n",
    "        tot_rec = characters_df.shape[0]\n",
    "        count = characters_df.shape[0] - 1\n",
    "        l5.configure(text=str(count+1)+\"/\"+str(tot_rec))\n",
    "        messagebox.showinfo(\"MESSAGE\", \"Addition Successful\")\n",
    "        characters_df.to_csv('./characters_stats.csv') \n",
    "#         clear()\n",
    "def delRec():\n",
    "    global count\n",
    "    global characters_df\n",
    "    if hero_exists(name.get()) == False:\n",
    "        messagebox.showinfo(\"MESSAGE\", \"SuperHero does not exist\")\n",
    "    else:\n",
    "        characters_df = characters_df.drop(characters_df.index[characters_df['Name'] == name.get()].tolist()[0])\n",
    "        characters_df = characters_df.reset_index(drop=True)\n",
    "        count = 0\n",
    "        tot_rec = characters_df.shape[0]\n",
    "        l5.configure(text=str(count)+\"/\"+str(tot_rec))\n",
    "        characters_df.to_csv('./characters_stats.csv') \n",
    "        messagebox.showinfo(\"MESSAGE\", \"Deletion Successful\")\n",
    "        clear()\n",
    "        \n",
    "# Cannot update name\n",
    "def updateRec():\n",
    "    global count\n",
    "    global characters_df\n",
    "    if hero_exists(name.get()) == False:\n",
    "        messagebox.showinfo(\"MESSAGE\", \"SuperHero does not exist\")\n",
    "    else:\n",
    "        row_index = characters_df.index[characters_df['Name'] == name.get()].tolist()[0]\n",
    "        characters_df.at[count, \"Name\"]\n",
    "        characters_df.at[count, \"Alignment\"]\n",
    "        characters_df.at[count, \"Intelligence\"]\n",
    "        characters_df.at[count, \"Strength\"]\n",
    "        characters_df.at[count, \"Speed\"]\n",
    "        characters_df.at[count, \"Durability\"]\n",
    "        characters_df.at[count, \"Power\"]\n",
    "        characters_df.at[count, \"Combat\"]\n",
    "        characters_df.at[count, \"Total\"]\n",
    "                 \n",
    "        characters_df = characters_df.drop(characters_df.index[characters_df['Name'] == name.get()].tolist()[0])\n",
    "        characters_df = characters_df.reset_index(drop=True)\n",
    "        count = 0\n",
    "        tot_rec = characters_df.shape[0]\n",
    "        l5.configure(text=str(count)+\"/\"+str(tot_rec))\n",
    "        characters_df.to_csv('./characters_stats.csv') \n",
    "        messagebox.showinfo(\"MESSAGE\", \"Deletion Successful\")\n",
    "        clear()\n",
    "def searchRec():\n",
    "    a = 5\n",
    "def clear():\n",
    "    nameEntered.delete(first=0, last=999)\n",
    "    alignmentEntered.delete(first=0, last=999)\n",
    "    intelligenceEntered.delete(first=0, last=999)\n",
    "    strengthEntered.delete(first=0, last=999)\n",
    "    speedEntered.delete(first=0, last=999)\n",
    "    durabilityEntered.delete(first=0, last=999)\n",
    "    powerEntered.delete(first=0, last=999)\n",
    "    combatEntered.delete(first=0, last=999)\n",
    "    totalEntered.delete(first=0, last=999)\n",
    "clear()\n",
    "\n",
    "b1 = tk.Button(tab1, width=\"8\", text=\"|<\", command=firstRec, font=(\"cambria\",13,\"bold\"))\n",
    "b1.grid(row=9, column=0, padx=10, pady=10)\n",
    "b2 = tk.Button(tab1, width=\"8\", text=\"<\", command=preRec, font=(\"cambria\",13,\"bold\"))\n",
    "b2.grid(row=9, column=1)\n",
    "b3 = tk.Button(tab1, width=\"8\", text=\">\", command=nextRec, font=(\"cambria\",13,\"bold\"))\n",
    "b3.grid(row=9, column=2)\n",
    "b4 = tk.Button(tab1, width=\"8\", text=\">|\", command=lastRec, font=(\"cambria\",13,\"bold\"))\n",
    "b4.grid(row=9, column=3)\n",
    "b5 = tk.Button(tab1, width=\"10\",text=\"ADD\", command=addRec, font=(\"cambria\",13,\"bold\"))\n",
    "b5.grid(row=10, column=0, padx=10, pady=10)\n",
    "b6 = tk.Button(tab1,width=\"10\",text=\"DELETE\", command=delRec, font=(\"cambria\",13,\"bold\"))\n",
    "b6.grid(row=10,column=1)\n",
    "b7 = tk.Button(tab1, width=\"10\", text=\"UPDATE\", command=updateRec, font=(\"cambria\",13,\"bold\"))\n",
    "b7.grid(row=10,column=2)\n",
    "b8 = tk.Button(tab1, width=\"10\", text=\"CLEAR ALL\", command=clear, font=(\"cambria\",13,\"bold\"))\n",
    "b8.grid(row=10,column=3)\n",
    "\n",
    "\n",
    "l5 = tk.Label(tab1 ,text=str(count)+\"/\"+str(tot_rec),font=(\"cambria\",15,\"bold\"),bg=\"white\", width=20, anchor=\"c\")\n",
    "l5.grid(row=11,column=1,columnspan=2)\n",
    "l5.configure(text=str(count)+\"/\"+str(tot_rec))\n",
    "\n",
    "form.mainloop()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "ename": "IndexError",
     "evalue": "list index out of range",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mIndexError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-8-c6dec96d4c4b>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mcharacters_df\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mcharacters_df\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'Name'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m\"x\"\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtolist\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mIndexError\u001b[0m: list index out of range"
     ]
    }
   ],
   "source": [
    "characters_df.index[characters_df['Name'] == \"x\"].tolist()[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9223372036854775807"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sys.maxsize"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "x = [\"a\",]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tkinter as tk\n",
    "form = tk.Tk()\n",
    "from tkinter import colorchooser\n",
    "\n",
    "rgb_color, web_color = colorchooser.askcolor(parent=form,\n",
    "                                             initialcolor=(255, 0, 0))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}