attendance.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "20c093bb",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "6fd01ad2",
   "metadata": {},
   "outputs": [],
   "source": [
    "def attendance(x):\n",
    "    x = x.replace('-','')\n",
    "    l = list(set(re.findall('\\d{13}',x)))\n",
    "    return pd.DataFrame({\"CNIC\":l})\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "1b140620",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "39\n"
     ]
    },
    {
     "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>CNIC</th>\n",
       "      <th>c1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4230108335683</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4410242997959</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4210164790696</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4220113316709</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4210146436547</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            CNIC  c1\n",
       "0  4230108335683   1\n",
       "1  4410242997959   1\n",
       "2  4210164790696   1\n",
       "3  4220113316709   1\n",
       "4  4210146436547   1"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = \"\"\"\n",
    "Shakir Hussain2:51 PM\n",
    "42101-9276734-9\n",
    "Muhammad Ayaz2:52 PM\n",
    "4410242997959\n",
    "Masroor3:02 PM\n",
    "42201-2286846-7\n",
    "taimoor qureshi3:06 PM\n",
    "4240179641627\n",
    "Tatheer Fatima3:07 PM\n",
    "4210124609792\n",
    "Dewan S Khan3:09 PM\n",
    "4220105630741\n",
    "Arsalan Ahmed3:12 PM\n",
    "42201-6535195-7\n",
    "Dewan S Khan3:12 PM\n",
    "4220105630741\n",
    "Bilal Uddin3:13 PM\n",
    "4220122191357\n",
    "Muhammad Atique Qayyum3:16 PM\n",
    "4220140225236\n",
    "Tariq Mehmood3:16 PM\n",
    "4220104505899\n",
    "Haris Chhipa3:17 PM\n",
    "4210156195059\n",
    "Dewan S Khan3:17 PM\n",
    "import re\n",
    "a=re.findall(r'\\bFrom (.*) To Everyone : (\\d{5,7})',x)\n",
    "Haris Chhipa3:19 PM\n",
    "3130399221225\n",
    "Zeeshan Naqvi3:19 PM\n",
    "4210151751811\n",
    "Muhammad Sameer3:20 PM\n",
    "42501-1025700-1\n",
    "Masroor3:20 PM\n",
    "42401-1880106-5\n",
    "Mohsin Kanani3:20 PM\n",
    "4230108335683\n",
    "Hassan Ahmed3:20 PM\n",
    "4220156089133\n",
    "Muhammad Sameer3:20 PM\n",
    "4250110257001\n",
    "Waqas Zafar3:20 PM\n",
    "5440004083505\n",
    "Ali Naiyar3:20 PM\n",
    "4210120075463\n",
    "Malik Humza3:20 PM\n",
    "4240105171159\n",
    "HAREEM RIZVI3:20 PM\n",
    "42101-3311570-4\n",
    "Muhammad Ayaz3:20 PM\n",
    "4410242997959\n",
    "Yusra Adnan3:20 PM\n",
    "4210164790696\n",
    "Shakir Hussain3:20 PM\n",
    "4210182767349\n",
    "Yusra Adnan3:20 PM\n",
    "Yusra Adnan\n",
    "Zareen Fatima3:20 PM\n",
    "3520269403788\n",
    "zain abidi3:20 PM\n",
    "4250119167549\n",
    "Muhammad Atique Qayyum3:20 PM\n",
    "4250104502069\n",
    "Syed Sajjad Raxa3:20 PM\n",
    "4220143471143\n",
    "usman ahmad3:20 PM\n",
    "4220113316709\n",
    "Syed Kashif3:21 PM\n",
    "4250144488545\n",
    "Syed Ammad Waheed3:21 PM\n",
    "4210113863591\n",
    "Dewan S Khan3:21 PM\n",
    "4220105630741\n",
    "Faizan Ehtesham3:21 PM\n",
    "4240114707349\n",
    "Hussain Ali3:21 PM\n",
    "4220117852609\n",
    "Muhammad Sameer3:21 PM\n",
    "4210115022744\n",
    "Arsalan Risalat3:21 PM\n",
    "4220124812817\n",
    "Mohsin Kanani3:21 PM\n",
    "4230108335683\n",
    "Syed Ammad Waheed3:21 PM\n",
    "4210113863591 Syed Ammad Waheed Hassani\n",
    "Asima Ali3:21 PM\n",
    "4420626938874\n",
    "Mushyada Ali3:21 PM\n",
    "4210103553847\n",
    "Muhammad Sameer3:22 PM\n",
    "425010257001\n",
    "Zareen Fatima3:22 PM\n",
    "3520269403788\n",
    "Mushyada Ali3:22 PM\n",
    "4210146436547 M Afnan Ali Khan\n",
    "Bilal Uddin3:22 PM\n",
    "4220122868467 Abdullah\n",
    "Sheikh Faizan3:22 PM\n",
    "42101-7490505-9\n",
    "Syed Tanveer3:22 PM\n",
    "4220169252467\n",
    "Sheikh Faizan3:22 PM\n",
    "Sheikh Faizan\n",
    "Mushyada Ali3:23 PM\n",
    "4210103553847\n",
    "Sheikh Faizan3:23 PM\n",
    "Sheikh Faizan\n",
    "42101-7490505-9\n",
    "Muhammad Sameer3:23 PM\n",
    "4250110257001\n",
    "4210115022744\n",
    "myd-bnjm-grb\n",
    "\"\"\"\n",
    "df1 = attendance(x)\n",
    "df1['c1'] = 1\n",
    "print(len(df1))\n",
    "df1.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "79b25724",
   "metadata": {},
   "source": [
    "# Class2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "c9092e1d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "43\n"
     ]
    },
    {
     "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>CNIC</th>\n",
       "      <th>c2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4230108335683</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4410242997959</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4210164790696</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4220113316709</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4250191411023</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            CNIC  c2\n",
       "0  4230108335683   1\n",
       "1  4410242997959   1\n",
       "2  4210164790696   1\n",
       "3  4220113316709   1\n",
       "4  4250191411023   1"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = \"\"\"\n",
    "Dewan S Khan1:32 PM\n",
    "4220105630741\n",
    "Zareen Fatima1:35 PM\n",
    "no voice\n",
    "Khawar Masood1:39 PM\n",
    "yes\n",
    "Muhammad faizan Farooque1:39 PM\n",
    "4230139662957\n",
    "Syed Ammad Waheed1:42 PM\n",
    "4210113863591 Syed Ammad Waheed Hassani\n",
    "Muhammad Rohan1:58 PM\n",
    "Avatar bnadya isne sir\n",
    "Nazneen Akram1:58 PM\n",
    ":D\n",
    "Ad Khan1:59 PM\n",
    "Muhammad Adnan Khan 4220113823383\n",
    "Masroor2:02 PM\n",
    "42401-1880106-5\n",
    "Khawar Masood2:19 PM\n",
    "42101-4113797-7\n",
    "Rozina Mazhar Ali2:25 PM\n",
    "4220159083880\n",
    "Yusra Adnan2:30 PM\n",
    "4210164790696\n",
    "Bilal Uddin2:31 PM\n",
    "4220122191357\n",
    "Shakir Hussain2:31 PM\n",
    "4210182767349\n",
    "Nazneen Akram2:31 PM\n",
    "4210145447712\n",
    "Zahid Bashir2:33 PM\n",
    "4250191411023\n",
    "Munir Ali2:34 PM\n",
    "4220101410369\n",
    "zain abidi2:38 PM\n",
    "4250119167549\n",
    "Muhammad Rohan2:45 PM\n",
    "4210116966995\n",
    "Sania Tehseen2:54 PM\n",
    "4210115022744\n",
    "Syed Tanveer2:55 PM\n",
    "4220169252467\n",
    "Zareen Fatima2:55 PM\n",
    "3520269403788\n",
    "HAREEM RIZVI2:55 PM\n",
    "42101-3311570-4\n",
    "Asima Ali2:55 PM\n",
    "4420626938874\n",
    "Syed Masroor Ali (Masroor)2:58 PM\n",
    "42401-1880106-5\n",
    "You2:58 PM\n",
    "https://github.com/EnggQasim/NED_ML_batch3/blob/main/class2/File%20Handling.ipynb\n",
    "Dewan S Khan2:59 PM\n",
    "4220105630741\n",
    "Arsalan Risalat2:59 PM\n",
    "4220124812817\n",
    "Tabassum Ali3:03 PM\n",
    "4230123126547\n",
    "Arsalan Ahmed3:03 PM\n",
    "42201-6535195-7\n",
    "Haris Chhipa3:04 PM\n",
    "4210156195059\n",
    "Syed Masroor Ali (Masroor)3:07 PM\n",
    "42201-2286846-7\n",
    "Tariq Mehmood3:08 PM\n",
    "4220104505899\n",
    "Haris Chhipa3:09 PM\n",
    "3130399221225\n",
    "Shakir Hussain3:14 PM\n",
    "42101-8276734-9\n",
    "Dewan S Khan3:14 PM\n",
    "4220105630741\n",
    "Muhammad Sameer3:16 PM\n",
    "4210115022744\n",
    "4250110257001\n",
    "Dewan S Khan3:16 PM\n",
    "4220105630741\n",
    "Syed Masroor Ali (Masroor)3:17 PM\n",
    "42401-1880106-5\n",
    "Zareen Fatima3:17 PM\n",
    "3520269403788\n",
    "Muhammad Atique Qayyum3:17 PM\n",
    "4220140225263\n",
    "Dewan S Khan3:17 PM\n",
    "4220105630741\n",
    "Khawar Masood3:17 PM\n",
    "42101-4113797-7\n",
    "Muhammad Rohan3:17 PM\n",
    "4210116966995\n",
    "Munir Ali3:17 PM\n",
    "4220101410369\n",
    "Hassan Ahmed3:17 PM\n",
    "4220156089133\n",
    "Sheikh Faizan3:17 PM\n",
    "Sheikh Faizan\n",
    "42101-7490505-9\n",
    "Muhammad Sameer3:17 PM\n",
    "4210115022744\n",
    "4250110257001\n",
    "Muhammad Ayaz3:17 PM\n",
    "4410242997959\n",
    "Nofil Ahmed3:17 PM\n",
    "4210175076663\n",
    "Fazal Diyan3:17 PM\n",
    "42301-9945992-1\n",
    "Mohsin Kanani3:17 PM\n",
    "4230108335683\n",
    "Syed Kashif Ahmed3:17 PM\n",
    "4250144488545\n",
    "Fazal Diyan3:17 PM\n",
    "4210146436547\n",
    "usman ahmad3:18 PM\n",
    "4220113316709\n",
    "Fazal Diyan3:18 PM\n",
    "4210184252633\n",
    "Malik Humza3:18 PM\n",
    "4240105171159\n",
    "Aqeel Mehdi3:18 PM\n",
    "4220105436681\n",
    "zain abidi3:18 PM\n",
    "4250119167549\n",
    "HAREEM RIZVI3:19 PM\n",
    "42101-3311570-4\n",
    "Bilal Ahmed3:19 PM\n",
    "4210120075463\n",
    "Khizra Rizvi3:19 PM\n",
    "544004746932\n",
    "Muhammad Sameer3:19 PM\n",
    "4210115022744\n",
    "4250110257001\n",
    "Bilal Ahmed3:19 PM\n",
    "4210198030681\n",
    "myd-bnjm-grb\n",
    "\"\"\"\n",
    "df2 = attendance(x)\n",
    "print(len(df2))\n",
    "df2['c2'] = 1\n",
    "df2.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c43d3243",
   "metadata": {},
   "source": [
    "# Class3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "89bc85cc",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "46\n"
     ]
    },
    {
     "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>CNIC</th>\n",
       "      <th>c3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4230108335683</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4220113316709</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4210164790696</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4410242997959</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4250191411023</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            CNIC  c3\n",
       "0  4230108335683   1\n",
       "1  4220113316709   1\n",
       "2  4210164790696   1\n",
       "3  4410242997959   1\n",
       "4  4250191411023   1"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = \"\"\"\n",
    "Syed Tanveer1:40 PM\n",
    "4240179641627\n",
    "4220169252467\n",
    "Zeeshan Naqvi1:40 PM\n",
    "4210151751811\n",
    "Syed Masroor Ali (Masroor)1:40 PM\n",
    "42401-1880106-5\n",
    "Mushyada Ali1:41 PM\n",
    "4210103553847\n",
    "Mohsin Kanani1:41 PM\n",
    "4230108335683\n",
    "Tatheer Fatima1:42 PM\n",
    "4210124609792\n",
    "Saba Naz1:42 PM\n",
    "4250125987808\n",
    "Zahid Bashir1:47 PM\n",
    "4250191411023\n",
    "Syed Ammad Waheed1:47 PM\n",
    "4210113863591 Syed Ammad Waheed Hassani\n",
    "Khawar Masood1:48 PM\n",
    "Syed Khawar Masood Naqvi \n",
    "42101-4113797-7\n",
    "Muhammad Rohan1:50 PM\n",
    "I shared a Jam file with the meeting: https://jamboard.google.com/d/1o_ATMRDs92LgPetAhYNo3SzGiTVY8FstCST6Pw6mTGQ/edit?usp=meet_whiteboard\n",
    "usman ahmad1:51 PM\n",
    "crude oil and petrol\n",
    "Dewan S Khan1:52 PM\n",
    "4220105630741\n",
    "usman ahmad1:55 PM\n",
    "no sir\n",
    "Hussain Ali2:03 PM\n",
    "4220117852609\n",
    "Ali Naiyar2:04 PM\n",
    "4210198030681\n",
    "Nazneen Akram2:07 PM\n",
    "https://www.simplilearn.com/\n",
    "I am using this learning machine learning\n",
    "Syed Usama Shahzad2:08 PM\n",
    "Thanks nazneen\n",
    "Khizra Rizvi2:08 PM\n",
    "Khizra\n",
    "5440047459326\n",
    "Muhammad Ayaz2:09 PM\n",
    "RapidMiner is an open-source data science platform that provides an integrated environment for data preparation, machine learning, deep learning, text mining, and predictive modeling.\n",
    "Rozina Mazhar Ali2:16 PM\n",
    "4220159083880\n",
    "Wasiq Gt2:16 PM\n",
    "4250104502069\n",
    "Muhammad Atique Qayyum2:17 PM\n",
    "4220140225263\n",
    "Arsalan Risalat2:24 PM\n",
    "4220124812817\n",
    "Tabassum Ali2:24 PM\n",
    "4230123126547\n",
    "Faiza Asad2:28 PM\n",
    "4200052746960\n",
    "Tariq Mehmood2:30 PM\n",
    "4220104505899\n",
    "Syed Usama Shahzad2:31 PM\n",
    "42101-3416307-9\n",
    "Tabish sheikh2:35 PM\n",
    "4210129511133\n",
    "zain abidi2:41 PM\n",
    "4250119167549\n",
    "Zeeshan Javed2:41 PM\n",
    "4230189725317\n",
    "Dewan S Khan2:41 PM\n",
    "4220105630741\n",
    "Yusra Adnan2:41 PM\n",
    "4210164790696\n",
    "Zeeshan Naqvi2:42 PM\n",
    "4210151751811\n",
    "Bilal Uddin2:42 PM\n",
    "4220122191357\n",
    "Dewan S Khan2:43 PM\n",
    "4220105630741\n",
    "usman ahmad2:45 PM\n",
    "4220113316709\n",
    "HAREEM RIZVI2:45 PM\n",
    "4210133115704\n",
    "Muhammad Rohan2:46 PM\n",
    "4210116966995\n",
    "Zareen Fatima2:46 PM\n",
    "3520269403788\n",
    "Asima Ali2:46 PM\n",
    "4420626938874\n",
    "Mohsin Kanani2:46 PM\n",
    "4230108335683\n",
    "Haris Chhipa2:46 PM\n",
    "4210156195059\n",
    "Nofil Ahmed2:46 PM\n",
    "4210175076663\n",
    "Syed Kashif2:46 PM\n",
    "4250144488545\n",
    "Dewan S Khan2:46 PM\n",
    "4220105630741\n",
    "Muhammad Ayaz2:46 PM\n",
    "4410242997959\n",
    "Faizan Ehtesham2:46 PM\n",
    "4240114707349\n",
    "Hassan Ahmed2:46 PM\n",
    "4220156089133\n",
    "Shakir Hussain2:46 PM\n",
    "42101-9276734-9\n",
    "Syed Usama Shahzad2:46 PM\n",
    "42101-3416307-9\n",
    "Syed Masroor Ali (Masroor)2:46 PM\n",
    "42401-1880106-5\n",
    "Faiza Asad2:46 PM\n",
    "4200052746960\n",
    "Rahat Qayoum EB20_110 (20102110)2:46 PM\n",
    "4240128161338\n",
    "Qazi Moawiz2:46 PM\n",
    "3130399221225\n",
    "Munir Ali2:46 PM\n",
    "4220101410369\n",
    "Syed Tanveer2:46 PM\n",
    "4240179641627\n",
    "taimoor qureshi2:46 PM\n",
    "4240179641627\n",
    "Saba Naz2:46 PM\n",
    "4250125987808\n",
    "Tatheer Fatima2:47 PM\n",
    "4210124609792\n",
    "Shakir Hussain2:47 PM\n",
    "4210182767349\n",
    "Syed Tanveer2:47 PM\n",
    "4220169252467\n",
    "Qazi Moawiz2:47 PM\n",
    "3130399221225\n",
    "Bilal Ahmed2:48 PM\n",
    "4210120075463\n",
    "4210182767349\n",
    "Shakir Hussain\n",
    "Nazneen Akram2:48 PM\n",
    "4210145447712\n",
    "Muhammad Rohan2:49 PM\n",
    "4210116966995\n",
    "myd-bnjm-grb\n",
    "\"\"\"\n",
    "df3 = attendance(x)\n",
    "print(len(df3))\n",
    "df3['c3'] = 1\n",
    "df3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "5b2e574b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "46\n"
     ]
    },
    {
     "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>CNIC</th>\n",
       "      <th>c4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4230108335683</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4220113316709</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4210164790696</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4410242997959</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4250191411023</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            CNIC  c4\n",
       "0  4230108335683   1\n",
       "1  4220113316709   1\n",
       "2  4210164790696   1\n",
       "3  4410242997959   1\n",
       "4  4250191411023   1"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x4 = \"\"\"\n",
    "Tabassum Ali3:06 PM\n",
    "sir your mic is off\n",
    "Syed Masroor Ali (Masroor)3:06 PM\n",
    "yes sir\n",
    "Khawar Masood3:06 PM\n",
    "Syed Khawar Masood Naqvi \n",
    "42101-4113797-7\n",
    "Syed Masroor Ali (Masroor)3:07 PM\n",
    "Yes\n",
    "42401-1880106-5\n",
    "Syed Ammad Waheed3:07 PM\n",
    "4210113863591 Syed Ammad Waheed Hassani\n",
    "Ali Naiyar3:07 PM\n",
    "4210198030681\n",
    "Ad Khan3:09 PM\n",
    "Muhammad Adnan Khan\n",
    "4220113823383\n",
    "Muhammad Ayaz3:17 PM\n",
    "4410242997959\n",
    "Zeeshan Naqvi3:18 PM\n",
    "4210151751811\n",
    "Syed Tanveer3:18 PM\n",
    "42201-6925246-7\n",
    "Malik Humza3:18 PM\n",
    "4240105171159\n",
    "You3:18 PM\n",
    "https://www.markdownguide.org/cheat-sheet/\n",
    "Syed Masroor Ali (Masroor)3:20 PM\n",
    "masroor\n",
    "yes\n",
    "OK\n",
    "You3:21 PM\n",
    "pip install tensorflow\n",
    "Ali Naiyar3:22 PM\n",
    "Already installed\n",
    "Dewan S Khan3:22 PM\n",
    "422010563074q\n",
    "4220105630741\n",
    "Tatheer Fatima3:23 PM\n",
    "4210124609792\n",
    "zain abidi3:23 PM\n",
    "4250119167549\n",
    "Zahid Bashir3:23 PM\n",
    "4250191411023\n",
    "Afnan Ali3:23 PM\n",
    "4210146436547\n",
    "Faiza Asad3:23 PM\n",
    "4200052746960\n",
    "Muhammad faizan Farooque3:23 PM\n",
    "4230139662957\n",
    "Mushyada Ali3:25 PM\n",
    "4210103553847\n",
    "Wasiq Gt3:28 PM\n",
    "4210120075463\n",
    "4250104502069\n",
    "Mohsin Kanani3:34 PM\n",
    "4230108335683\n",
    "Zareen Fatima3:34 PM\n",
    "please guide on which version to intall\n",
    "Rozina Mazhar Ali3:40 PM\n",
    "4220159083880\n",
    "Saba Naz3:45 PM\n",
    "4250125987808\n",
    "Zeeshan Javed3:46 PM\n",
    "4230189725317\n",
    "Bilal Uddin3:47 PM\n",
    "4220122191357\n",
    "Arsalan Risalat3:56 PM\n",
    "4220124812817\n",
    "Faizan Ehtesham3:57 PM\n",
    "4240114707349\n",
    "Muhammad Ayaz4:03 PM\n",
    "4410242997959\n",
    "Tabassum Ali4:11 PM\n",
    "4410242997959\n",
    "Shakir Hussain4:14 PM\n",
    "42101-8276734-9\n",
    "4210182767349\n",
    "Muhammad faizan Farooque4:16 PM\n",
    "4230139662957\n",
    "HAREEM RIZVI4:22 PM\n",
    "42101-3311570-4\n",
    "Zeeshan Naqvi4:22 PM\n",
    "4210151751811\n",
    "Hassan Ahmed4:22 PM\n",
    "4220156089133\n",
    "Syed Masroor Ali (Masroor)4:22 PM\n",
    "42401-1880106-5\n",
    "Tabish sheikh4:22 PM\n",
    "4210129511133\n",
    "Syed Kashif4:24 PM\n",
    "4250144488545\n",
    "Munir Ali4:24 PM\n",
    "4220101410369\n",
    "Nazneen Akram4:24 PM\n",
    "4210145447712\n",
    "Munir Ali4:29 PM\n",
    "4220101410369\n",
    "Dewan S Khan4:31 PM\n",
    "4220105630741\n",
    "Arsalan Ahmed4:31 PM\n",
    "42201-6535195-7\n",
    "Tariq Mehmood4:31 PM\n",
    "4220104505899\n",
    "Waqas Zafar4:34 PM\n",
    "5440004083505\n",
    "Syed Masroor Ali (Masroor)4:38 PM\n",
    "42401-1880106-5\n",
    "Dewan S Khan4:38 PM\n",
    "4220105630741\n",
    "Asima Ali4:38 PM\n",
    "4420626938874\n",
    "Bilal Ahmed4:40 PM\n",
    "4210120075463\n",
    "Muhammad Atique Qayyum4:43 PM\n",
    "4220140225263\n",
    "Yusra Adnan4:44 PM\n",
    "4210164790696\n",
    "Dewan S Khan4:44 PM\n",
    "4220105630741\n",
    "Syed Masroor Ali (Masroor)4:44 PM\n",
    "42201-2286846-7\n",
    "Faizan Ehtesham4:46 PM\n",
    "4240114707349\n",
    "Syed Tanveer4:46 PM\n",
    "4220169252467\n",
    "Zareen Fatima4:47 PM\n",
    "3520269403788\n",
    "Zeeshan Naqvi4:47 PM\n",
    "4210151751811\n",
    "Tabassum Ali4:49 PM\n",
    "4230123126547\n",
    "4230123126547\n",
    "Haris Chhipa4:51 PM\n",
    "4210156195059\n",
    "Ali Naiyar4:51 PM\n",
    "4210198030681\n",
    "Dewan S Khan4:51 PM\n",
    "4220105630741\n",
    "Muhammad Sameer4:51 PM\n",
    "4250110257001\n",
    "Muhammad Ayaz4:51 PM\n",
    "4410242997959\n",
    "Qazi Moawiz4:51 PM\n",
    "3130399221225\n",
    "Munir Ali4:51 PM\n",
    "4220101410369\n",
    "Nofil Ahmed4:51 PM\n",
    "4210175076663\n",
    "Hussain Ali4:51 PM\n",
    "4220117852609\n",
    "Dewan S Khan4:51 PM\n",
    "4220105630741\n",
    "Muhammad Rohan4:51 PM\n",
    "4210116966995\n",
    "Sheikh Faizan4:51 PM\n",
    "Sheikh m Faizan Saleem\n",
    "42101-7490505-9\n",
    "Fazal Diyan4:51 PM\n",
    "4230199459921\n",
    "Zeeshan Naqvi4:52 PM\n",
    "4210151751811\n",
    "Zeeshan Javed4:52 PM\n",
    "4230189725317\n",
    "Syed Masroor Ali (Masroor)4:52 PM\n",
    "42401-1880106-5\n",
    "Mohsin Kanani4:52 PM\n",
    "423010835683\n",
    "Muhammad Sameer4:52 PM\n",
    "4210115022744\n",
    "Faiza Asad4:52 PM\n",
    "4200052746960\n",
    "Khawar Masood4:52 PM\n",
    "4210141137977\n",
    "Faizan Ehtesham4:52 PM\n",
    "4240114707349\n",
    "Arsalan Ahmed4:52 PM\n",
    "42201-6535195-7\n",
    "Zareen Fatima4:52 PM\n",
    "3520269403788\n",
    "Tabish sheikh4:52 PM\n",
    "4210129511133\n",
    "Mohsin Kanani4:52 PM\n",
    "4230108335683\n",
    "Zeeshan Naqvi4:52 PM\n",
    "4210151751811\n",
    "Syed Masroor Ali (Masroor)4:52 PM\n",
    "42201-2286846-7\n",
    "Tatheer Fatima4:52 PM\n",
    "4210124609792\n",
    "Muhammad Sameer4:52 PM\n",
    "4210115022744\n",
    "myd-bnjm-grb\n",
    "\"\"\"\n",
    "df4 = attendance(x)\n",
    "print(len(df4))\n",
    "df4['c4'] = 1\n",
    "df4.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "1cbff577",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "46\n"
     ]
    },
    {
     "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>CNIC</th>\n",
       "      <th>c5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4230108335683</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4220113316709</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4210164790696</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4410242997959</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4250191411023</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            CNIC  c5\n",
       "0  4230108335683   1\n",
       "1  4220113316709   1\n",
       "2  4210164790696   1\n",
       "3  4410242997959   1\n",
       "4  4250191411023   1"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x5 = \"\"\"\n",
    "Zareen Fatima1:58 PM\n",
    "yes\n",
    "Saba Naz2:04 PM\n",
    "4250125987808\n",
    "Dewan S Khan2:04 PM\n",
    "4220105630741\n",
    "Munir Ali2:04 PM\n",
    "4220101410369\n",
    "Wasiq Gt2:04 PM\n",
    "4250104502069\n",
    "Ali Naiyar2:04 PM\n",
    "4210198030681\n",
    "Khawar Masood2:04 PM\n",
    "4210141137977\n",
    "Zeeshan Naqvi2:05 PM\n",
    "4210151751811\n",
    "Waqas Zafar2:05 PM\n",
    "5440004083505\n",
    "Meta Captives2:15 PM\n",
    "4210120075463\n",
    "Tabish sheikh2:15 PM\n",
    "4210129511133\n",
    "Zahid Bashir2:16 PM\n",
    "4250191411023\n",
    "Tatheer Fatima2:20 PM\n",
    "4210124609792\n",
    "Dewan S Khan2:21 PM\n",
    "4220105630741\n",
    "Muhammad Ayaz2:21 PM\n",
    "4410242997959\n",
    "Fazal Diyan2:22 PM\n",
    "42301-9945992-1\n",
    "Muhammad Uzair2:23 PM\n",
    "True\n",
    "Muneeb Ahmed2:24 PM\n",
    "42101 8342718 3\n",
    "Sheikh Faizan2:26 PM\n",
    "done sir\n",
    "Bilal Uddin2:30 PM\n",
    "4220122191357\n",
    "Syed Masroor Ali (Masroor)2:32 PM\n",
    "4240118801065\n",
    "Mohsin Kanani2:32 PM\n",
    "4230108335683\n",
    "Muhammad Uzair2:32 PM\n",
    "4210184252633\n",
    "Yusra Adnan2:33 PM\n",
    "4210164790696\n",
    "zain abidi2:34 PM\n",
    "4250119167549\n",
    "Faiza Asad2:34 PM\n",
    "4200052746960\n",
    "Zeeshan Javed2:35 PM\n",
    "4230189725317\n",
    "Muneeb Ahmed2:35 PM\n",
    "42101 8342718 3\n",
    "Khizra Rizvi2:35 PM\n",
    "5440047459326\n",
    "Syed Usama Shahzad2:46 PM\n",
    "42101-3416307-9\n",
    "Mohsin Kanani2:52 PM\n",
    "42301-0833568-3\n",
    "Hussain Ali2:55 PM\n",
    "4220117852609\n",
    "Tariq Mehmood3:02 PM\n",
    "4220104505899\n",
    "Syed Masroor Ali (Masroor)3:03 PM\n",
    "4240118801065\n",
    "Faizan Ehtesham3:03 PM\n",
    "4240114707349\n",
    "Arsalan Ahmed3:03 PM\n",
    "42201-6535195-7\n",
    "Dewan S Khan3:04 PM\n",
    "4220105630741\n",
    "Zareen Fatima3:04 PM\n",
    "3520269403788\n",
    "Qazi Moawiz3:04 PM\n",
    "3130399221225\n",
    "Mushyada Ali3:04 PM\n",
    "4210103553847\n",
    "Qazi Moawiz3:04 PM\n",
    "4210156195059\n",
    "Muneeb Ahmed3:04 PM\n",
    "42101 8342718 3\n",
    "Faiza Asad3:04 PM\n",
    "4200052746960\n",
    "Zeeshan Javed3:05 PM\n",
    "4230189725317\n",
    "Nazneen Akram3:05 PM\n",
    "4210145447712\n",
    "Asima Ali3:06 PM\n",
    "4420626938874\n",
    "Munir Ali3:07 PM\n",
    "4220101410369\n",
    "Shakir Hussain3:11 PM\n",
    "4210182767349\n",
    "HAREEM RIZVI3:12 PM\n",
    "42101-3311570-4\n",
    "Syed Kashif3:13 PM\n",
    "4250144488545\n",
    "Yusra Adnan3:13 PM\n",
    "Can't hear you\n",
    "Lagging\n",
    "Zeeshan Javed3:14 PM\n",
    "4230189725317\n",
    "Rahat Qayoum EB20_110 (20102110)3:14 PM\n",
    "4240128161338\n",
    "Tabassum Ali3:14 PM\n",
    "4230123126547\n",
    "Meta Captives3:14 PM\n",
    "4210120075463\n",
    "Syed Tanveer3:14 PM\n",
    "4220169252467\n",
    "Afnan Ali3:14 PM\n",
    "4210146436547\n",
    "Hassan Ahmed3:14 PM\n",
    "4220156089133\n",
    "Mohsin Kanani3:14 PM\n",
    "42301-0833568-3\n",
    "Saba Naz3:14 PM\n",
    "4250125987808\n",
    "Faiza Asad3:14 PM\n",
    "4200052746960\n",
    "Nofil Ahmed3:14 PM\n",
    "4210175076663\n",
    "Sheikh Faizan3:14 PM\n",
    "Sheikh Faizan\n",
    "42101-7490505-9\n",
    "Muhammad Rohan3:14 PM\n",
    "4210116966995\n",
    "Syed Masroor Ali (Masroor)3:14 PM\n",
    "4240118801065\n",
    "Fazal Diyan3:14 PM\n",
    "42301-9945992-1\n",
    "Afnan Ali3:14 PM\n",
    "4250110257001\n",
    "Tatheer Fatima3:14 PM\n",
    "4210124609792\n",
    "Asima Ali3:15 PM\n",
    "4420626938874\n",
    "Muhammad Uzair3:15 PM\n",
    "4210184252633\n",
    "zain abidi3:15 PM\n",
    "4250119167549\n",
    "Dewan S Khan3:16 PM\n",
    "4220105630741\n",
    "Wasiq Gt3:17 PM\n",
    "4250104502069\n",
    "Zeeshan Naqvi3:17 PM\n",
    "4210151751811\n",
    "Dewan S Khan3:17 PM\n",
    "4220105630741\n",
    "myd-bnjm-grb\n",
    "\"\"\"\n",
    "df5 = attendance(x)\n",
    "print(len(df5))\n",
    "df5['c5'] = 1\n",
    "df5.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "15199682",
   "metadata": {},
   "source": [
    "# Final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "cd65394e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "61\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "c1        39.0\n",
       "c2        43.0\n",
       "c3        46.0\n",
       "c4        46.0\n",
       "c5        46.0\n",
       "total    220.0\n",
       "dtype: float64"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>CNIC</th>\n",
       "      <th>c1</th>\n",
       "      <th>c2</th>\n",
       "      <th>c3</th>\n",
       "      <th>c4</th>\n",
       "      <th>c5</th>\n",
       "      <th>total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4230108335683</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3520269403788</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3130399221225</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>4210133115704</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>4210182767349</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>4210120075463</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>4220124812817</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>4240118801065</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>4220156089133</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4220104505899</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>4250144488545</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4420626938874</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>4220122191357</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>4220169252467</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4250119167549</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4210164790696</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4220113316709</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>4210113863591</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4410242997959</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4220105630741</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>4210156195059</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>4210145447712</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>4250191411023</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>4220140225263</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>4210198030681</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>4210141137977</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>4220101410369</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>4210124609792</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>4210175076663</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>4210103553847</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>4220159083880</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>4210151751811</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>4210192767349</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>4250104502069</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>4220117852609</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>4210116966995</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4240179641627</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4240114707349</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>4230123126547</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>5440047459326</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>4200052746960</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>4230189725317</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>4250125987808</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>4210129511133</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>4240128161338</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>4210134163079</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>4250110257001</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>4220122868467</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>4210174905059</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>4210115022744</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4220165351957</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4210146436547</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>4240105171159</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>4230199459921</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>4210184252633</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>4220105436681</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>4230139662957</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>4220113823383</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4220143471143</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5440004083505</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             CNIC   c1   c2   c3   c4   c5  total\n",
       "0   4230108335683  1.0  1.0  1.0  1.0  1.0      5\n",
       "13  3520269403788  1.0  1.0  1.0  1.0  1.0      5\n",
       "29  3130399221225  1.0  1.0  1.0  1.0  1.0      5\n",
       "32  4210133115704  1.0  1.0  1.0  1.0  1.0      5\n",
       "33  4210182767349  1.0  1.0  1.0  1.0  1.0      5\n",
       "24  4210120075463  1.0  1.0  1.0  1.0  1.0      5\n",
       "21  4220124812817  1.0  1.0  1.0  1.0  1.0      5\n",
       "20  4240118801065  1.0  1.0  1.0  1.0  1.0      5\n",
       "38  4220156089133  1.0  1.0  1.0  1.0  1.0      5\n",
       "18  4220104505899  1.0  1.0  1.0  1.0  1.0      5\n",
       "16  4250144488545  1.0  1.0  1.0  1.0  1.0      5\n",
       "14  4420626938874  1.0  1.0  1.0  1.0  1.0      5\n",
       "15  4220122191357  1.0  1.0  1.0  1.0  1.0      5\n",
       "12  4220169252467  1.0  1.0  1.0  1.0  1.0      5\n",
       "8   4250119167549  1.0  1.0  1.0  1.0  1.0      5\n",
       "2   4210164790696  1.0  1.0  1.0  1.0  1.0      5\n",
       "3   4220113316709  1.0  1.0  1.0  1.0  1.0      5\n",
       "6   4210113863591  1.0  1.0  1.0  1.0  1.0      5\n",
       "1   4410242997959  1.0  1.0  1.0  1.0  1.0      5\n",
       "9   4220105630741  1.0  1.0  1.0  1.0  1.0      5\n",
       "10  4210156195059  1.0  1.0  1.0  1.0  1.0      5\n",
       "49  4210145447712  0.0  1.0  1.0  1.0  1.0      4\n",
       "39  4250191411023  0.0  1.0  1.0  1.0  1.0      4\n",
       "40  4220140225263  0.0  1.0  1.0  1.0  1.0      4\n",
       "51  4210198030681  0.0  1.0  1.0  1.0  1.0      4\n",
       "48  4210141137977  0.0  1.0  1.0  1.0  1.0      4\n",
       "53  4220101410369  0.0  1.0  1.0  1.0  1.0      4\n",
       "34  4210124609792  1.0  0.0  1.0  1.0  1.0      4\n",
       "47  4210175076663  0.0  1.0  1.0  1.0  1.0      4\n",
       "31  4210103553847  1.0  0.0  1.0  1.0  1.0      4\n",
       "50  4220159083880  0.0  1.0  1.0  1.0  1.0      4\n",
       "22  4210151751811  1.0  0.0  1.0  1.0  1.0      4\n",
       "28  4210192767349  1.0  0.0  1.0  1.0  1.0      4\n",
       "26  4250104502069  1.0  0.0  1.0  1.0  1.0      4\n",
       "25  4220117852609  1.0  0.0  1.0  1.0  1.0      4\n",
       "45  4210116966995  0.0  1.0  1.0  1.0  1.0      4\n",
       "17  4240179641627  1.0  0.0  1.0  1.0  1.0      4\n",
       "11  4240114707349  1.0  0.0  1.0  1.0  1.0      4\n",
       "44  4230123126547  0.0  1.0  1.0  1.0  1.0      4\n",
       "54  5440047459326  0.0  0.0  1.0  1.0  1.0      3\n",
       "55  4200052746960  0.0  0.0  1.0  1.0  1.0      3\n",
       "56  4230189725317  0.0  0.0  1.0  1.0  1.0      3\n",
       "57  4250125987808  0.0  0.0  1.0  1.0  1.0      3\n",
       "58  4210129511133  0.0  0.0  1.0  1.0  1.0      3\n",
       "59  4240128161338  0.0  0.0  1.0  1.0  1.0      3\n",
       "60  4210134163079  0.0  0.0  1.0  1.0  1.0      3\n",
       "37  4250110257001  1.0  1.0  0.0  0.0  0.0      2\n",
       "36  4220122868467  1.0  1.0  0.0  0.0  0.0      2\n",
       "35  4210174905059  1.0  1.0  0.0  0.0  0.0      2\n",
       "23  4210115022744  1.0  1.0  0.0  0.0  0.0      2\n",
       "7   4220165351957  1.0  1.0  0.0  0.0  0.0      2\n",
       "4   4210146436547  1.0  1.0  0.0  0.0  0.0      2\n",
       "30  4240105171159  1.0  1.0  0.0  0.0  0.0      2\n",
       "46  4230199459921  0.0  1.0  0.0  0.0  0.0      1\n",
       "43  4210184252633  0.0  1.0  0.0  0.0  0.0      1\n",
       "42  4220105436681  0.0  1.0  0.0  0.0  0.0      1\n",
       "41  4230139662957  0.0  1.0  0.0  0.0  0.0      1\n",
       "52  4220113823383  0.0  1.0  0.0  0.0  0.0      1\n",
       "27  4220143471143  1.0  0.0  0.0  0.0  0.0      1\n",
       "19  5440004083505  1.0  0.0  0.0  0.0  0.0      1"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df1.merge(df2,on='CNIC', how='outer').fillna(0).merge(df3,\n",
    "                                                          on=\"CNIC\",\n",
    "                                                          how='outer').fillna(0).\\\n",
    "merge(df4,\n",
    "       on=\"CNIC\",\n",
    "       how='outer').fillna(0)\\\n",
    ".merge(df5,\n",
    "       on=\"CNIC\",\n",
    "       how='outer').fillna(0)\n",
    "\n",
    "df['total'] = df.iloc[:,1:].astype(int).sum(axis=1)\n",
    "df.sort_values(by=\"total\", inplace=True, ascending=False)\n",
    "print(len(df))\n",
    "display(df.iloc[:,1:].sum(axis=0).T)\n",
    "df.head(60)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "49ed12f6",
   "metadata": {},
   "outputs": [
    {
     "ename": "SyntaxError",
     "evalue": "invalid syntax (<ipython-input-8-2f0c2c3ff6ae>, line 1)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;36m  File \u001b[0;32m\"<ipython-input-8-2f0c2c3ff6ae>\"\u001b[0;36m, line \u001b[0;32m1\u001b[0m\n\u001b[0;31m    function abc(a,b){ a + b}\u001b[0m\n\u001b[0m               ^\u001b[0m\n\u001b[0;31mSyntaxError\u001b[0m\u001b[0;31m:\u001b[0m invalid syntax\n"
     ]
    }
   ],
   "source": [
    "function abc(a,b){ a + b}\n",
    "\n",
    "function abc(a,b){ \n",
    "    a + b\n",
    "}\n",
    "\n",
    "def abc(a,b):\n",
    "    a + b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f899502a",
   "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.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}