Stats_notebook.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "d9cc22c1-9487-4219-842e-5c05bcab0cbc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "5ca67a18-54c6-490f-8251-a0cdafdb738b",
   "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>Sl.No</th>\n",
       "      <th>Police Stion</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>Date</th>\n",
       "      <th>Time</th>\n",
       "      <th>Place of Occurrence</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2016</td>\n",
       "      <td>Murder</td>\n",
       "      <td>29/07/2016</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>22nd Cross, Jayanagara 6th Block Bangalore</td>\n",
       "      <td>12.93297</td>\n",
       "      <td>77.58381</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2016</td>\n",
       "      <td>Murder</td>\n",
       "      <td>13/11/2016</td>\n",
       "      <td>23:45:00</td>\n",
       "      <td>On the Road of 30th Cross, Opp Vinayaka textti...</td>\n",
       "      <td>12.930433</td>\n",
       "      <td>77.549761</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2017</td>\n",
       "      <td>Murder</td>\n",
       "      <td>2017-10-05 00:00:00</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>No. 282, 36th Cross Jayanagara 7th Block Banga...</td>\n",
       "      <td>12.923736</td>\n",
       "      <td>77.58182</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2017</td>\n",
       "      <td>Murder</td>\n",
       "      <td>19/07/2017</td>\n",
       "      <td>19:30:00</td>\n",
       "      <td>Near Transfaram, Opp Amejan, Kanakapura Main R...</td>\n",
       "      <td>12.924123</td>\n",
       "      <td>77.576913</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2018</td>\n",
       "      <td>Murder</td>\n",
       "      <td>21/06/2018</td>\n",
       "      <td>23:30:00</td>\n",
       "      <td>No. 53, 2nd Floor, 8th Main 4th Block Jayanaga...</td>\n",
       "      <td>12.924377</td>\n",
       "      <td>77.582729</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Sl.No Police Stion  Year    Type                 Date      Time  \\\n",
       "0      1   Jayanagar   2016  Murder           29/07/2016  21:00:00   \n",
       "1      2   Jayanagar   2016  Murder           13/11/2016  23:45:00   \n",
       "2      3   Jayanagar   2017  Murder  2017-10-05 00:00:00  21:00:00   \n",
       "3      4   Jayanagar   2017  Murder           19/07/2017  19:30:00   \n",
       "4      5   Jayanagar   2018  Murder           21/06/2018  23:30:00   \n",
       "\n",
       "                                 Place of Occurrence   Latitude Longitude   \\\n",
       "0         22nd Cross, Jayanagara 6th Block Bangalore   12.93297   77.58381   \n",
       "1  On the Road of 30th Cross, Opp Vinayaka textti...  12.930433  77.549761   \n",
       "2  No. 282, 36th Cross Jayanagara 7th Block Banga...  12.923736   77.58182   \n",
       "3  Near Transfaram, Opp Amejan, Kanakapura Main R...  12.924123  77.576913   \n",
       "4  No. 53, 2nd Floor, 8th Main 4th Block Jayanaga...  12.924377  77.582729   \n",
       "\n",
       "   Unnamed: 9  \n",
       "0         NaN  \n",
       "1         NaN  \n",
       "2         NaN  \n",
       "3         NaN  \n",
       "4         NaN  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "murder = pd.read_excel('data/Murder.xlsx')\n",
    "murder.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "d3da13bc-8720-4c89-bcc9-36fc520309d5",
   "metadata": {},
   "outputs": [],
   "source": [
    "murder.drop('Unnamed: 9', axis = 'columns', inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "27f97345-7a9c-459a-a41b-10571eb339e7",
   "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>Sl.No</th>\n",
       "      <th>Police Stion</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>Date</th>\n",
       "      <th>Time</th>\n",
       "      <th>Place of Occurrence</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2016</td>\n",
       "      <td>Murder</td>\n",
       "      <td>29/07/2016</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>22nd Cross, Jayanagara 6th Block Bangalore</td>\n",
       "      <td>12.93297</td>\n",
       "      <td>77.58381</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2016</td>\n",
       "      <td>Murder</td>\n",
       "      <td>13/11/2016</td>\n",
       "      <td>23:45:00</td>\n",
       "      <td>On the Road of 30th Cross, Opp Vinayaka textti...</td>\n",
       "      <td>12.930433</td>\n",
       "      <td>77.549761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2017</td>\n",
       "      <td>Murder</td>\n",
       "      <td>2017-10-05 00:00:00</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>No. 282, 36th Cross Jayanagara 7th Block Banga...</td>\n",
       "      <td>12.923736</td>\n",
       "      <td>77.58182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2017</td>\n",
       "      <td>Murder</td>\n",
       "      <td>19/07/2017</td>\n",
       "      <td>19:30:00</td>\n",
       "      <td>Near Transfaram, Opp Amejan, Kanakapura Main R...</td>\n",
       "      <td>12.924123</td>\n",
       "      <td>77.576913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2018</td>\n",
       "      <td>Murder</td>\n",
       "      <td>21/06/2018</td>\n",
       "      <td>23:30:00</td>\n",
       "      <td>No. 53, 2nd Floor, 8th Main 4th Block Jayanaga...</td>\n",
       "      <td>12.924377</td>\n",
       "      <td>77.582729</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Sl.No Police Stion  Year    Type                 Date      Time  \\\n",
       "0      1   Jayanagar   2016  Murder           29/07/2016  21:00:00   \n",
       "1      2   Jayanagar   2016  Murder           13/11/2016  23:45:00   \n",
       "2      3   Jayanagar   2017  Murder  2017-10-05 00:00:00  21:00:00   \n",
       "3      4   Jayanagar   2017  Murder           19/07/2017  19:30:00   \n",
       "4      5   Jayanagar   2018  Murder           21/06/2018  23:30:00   \n",
       "\n",
       "                                 Place of Occurrence   Latitude Longitude   \n",
       "0         22nd Cross, Jayanagara 6th Block Bangalore   12.93297   77.58381  \n",
       "1  On the Road of 30th Cross, Opp Vinayaka textti...  12.930433  77.549761  \n",
       "2  No. 282, 36th Cross Jayanagara 7th Block Banga...  12.923736   77.58182  \n",
       "3  Near Transfaram, Opp Amejan, Kanakapura Main R...  12.924123  77.576913  \n",
       "4  No. 53, 2nd Floor, 8th Main 4th Block Jayanaga...  12.924377  77.582729  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "murder.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d61a8d6c-0508-42b0-ba3b-957cd5ccf0a8",
   "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>Police Stion</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>Date</th>\n",
       "      <th>Time</th>\n",
       "      <th>Place of Occurrence</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2016</td>\n",
       "      <td>Murder</td>\n",
       "      <td>29/07/2016</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>22nd Cross, Jayanagara 6th Block Bangalore</td>\n",
       "      <td>12.93297</td>\n",
       "      <td>77.58381</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2016</td>\n",
       "      <td>Murder</td>\n",
       "      <td>13/11/2016</td>\n",
       "      <td>23:45:00</td>\n",
       "      <td>On the Road of 30th Cross, Opp Vinayaka textti...</td>\n",
       "      <td>12.930433</td>\n",
       "      <td>77.549761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2017</td>\n",
       "      <td>Murder</td>\n",
       "      <td>2017-10-05 00:00:00</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>No. 282, 36th Cross Jayanagara 7th Block Banga...</td>\n",
       "      <td>12.923736</td>\n",
       "      <td>77.58182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2017</td>\n",
       "      <td>Murder</td>\n",
       "      <td>19/07/2017</td>\n",
       "      <td>19:30:00</td>\n",
       "      <td>Near Transfaram, Opp Amejan, Kanakapura Main R...</td>\n",
       "      <td>12.924123</td>\n",
       "      <td>77.576913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2018</td>\n",
       "      <td>Murder</td>\n",
       "      <td>21/06/2018</td>\n",
       "      <td>23:30:00</td>\n",
       "      <td>No. 53, 2nd Floor, 8th Main 4th Block Jayanaga...</td>\n",
       "      <td>12.924377</td>\n",
       "      <td>77.582729</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Police Stion  Year    Type                 Date      Time  \\\n",
       "0   Jayanagar   2016  Murder           29/07/2016  21:00:00   \n",
       "1   Jayanagar   2016  Murder           13/11/2016  23:45:00   \n",
       "2   Jayanagar   2017  Murder  2017-10-05 00:00:00  21:00:00   \n",
       "3   Jayanagar   2017  Murder           19/07/2017  19:30:00   \n",
       "4   Jayanagar   2018  Murder           21/06/2018  23:30:00   \n",
       "\n",
       "                                 Place of Occurrence   Latitude Longitude   \n",
       "0         22nd Cross, Jayanagara 6th Block Bangalore   12.93297   77.58381  \n",
       "1  On the Road of 30th Cross, Opp Vinayaka textti...  12.930433  77.549761  \n",
       "2  No. 282, 36th Cross Jayanagara 7th Block Banga...  12.923736   77.58182  \n",
       "3  Near Transfaram, Opp Amejan, Kanakapura Main R...  12.924123  77.576913  \n",
       "4  No. 53, 2nd Floor, 8th Main 4th Block Jayanaga...  12.924377  77.582729  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "murder.drop('Sl.No', axis = 'columns', inplace = True)\n",
    "murder.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b7c51f2a-b539-49c7-a392-9db921e96e05",
   "metadata": {},
   "source": [
    "### Checking all the name of the Places in Column = Police Station, to check for Speiing Errors and Repetetipons"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "403fc5e4-f1c6-4687-8d8c-85a0c12fbd76",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Jayanagar ', 'Basavanagudi', 'J.P.nagar ', 'Banashankari', 'BSK',\n",
       "       'Siddapura ', 'Subramanyapura ', 'Thalaghtapura', 'Konanakunte',\n",
       "       'Puttenahalli', 'K.S.Layout', 'Ramakrishnanagar', 'J.P.Nagar',\n",
       "       'Chandranagar', 'Bendrenagar', 'Kashinagar', 'Yelachenahalli',\n",
       "       'Praghipura', 'Kadirenahalli', 'Uttarahalli', 'Iliyasnagar',\n",
       "       'GIRINAGAR PS', 'kg nagar ps', 'VV Puram', 'H NAGAR PS',\n",
       "       'C.K. Achuktu'], dtype=object)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "murder['Police Stion'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "1d363dab-5099-40eb-9b8c-476c15e0701d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Jayanagar ', 'Basavanagudi', 'J.P.nagar ', 'Banashankari',\n",
       "       'Siddapura ', 'Subramanyapura ', 'Thalaghtapura', 'Konanakunte',\n",
       "       'Puttenahalli', 'K.S.Layout', 'Ramakrishnanagar', 'J.P.Nagar',\n",
       "       'Chandranagar', 'Bendrenagar', 'Kashinagar', 'Yelachenahalli',\n",
       "       'Praghipura', 'Kadirenahalli', 'Uttarahalli', 'Iliyasnagar',\n",
       "       'GIRINAGAR PS', 'kg nagar ps', 'VV Puram', 'H NAGAR PS',\n",
       "       'C.K. Achuktu'], dtype=object)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "murder['Police Stion'].replace(to_replace = 'BSK', value = 'Banashankari', inplace = True)\n",
    "murder['Police Stion'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "2a6a6c1e-2ac2-4f0f-b97d-20dba0ed6d4e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Jayanagar ', 'Basavanagudi', 'J.P.Nagar', 'Banashankari',\n",
       "       'Siddapura ', 'Subramanyapura ', 'Thalaghtapura', 'Konanakunte',\n",
       "       'Puttenahalli', 'K.S.Layout', 'Ramakrishnanagar', 'Chandranagar',\n",
       "       'Bendrenagar', 'Kashinagar', 'Yelachenahalli', 'Praghipura',\n",
       "       'Kadirenahalli', 'Uttarahalli', 'Iliyasnagar', 'GIRINAGAR PS',\n",
       "       'kg nagar ps', 'VV Puram', 'H NAGAR PS', 'C.K. Achuktu'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "murder['Police Stion'].replace(to_replace = 'J.P.nagar ', value = 'J.P.Nagar', inplace = True)\n",
    "murder['Police Stion'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "bc570d27-368e-4603-9835-47e482f8b2e9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 135 entries, 0 to 134\n",
      "Data columns (total 8 columns):\n",
      " #   Column               Non-Null Count  Dtype \n",
      "---  ------               --------------  ----- \n",
      " 0   Police Stion         135 non-null    object\n",
      " 1   Year                 135 non-null    int64 \n",
      " 2   Type                 135 non-null    object\n",
      " 3   Date                 135 non-null    object\n",
      " 4   Time                 123 non-null    object\n",
      " 5   Place of Occurrence  135 non-null    object\n",
      " 6   Latitude             135 non-null    object\n",
      " 7   Longitude            135 non-null    object\n",
      "dtypes: int64(1), object(7)\n",
      "memory usage: 8.6+ KB\n"
     ]
    }
   ],
   "source": [
    "murder.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "71bfccf2-776d-439c-8110-63b30a5253de",
   "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>Police_Station</th>\n",
       "      <th>Year</th>\n",
       "      <th>Type</th>\n",
       "      <th>Date</th>\n",
       "      <th>Time</th>\n",
       "      <th>Place</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2016</td>\n",
       "      <td>Murder</td>\n",
       "      <td>29/07/2016</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>22nd Cross, Jayanagara 6th Block Bangalore</td>\n",
       "      <td>12.93297</td>\n",
       "      <td>77.58381</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2016</td>\n",
       "      <td>Murder</td>\n",
       "      <td>13/11/2016</td>\n",
       "      <td>23:45:00</td>\n",
       "      <td>On the Road of 30th Cross, Opp Vinayaka textti...</td>\n",
       "      <td>12.930433</td>\n",
       "      <td>77.549761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2017</td>\n",
       "      <td>Murder</td>\n",
       "      <td>2017-10-05 00:00:00</td>\n",
       "      <td>21:00:00</td>\n",
       "      <td>No. 282, 36th Cross Jayanagara 7th Block Banga...</td>\n",
       "      <td>12.923736</td>\n",
       "      <td>77.58182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2017</td>\n",
       "      <td>Murder</td>\n",
       "      <td>19/07/2017</td>\n",
       "      <td>19:30:00</td>\n",
       "      <td>Near Transfaram, Opp Amejan, Kanakapura Main R...</td>\n",
       "      <td>12.924123</td>\n",
       "      <td>77.576913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jayanagar</td>\n",
       "      <td>2018</td>\n",
       "      <td>Murder</td>\n",
       "      <td>21/06/2018</td>\n",
       "      <td>23:30:00</td>\n",
       "      <td>No. 53, 2nd Floor, 8th Main 4th Block Jayanaga...</td>\n",
       "      <td>12.924377</td>\n",
       "      <td>77.582729</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Police_Station  Year    Type                 Date      Time  \\\n",
       "0     Jayanagar   2016  Murder           29/07/2016  21:00:00   \n",
       "1     Jayanagar   2016  Murder           13/11/2016  23:45:00   \n",
       "2     Jayanagar   2017  Murder  2017-10-05 00:00:00  21:00:00   \n",
       "3     Jayanagar   2017  Murder           19/07/2017  19:30:00   \n",
       "4     Jayanagar   2018  Murder           21/06/2018  23:30:00   \n",
       "\n",
       "                                               Place   Latitude Longitude   \n",
       "0         22nd Cross, Jayanagara 6th Block Bangalore   12.93297   77.58381  \n",
       "1  On the Road of 30th Cross, Opp Vinayaka textti...  12.930433  77.549761  \n",
       "2  No. 282, 36th Cross Jayanagara 7th Block Banga...  12.923736   77.58182  \n",
       "3  Near Transfaram, Opp Amejan, Kanakapura Main R...  12.924123  77.576913  \n",
       "4  No. 53, 2nd Floor, 8th Main 4th Block Jayanaga...  12.924377  77.582729  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "murder.rename(columns = {'Police Stion' : 'Police_Station', 'Year' : 'Year', 'Type':'Type', 'Date':'Date', 'Time':'Time', 'Place of Occurrence' : 'Place', 'Latitude' : 'Latitude', 'Longitude' : 'Longitude'}, inplace = True)\n",
    "murder.head()             "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bec3a7be-29f2-4b7e-a560-30db7962f1f2",
   "metadata": {},
   "source": [
    "### Performed to see how many years of Data are we dealing With"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "72d99b1a-3642-48c0-bc5b-695f9ac298ba",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([2016, 2017, 2018, 2015, 2019], dtype=int64)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "murder['Year'].unique()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e0da4684-ae3a-48da-90f3-50cfe7d7efb3",
   "metadata": {},
   "source": [
    "## Finding the Murder Count varring accross the Years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "1883e776-fdf6-4714-b6b6-a3a01e829754",
   "metadata": {},
   "outputs": [],
   "source": [
    "murder_df = pd.DataFrame(murder['Year'].value_counts())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "0b3d425f-1948-472b-9d99-b64c88c11d33",
   "metadata": {},
   "outputs": [],
   "source": [
    "murder_df = murder_df.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "49ea0bc8-8361-47e0-81fc-d65ea3fcadc2",
   "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>index</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index  Year\n",
       "0   2016    33\n",
       "1   2017    32\n",
       "2   2018    28\n",
       "3   2015    21\n",
       "4   2019    21"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "murder_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "2f8323f3-8c38-4058-a47b-9ed1b7956ce9",
   "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>Year</th>\n",
       "      <th>Murder_Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2015</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Year  Murder_Count\n",
       "0  2016            33\n",
       "1  2017            32\n",
       "2  2018            28\n",
       "3  2015            21"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "murder_df.rename(columns = {'index' : 'Year', 'Year' : 'Murder_Count'}, inplace = True)\n",
    "murder_df.drop(labels = 4, axis = 0, inplace = True)\n",
    "murder_df "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "da58825e-0816-4db0-a3e2-015b9972db7e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='Year', ylabel='Murder_Count'>"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX8AAAEGCAYAAACNaZVuAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAASQElEQVR4nO3de9BcdX3H8fdHLqUqVCgPGMUYx0EtRQ34aK2oRRQHvFsvY1oxXjrRjlDxNl7GKtTO1HqtFetMHNRolaqDCGq9UEakWgUTTCEYLV6QiikJWkfEKgLf/rEnw0NI8uw+2bP7PPzer5md3fPbc/Z892Tzec6e89vfSVUhSWrLnaZdgCRp8gx/SWqQ4S9JDTL8JalBhr8kNWjvaRcwrIMPPrhWrFgx7TIkaUnZsGHDdVU1s2P7kgn/FStWsH79+mmXIUlLSpIf7azdwz6S1CDDX5IaZPhLUoMMf0lqkOEvSQ0y/CWpQYa/JDXI8JekBhn+ktSgJfMLX03W1X/zwGmXsGgsf+Pl0y5BGjv3/CWpQYa/JDXI8JekBhn+ktQgw1+SGmRvH2kCjnnPMdMuYdH42ilfm3YJwj1/SWqS4S9JDTL8JalBhr8kNcjwl6QGGf6S1CDDX5IaZPhLUoN6Df8k+yW5JMl/Jrkiyeld+0FJzk9yZXd/YJ91SJJuq+89/98Ax1XVg4GVwAlJHg68Frigqg4HLuimJUkT0mv418Avu8l9ulsBTwXWde3rgKf1WYck6bZ6P+afZK8kG4GtwPlVdTFwaFVtAejuD+m7DknSrXoP/6q6uapWAocBD0ty5LDLJlmTZH2S9du2beutRklqzcR6+1TVz4ELgROAa5MsA+jut+5imbVVNVtVszMzM5MqVZLu8Pru7TOT5G7d498FHgd8BzgPWN3Ntho4t886JEm31fd4/suAdUn2YvCH5hNV9dkkXwc+keRFwNXAs3quQ5I0R6/hX1WXAUftpP2nwGP7XLckadf8ha8kNcjwl6QGGf6S1CDDX5IaZPhLUoMMf0lqkOEvSQ3q+0dekjRWX3n0n0y7hEXjTy76yoKXdc9fkhpk+EtSgwx/SWqQ4S9JDTL8JalBhr8kNcjwl6QGGf6S1CDDX5IaZPhLUoMMf0lqkOEvSQ0y/CWpQYa/JDXI8JekBvUa/knuleTLSTYnuSLJy7r205Jck2Rjd3tCn3VIkm6r74u53AS8sqouTbI/sCHJ+d1z76qqt/e8fknSTvQa/lW1BdjSPb4+yWbgnn2uU5I0v4kd80+yAjgKuLhrOjnJZUk+kOTAXSyzJsn6JOu3bds2qVIl6Q5vIuGf5K7A2cCpVfUL4H3AfYGVDL4ZvGNny1XV2qqararZmZmZSZQqSU3oPfyT7MMg+D9aVZ8CqKprq+rmqroFeD/wsL7rkCTdqu/ePgHOBDZX1TvntC+bM9vTgU191iFJuq2+e/scA5wEXJ5kY9f2emBVkpVAAVcBL+65DknSHH339vkqkJ089a99rleStHv+wleSGmT4S1KDDH9JapDhL0kNMvwlqUGGvyQ1yPCXpAYZ/pLUIMNfkhpk+EtSg4YO/yQXDNMmSVr85h3bJ8l+wJ2Bg7uLrmwfq+cA4B491iZJ6skwA7u9GDiVQdBv4Nbw/wXw3n7KkiT1ad7wr6p3A+9OckpVvWcCNUmSejb0kM5V9Z4kjwBWzF2uqj7cQ12SpB4NHf5JPsLgursbgZu75gIMf0laYka5mMsscERVVV/FSJImY5R+/puAu/dViCRpckbZ8z8Y+HaSS4DfbG+sqqeMvSpJUq9GCf/T+ipiHB7yak89bLfhbc+bdgmSFrlRevt8pc9CJEmTM0pvn+sZ9O4B2BfYB7ihqg7oozBJUn+GPuFbVftX1QHdbT/gGcAZu1smyb2SfDnJ5iRXJHlZ135QkvOTXNndH7hnb0OSNIoFj+pZVZ8GjptntpuAV1bVHwAPB16a5AjgtcAFVXU4cEE3LUmakFEO+/zpnMk7Mej3v9s+/1W1BdjSPb4+yWbgnsBTgWO72dYBFwKvGbYWSdKeGaW3z5PnPL4JuIpBiA8lyQrgKOBi4NDuDwNVtSXJIbtYZg2wBmD58uUjlCpJ2p1Revu8YKErSXJX4Gzg1Kr6RZL5Ftm+zrXAWoDZ2Vl/WSxJYzLKxVwOS3JOkq1Jrk1ydpLDhlhuHwbB/9Gq+lTXfG2SZd3zy4CtCylekrQwo5zw/SBwHoNx/e8JfKZr26UMdvHPBDZX1TvnPHUesLp7vBo4d4Q6JEl7aJTwn6mqD1bVTd3tQ8DMPMscA5wEHJdkY3d7AvAW4PgkVwLHd9OSpAkZ5YTvdUmeC5zVTa8Cfrq7Barqq9x65a8dPXaEdUuSxmiUPf8XAs8G/odB981ndm2SpCVmlN4+VwOO4ClJdwDz7vkneWuSl+yk/eVJ/r6fsiRJfRrmsM+T6Pra7+DdwBPHW44kaRKGCf+qqlt20ngLuz6ZK0laxIYJ/18lOXzHxq7t/8ZfkiSpb8Oc8H0j8Pkkfwts6NpmgdcBp/ZUlySpR/OGf1V9PsnTgFcDp3TNm4BnVNXlPdYmSerJUF09q2oTtw7HsFNJ3lNVp+xuHknS4rDgi7nsxDFjfC1JUo/GGf6SpCXC8JekBo0z/O3zL0lLxFDhn2SvJG+bZ7Z3j6EeSdIEDBX+VXUz8JDs5vqL3fj+kqQlYJTx/L8FnJvkk8AN2xvnXJpRkrREjBL+BzG4eMtxc9oKMPwlaYkZZTz/F/RZiCRpcobu7ZPkfkkuSLKpm35Qkjf0V5okqS+jdPV8P4PB3H4LUFWXAc/poyhJUr9GCf87V9UlO7TdNM5iJEmTMUr4X5fkvgxO8pLkmQwu5C5JWmJG6e3zUgaXc3xAkmuAHwLP7aUqSVKvht7zr6ofVNXjgBngAVX1yKq6anfLJPlAkq3bTxJ3bacluSbJxu72hAVXL0lakHn3/JO8YhftAFTVO3ez+IeAM4AP79D+rqp6+3AlSpLGbZjDPvt39/cHHgqc100/GbhodwtW1UVJViy4OklSL4a5jOPpAEm+BBxdVdd306cBn1zgek9O8jxgPfDKqvrfnc2UZA2wBmD58uULXJUkaUej9PZZDtw4Z/pGYMUC1vk+4L7ASga9hd6xqxmram1VzVbV7MzMzAJWJUnamVF6+3wEuCTJOQy6ez4dWDfqCqvq2u2Pk7wf+OyoryFJ2jNDhX83lPOHgc8Dj+qaX1BV3xp1hUmWVdX23wc8Hdi0u/klSeM3VPhXVSX5dFU9BLh02BdPchZwLHBwkh8DbwKOTbKSwbeHq4AXj1izJGkPjXLY5xtJHlpV3xx2gapatZPmM0dYpySpB6OE/2OAFyf5EYOLuYTBl4IH9VKZJKk3o4T/ib1VIUmaqFHCv3qrQpI0UaOE/+cY/AEIsB9wH+C7wB/2UJckqUejXMbxgXOnkxyNPXUkaUka5Re+t1FVlzIY60eStMQMvee/w+iedwKOBraNvSJJUu9GOea//5zHNzE4B3D2eMuRJE3CKMf8T++zEEnS5AxzMZfzdvd8VT1lfOVIkiZhmD3/Pwb+GzgLuJhBV09J0hI2TPjfHTgeWAX8GYNj/WdV1RV9FiZJ6s+8XT2r6uaq+kJVrQYeDnwPuDDJKb1XJ0nqxbDj+f8O8EQGe/8rgH8EPtVfWZKkPg1zwncdcCSDC7mcXlVefEWSlrhh9vxPYjCE8/2Avxpc1Au4dUjnA3qqTZLUk3nDv6oWPASEJGlxMtglqUGGvyQ1yPCXpAYZ/pLUIMNfkhrUa/gn+UCSrUk2zWk7KMn5Sa7s7g/sswZJ0u31vef/IeCEHdpeC1xQVYcDF3TTkqQJ6jX8q+oi4Gc7ND8VWNc9Xgc8rc8aJEm3N41j/odW1RaA7v6QXc2YZE2S9UnWb9vmFSMlaVwW9QnfqlpbVbNVNTszMzPtciTpDmMa4X9tkmUA3f3WKdQgSU2bRvifB6zuHq8Gzp1CDZLUtL67ep4FfB24f5IfJ3kR8Bbg+CRXMrhC2Fv6rEGSdHtDXcxloapq1S6eemyf65Uk7d6iPuErSeqH4S9JDTL8JalBhr8kNcjwl6QGGf6S1CDDX5IaZPhLUoMMf0lqkOEvSQ0y/CWpQYa/JDXI8JekBhn+ktQgw1+SGmT4S1KDDH9JapDhL0kNMvwlqUGGvyQ1yPCXpAYZ/pLUoL2nteIkVwHXAzcDN1XV7LRqkaTWTC38O4+pquumXIMkNcfDPpLUoGmGfwFfSrIhyZqdzZBkTZL1SdZv27ZtwuVJ0h3XNMP/mKo6GjgReGmSR+84Q1WtrarZqpqdmZmZfIWSdAc1tfCvqp9091uBc4CHTasWSWrNVMI/yV2S7L/9MfB4YNM0apGkFk2rt8+hwDlJttfwsar6wpRqkaTmTCX8q+oHwIOnsW5Jkl09JalJhr8kNcjwl6QGGf6S1CDDX5IaZPhLUoMMf0lqkOEvSQ0y/CWpQYa/JDXI8JekBhn+ktQgw1+SGmT4S1KDDH9JapDhL0kNMvwlqUGGvyQ1yPCXpAYZ/pLUIMNfkhpk+EtSgwx/SWrQ1MI/yQlJvpvke0leO606JKlFUwn/JHsB7wVOBI4AViU5Yhq1SFKLprXn/zDge1X1g6q6EfgX4KlTqkWSmpOqmvxKk2cCJ1TVX3TTJwF/VFUn7zDfGmBNN3l/4LsTLXRhDgaum3YRdxBuy/Fye47XUtme966qmR0b955GJUB20na7v0JVtRZY238545NkfVXNTruOOwK35Xi5PcdrqW/PaR32+TFwrznThwE/mVItktScaYX/N4HDk9wnyb7Ac4DzplSLJDVnKod9quqmJCcDXwT2Aj5QVVdMo5YeLKnDVIuc23K83J7jtaS351RO+EqSpstf+EpSgwx/SWqQ4T+PJPdK8uUkm5NckeRlXftBSc5PcmV3f2DX/vvd/L9McsYOr3VhN6TFxu52yDTe07SMeVvum2Rtkv9K8p0kz5jGe5qmcW3PJPvP+UxuTHJdkn+Y0tuamjF/PlcluTzJZUm+kOTgabyn3fGY/zySLAOWVdWlSfYHNgBPA54P/Kyq3tKNTXRgVb0myV2Ao4AjgSPn/nAtyYXAq6pq/YTfxqIw5m15OrBXVb0hyZ2Ag6pqKfzgZmzGuT13eN0NwMur6qJJvI/FYlzbM8neDLquH1FV1yV5K/Crqjpt4m9qN9zzn0dVbamqS7vH1wObgXsyGI5iXTfbOgYfEqrqhqr6KvDryVe7uI15W74Q+LtuvltaC37o57OZ5HDgEODf+6t8cRrj9kx3u0uSAAewCH/HZPiPIMkKBn/pLwYOraotMPjQMPgPM4wPdl+t/7r7YDRpT7Zlkrt1D9+c5NIkn0xyaI/lLnpj+mwCrAI+Xo0fEtiT7VlVvwX+Eric7hsAcGaf9S6E4T+kJHcFzgZOrapfLPBl/ryqHgg8qrudNK76lpIxbMu9Gfwq/GtVdTTwdeDtYyxxSRnTZ3O75wBn7XlVS9eebs8k+zAI/6OAewCXAa8ba5FjYPgPofvHPBv4aFV9qmu+tjtGuP1Y4db5Xqeqrunurwc+xmB006aMaVv+FPgVcE43/Ung6B7KXfTG9dns5n0wsHdVbeil2CVgTNtzJUBVfb/7BvUJ4BH9VLxwhv88ukMzZwKbq+qdc546D1jdPV4NnDvP6+y9/Yx/9wF7ErBp/BUvXuPalt1/qM8Ax3ZNjwW+PdZil4Bxbc85VtHwXv8Yt+c1wBFJto+keTyD8weLir195pHkkQxOfl0O3NI1v57BscBPAMuBq4FnVdXPumWuYnCSZ1/g58DjgR8BFwH7MBjS4t+AV1TVzRN6K1M3rm1ZVd9Ocm/gI8DdgG3AC6rq6km9l8VgnNuze+4HwBOq6juTexeLx5g/ny8BXgb8lsH//edX1U8n9maGYPhLUoM87CNJDTL8JalBhr8kNcjwl6QGGf6S1CDDX9qFDHw1yYlz2p6d5AvTrEsaB7t6SruR5EgGvyA+isHvMzYCJ1TV9xfwWnu19LsOLW6GvzSPbkjeG4C7dPf3Bh7IYIyh06rq3G4gsI908wCcXFX/keRY4E3AFmBlVR0x2eqlnTP8pXl047ZfCtwIfBa4oqr+uRtd9BIG3woKuKWqft0Ni3xWVc124f85BuO9/3Aa9Us7s/e0C5AWu6q6IcnHgV8CzwaenORV3dP7MfjZ/0+AM5KsBG4G7jfnJS4x+LXYGP7ScG7pbgGeUVXfnftkktOAa4EHM+hIMfcCHzdMqEZpaPb2kUbzReCU7RfiSXJU1/57wJaquoXBdRr2mlJ90lAMf2k0b2YwMutlSTZ10wD/BKxO8g0Gh3zc29ei5glfSWqQe/6S1CDDX5IaZPhLUoMMf0lqkOEvSQ0y/CWpQYa/JDXo/wHBMKKTSbPXlgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.barplot(data=murder_df, x=\"Year\", y=\"Murder_Count\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9bf402c4-aa78-432a-9f56-3355a4a9482a",
   "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
}