feature_creation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import math\n",
    "import hashlib\n",
    "import re"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Load Dataframes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 100000 most popular passwords\n",
    "df = pd.read_csv('Datasets/popular_100000.csv')\n",
    "\n",
    "# Drop totals of 0 (only using data for passwords pwned >= 10 times)\n",
    "df = df[df['Total'] != 0]\n",
    "\n",
    "# Subtract 10 from all totals to compensate for dropped data\n",
    "df['Total'] = df['Total'] - 10\n",
    "\n",
    "# Sort dataframe by total pwned in descending order\n",
    "df.sort_values('Total', ascending=False, inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Password Length"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to add password length and drop passwords below length 6\n",
    "def length(df):\n",
    "    df['Length'] = df['Password'].astype(str).map(len)\n",
    "    df = df[df['Length'] >= 6]\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to add password length squared, cubed, and proportion of the longest\n",
    "def len_fts(df):\n",
    "    longest = max(df['Length'])\n",
    "    df['Length_Sq'] = df['Length']**2\n",
    "    df['Length_Cb'] = df['Length']**3\n",
    "    df['Length_Pp'] = df['Length']/longest\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Password</th>\n",
       "      <th>SHA_1</th>\n",
       "      <th>Total</th>\n",
       "      <th>Length</th>\n",
       "      <th>Length_Sq</th>\n",
       "      <th>Length_Cb</th>\n",
       "      <th>Length_Pp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123456</td>\n",
       "      <td>7C4A8D09CA3762AF61E59520943DC26494F8941B</td>\n",
       "      <td>23547443</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>123456789</td>\n",
       "      <td>F7C3BC1D808E04732ADF679965CCC34CA7AE3441</td>\n",
       "      <td>7799804</td>\n",
       "      <td>9</td>\n",
       "      <td>81</td>\n",
       "      <td>729</td>\n",
       "      <td>0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>qwerty</td>\n",
       "      <td>B1B3773A05C0ED0176787A4F1574FF0075F7521E</td>\n",
       "      <td>3912806</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>password</td>\n",
       "      <td>5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8</td>\n",
       "      <td>3730461</td>\n",
       "      <td>8</td>\n",
       "      <td>64</td>\n",
       "      <td>512</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>111111</td>\n",
       "      <td>3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D</td>\n",
       "      <td>3120725</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Password                                     SHA_1     Total  Length  \\\n",
       "0     123456  7C4A8D09CA3762AF61E59520943DC26494F8941B  23547443       6   \n",
       "4  123456789  F7C3BC1D808E04732ADF679965CCC34CA7AE3441   7799804       9   \n",
       "3     qwerty  B1B3773A05C0ED0176787A4F1574FF0075F7521E   3912806       6   \n",
       "1   password  5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8   3730461       8   \n",
       "7     111111  3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D   3120725       6   \n",
       "\n",
       "   Length_Sq  Length_Cb  Length_Pp  \n",
       "0         36        216       0.30  \n",
       "4         81        729       0.45  \n",
       "3         36        216       0.30  \n",
       "1         64        512       0.40  \n",
       "7         36        216       0.30  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Apply length and len features\n",
    "df = length(df)\n",
    "df = len_fts(df)\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Password Composition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check if only letters\n",
    "def only_let(pwd):\n",
    "    reg = '^[a-zA-Z]+$'\n",
    "    if re.search(reg, pwd)!=None:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check if only digits\n",
    "def only_dig(pwd):\n",
    "    reg = '^\\d+$'\n",
    "    if re.search(reg, pwd)!=None:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check if only special chars\n",
    "def only_spc(pwd):\n",
    "    reg = '^\\W+$'\n",
    "    if re.search(reg, pwd)!=None:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check if only letters and digits\n",
    "def let_and_dig(pwd):\n",
    "    let, dig, spc = ('(?=[a-zA-Z])', '(?=\\d)', '(?=\\W)')\n",
    "    if (re.search(let, pwd)!=None) and (re.search(dig, pwd)!=None) and (re.search(spc, pwd)==None):\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check if only letters and special chars\n",
    "def let_and_spc(pwd):\n",
    "    let, dig, spc = ('(?=[a-zA-Z])', '(?=\\d)', '(?=\\W)')\n",
    "    if (re.search(let, pwd)!=None) and (re.search(spc, pwd)!=None) and (re.search(dig, pwd)==None):\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check if only digits and special chars\n",
    "def dig_and_spc(pwd):\n",
    "    let, dig, spc = ('(?=[a-zA-Z])', '(?=\\d)', '(?=\\W)')\n",
    "    if (re.search(dig, pwd)!=None) and (re.search(spc, pwd)!=None) and (re.search(let, pwd)==None):\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to apply password composition features\n",
    "def comp_fts(df):\n",
    "    df['Only_Let'] = df['Password'].apply(only_let)\n",
    "    df['Only_Dig'] = df['Password'].apply(only_dig)\n",
    "    df['Only_Spc'] = df['Password'].apply(only_spc)\n",
    "    df['Let_And_Dig'] = df['Password'].apply(let_and_dig)\n",
    "    df['Let_And_Spc'] = df['Password'].apply(let_and_spc)\n",
    "    df['Dig_And_Spc'] = df['Password'].apply(dig_and_spc)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>Password</th>\n",
       "      <th>SHA_1</th>\n",
       "      <th>Total</th>\n",
       "      <th>Length</th>\n",
       "      <th>Length_Sq</th>\n",
       "      <th>Length_Cb</th>\n",
       "      <th>Length_Pp</th>\n",
       "      <th>Only_Let</th>\n",
       "      <th>Only_Dig</th>\n",
       "      <th>Only_Spc</th>\n",
       "      <th>Let_And_Dig</th>\n",
       "      <th>Let_And_Spc</th>\n",
       "      <th>Dig_And_Spc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123456</td>\n",
       "      <td>7C4A8D09CA3762AF61E59520943DC26494F8941B</td>\n",
       "      <td>23547443</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>123456789</td>\n",
       "      <td>F7C3BC1D808E04732ADF679965CCC34CA7AE3441</td>\n",
       "      <td>7799804</td>\n",
       "      <td>9</td>\n",
       "      <td>81</td>\n",
       "      <td>729</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>qwerty</td>\n",
       "      <td>B1B3773A05C0ED0176787A4F1574FF0075F7521E</td>\n",
       "      <td>3912806</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>password</td>\n",
       "      <td>5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8</td>\n",
       "      <td>3730461</td>\n",
       "      <td>8</td>\n",
       "      <td>64</td>\n",
       "      <td>512</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>111111</td>\n",
       "      <td>3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D</td>\n",
       "      <td>3120725</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Password                                     SHA_1     Total  Length  \\\n",
       "0     123456  7C4A8D09CA3762AF61E59520943DC26494F8941B  23547443       6   \n",
       "4  123456789  F7C3BC1D808E04732ADF679965CCC34CA7AE3441   7799804       9   \n",
       "3     qwerty  B1B3773A05C0ED0176787A4F1574FF0075F7521E   3912806       6   \n",
       "1   password  5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8   3730461       8   \n",
       "7     111111  3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D   3120725       6   \n",
       "\n",
       "   Length_Sq  Length_Cb  Length_Pp  Only_Let  Only_Dig  Only_Spc  Let_And_Dig  \\\n",
       "0         36        216       0.30         0         1         0            0   \n",
       "4         81        729       0.45         0         1         0            0   \n",
       "3         36        216       0.30         1         0         0            0   \n",
       "1         64        512       0.40         1         0         0            0   \n",
       "7         36        216       0.30         0         1         0            0   \n",
       "\n",
       "   Let_And_Spc  Dig_And_Spc  \n",
       "0            0            0  \n",
       "4            0            0  \n",
       "3            0            0  \n",
       "1            0            0  \n",
       "7            0            0  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Apply password composition features\n",
    "df = comp_fts(df)\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Check for Dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for full dates\n",
    "def is_date(pwd):\n",
    "    b, e, s = ('^', '$', '(\\/|\\-|\\.)')\n",
    "    yyyy, yy, mm, m, dd, d = ('\\d{4}', '\\d{2}', '(((0)[0-9])|((1)[0-2]))',\n",
    "                              '[0-9]', '([0-2][0-9]|(3)[0-1])', '[0-9]')\n",
    "    if (re.search(b+yyyy+s+mm+s+dd+e, pwd)!=None) or (re.search(b+yyyy+s+m+s+dd+e, pwd)!=None) or (\n",
    "        re.search(b+yyyy+s+mm+s+d+e, pwd)!=None) or (re.search(b+yyyy+s+m+s+d+e, pwd)!=None) or (\n",
    "        re.search(b+dd+s+mm+s+yyyy+e, pwd)!=None) or (re.search(b+d+s+mm+s+yyyy+e, pwd)!=None) or (\n",
    "        re.search(b+dd+s+m+s+yyyy+e, pwd)!=None) or (re.search(b+d+s+m+s+yyyy+e, pwd)!=None) or (\n",
    "        re.search(b+mm+s+dd+s+yyyy+e, pwd)!=None) or (re.search(b+m+s+dd+s+yyyy+e, pwd)!=None) or (\n",
    "        re.search(b+mm+s+d+s+yyyy+e, pwd)!=None) or (re.search(b+m+s+d+s+yyyy+e, pwd)!=None) or (\n",
    "        re.search(b+yy+s+mm+s+dd+e, pwd)!=None) or (re.search(b+yy+s+m+s+dd+e, pwd)!=None) or (\n",
    "        re.search(b+yy+s+mm+s+d+e, pwd)!=None) or (re.search(b+yy+s+m+s+d+e, pwd)!=None) or (\n",
    "        re.search(b+dd+s+mm+s+yy+e, pwd)!=None) or (re.search(b+d+s+mm+s+yy+e, pwd)!=None) or (\n",
    "        re.search(b+dd+s+m+s+yy+e, pwd)!=None) or (re.search(b+d+s+m+s+yy+e, pwd)!=None) or (\n",
    "        re.search(b+mm+s+dd+s+yy+e, pwd)!=None) or (re.search(b+m+s+dd+s+yy+e, pwd)!=None) or (\n",
    "        re.search(b+mm+s+d+s+yy+e, pwd)!=None) or (re.search(b+m+s+d+s+yy+e, pwd)!=None):\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for year (four-digit number starting with 1 or 2)\n",
    "def has_year(pwd):\n",
    "    four = '\\d{4}'\n",
    "    five = '\\d{5}'\n",
    "    if (re.search(four, pwd)!=None) and (re.search(five, pwd)==None):\n",
    "        years = [str(i) for i in range(1800,2031)]\n",
    "        return 1 if any(y in pwd for y in years) else 0\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to apply year features\n",
    "def date_fts(df):\n",
    "    df['Date'] = df['Password'].apply(is_date)\n",
    "    df['Year'] = df['Password'].apply(has_year)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Password</th>\n",
       "      <th>SHA_1</th>\n",
       "      <th>Total</th>\n",
       "      <th>Length</th>\n",
       "      <th>Length_Sq</th>\n",
       "      <th>Length_Cb</th>\n",
       "      <th>Length_Pp</th>\n",
       "      <th>Only_Let</th>\n",
       "      <th>Only_Dig</th>\n",
       "      <th>Only_Spc</th>\n",
       "      <th>Let_And_Dig</th>\n",
       "      <th>Let_And_Spc</th>\n",
       "      <th>Dig_And_Spc</th>\n",
       "      <th>Date</th>\n",
       "      <th>Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123456</td>\n",
       "      <td>7C4A8D09CA3762AF61E59520943DC26494F8941B</td>\n",
       "      <td>23547443</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>123456789</td>\n",
       "      <td>F7C3BC1D808E04732ADF679965CCC34CA7AE3441</td>\n",
       "      <td>7799804</td>\n",
       "      <td>9</td>\n",
       "      <td>81</td>\n",
       "      <td>729</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>qwerty</td>\n",
       "      <td>B1B3773A05C0ED0176787A4F1574FF0075F7521E</td>\n",
       "      <td>3912806</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>password</td>\n",
       "      <td>5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8</td>\n",
       "      <td>3730461</td>\n",
       "      <td>8</td>\n",
       "      <td>64</td>\n",
       "      <td>512</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>111111</td>\n",
       "      <td>3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D</td>\n",
       "      <td>3120725</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Password                                     SHA_1     Total  Length  \\\n",
       "0     123456  7C4A8D09CA3762AF61E59520943DC26494F8941B  23547443       6   \n",
       "4  123456789  F7C3BC1D808E04732ADF679965CCC34CA7AE3441   7799804       9   \n",
       "3     qwerty  B1B3773A05C0ED0176787A4F1574FF0075F7521E   3912806       6   \n",
       "1   password  5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8   3730461       8   \n",
       "7     111111  3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D   3120725       6   \n",
       "\n",
       "   Length_Sq  Length_Cb  Length_Pp  Only_Let  Only_Dig  Only_Spc  Let_And_Dig  \\\n",
       "0         36        216       0.30         0         1         0            0   \n",
       "4         81        729       0.45         0         1         0            0   \n",
       "3         36        216       0.30         1         0         0            0   \n",
       "1         64        512       0.40         1         0         0            0   \n",
       "7         36        216       0.30         0         1         0            0   \n",
       "\n",
       "   Let_And_Spc  Dig_And_Spc  Date  Year  \n",
       "0            0            0     0     0  \n",
       "4            0            0     0     0  \n",
       "3            0            0     0     0  \n",
       "1            0            0     0     0  \n",
       "7            0            0     0     0  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Apply year functions\n",
    "df = date_fts(df)\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Check for Repeated Characters"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for two repeated characters\n",
    "def rep_2(pwd):\n",
    "    two = re.compile(r'(\\w|\\W)\\1{1}').search(pwd)\n",
    "    three = re.compile(r'(\\w|\\W)\\1{2}').search(pwd)\n",
    "    if two and not three:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for three repeated characters\n",
    "def rep_3(pwd):\n",
    "    three = re.compile(r'(\\w|\\W)\\1{2}').search(pwd)\n",
    "    four = re.compile(r'(\\w|\\W)\\1{3}').search(pwd)\n",
    "    if three and not four:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for four repeated characters\n",
    "def rep_4(pwd):\n",
    "    four = re.compile(r'(\\w|\\W)\\1{3}').search(pwd)\n",
    "    five = re.compile(r'(\\w|\\W)\\1{4}').search(pwd)\n",
    "    if four and not five:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for five repeated characters\n",
    "def rep_5(pwd):\n",
    "    five = re.compile(r'(\\w|\\W)\\1{4}').search(pwd)\n",
    "    six = re.compile(r'(\\w|\\W)\\1{5}').search(pwd)\n",
    "    if five and not six:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for six repeated characters\n",
    "def rep_6(pwd):\n",
    "    six = re.compile(r'(\\w|\\W)\\1{5}').search(pwd)\n",
    "    seven = re.compile(r'(\\w|\\W)\\1{6}').search(pwd)\n",
    "    if six and not seven:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for seven repeated characters\n",
    "def rep_7(pwd):\n",
    "    seven = re.compile(r'(\\w|\\W)\\1{6}').search(pwd)\n",
    "    eight = re.compile(r'(\\w|\\W)\\1{7}').search(pwd)\n",
    "    if seven and not eight:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for eight repeated characters\n",
    "def rep_8(pwd):\n",
    "    eight = re.compile(r'(\\w|\\W)\\1{7}').search(pwd)\n",
    "    nine = re.compile(r'(\\w|\\W)\\1{8}').search(pwd)\n",
    "    if eight and not nine:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for nine repeated characters\n",
    "def rep_9(pwd):\n",
    "    nine = re.compile(r'(\\w|\\W)\\1{8}').search(pwd)\n",
    "    ten = re.compile(r'(\\w|\\W)\\1{9}').search(pwd)\n",
    "    if nine and not ten:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for ten or more repeated characters\n",
    "def rep_10(pwd):\n",
    "    ten = re.compile(r'(\\w|\\W)\\1{9}').search(pwd)\n",
    "    if ten:\n",
    "        return 1\n",
    "    else:\n",
    "        return 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to apply repeated characters features\n",
    "def rep_fts(df):\n",
    "    df['Rep_2'] = df['Password'].apply(rep_2)\n",
    "    df['Rep_3'] = df['Password'].apply(rep_3)\n",
    "    df['Rep_4'] = df['Password'].apply(rep_4)\n",
    "    df['Rep_5'] = df['Password'].apply(rep_5)\n",
    "    df['Rep_6'] = df['Password'].apply(rep_6)\n",
    "    df['Rep_7'] = df['Password'].apply(rep_7)\n",
    "    df['Rep_8'] = df['Password'].apply(rep_8)\n",
    "    df['Rep_9'] = df['Password'].apply(rep_9)\n",
    "    df['Rep_10'] = df['Password'].apply(rep_10)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>Password</th>\n",
       "      <th>SHA_1</th>\n",
       "      <th>Total</th>\n",
       "      <th>Length</th>\n",
       "      <th>Length_Sq</th>\n",
       "      <th>Length_Cb</th>\n",
       "      <th>Length_Pp</th>\n",
       "      <th>Only_Let</th>\n",
       "      <th>Only_Dig</th>\n",
       "      <th>Only_Spc</th>\n",
       "      <th>...</th>\n",
       "      <th>Year</th>\n",
       "      <th>Rep_2</th>\n",
       "      <th>Rep_3</th>\n",
       "      <th>Rep_4</th>\n",
       "      <th>Rep_5</th>\n",
       "      <th>Rep_6</th>\n",
       "      <th>Rep_7</th>\n",
       "      <th>Rep_8</th>\n",
       "      <th>Rep_9</th>\n",
       "      <th>Rep_10</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123456</td>\n",
       "      <td>7C4A8D09CA3762AF61E59520943DC26494F8941B</td>\n",
       "      <td>23547443</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>123456789</td>\n",
       "      <td>F7C3BC1D808E04732ADF679965CCC34CA7AE3441</td>\n",
       "      <td>7799804</td>\n",
       "      <td>9</td>\n",
       "      <td>81</td>\n",
       "      <td>729</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>qwerty</td>\n",
       "      <td>B1B3773A05C0ED0176787A4F1574FF0075F7521E</td>\n",
       "      <td>3912806</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>password</td>\n",
       "      <td>5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8</td>\n",
       "      <td>3730461</td>\n",
       "      <td>8</td>\n",
       "      <td>64</td>\n",
       "      <td>512</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>111111</td>\n",
       "      <td>3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D</td>\n",
       "      <td>3120725</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Password                                     SHA_1     Total  Length  \\\n",
       "0     123456  7C4A8D09CA3762AF61E59520943DC26494F8941B  23547443       6   \n",
       "4  123456789  F7C3BC1D808E04732ADF679965CCC34CA7AE3441   7799804       9   \n",
       "3     qwerty  B1B3773A05C0ED0176787A4F1574FF0075F7521E   3912806       6   \n",
       "1   password  5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8   3730461       8   \n",
       "7     111111  3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D   3120725       6   \n",
       "\n",
       "   Length_Sq  Length_Cb  Length_Pp  Only_Let  Only_Dig  Only_Spc  ...  Year  \\\n",
       "0         36        216       0.30         0         1         0  ...     0   \n",
       "4         81        729       0.45         0         1         0  ...     0   \n",
       "3         36        216       0.30         1         0         0  ...     0   \n",
       "1         64        512       0.40         1         0         0  ...     0   \n",
       "7         36        216       0.30         0         1         0  ...     0   \n",
       "\n",
       "   Rep_2  Rep_3  Rep_4  Rep_5  Rep_6  Rep_7  Rep_8  Rep_9  Rep_10  \n",
       "0      0      0      0      0      0      0      0      0       0  \n",
       "4      0      0      0      0      0      0      0      0       0  \n",
       "3      0      0      0      0      0      0      0      0       0  \n",
       "1      1      0      0      0      0      0      0      0       0  \n",
       "7      0      0      0      0      1      0      0      0       0  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Apply repeated characters features\n",
    "df = rep_fts(df)\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Check for Consecutive Ascending Digits"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for two consecutive ascending digits\n",
    "def asc_d_2(pwd):\n",
    "    two = ['01', '12', '23', '34', '45', '56', '67', '78', '89']\n",
    "    return 1 if any(i in pwd for i in two) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for three consecutive ascending digits\n",
    "def asc_d_3(pwd):\n",
    "    three = ['012', '123', '234', '345', '456', '567', '678', '789']\n",
    "    return 1 if any(i in pwd for i in three) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for four consecutive ascending digits\n",
    "def asc_d_4(pwd):\n",
    "    four = ['0123', '1234', '2345', '3456', '4567', '5678', '6789']\n",
    "    return 1 if any(i in pwd for i in four) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for five consecutive ascending digits\n",
    "def asc_d_5(pwd):\n",
    "    five = ['01234', '12345', '23456', '34567', '45678', '56789']\n",
    "    return 1 if any(i in pwd for i in five) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for six consecutive ascending digits\n",
    "def asc_d_6(pwd):\n",
    "    six = ['012345', '123456', '234567', '345678', '456789']\n",
    "    return 1 if any(i in pwd for i in six) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for seven consecutive ascending digits\n",
    "def asc_d_7(pwd):\n",
    "    seven = ['0123456', '1234567', '2345678', '3456789']\n",
    "    return 1 if any(i in pwd for i in seven) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for eight consecutive ascending digits\n",
    "def asc_d_8(pwd):\n",
    "    eight = ['01234567', '12345678', '23456789']\n",
    "    return 1 if any(i in pwd for i in eight) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for nine consecutive ascending digits\n",
    "def asc_d_9(pwd):\n",
    "    nine = ['012345678', '123456789']\n",
    "    return 1 if any(i in pwd for i in nine) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for ten consecutive ascending digits\n",
    "def asc_d_10(pwd):\n",
    "    ten = ['0123456789']\n",
    "    return 1 if any(i in pwd for i in ten) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to apply consecutive ascending digits features\n",
    "def asc_dig_fts(df):\n",
    "    df['Asc_Dig_2'] = df['Password'].apply(asc_d_2)\n",
    "    df['Asc_Dig_3'] = df['Password'].apply(asc_d_3)\n",
    "    df['Asc_Dig_4'] = df['Password'].apply(asc_d_4)\n",
    "    df['Asc_Dig_5'] = df['Password'].apply(asc_d_5)\n",
    "    df['Asc_Dig_6'] = df['Password'].apply(asc_d_6)\n",
    "    df['Asc_Dig_7'] = df['Password'].apply(asc_d_7)\n",
    "    df['Asc_Dig_8'] = df['Password'].apply(asc_d_8)\n",
    "    df['Asc_Dig_9'] = df['Password'].apply(asc_d_9)\n",
    "    df['Asc_Dig_10'] = df['Password'].apply(asc_d_10)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "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>Password</th>\n",
       "      <th>SHA_1</th>\n",
       "      <th>Total</th>\n",
       "      <th>Length</th>\n",
       "      <th>Length_Sq</th>\n",
       "      <th>Length_Cb</th>\n",
       "      <th>Length_Pp</th>\n",
       "      <th>Only_Let</th>\n",
       "      <th>Only_Dig</th>\n",
       "      <th>Only_Spc</th>\n",
       "      <th>...</th>\n",
       "      <th>Rep_10</th>\n",
       "      <th>Asc_Dig_2</th>\n",
       "      <th>Asc_Dig_3</th>\n",
       "      <th>Asc_Dig_4</th>\n",
       "      <th>Asc_Dig_5</th>\n",
       "      <th>Asc_Dig_6</th>\n",
       "      <th>Asc_Dig_7</th>\n",
       "      <th>Asc_Dig_8</th>\n",
       "      <th>Asc_Dig_9</th>\n",
       "      <th>Asc_Dig_10</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123456</td>\n",
       "      <td>7C4A8D09CA3762AF61E59520943DC26494F8941B</td>\n",
       "      <td>23547443</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>123456789</td>\n",
       "      <td>F7C3BC1D808E04732ADF679965CCC34CA7AE3441</td>\n",
       "      <td>7799804</td>\n",
       "      <td>9</td>\n",
       "      <td>81</td>\n",
       "      <td>729</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>qwerty</td>\n",
       "      <td>B1B3773A05C0ED0176787A4F1574FF0075F7521E</td>\n",
       "      <td>3912806</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>password</td>\n",
       "      <td>5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8</td>\n",
       "      <td>3730461</td>\n",
       "      <td>8</td>\n",
       "      <td>64</td>\n",
       "      <td>512</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>111111</td>\n",
       "      <td>3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D</td>\n",
       "      <td>3120725</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Password                                     SHA_1     Total  Length  \\\n",
       "0     123456  7C4A8D09CA3762AF61E59520943DC26494F8941B  23547443       6   \n",
       "4  123456789  F7C3BC1D808E04732ADF679965CCC34CA7AE3441   7799804       9   \n",
       "3     qwerty  B1B3773A05C0ED0176787A4F1574FF0075F7521E   3912806       6   \n",
       "1   password  5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8   3730461       8   \n",
       "7     111111  3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D   3120725       6   \n",
       "\n",
       "   Length_Sq  Length_Cb  Length_Pp  Only_Let  Only_Dig  Only_Spc  ...  Rep_10  \\\n",
       "0         36        216       0.30         0         1         0  ...       0   \n",
       "4         81        729       0.45         0         1         0  ...       0   \n",
       "3         36        216       0.30         1         0         0  ...       0   \n",
       "1         64        512       0.40         1         0         0  ...       0   \n",
       "7         36        216       0.30         0         1         0  ...       0   \n",
       "\n",
       "   Asc_Dig_2  Asc_Dig_3  Asc_Dig_4  Asc_Dig_5  Asc_Dig_6  Asc_Dig_7  \\\n",
       "0          1          1          1          1          1          0   \n",
       "4          1          1          1          1          1          1   \n",
       "3          0          0          0          0          0          0   \n",
       "1          0          0          0          0          0          0   \n",
       "7          0          0          0          0          0          0   \n",
       "\n",
       "   Asc_Dig_8  Asc_Dig_9  Asc_Dig_10  \n",
       "0          0          0           0  \n",
       "4          1          1           0  \n",
       "3          0          0           0  \n",
       "1          0          0           0  \n",
       "7          0          0           0  \n",
       "\n",
       "[5 rows x 33 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Apply consecutive ascending digits features\n",
    "df = asc_dig_fts(df)\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Check for Consecutive Descending Digits"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for two consecutive descending digits\n",
    "def dsc_d_2(pwd):\n",
    "    two = ['98', '87', '76', '65', '54', '43', '32', '21', '10']\n",
    "    return 1 if any(i in pwd for i in two) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for three consecutive descending digits\n",
    "def dsc_d_3(pwd):\n",
    "    three = ['987', '876', '765', '654', '543', '432', '321', '210']\n",
    "    return 1 if any(i in pwd for i in three) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for four consecutive descending digits\n",
    "def dsc_d_4(pwd):\n",
    "    four = ['9876', '8765', '7654', '6543', '5432', '4321', '3210']\n",
    "    return 1 if any(i in pwd for i in four) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for five consecutive descending digits\n",
    "def dsc_d_5(pwd):\n",
    "    five = ['98765', '87654', '76543', '65432', '54321', '43210']\n",
    "    return 1 if any(i in pwd for i in five) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for six consecutive descending digits\n",
    "def dsc_d_6(pwd):\n",
    "    six = ['987654', '876543', '765432', '654321', '543210']\n",
    "    return 1 if any(i in pwd for i in six) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for seven consecutive descending digits\n",
    "def dsc_d_7(pwd):\n",
    "    seven = ['9876543', '8765432', '7654321', '6543210']\n",
    "    return 1 if any(i in pwd for i in seven) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for eight consecutive descending digits\n",
    "def dsc_d_8(pwd):\n",
    "    eight = ['98765432', '87654321', '76543210']\n",
    "    return 1 if any(i in pwd for i in eight) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for nine consecutive descending digits\n",
    "def dsc_d_9(pwd):\n",
    "    nine = ['987654321', '876543210']\n",
    "    return 1 if any(i in pwd for i in nine) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for ten consecutive descending digits\n",
    "def dsc_d_10(pwd):\n",
    "    ten = ['9876543210']\n",
    "    return 1 if any(i in pwd for i in ten) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to apply consecutive descending digits features\n",
    "def dsc_dig_fts(df):\n",
    "    df['Dsc_Dig_2'] = df['Password'].apply(dsc_d_2)\n",
    "    df['Dsc_Dig_3'] = df['Password'].apply(dsc_d_3)\n",
    "    df['Dsc_Dig_4'] = df['Password'].apply(dsc_d_4)\n",
    "    df['Dsc_Dig_5'] = df['Password'].apply(dsc_d_5)\n",
    "    df['Dsc_Dig_6'] = df['Password'].apply(dsc_d_6)\n",
    "    df['Dsc_Dig_7'] = df['Password'].apply(dsc_d_7)\n",
    "    df['Dsc_Dig_8'] = df['Password'].apply(dsc_d_8)\n",
    "    df['Dsc_Dig_9'] = df['Password'].apply(dsc_d_9)\n",
    "    df['Dsc_Dig_10'] = df['Password'].apply(dsc_d_10)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>Password</th>\n",
       "      <th>SHA_1</th>\n",
       "      <th>Total</th>\n",
       "      <th>Length</th>\n",
       "      <th>Length_Sq</th>\n",
       "      <th>Length_Cb</th>\n",
       "      <th>Length_Pp</th>\n",
       "      <th>Only_Let</th>\n",
       "      <th>Only_Dig</th>\n",
       "      <th>Only_Spc</th>\n",
       "      <th>...</th>\n",
       "      <th>Asc_Dig_10</th>\n",
       "      <th>Dsc_Dig_2</th>\n",
       "      <th>Dsc_Dig_3</th>\n",
       "      <th>Dsc_Dig_4</th>\n",
       "      <th>Dsc_Dig_5</th>\n",
       "      <th>Dsc_Dig_6</th>\n",
       "      <th>Dsc_Dig_7</th>\n",
       "      <th>Dsc_Dig_8</th>\n",
       "      <th>Dsc_Dig_9</th>\n",
       "      <th>Dsc_Dig_10</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123456</td>\n",
       "      <td>7C4A8D09CA3762AF61E59520943DC26494F8941B</td>\n",
       "      <td>23547443</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>123456789</td>\n",
       "      <td>F7C3BC1D808E04732ADF679965CCC34CA7AE3441</td>\n",
       "      <td>7799804</td>\n",
       "      <td>9</td>\n",
       "      <td>81</td>\n",
       "      <td>729</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>qwerty</td>\n",
       "      <td>B1B3773A05C0ED0176787A4F1574FF0075F7521E</td>\n",
       "      <td>3912806</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>password</td>\n",
       "      <td>5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8</td>\n",
       "      <td>3730461</td>\n",
       "      <td>8</td>\n",
       "      <td>64</td>\n",
       "      <td>512</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>111111</td>\n",
       "      <td>3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D</td>\n",
       "      <td>3120725</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Password                                     SHA_1     Total  Length  \\\n",
       "0     123456  7C4A8D09CA3762AF61E59520943DC26494F8941B  23547443       6   \n",
       "4  123456789  F7C3BC1D808E04732ADF679965CCC34CA7AE3441   7799804       9   \n",
       "3     qwerty  B1B3773A05C0ED0176787A4F1574FF0075F7521E   3912806       6   \n",
       "1   password  5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8   3730461       8   \n",
       "7     111111  3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D   3120725       6   \n",
       "\n",
       "   Length_Sq  Length_Cb  Length_Pp  Only_Let  Only_Dig  Only_Spc  ...  \\\n",
       "0         36        216       0.30         0         1         0  ...   \n",
       "4         81        729       0.45         0         1         0  ...   \n",
       "3         36        216       0.30         1         0         0  ...   \n",
       "1         64        512       0.40         1         0         0  ...   \n",
       "7         36        216       0.30         0         1         0  ...   \n",
       "\n",
       "   Asc_Dig_10  Dsc_Dig_2  Dsc_Dig_3  Dsc_Dig_4  Dsc_Dig_5  Dsc_Dig_6  \\\n",
       "0           0          0          0          0          0          0   \n",
       "4           0          0          0          0          0          0   \n",
       "3           0          0          0          0          0          0   \n",
       "1           0          0          0          0          0          0   \n",
       "7           0          0          0          0          0          0   \n",
       "\n",
       "   Dsc_Dig_7  Dsc_Dig_8  Dsc_Dig_9  Dsc_Dig_10  \n",
       "0          0          0          0           0  \n",
       "4          0          0          0           0  \n",
       "3          0          0          0           0  \n",
       "1          0          0          0           0  \n",
       "7          0          0          0           0  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Apply consecutive descending digits features\n",
    "df = dsc_dig_fts(df)\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Check for Consecutive Ascending Letters"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for two consecutive ascending letters\n",
    "def asc_l_2(pwd):\n",
    "    two = ['ab', 'bc', 'cd', 'de', 'ef', 'fg', 'gh', 'hi', 'ij', 'jk', 'kl', 'lm', 'mn',\n",
    "           'no', 'op', 'pq', 'qr', 'rs', 'st', 'tu', 'uv', 'vw', 'wx', 'xy', 'yz']\n",
    "    return 1 if any(i in pwd for i in two) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for three consecutive ascending letters\n",
    "def asc_l_3(pwd):\n",
    "    three = ['abc', 'bcd', 'cde', 'def', 'efg', 'fgh', 'ghi', 'hij', 'ijk', 'jkl', 'klm',\n",
    "             'lmn', 'mno', 'nop', 'opq', 'pqr', 'qrs', 'rst', 'stu', 'tuv', 'uvw', 'vwx',\n",
    "             'wxy', 'xyz']\n",
    "    return 1 if any(i in pwd for i in three) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for four consecutive ascending letters\n",
    "def asc_l_4(pwd):\n",
    "    four = ['abcd', 'bcde', 'cdef', 'defg', 'efgh', 'fghi', 'ghij', 'hijk', 'ijkl', 'jklm',\n",
    "            'klmn', 'lmno', 'mnop', 'nopq', 'opqr', 'pqrs', 'qrst', 'rstu', 'stuv', 'tuvw',\n",
    "            'uvwx', 'vwxy', 'wxyz']\n",
    "    return 1 if any(i in pwd for i in four) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for five consecutive ascending letters\n",
    "def asc_l_5(pwd):\n",
    "    five = ['abcde', 'bcdef', 'cdefg', 'defgh', 'efghi', 'fghij', 'ghijk', 'hijkl', 'ijklm',\n",
    "            'jklmn', 'klmno', 'lmnop', 'mnopq', 'nopqr', 'opqrs', 'pqrst', 'qrstu', 'rstuv',\n",
    "            'stuvw', 'tuvwx', 'uvwxy', 'vwxyz']\n",
    "    return 1 if any(i in pwd for i in five) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for six consecutive ascending letters\n",
    "def asc_l_6(pwd):\n",
    "    six = ['abcdef', 'bcdefg', 'cdefgh', 'defghi', 'efghij', 'fghijk', 'ghijkl', 'hijklm',\n",
    "           'ijklmn', 'jklmno', 'klmnop', 'lmnopq', 'mnopqr', 'nopqrs', 'opqrst', 'pqrstu',\n",
    "           'qrstuv', 'rstuvw', 'stuvwx', 'tuvwxy', 'uvwxyz']\n",
    "    return 1 if any(i in pwd for i in six) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for seven consecutive ascending letters\n",
    "def asc_l_7(pwd):\n",
    "    seven = ['abcdefg', 'bcdefgh', 'cdefghi', 'defghij', 'efghijk', 'fghijkl', 'ghijklm',\n",
    "             'hijklmn', 'ijklmno', 'jklmnop', 'klmnopq', 'lmnopqr', 'mnopqrs', 'nopqrst',\n",
    "             'opqrstu', 'pqrstuv', 'qrstuvw', 'rstuvwx', 'stuvwxy', 'tuvwxyz']\n",
    "    return 1 if any(i in pwd for i in seven) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for eight consecutive ascending letters\n",
    "def asc_l_8(pwd):\n",
    "    eight = ['abcdefgh', 'bcdefghi', 'cdefghij', 'defghijk', 'efghijkl', 'fghijklm',\n",
    "             'ghijklmn', 'hijklmno', 'ijklmnop', 'jklmnopq', 'klmnopqr', 'lmnopqrs',\n",
    "             'mnopqrst', 'nopqrstu', 'opqrstuv', 'pqrstuvw', 'qrstuvwx', 'rstuvwxy',\n",
    "             'stuvwxyz']\n",
    "    return 1 if any(i in pwd for i in eight) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for nine consecutive ascending letters\n",
    "def asc_l_9(pwd):\n",
    "    nine = ['abcdefghi', 'bcdefghij', 'cdefghijk', 'defghijkl', 'efghijklm', 'fghijklmn',\n",
    "            'ghijklmno', 'hijklmnop', 'ijklmnopq', 'jklmnopqr', 'klmnopqrs', 'lmnopqrst',\n",
    "            'mnopqrstu', 'nopqrstuv', 'opqrstuvw', 'pqrstuvwx', 'qrstuvwxy', 'rstuvwxyz']\n",
    "    return 1 if any(i in pwd for i in nine) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for ten consecutive ascending letters\n",
    "def asc_l_10(pwd):\n",
    "    ten = ['abcdefghij', 'bcdefghijk', 'cdefghijkl', 'defghijklm', 'efghijklmn', 'fghijklmno',\n",
    "           'ghijklmnop', 'hijklmnopq', 'ijklmnopqr', 'jklmnopqrs', 'klmnopqrst', 'lmnopqrstu',\n",
    "           'mnopqrstuv', 'nopqrstuvw', 'opqrstuvwx', 'pqrstuvwxy', 'qrstuvwxyz']\n",
    "    return 1 if any(i in pwd for i in ten) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to apply consecutive ascending letters features\n",
    "def asc_let_fts(df):\n",
    "    df['Asc_Let_2'] = df['Password'].apply(asc_l_2)\n",
    "    df['Asc_Let_3'] = df['Password'].apply(asc_l_3)\n",
    "    df['Asc_Let_4'] = df['Password'].apply(asc_l_4)\n",
    "    df['Asc_Let_5'] = df['Password'].apply(asc_l_5)\n",
    "    df['Asc_Let_6'] = df['Password'].apply(asc_l_6)\n",
    "    df['Asc_Let_7'] = df['Password'].apply(asc_l_7)\n",
    "    df['Asc_Let_8'] = df['Password'].apply(asc_l_8)\n",
    "    df['Asc_Let_9'] = df['Password'].apply(asc_l_9)\n",
    "    df['Asc_Let_10'] = df['Password'].apply(asc_l_10)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "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>Password</th>\n",
       "      <th>SHA_1</th>\n",
       "      <th>Total</th>\n",
       "      <th>Length</th>\n",
       "      <th>Length_Sq</th>\n",
       "      <th>Length_Cb</th>\n",
       "      <th>Length_Pp</th>\n",
       "      <th>Only_Let</th>\n",
       "      <th>Only_Dig</th>\n",
       "      <th>Only_Spc</th>\n",
       "      <th>...</th>\n",
       "      <th>Dsc_Dig_10</th>\n",
       "      <th>Asc_Let_2</th>\n",
       "      <th>Asc_Let_3</th>\n",
       "      <th>Asc_Let_4</th>\n",
       "      <th>Asc_Let_5</th>\n",
       "      <th>Asc_Let_6</th>\n",
       "      <th>Asc_Let_7</th>\n",
       "      <th>Asc_Let_8</th>\n",
       "      <th>Asc_Let_9</th>\n",
       "      <th>Asc_Let_10</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123456</td>\n",
       "      <td>7C4A8D09CA3762AF61E59520943DC26494F8941B</td>\n",
       "      <td>23547443</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>123456789</td>\n",
       "      <td>F7C3BC1D808E04732ADF679965CCC34CA7AE3441</td>\n",
       "      <td>7799804</td>\n",
       "      <td>9</td>\n",
       "      <td>81</td>\n",
       "      <td>729</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>qwerty</td>\n",
       "      <td>B1B3773A05C0ED0176787A4F1574FF0075F7521E</td>\n",
       "      <td>3912806</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>password</td>\n",
       "      <td>5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8</td>\n",
       "      <td>3730461</td>\n",
       "      <td>8</td>\n",
       "      <td>64</td>\n",
       "      <td>512</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>111111</td>\n",
       "      <td>3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D</td>\n",
       "      <td>3120725</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 51 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Password                                     SHA_1     Total  Length  \\\n",
       "0     123456  7C4A8D09CA3762AF61E59520943DC26494F8941B  23547443       6   \n",
       "4  123456789  F7C3BC1D808E04732ADF679965CCC34CA7AE3441   7799804       9   \n",
       "3     qwerty  B1B3773A05C0ED0176787A4F1574FF0075F7521E   3912806       6   \n",
       "1   password  5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8   3730461       8   \n",
       "7     111111  3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D   3120725       6   \n",
       "\n",
       "   Length_Sq  Length_Cb  Length_Pp  Only_Let  Only_Dig  Only_Spc  ...  \\\n",
       "0         36        216       0.30         0         1         0  ...   \n",
       "4         81        729       0.45         0         1         0  ...   \n",
       "3         36        216       0.30         1         0         0  ...   \n",
       "1         64        512       0.40         1         0         0  ...   \n",
       "7         36        216       0.30         0         1         0  ...   \n",
       "\n",
       "   Dsc_Dig_10  Asc_Let_2  Asc_Let_3  Asc_Let_4  Asc_Let_5  Asc_Let_6  \\\n",
       "0           0          0          0          0          0          0   \n",
       "4           0          0          0          0          0          0   \n",
       "3           0          0          0          0          0          0   \n",
       "1           0          0          0          0          0          0   \n",
       "7           0          0          0          0          0          0   \n",
       "\n",
       "   Asc_Let_7  Asc_Let_8  Asc_Let_9  Asc_Let_10  \n",
       "0          0          0          0           0  \n",
       "4          0          0          0           0  \n",
       "3          0          0          0           0  \n",
       "1          0          0          0           0  \n",
       "7          0          0          0           0  \n",
       "\n",
       "[5 rows x 51 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Apply consecutive ascending letters features\n",
    "df = asc_let_fts(df)\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Check for Consecutive Descending Letters"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for two consecutive descending letters\n",
    "def dsc_l_2(pwd):\n",
    "    two = ['zy', 'yx', 'xw', 'wv', 'vu', 'ut', 'ts', 'sr', 'rq', 'qp', 'po', 'on', 'nm',\n",
    "           'ml', 'lk', 'kj', 'ji', 'ih', 'hg', 'gf', 'fe', 'ed', 'dc', 'cb', 'ba']\n",
    "    return 1 if any(i in pwd for i in two) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for three consecutive descending letters\n",
    "def dsc_l_3(pwd):\n",
    "    three = ['zyx', 'yxw', 'xwv', 'wvu', 'vut', 'uts', 'tsr', 'srq', 'rqp', 'qpo', 'pon',\n",
    "             'onm', 'nml', 'mlk', 'lkj', 'kji', 'jih', 'ihg', 'hgf', 'gfe', 'fed', 'edc',\n",
    "             'dcb', 'cba']\n",
    "    return 1 if any(i in pwd for i in three) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for four consecutive descending letters\n",
    "def dsc_l_4(pwd):\n",
    "    four = ['zyxw', 'yxwv', 'xwvu', 'wvut', 'vuts', 'utsr', 'tsrq', 'srqp', 'rqpo', 'qpon',\n",
    "            'ponm', 'onml', 'nmlk', 'mlkj', 'lkji', 'kjih', 'jihg', 'ihgf', 'hgfe', 'gfed',\n",
    "            'fedc', 'edcb', 'dcba']\n",
    "    return 1 if any(i in pwd for i in four) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for five consecutive descending letters\n",
    "def dsc_l_5(pwd):\n",
    "    five = ['zyxwv', 'yxwvu', 'xwvut', 'wvuts', 'vutsr', 'utsrq', 'tsrqp', 'srqpo', 'rqpon',\n",
    "            'qponm', 'ponml', 'onmlk', 'nmlkj', 'mlkji', 'lkjih', 'kjihg', 'jihgf', 'ihgfe',\n",
    "            'hgfed', 'gfedc', 'fedcb', 'edcba']\n",
    "    return 1 if any(i in pwd for i in five) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for six consecutive descending letters\n",
    "def dsc_l_6(pwd):\n",
    "    six = ['zyxwvu', 'yxwvut', 'xwvuts', 'wvutsr', 'vutsrq', 'utsrqp', 'tsrqpo', 'srqpon',\n",
    "           'rqponm', 'qponml', 'ponmlk', 'onmlkj', 'nmlkji', 'mlkjih', 'lkjihg', 'kjihgf',\n",
    "           'jihgfe', 'ihgfed', 'hgfedc', 'gfedcb', 'fedcba']\n",
    "    return 1 if any(i in pwd for i in six) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for seven consecutive descending letters\n",
    "def dsc_l_7(pwd):\n",
    "    seven = ['zyxwvut', 'yxwvuts', 'xwvutsr', 'wvutsrq', 'vutsrqp', 'utsrqpo', 'tsrqpon',\n",
    "             'srqponm', 'rqponml', 'qponmlk', 'ponmlkj', 'onmlkji', 'nmlkjih', 'mlkjihg',\n",
    "             'lkjihgf', 'kjihgfe', 'jihgfed', 'ihgfedc', 'hgfedcb', 'gfedcba']\n",
    "    return 1 if any(i in pwd for i in seven) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for eight consecutive descending letters\n",
    "def dsc_l_8(pwd):\n",
    "    eight = ['zyxwvuts', 'yxwvutsr', 'xwvutsrq', 'wvutsrqp', 'vutsrqpo', 'utsrqpon',\n",
    "             'tsrqponm', 'srqponml', 'rqponmlk', 'qponmlkj', 'ponmlkji', 'onmlkjih',\n",
    "             'nmlkjihg', 'mlkjihgf', 'lkjihgfe', 'kjihgfed', 'jihgfedc', 'ihgfedcb',\n",
    "             'hgfedcba']\n",
    "    return 1 if any(i in pwd for i in eight) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for nine consecutive descending letters\n",
    "def dsc_l_9(pwd):\n",
    "    nine = ['zyxwvutsr', 'yxwvutsrq', 'xwvutsrqp', 'wvutsrqpo', 'vutsrqpon', 'utsrqponm',\n",
    "            'tsrqponml', 'srqponmlk', 'rqponmlkj', 'qponmlkji', 'ponmlkjih', 'onmlkjihg',\n",
    "            'nmlkjihgf', 'mlkjihgfe', 'lkjihgfed', 'kjihgfedc', 'jihgfedcb', 'ihgfedcba']\n",
    "    return 1 if any(i in pwd for i in nine) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to check for ten consecutive descending letters\n",
    "def dsc_l_10(pwd):\n",
    "    ten = ['zyxwvutsrq', 'yxwvutsrqp', 'xwvutsrqpo', 'wvutsrqpon', 'vutsrqponm', 'utsrqponml',\n",
    "           'tsrqponmlk', 'srqponmlkj', 'rqponmlkji', 'qponmlkjih', 'ponmlkjihg', 'onmlkjihgf',\n",
    "           'nmlkjihgfe', 'mlkjihgfed', 'lkjihgfedc', 'kjihgfedcb', 'jihgfedcba']\n",
    "    return 1 if any(i in pwd for i in ten) else 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to apply consecutive descending letters features\n",
    "def dsc_let_fts(df):\n",
    "    df['Dsc_Let_2'] = df['Password'].apply(dsc_l_2)\n",
    "    df['Dsc_Let_3'] = df['Password'].apply(dsc_l_3)\n",
    "    df['Dsc_Let_4'] = df['Password'].apply(dsc_l_4)\n",
    "    df['Dsc_Let_5'] = df['Password'].apply(dsc_l_5)\n",
    "    df['Dsc_Let_6'] = df['Password'].apply(dsc_l_6)\n",
    "    df['Dsc_Let_7'] = df['Password'].apply(dsc_l_7)\n",
    "    df['Dsc_Let_8'] = df['Password'].apply(dsc_l_8)\n",
    "    df['Dsc_Let_9'] = df['Password'].apply(dsc_l_9)\n",
    "    df['Dsc_Let_10'] = df['Password'].apply(dsc_l_10)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "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>Password</th>\n",
       "      <th>SHA_1</th>\n",
       "      <th>Total</th>\n",
       "      <th>Length</th>\n",
       "      <th>Length_Sq</th>\n",
       "      <th>Length_Cb</th>\n",
       "      <th>Length_Pp</th>\n",
       "      <th>Only_Let</th>\n",
       "      <th>Only_Dig</th>\n",
       "      <th>Only_Spc</th>\n",
       "      <th>...</th>\n",
       "      <th>Asc_Let_10</th>\n",
       "      <th>Dsc_Let_2</th>\n",
       "      <th>Dsc_Let_3</th>\n",
       "      <th>Dsc_Let_4</th>\n",
       "      <th>Dsc_Let_5</th>\n",
       "      <th>Dsc_Let_6</th>\n",
       "      <th>Dsc_Let_7</th>\n",
       "      <th>Dsc_Let_8</th>\n",
       "      <th>Dsc_Let_9</th>\n",
       "      <th>Dsc_Let_10</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123456</td>\n",
       "      <td>7C4A8D09CA3762AF61E59520943DC26494F8941B</td>\n",
       "      <td>23547443</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>123456789</td>\n",
       "      <td>F7C3BC1D808E04732ADF679965CCC34CA7AE3441</td>\n",
       "      <td>7799804</td>\n",
       "      <td>9</td>\n",
       "      <td>81</td>\n",
       "      <td>729</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>qwerty</td>\n",
       "      <td>B1B3773A05C0ED0176787A4F1574FF0075F7521E</td>\n",
       "      <td>3912806</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>password</td>\n",
       "      <td>5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8</td>\n",
       "      <td>3730461</td>\n",
       "      <td>8</td>\n",
       "      <td>64</td>\n",
       "      <td>512</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>111111</td>\n",
       "      <td>3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D</td>\n",
       "      <td>3120725</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Password                                     SHA_1     Total  Length  \\\n",
       "0     123456  7C4A8D09CA3762AF61E59520943DC26494F8941B  23547443       6   \n",
       "4  123456789  F7C3BC1D808E04732ADF679965CCC34CA7AE3441   7799804       9   \n",
       "3     qwerty  B1B3773A05C0ED0176787A4F1574FF0075F7521E   3912806       6   \n",
       "1   password  5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8   3730461       8   \n",
       "7     111111  3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D   3120725       6   \n",
       "\n",
       "   Length_Sq  Length_Cb  Length_Pp  Only_Let  Only_Dig  Only_Spc  ...  \\\n",
       "0         36        216       0.30         0         1         0  ...   \n",
       "4         81        729       0.45         0         1         0  ...   \n",
       "3         36        216       0.30         1         0         0  ...   \n",
       "1         64        512       0.40         1         0         0  ...   \n",
       "7         36        216       0.30         0         1         0  ...   \n",
       "\n",
       "   Asc_Let_10  Dsc_Let_2  Dsc_Let_3  Dsc_Let_4  Dsc_Let_5  Dsc_Let_6  \\\n",
       "0           0          0          0          0          0          0   \n",
       "4           0          0          0          0          0          0   \n",
       "3           0          0          0          0          0          0   \n",
       "1           0          0          0          0          0          0   \n",
       "7           0          0          0          0          0          0   \n",
       "\n",
       "   Dsc_Let_7  Dsc_Let_8  Dsc_Let_9  Dsc_Let_10  \n",
       "0          0          0          0           0  \n",
       "4          0          0          0           0  \n",
       "3          0          0          0           0  \n",
       "1          0          0          0           0  \n",
       "7          0          0          0           0  \n",
       "\n",
       "[5 rows x 60 columns]"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Apply consecutive descending letters features\n",
    "df = dsc_let_fts(df)\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Interaction Features"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to create interaction features of dummy variables divided by password length\n",
    "def int_fts(df):\n",
    "    ignore = ['Password', 'SHA_1', 'Total', 'Length', 'Length_Sq', 'Length_Cb', 'Length_Pp']\n",
    "    features = df.drop(columns=ignore, axis=1).keys()\n",
    "    for f in features:\n",
    "        df[f'{f}_Div_Len'] = df[f'{f}']/df['Length']\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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>Password</th>\n",
       "      <th>SHA_1</th>\n",
       "      <th>Total</th>\n",
       "      <th>Length</th>\n",
       "      <th>Length_Sq</th>\n",
       "      <th>Length_Cb</th>\n",
       "      <th>Length_Pp</th>\n",
       "      <th>Only_Let</th>\n",
       "      <th>Only_Dig</th>\n",
       "      <th>Only_Spc</th>\n",
       "      <th>...</th>\n",
       "      <th>Asc_Let_10_Div_Len</th>\n",
       "      <th>Dsc_Let_2_Div_Len</th>\n",
       "      <th>Dsc_Let_3_Div_Len</th>\n",
       "      <th>Dsc_Let_4_Div_Len</th>\n",
       "      <th>Dsc_Let_5_Div_Len</th>\n",
       "      <th>Dsc_Let_6_Div_Len</th>\n",
       "      <th>Dsc_Let_7_Div_Len</th>\n",
       "      <th>Dsc_Let_8_Div_Len</th>\n",
       "      <th>Dsc_Let_9_Div_Len</th>\n",
       "      <th>Dsc_Let_10_Div_Len</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>123456</td>\n",
       "      <td>7C4A8D09CA3762AF61E59520943DC26494F8941B</td>\n",
       "      <td>23547443</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>123456789</td>\n",
       "      <td>F7C3BC1D808E04732ADF679965CCC34CA7AE3441</td>\n",
       "      <td>7799804</td>\n",
       "      <td>9</td>\n",
       "      <td>81</td>\n",
       "      <td>729</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>qwerty</td>\n",
       "      <td>B1B3773A05C0ED0176787A4F1574FF0075F7521E</td>\n",
       "      <td>3912806</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>password</td>\n",
       "      <td>5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8</td>\n",
       "      <td>3730461</td>\n",
       "      <td>8</td>\n",
       "      <td>64</td>\n",
       "      <td>512</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>111111</td>\n",
       "      <td>3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D</td>\n",
       "      <td>3120725</td>\n",
       "      <td>6</td>\n",
       "      <td>36</td>\n",
       "      <td>216</td>\n",
       "      <td>0.30</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 113 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Password                                     SHA_1     Total  Length  \\\n",
       "0     123456  7C4A8D09CA3762AF61E59520943DC26494F8941B  23547443       6   \n",
       "4  123456789  F7C3BC1D808E04732ADF679965CCC34CA7AE3441   7799804       9   \n",
       "3     qwerty  B1B3773A05C0ED0176787A4F1574FF0075F7521E   3912806       6   \n",
       "1   password  5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8   3730461       8   \n",
       "7     111111  3D4F2BF07DC1BE38B20CD6E46949A1071F9D0E3D   3120725       6   \n",
       "\n",
       "   Length_Sq  Length_Cb  Length_Pp  Only_Let  Only_Dig  Only_Spc  ...  \\\n",
       "0         36        216       0.30         0         1         0  ...   \n",
       "4         81        729       0.45         0         1         0  ...   \n",
       "3         36        216       0.30         1         0         0  ...   \n",
       "1         64        512       0.40         1         0         0  ...   \n",
       "7         36        216       0.30         0         1         0  ...   \n",
       "\n",
       "   Asc_Let_10_Div_Len  Dsc_Let_2_Div_Len  Dsc_Let_3_Div_Len  \\\n",
       "0                 0.0                0.0                0.0   \n",
       "4                 0.0                0.0                0.0   \n",
       "3                 0.0                0.0                0.0   \n",
       "1                 0.0                0.0                0.0   \n",
       "7                 0.0                0.0                0.0   \n",
       "\n",
       "   Dsc_Let_4_Div_Len  Dsc_Let_5_Div_Len  Dsc_Let_6_Div_Len  Dsc_Let_7_Div_Len  \\\n",
       "0                0.0                0.0                0.0                0.0   \n",
       "4                0.0                0.0                0.0                0.0   \n",
       "3                0.0                0.0                0.0                0.0   \n",
       "1                0.0                0.0                0.0                0.0   \n",
       "7                0.0                0.0                0.0                0.0   \n",
       "\n",
       "   Dsc_Let_8_Div_Len  Dsc_Let_9_Div_Len  Dsc_Let_10_Div_Len  \n",
       "0                0.0                0.0                 0.0  \n",
       "4                0.0                0.0                 0.0  \n",
       "3                0.0                0.0                 0.0  \n",
       "1                0.0                0.0                 0.0  \n",
       "7                0.0                0.0                 0.0  \n",
       "\n",
       "[5 rows x 113 columns]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Apply interaction features\n",
    "df = int_fts(df)\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(86140, 113)"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # Function to create features of dummy variables divided by password length\n",
    "# def int_fts(df):\n",
    "#     ignore = ['Password', 'SHA_1', 'Total', 'Length', 'Length_Sq', 'Length_Cb', 'Length_Pp']\n",
    "#     dummies = df.drop(columns=ignore, axis=1).keys()\n",
    "#     for d in dummies:\n",
    "#         df[f'{d}_Dby_Len'] = df[f'{d}']/df['Length']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Save Working Dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(86140, 113)"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # Save to csv\n",
    "# df.to_csv('Datasets/working_df.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}