Database_1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "a93821db",
   "metadata": {},
   "outputs": [],
   "source": [
    "# connecting to the local Mysql database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "96d4579b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: mysql-connector-python in c:\\users\\naman jain\\anaconda3\\lib\\site-packages (8.0.27)Note: you may need to restart the kernel to use updated packages.\n",
      "Requirement already satisfied: protobuf>=3.0.0 in c:\\users\\naman jain\\anaconda3\\lib\\site-packages (from mysql-connector-python) (3.19.1)\n",
      "\n"
     ]
    }
   ],
   "source": [
    "pip install mysql-connector-python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "50325d63",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Connecting to the database "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f2f15753",
   "metadata": {},
   "outputs": [],
   "source": [
    "import mysql.connector as connection"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ae8dce5b",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"show databases\" # checking all the databases available in Mysql\n",
    "    \n",
    "    cursor.execute(query) \n",
    "    \n",
    "    print(cursor.fetchall())\n",
    "\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "a40f3885",
   "metadata": {},
   "outputs": [],
   "source": [
    "mydb=connection.connect(host=\"localhost\",user=\"root\",passwd=\"1234\",use_pure=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "a6587dfa",
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor = mydb.cursor()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "91de9929",
   "metadata": {},
   "outputs": [],
   "source": [
    "query = \"show databases\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "62b19808",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NoneType"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(cursor.execute(query))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "b08ab6a4",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('information_schema',),\n",
       " ('mysql',),\n",
       " ('performance_schema',),\n",
       " ('property_sale',),\n",
       " ('sakila',),\n",
       " ('students',),\n",
       " ('sys',),\n",
       " ('world',)]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cursor.fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "e9e37b98",
   "metadata": {},
   "outputs": [],
   "source": [
    "f=[('information_schema',),\n",
    " ('mysql',),\n",
    " ('performance_schema',),\n",
    " ('property_sale',),\n",
    " ('sakila',),\n",
    " ('students',),\n",
    " ('sys',),\n",
    " ('world',)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "ba08410f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f.index(('students',))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "c5abf810",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'students'"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f[5][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "e781801c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('information_schema',), ('mysql',), ('performance_schema',), ('property_sale',), ('sakila',), ('students',), ('sys',), ('world',)]\n"
     ]
    }
   ],
   "source": [
    "\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"show databases\" # checking all the databases available in Mysql\n",
    "    \n",
    "    cursor.execute(query) \n",
    "    \n",
    "    print(cursor.fetchall())\n",
    "\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "04714941",
   "metadata": {},
   "outputs": [],
   "source": [
    "# create database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "21d5e250",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Database created\n"
     ]
    }
   ],
   "source": [
    "\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"create database Student1\" # checking all the databases available in Mysql\n",
    "    \n",
    "    cursor.execute(query) \n",
    "    \n",
    "    print(\"Database created\")\n",
    "\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "efef16c8",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Checking for the databases already available"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "301004b7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('information_schema',), ('mysql',), ('performance_schema',), ('property_sale',), ('sakila',), ('student1',), ('students',), ('sys',), ('world',)]\n"
     ]
    }
   ],
   "source": [
    "\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"show databases\" # checking all the databases available in Mysql\n",
    "    \n",
    "    cursor.execute(query) \n",
    "    \n",
    "    print(cursor.fetchall())\n",
    "\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "b1099152",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a table in the data base"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "a0456fe3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Table Created\n"
     ]
    }
   ],
   "source": [
    "\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",database=\"student1\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"Create table studentdetails (Studentid INT(10) AUTO_INCREMENT PRIMARY KEY, Firstname VARCHAR(20), Lname VARCHAR(20), RegistrationDate DATE, Section VARCHAR(10))\" # checking all the databases available in Mysql\n",
    "    \n",
    "    cursor.execute(query) \n",
    "    \n",
    "    print(\"Table Created\")\n",
    "    mydb.close()\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "4ed3c305",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1050 (42S01): Table 'studentdetails' already exists\n"
     ]
    }
   ],
   "source": [
    "# when table is already present, cant create table with the same name\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",database=\"student1\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"Create table studentdetails (Studentid INT(10) AUTO_INCREMENT PRIMARY KEY, Firstname VARCHAR(20), Lname VARCHAR(20), RegistrationDate DATE, Section VARCHAR(10))\" # checking all the databases available in Mysql\n",
    "    \n",
    "    cursor.execute(query) \n",
    "    \n",
    "    print(\"Table Created\")\n",
    "    mydb.close()\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "72f1e99e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "b1f3b820",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Inserting the data into the table created in the database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "a7e400ce",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data Inserted into the table\n"
     ]
    }
   ],
   "source": [
    "\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",database=\"student1\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"Insert into studentdetails value (1134,'Schin','Kumar','1997-11-11','Eleventh')\" \n",
    "    \n",
    "    cursor.execute(query) \n",
    "    mydb.commit()\n",
    "    print(\"Data Inserted into the table\")\n",
    "    mydb.close()\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "2132ca4c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# date format YYYY-MM-DD"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "5cf6d294",
   "metadata": {},
   "outputs": [],
   "source": [
    "# fetching the data from table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "3aa694b2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[(1132, 'Sachin', 'Kumar', datetime.date(1997, 11, 11), 'Eleventh')]\n"
     ]
    }
   ],
   "source": [
    "\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",database=\"student1\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"select * from studentdetails\" \n",
    "    \n",
    "    cursor.execute(query) \n",
    "    \n",
    "    print(cursor.fetchall())\n",
    "    mydb.close()\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "f7239278",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import csv\n",
    "mydb = connection.connect(host=\"localhost\",database=\"student1\",user=\"root\",passwd=\"1234\",use_pure=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "cbf23a50",
   "metadata": {},
   "outputs": [],
   "source": [
    "a=pd.read_sql(\"select * from studentdetails\",mydb)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "a578acf4",
   "metadata": {},
   "outputs": [],
   "source": [
    "a.to_csv(\"mydata.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "c2029178",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<mysql.connector.connection.MySQLConnection at 0x1fd22519e50>"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mydb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "c2ace509",
   "metadata": {},
   "outputs": [],
   "source": [
    "cur=mydb.cursor()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "88b6423d",
   "metadata": {},
   "outputs": [],
   "source": [
    "data =pd.read_csv(\"mydata.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "526870b5",
   "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>1</th>\n",
       "      <th>90</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   1  90\n",
       "0  4  90"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "839402d8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<_csv.reader object at 0x000001FD2256E8E0>\n",
      "(0, ['1,90'])\n",
      "1,90\n",
      "(1, ['4,90'])\n",
      "4,90\n",
      "(2, [])\n"
     ]
    }
   ],
   "source": [
    "with open(\"mydata.csv\",\"r\") as f:\n",
    "    data = csv.reader(f, delimiter=\"\\n\")\n",
    "    print(data)\n",
    "    for line in enumerate(data):\n",
    "        print(line)\n",
    "        for list_ in line[1]:\n",
    "            print(list_)\n",
    "            \n",
    "mydb.commit()\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "493948a9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'hello my name is 1,2,3,\"Naman\"'"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"hello my name is {}\".format('1,2,3,\"Naman\"')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "id": "9f000105",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1,2,3,4'"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "str([\"1,2,3,4\"][0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "id": "336e9c55",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "hello\n"
     ]
    }
   ],
   "source": [
    "print(\"hello\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "id": "e1ab0789",
   "metadata": {},
   "outputs": [],
   "source": [
    "a=[1,2]\n",
    "b=[\"a\",\"b\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "id": "22dc008f",
   "metadata": {},
   "outputs": [],
   "source": [
    "zipped = zip(a,b)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "id": "d897e03e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<zip at 0x1fd223f1100>"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zipped"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "id": "863f9925",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1, 'a')"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "next(zipped)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "id": "05f5edbc",
   "metadata": {},
   "outputs": [
    {
     "ename": "StopIteration",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mStopIteration\u001b[0m                             Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[111], line 1\u001b[0m\n\u001b[1;32m----> 1\u001b[0m \u001b[38;5;28;43mnext\u001b[39;49m\u001b[43m(\u001b[49m\u001b[43mzipped\u001b[49m\u001b[43m)\u001b[49m\n",
      "\u001b[1;31mStopIteration\u001b[0m: "
     ]
    }
   ],
   "source": [
    "next(zipped)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "id": "33c73e7f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'map'>\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a=[\"1\",\"2\"]\n",
    "\n",
    "b=map(int,a)\n",
    "\n",
    "print(type(b))\n",
    "\n",
    "next(b)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "4444acfb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Deleting records from database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "id": "84afbdbf",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Deleted\n"
     ]
    }
   ],
   "source": [
    "\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",database=\"student1\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"delete from studentdetails where studentid = Null\" \n",
    "    \n",
    "    cursor.execute(query) \n",
    "    mydb.commit()\n",
    "    print(\"Deleted\")\n",
    "    mydb.close()\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "id": "330fc76a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Inserted\n"
     ]
    }
   ],
   "source": [
    "\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",database=\"student1\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"Insert into studentdetails value (1134,'Sachin','Kumar','1997-11-11','Eleventh')\" \n",
    "    \n",
    "    cursor.execute(query) \n",
    "    mydb.commit()\n",
    "    print(\"Inserted\")\n",
    "    mydb.close()\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "id": "8f72ca2d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Update the record"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "id": "296ed14d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Inserted\n"
     ]
    }
   ],
   "source": [
    "\n",
    "try:\n",
    "    mydb = connection.connect(host=\"localhost\",database=\"student1\",user=\"root\",passwd=\"1234\",use_pure=True) # return an object (which connected to the Mysql\n",
    "    \n",
    "    cursor = mydb.cursor() # create a cursor to execute queries at very first index        \n",
    "    \n",
    "    query = \"update studentdetails set studentid=1 where studentid=1134\" \n",
    "    \n",
    "    cursor.execute(query) \n",
    "    mydb.commit()\n",
    "    print(\"Updated\")\n",
    "    mydb.close()\n",
    "except Exception as e:\n",
    "    mydb.close()\n",
    "    \n",
    "    print(str(e))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4a7bd561",
   "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}