13-07-23_Naresh_kumar.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 414,
   "id": "a8db3386",
   "metadata": {},
   "outputs": [],
   "source": [
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "5a85b1f4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['19Rahul', '26mahendra']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"[1-9]+[a-z,A-Z]*\"\n",
    "text=\"19Rahul 26mahendra kamal\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "963a44d5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['', '', 'Rahul', '', '', '', 'mahendra', '', 'kamal', '']\n"
     ]
    }
   ],
   "source": [
    "pattern=\"[a-z,A-Z]*\"\n",
    "text=\"19Rahul 26mahendra kamal\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "efcb1e4c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['19Rahul', '26mahendra', 'kamal']\n"
     ]
    }
   ],
   "source": [
    "pattern=\"[1-9a-zA-Z]+\"\n",
    "text=\"19Rahul 26mahendra kamal\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "08de3976",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['19Rahul', '26mahendra']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"[0-9]+[a-zA-Z]+\"\n",
    "text=\"19Rahul 26mahendra kamal\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "4e45f25e",
   "metadata": {},
   "outputs": [],
   "source": [
    "pattern=r\"[192.168]\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "3f342b78",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['192.168.19.24', '192.168.31.20']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"\\b(?:(192.168.([0-9]|1[0-9]|2[0-9]|3[0-1]).([0-9]|1[0-9]|2[0-4])))\\b\"\n",
    "text=\"ip address 192.168.21.32, 192.168.19.24, 192.168.31.20 \"\n",
    "x=re.findall(pattern,text)\n",
    "d=[]\n",
    "for i in x:\n",
    "    d.append(i[0])\n",
    "print(d)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "ebefc858",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "192.168.19.24\n",
      "192.168.31.9\n"
     ]
    }
   ],
   "source": [
    "for i in x:\n",
    "    print(i[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "8c629c75",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['kamal', 'karan']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"\\b[a-m]+[a-d]+[i-s]+[a]+[l-p]\\b\"\n",
    "text=\"Rahul mahendra kamal karan\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "id": "f59c170e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['rahul', ' karan', ' yash']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"[^a-l][a-z]+[h-q$]+\"\n",
    "text=\"rahul karan yash yay\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "id": "94e09d44",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['rahul', ' karan']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"\\b[^a-l]+[a-z]+[h-q$]+\\b\"\n",
    "text=\"rahul karan\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "93a070a9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['destinationServiceName != ', 'komal in ', 'deviceEventClassId = ', 'devicevendor = ', 'deviceEventClassId = ', 'deviceEventClassId = ', 'deviceEventClassId = ', 'suser != ']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"[a-z,A-Z]+[\\s]+[=,!=,=,<>,<,>, in]+\"\n",
    "text=\"destinationServiceName != 'None' AND komal in kamal ( deviceEventClassId = 'Service Control Manager:7036'  AND (devicevendor = 'Microsoft' AND ( deviceEventClassId = '4728' OR deviceEventClassId = '4732' OR deviceEventClassId = '4756' )  AND suser != 'None'))\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "id": "c85afeed",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['rahul', ' karan', ' yas']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"\\b[^a-l]+[a-z]+\\b\"\n",
    "text=\"rahul karan yas\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "id": "e4b6d784",
   "metadata": {},
   "outputs": [],
   "source": [
    "pattern=r\"a-j+[a-z]\"\n",
    "text=\"amar kamal bharat\"\n",
    "x=re.finditer(pattern,text)\n",
    "for i in x:\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "id": "bd3bea1b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['lamar']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"^\\w+\"\n",
    "text=\"lamar kamal bharat\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 194,
   "id": "c17dcc1c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['lamar']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"^[a-m]\\w+\"\n",
    "text=\"lamar kamal bharat\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 212,
   "id": "3d8c1385",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['destinationServiceName', 'None', 'komal', 'kamal', 'deviceEventClass', 'Service', 'Control', 'Manager', 'devicevendor', 'Microsoft', 'deviceEventClass', 'deviceEventClass', 'deviceEventClass', 'suser', 'None']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"[a-z,A-Z]+[a-z]+[a-z$]+\"\n",
    "text=\"destinationServiceName != 'None' AND komal in kamal ( deviceEventClassId = 'Service Control Manager:7036'  AND (devicevendor = 'Microsoft' AND ( deviceEventClassId = '4728' OR deviceEventClassId = '4732' OR deviceEventClassId = '4756' )  AND suser != 'None'))\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 219,
   "id": "c81eaaa8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['hello']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"hello$\"\n",
    "pattern=r\"hello\\Z\"\n",
    "text=\"what is hello\"\n",
    "x=re.findall(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 222,
   "id": "be8db64c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['what is ', '']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"hello\"\n",
    "text=\"what is hello\"\n",
    "x=re.split(pattern,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 226,
   "id": "e8eb3134",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "what is 98 98\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"hello\"\n",
    "text=\"what is hello hello\"\n",
    "x=re.sub(pattern,\"98\" ,text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 227,
   "id": "564f9872",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "id": "d578b4e3",
   "metadata": {},
   "outputs": [],
   "source": [
    "x=pd.read_csv(\"test.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "id": "3d9779e2",
   "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>Unnamed: 0</th>\n",
       "      <th>StartTime</th>\n",
       "      <th>RuleId</th>\n",
       "      <th>RuleName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2023-05-16 14:59:30</td>\n",
       "      <td>320</td>\n",
       "      <td>Microsoft Logs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2023-05-16 14:59:30</td>\n",
       "      <td>320</td>\n",
       "      <td>Microsoft Logs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2023-05-16 14:59:30</td>\n",
       "      <td>320</td>\n",
       "      <td>Microsoft Logs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2023-05-16 14:59:30</td>\n",
       "      <td>320</td>\n",
       "      <td>Microsoft Logs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2023-05-16 14:59:30</td>\n",
       "      <td>320</td>\n",
       "      <td>Microsoft Logs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23643</th>\n",
       "      <td>23643</td>\n",
       "      <td>2023-05-31 16:29:54</td>\n",
       "      <td>325</td>\n",
       "      <td>Securnoix Alerts_Redington</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23644</th>\n",
       "      <td>23644</td>\n",
       "      <td>2023-05-31 23:45:57</td>\n",
       "      <td>325</td>\n",
       "      <td>Securnoix Alerts_Redington</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23645</th>\n",
       "      <td>23645</td>\n",
       "      <td>2023-05-31 23:45:57</td>\n",
       "      <td>325</td>\n",
       "      <td>Securnoix Alerts_Redington</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23646</th>\n",
       "      <td>23646</td>\n",
       "      <td>2023-05-31 23:45:57</td>\n",
       "      <td>325</td>\n",
       "      <td>Securnoix Alerts_Redington</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23647</th>\n",
       "      <td>23647</td>\n",
       "      <td>2023-05-31 23:45:57</td>\n",
       "      <td>325</td>\n",
       "      <td>Securnoix Alerts_Redington</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23648 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0            StartTime  RuleId                    RuleName\n",
       "0               0  2023-05-16 14:59:30     320              Microsoft Logs\n",
       "1               1  2023-05-16 14:59:30     320              Microsoft Logs\n",
       "2               2  2023-05-16 14:59:30     320              Microsoft Logs\n",
       "3               3  2023-05-16 14:59:30     320              Microsoft Logs\n",
       "4               4  2023-05-16 14:59:30     320              Microsoft Logs\n",
       "...           ...                  ...     ...                         ...\n",
       "23643       23643  2023-05-31 16:29:54     325  Securnoix Alerts_Redington\n",
       "23644       23644  2023-05-31 23:45:57     325  Securnoix Alerts_Redington\n",
       "23645       23645  2023-05-31 23:45:57     325  Securnoix Alerts_Redington\n",
       "23646       23646  2023-05-31 23:45:57     325  Securnoix Alerts_Redington\n",
       "23647       23647  2023-05-31 23:45:57     325  Securnoix Alerts_Redington\n",
       "\n",
       "[23648 rows x 4 columns]"
      ]
     },
     "execution_count": 230,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "id": "0313bea2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "325"
      ]
     },
     "execution_count": 237,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x.iloc[21546,2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 238,
   "id": "4a92f101",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "325"
      ]
     },
     "execution_count": 238,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x.loc[21545,'RuleId']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 241,
   "id": "136f9eed",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        320\n",
       "1        320\n",
       "2        320\n",
       "3        320\n",
       "4        320\n",
       "        ... \n",
       "23643    450\n",
       "23644    450\n",
       "23645    450\n",
       "23646    450\n",
       "23647    450\n",
       "Name: RuleId, Length: 23648, dtype: int64"
      ]
     },
     "execution_count": 241,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x['RuleId'].replace(325,450)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 244,
   "id": "07e1d60d",
   "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>RuleName</th>\n",
       "      <th>RuleId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Microsoft Logs</td>\n",
       "      <td>320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Microsoft Logs</td>\n",
       "      <td>320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Microsoft Logs</td>\n",
       "      <td>320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Microsoft Logs</td>\n",
       "      <td>320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Microsoft Logs</td>\n",
       "      <td>320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23643</th>\n",
       "      <td>Securnoix Alerts_Redington</td>\n",
       "      <td>325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23644</th>\n",
       "      <td>Securnoix Alerts_Redington</td>\n",
       "      <td>325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23645</th>\n",
       "      <td>Securnoix Alerts_Redington</td>\n",
       "      <td>325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23646</th>\n",
       "      <td>Securnoix Alerts_Redington</td>\n",
       "      <td>325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23647</th>\n",
       "      <td>Securnoix Alerts_Redington</td>\n",
       "      <td>325</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23648 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         RuleName  RuleId\n",
       "0                  Microsoft Logs     320\n",
       "1                  Microsoft Logs     320\n",
       "2                  Microsoft Logs     320\n",
       "3                  Microsoft Logs     320\n",
       "4                  Microsoft Logs     320\n",
       "...                           ...     ...\n",
       "23643  Securnoix Alerts_Redington     325\n",
       "23644  Securnoix Alerts_Redington     325\n",
       "23645  Securnoix Alerts_Redington     325\n",
       "23646  Securnoix Alerts_Redington     325\n",
       "23647  Securnoix Alerts_Redington     325\n",
       "\n",
       "[23648 rows x 2 columns]"
      ]
     },
     "execution_count": 244,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x.filter(items=['RuleName','RuleId'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dfe6a525",
   "metadata": {},
   "source": [
    "# requests Module"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ea6bfdf6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import smtplib\n",
    "from mail.mime.text import MIMEText\n",
    "from mail.mime."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 258,
   "id": "f7b76118",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['hello', 'hello']\n"
     ]
    }
   ],
   "source": [
    "pattern=r\"hello\"\n",
    "text=\"what is hello hello\"\n",
    "x=re.findall((pattern),text)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 286,
   "id": "472073b0",
   "metadata": {},
   "outputs": [],
   "source": [
    "pattern=re.compile(r\"\\b(?:(192.168.([0-9]|1[0-9]|2[0-9]).([0-9]|1[0-9])))\\b\")\n",
    "x=pattern.findall(\"192.168.21.95\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 287,
   "id": "6bc75952",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[]\n"
     ]
    }
   ],
   "source": [
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 283,
   "id": "a4793c42",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('192.168.21.5', '21', '5')]\n"
     ]
    }
   ],
   "source": [
    "pattern=re.compile(r\"\\b(?:(192.168.([0-9]|1[0-9]|2[0-9]|3[0-1]).([0-9]|1[0-9]|2[0-4])))\\b\")\n",
    "x=pattern.findall(\"192.168.21.5\")\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 317,
   "id": "c79a125f",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pandasql import sqldf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 384,
   "id": "3208c056",
   "metadata": {},
   "outputs": [],
   "source": [
    "data=pd.read_csv(\"demo_inci.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 385,
   "id": "45780914",
   "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>Unnamed: 0</th>\n",
       "      <th>Category</th>\n",
       "      <th>CreatedOn</th>\n",
       "      <th>src</th>\n",
       "      <th>dst</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>183.82.204.163</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>10.172.195.2</td>\n",
       "      <td>34.120.5.221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>120.138.12.43</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>120.138.12.43</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>183.82.204.163</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>195</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>196</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>197</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>198</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>199</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0        Category            CreatedOn             src  \\\n",
       "0             0   abuse_categor  2023-07-04 12:34:30  183.82.204.163   \n",
       "1             1  attack_categor  2023-07-04 12:34:30    10.172.195.2   \n",
       "2             2   abuse_categor  2023-07-04 12:34:30   120.138.12.43   \n",
       "3             3   abuse_categor  2023-07-04 12:34:30   120.138.12.43   \n",
       "4             4   abuse_categor  2023-07-04 12:34:30  183.82.204.163   \n",
       "..          ...             ...                  ...             ...   \n",
       "195         195   abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "196         196   abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "197         197   abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "198         198   abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "199         199   abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "\n",
       "               dst  \n",
       "0    14.99.224.214  \n",
       "1     34.120.5.221  \n",
       "2    14.99.224.214  \n",
       "3    14.99.224.214  \n",
       "4    14.99.224.214  \n",
       "..             ...  \n",
       "195  14.99.224.214  \n",
       "196  14.99.224.214  \n",
       "197  14.99.224.214  \n",
       "198  14.99.224.214  \n",
       "199  14.99.224.214  \n",
       "\n",
       "[200 rows x 5 columns]"
      ]
     },
     "execution_count": 385,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 374,
   "id": "5de6bc4c",
   "metadata": {},
   "outputs": [],
   "source": [
    "data2=sqldf('''select * from data where src regexp \"(?:(192.168.([0-9]|1[0-9]|2[0-9]|3[0-1]).+([0-9]|1[0-9]|2[0-4])))\" ''')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 375,
   "id": "7dbad96f",
   "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>Unnamed: 0</th>\n",
       "      <th>Category</th>\n",
       "      <th>CreatedOn</th>\n",
       "      <th>src</th>\n",
       "      <th>dst</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.5.51</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.55</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>9</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.21.95</td>\n",
       "      <td>117.18.232.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>15</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.55</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>24</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>184.26.161.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>35</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.5.108</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>36</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.30.99</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>37</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.155</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>64</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.5.108</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>65</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.5.108</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>77</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.26</td>\n",
       "      <td>117.18.232.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>89</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.30.138</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>95</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.30.99</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>124</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>137</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>138</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>162.159.24.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>220</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>217.13.106.203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>226</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>208.80.125.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>233</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>208.80.125.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>248</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>217.13.106.203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>262</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>208.80.125.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>309</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>208.80.125.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>327</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>208.80.125.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>353</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.54</td>\n",
       "      <td>13.107.42.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>354</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.54</td>\n",
       "      <td>13.107.42.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>382</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.54</td>\n",
       "      <td>13.107.42.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>383</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.54</td>\n",
       "      <td>13.107.42.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>394</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.54</td>\n",
       "      <td>13.107.42.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>395</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.54</td>\n",
       "      <td>13.107.42.13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0            Category            CreatedOn             src  \\\n",
       "0            1  anonymizer_categor  2023-07-04 12:34:31    192.168.5.51   \n",
       "1            5  anonymizer_categor  2023-07-04 12:34:31    192.168.8.55   \n",
       "2            9  anonymizer_categor  2023-07-04 12:34:31   192.168.21.95   \n",
       "3           15  anonymizer_categor  2023-07-04 12:34:31    192.168.8.55   \n",
       "4           24      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "5           35  anonymizer_categor  2023-07-04 12:34:31   192.168.5.108   \n",
       "6           36  anonymizer_categor  2023-07-04 12:34:31   192.168.30.99   \n",
       "7           37  anonymizer_categor  2023-07-04 12:34:31   192.168.8.155   \n",
       "8           64  anonymizer_categor  2023-07-04 12:34:31   192.168.5.108   \n",
       "9           65  anonymizer_categor  2023-07-04 12:34:31   192.168.5.108   \n",
       "10          77  anonymizer_categor  2023-07-04 12:34:31    192.168.8.26   \n",
       "11          89  anonymizer_categor  2023-07-04 12:34:31  192.168.30.138   \n",
       "12          95  anonymizer_categor  2023-07-04 12:34:31   192.168.30.99   \n",
       "13         124      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "14         137      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "15         138      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "16         220      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "17         226      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "18         233      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "19         248  anonymizer_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "20         262      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "21         309      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "22         327      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "23         353      attack_categor  2023-07-04 12:34:31    192.168.8.54   \n",
       "24         354      attack_categor  2023-07-04 12:34:31    192.168.8.54   \n",
       "25         382      attack_categor  2023-07-04 12:34:31    192.168.8.54   \n",
       "26         383      attack_categor  2023-07-04 12:34:31    192.168.8.54   \n",
       "27         394      attack_categor  2023-07-04 12:34:31    192.168.8.54   \n",
       "28         395      attack_categor  2023-07-04 12:34:31    192.168.8.54   \n",
       "\n",
       "               dst  \n",
       "0   52.113.195.132  \n",
       "1   52.113.195.132  \n",
       "2   117.18.232.200  \n",
       "3   52.113.195.132  \n",
       "4    184.26.161.66  \n",
       "5   52.113.195.132  \n",
       "6   52.113.195.132  \n",
       "7   52.113.195.132  \n",
       "8   52.113.195.132  \n",
       "9   52.113.195.132  \n",
       "10  117.18.232.200  \n",
       "11  52.113.195.132  \n",
       "12  52.113.195.132  \n",
       "13     13.107.42.1  \n",
       "14     13.107.42.1  \n",
       "15   162.159.24.11  \n",
       "16  217.13.106.203  \n",
       "17    208.80.125.4  \n",
       "18    208.80.125.4  \n",
       "19  217.13.106.203  \n",
       "20    208.80.125.4  \n",
       "21    208.80.125.4  \n",
       "22    208.80.125.4  \n",
       "23    13.107.42.13  \n",
       "24    13.107.42.13  \n",
       "25    13.107.42.13  \n",
       "26    13.107.42.13  \n",
       "27    13.107.42.13  \n",
       "28    13.107.42.13  "
      ]
     },
     "execution_count": 375,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cbe12675",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 361,
   "id": "dbcc893d",
   "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>Unnamed: 0</th>\n",
       "      <th>Category</th>\n",
       "      <th>CreatedOn</th>\n",
       "      <th>src</th>\n",
       "      <th>dst</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Unnamed: 0, Category, CreatedOn, src, dst]\n",
       "Index: []"
      ]
     },
     "execution_count": 361,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=\"select * from data;\"\n",
    "sqldf(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 335,
   "id": "6064df40",
   "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>Unnamed: 0</th>\n",
       "      <th>Category</th>\n",
       "      <th>CreatedOn</th>\n",
       "      <th>src</th>\n",
       "      <th>dst</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Unnamed: 0, Category, CreatedOn, src, dst]\n",
       "Index: []"
      ]
     },
     "execution_count": 335,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data='''172.'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 393,
   "id": "d01a6258",
   "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>Unnamed: 0</th>\n",
       "      <th>Category</th>\n",
       "      <th>CreatedOn</th>\n",
       "      <th>src</th>\n",
       "      <th>dst</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>22</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.20.18</td>\n",
       "      <td>40.81.94.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>34</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.20.13</td>\n",
       "      <td>40.81.94.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>74</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.20.13</td>\n",
       "      <td>40.81.94.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>103</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.30.3</td>\n",
       "      <td>35.186.224.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>112</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>113</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>205.251.197.250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>117</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>124</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>127</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>141</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.5.13</td>\n",
       "      <td>13.107.42.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>146</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>169</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0            Category            CreatedOn            src  \\\n",
       "0           22      attack_categor  2023-07-04 12:34:30  192.168.20.18   \n",
       "1           34      attack_categor  2023-07-04 12:34:30  192.168.20.13   \n",
       "2           74      attack_categor  2023-07-04 12:34:30  192.168.20.13   \n",
       "3          103  anonymizer_categor  2023-07-04 12:34:30   192.168.30.3   \n",
       "4          112      attack_categor  2023-07-04 12:34:30    192.168.6.2   \n",
       "5          113      attack_categor  2023-07-04 12:34:30    192.168.6.2   \n",
       "6          117      attack_categor  2023-07-04 12:34:30    192.168.6.2   \n",
       "7          124      attack_categor  2023-07-04 12:34:30    192.168.6.2   \n",
       "8          127      attack_categor  2023-07-04 12:34:30    192.168.6.2   \n",
       "9          141      attack_categor  2023-07-04 12:34:30   192.168.5.13   \n",
       "10         146      attack_categor  2023-07-04 12:34:31    192.168.6.2   \n",
       "11         169      attack_categor  2023-07-04 12:34:31    192.168.6.2   \n",
       "\n",
       "                dst  \n",
       "0       40.81.94.65  \n",
       "1       40.81.94.65  \n",
       "2       40.81.94.65  \n",
       "3     35.186.224.25  \n",
       "4       13.107.42.2  \n",
       "5   205.251.197.250  \n",
       "6       13.107.42.2  \n",
       "7       13.107.42.2  \n",
       "8       13.107.42.2  \n",
       "9      13.107.42.16  \n",
       "10      13.107.42.2  \n",
       "11      13.107.42.2  "
      ]
     },
     "execution_count": 393,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data2=sqldf('''select * from data where src regexp \"(?:(192.168.([0-9]|1[0-9]|2[0-9]|3[0-1]).([0-9]|1[0-9]|2[0-4])$))\" ''')\n",
    "data2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 397,
   "id": "079569e6",
   "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>Unnamed: 0</th>\n",
       "      <th>Category</th>\n",
       "      <th>CreatedOn</th>\n",
       "      <th>src</th>\n",
       "      <th>dst</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>160</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.81.237.188</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>161</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.109.78.179</td>\n",
       "      <td>255.255.255.255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>162</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.61.113.218</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>163</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.61.113.218</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>164</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.81.237.188</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>165</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.81.237.188</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>166</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.61.113.218</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>167</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.61.113.218</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>168</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.81.237.188</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>169</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>170</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.61.113.218</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>171</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.61.113.218</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>172</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.81.237.188</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>173</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.81.237.188</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>174</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.81.237.188</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>175</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>1.9.8.2</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>176</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>1.9.8.2</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>177</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>1.9.8.2</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>178</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.212.146.21</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>179</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>180</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>181</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>182</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>183</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>184</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>185</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.37</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>186</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.46.201.34</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>187</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>188</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>189</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.30.150</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>190</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.8.102</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>191</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.5.73</td>\n",
       "      <td>52.113.195.132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>192</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>103.46.201.34</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>193</td>\n",
       "      <td>anonymizer_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.5.108</td>\n",
       "      <td>117.18.232.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>194</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>193.3.53.3</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>195</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>196</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>197</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>198</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>199</td>\n",
       "      <td>abuse_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>45.112.178.18</td>\n",
       "      <td>14.99.224.214</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0            Category            CreatedOn             src  \\\n",
       "160         160       abuse_categor  2023-07-04 12:34:31  103.81.237.188   \n",
       "161         161       abuse_categor  2023-07-04 12:34:31  103.109.78.179   \n",
       "162         162       abuse_categor  2023-07-04 12:34:31  103.61.113.218   \n",
       "163         163       abuse_categor  2023-07-04 12:34:31  103.61.113.218   \n",
       "164         164       abuse_categor  2023-07-04 12:34:31  103.81.237.188   \n",
       "165         165       abuse_categor  2023-07-04 12:34:31  103.81.237.188   \n",
       "166         166       abuse_categor  2023-07-04 12:34:31  103.61.113.218   \n",
       "167         167       abuse_categor  2023-07-04 12:34:31  103.61.113.218   \n",
       "168         168       abuse_categor  2023-07-04 12:34:31  103.81.237.188   \n",
       "169         169      attack_categor  2023-07-04 12:34:31     192.168.6.2   \n",
       "170         170       abuse_categor  2023-07-04 12:34:31  103.61.113.218   \n",
       "171         171       abuse_categor  2023-07-04 12:34:31  103.61.113.218   \n",
       "172         172       abuse_categor  2023-07-04 12:34:31  103.81.237.188   \n",
       "173         173       abuse_categor  2023-07-04 12:34:31  103.81.237.188   \n",
       "174         174       abuse_categor  2023-07-04 12:34:31  103.81.237.188   \n",
       "175         175  anonymizer_categor  2023-07-04 12:34:31         1.9.8.2   \n",
       "176         176  anonymizer_categor  2023-07-04 12:34:31         1.9.8.2   \n",
       "177         177  anonymizer_categor  2023-07-04 12:34:31         1.9.8.2   \n",
       "178         178       abuse_categor  2023-07-04 12:34:31  103.212.146.21   \n",
       "179         179       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "180         180       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "181         181       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "182         182       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "183         183       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "184         184       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "185         185  anonymizer_categor  2023-07-04 12:34:31    192.168.8.37   \n",
       "186         186       abuse_categor  2023-07-04 12:34:31   103.46.201.34   \n",
       "187         187       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "188         188       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "189         189  anonymizer_categor  2023-07-04 12:34:31  192.168.30.150   \n",
       "190         190  anonymizer_categor  2023-07-04 12:34:31   192.168.8.102   \n",
       "191         191  anonymizer_categor  2023-07-04 12:34:31    192.168.5.73   \n",
       "192         192       abuse_categor  2023-07-04 12:34:31   103.46.201.34   \n",
       "193         193  anonymizer_categor  2023-07-04 12:34:31   192.168.5.108   \n",
       "194         194      attack_categor  2023-07-04 12:34:31      193.3.53.3   \n",
       "195         195       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "196         196       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "197         197       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "198         198       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "199         199       abuse_categor  2023-07-04 12:34:31   45.112.178.18   \n",
       "\n",
       "                 dst  \n",
       "160    14.99.224.214  \n",
       "161  255.255.255.255  \n",
       "162    14.99.224.214  \n",
       "163    14.99.224.214  \n",
       "164    14.99.224.214  \n",
       "165    14.99.224.214  \n",
       "166    14.99.224.214  \n",
       "167    14.99.224.214  \n",
       "168    14.99.224.214  \n",
       "169      13.107.42.2  \n",
       "170    14.99.224.214  \n",
       "171    14.99.224.214  \n",
       "172    14.99.224.214  \n",
       "173    14.99.224.214  \n",
       "174    14.99.224.214  \n",
       "175    14.99.224.214  \n",
       "176    14.99.224.214  \n",
       "177    14.99.224.214  \n",
       "178    14.99.224.214  \n",
       "179    14.99.224.214  \n",
       "180    14.99.224.214  \n",
       "181    14.99.224.214  \n",
       "182    14.99.224.214  \n",
       "183    14.99.224.214  \n",
       "184    14.99.224.214  \n",
       "185   52.113.195.132  \n",
       "186    14.99.224.214  \n",
       "187    14.99.224.214  \n",
       "188    14.99.224.214  \n",
       "189   52.113.195.132  \n",
       "190   52.113.195.132  \n",
       "191   52.113.195.132  \n",
       "192    14.99.224.214  \n",
       "193   117.18.232.200  \n",
       "194    14.99.224.214  \n",
       "195    14.99.224.214  \n",
       "196    14.99.224.214  \n",
       "197    14.99.224.214  \n",
       "198    14.99.224.214  \n",
       "199    14.99.224.214  "
      ]
     },
     "execution_count": 397,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail(40)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c4b68322",
   "metadata": {},
   "source": [
    "# 172.16.200.0/24\n",
    "# 172.16.20.0/24"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 400,
   "id": "a46d6699",
   "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>Unnamed: 0</th>\n",
       "      <th>Category</th>\n",
       "      <th>CreatedOn</th>\n",
       "      <th>src</th>\n",
       "      <th>dst</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>112</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>113</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>205.251.197.250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>117</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>124</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>127</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>141</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:30</td>\n",
       "      <td>192.168.5.13</td>\n",
       "      <td>13.107.42.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>146</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>169</td>\n",
       "      <td>attack_categor</td>\n",
       "      <td>2023-07-04 12:34:31</td>\n",
       "      <td>192.168.6.2</td>\n",
       "      <td>13.107.42.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0        Category            CreatedOn           src  \\\n",
       "0         112  attack_categor  2023-07-04 12:34:30   192.168.6.2   \n",
       "1         113  attack_categor  2023-07-04 12:34:30   192.168.6.2   \n",
       "2         117  attack_categor  2023-07-04 12:34:30   192.168.6.2   \n",
       "3         124  attack_categor  2023-07-04 12:34:30   192.168.6.2   \n",
       "4         127  attack_categor  2023-07-04 12:34:30   192.168.6.2   \n",
       "5         141  attack_categor  2023-07-04 12:34:30  192.168.5.13   \n",
       "6         146  attack_categor  2023-07-04 12:34:31   192.168.6.2   \n",
       "7         169  attack_categor  2023-07-04 12:34:31   192.168.6.2   \n",
       "\n",
       "               dst  \n",
       "0      13.107.42.2  \n",
       "1  205.251.197.250  \n",
       "2      13.107.42.2  \n",
       "3      13.107.42.2  \n",
       "4      13.107.42.2  \n",
       "5     13.107.42.16  \n",
       "6      13.107.42.2  \n",
       "7      13.107.42.2  "
      ]
     },
     "execution_count": 400,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data2=sqldf('''select * from data where src regexp \"(?:(192.168.([0-9]|25[0-5]).([0-9]|1[0-9]|2[0-4])$))\" ''')\n",
    "data2"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "01fbf4ab",
   "metadata": {},
   "source": [
    "### 192.168.250.0/24\n",
    "### 192.168.251.0/24\n",
    "### 192.168.252.0/24\n",
    "### 192.168.253.0/24\n",
    "### 192.168.254.0/24\n",
    "### 192.168.255.0/24"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 420,
   "id": "69331ab9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[]\n"
     ]
    }
   ],
   "source": [
    "pattern=re.compile(r\"\\b(?:(192.168.(25[0-5]).([0-9]|[1-2][0-4][0-9]|25[0-4]))$)\\b\")\n",
    "raw=\"192.168.253.23, 192.168.253.212 192.168.200.95 192.168.255.24\"\n",
    "x=re.findall(pattern,raw)\n",
    "d=[]\n",
    "for i in x:\n",
    "    d.append(i[0])\n",
    "print(d)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 415,
   "id": "9795ec67",
   "metadata": {},
   "outputs": [],
   "source": [
    "# ^(172\\.16\\.(20|200)\\.(?:[0-9]|[1-9][0-9]|[1-2][0-4][0-9]|25[0-4]))$"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 439,
   "id": "d212e855",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('192.168.253.212', '253', '212')]\n",
      "['192.168.253.212']\n"
     ]
    }
   ],
   "source": [
    "pattern=re.compile(r\"\\b(?:(192.168.([2][5][0-5]).([0-9]|[1-2][0-4][0-9]|25[0-4])))\\b\")\n",
    "raw=\"192.168.253.23, 192.168.253.212, 192.168.250.95, 192.168.255.24\"\n",
    "x=re.findall(pattern,raw)\n",
    "print(x)\n",
    "d=[]\n",
    "for i in x:\n",
    "    d.append(i[0])\n",
    "print(d)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c6b3ba13",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}