Separate Name, Contact, Mail Id from the Given Data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "7456c1b8",
   "metadata": {},
   "source": [
    "### Separate Name, Contact and MailId from the given DataFrame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "ee34cfbf",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "c13502ed",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = [\"kumod1234287423@gmail.com\",\"hema@7654874537gmail.com\",\"ra9637452637hul@gmail.com\",\"rupanshi@yahoo.com8347658382\",\n",
    "        \"deepanshu345@gmail.com\",\"387@gmail9567848567.com\",\"shashank786@gmail.com\",\"7698457382kirti456@gmail.com\",\n",
    "        \"prince34@ymail.com\",\"bhanu@9456738454gmail.com\",\"ANKiT@8576893945gmail.com\",\"mo56@gmail.com\",\"345@gmail.com\",\n",
    "        \"LaXMi456@gmail.com\",\"567@yahoo.com\",\"abhi345nash@ymail.com\",\"komal@34gmail7896453678.com\",\"deepak@345gmail.com\",\n",
    "        \"345@yahoo.com\",\"manu9845673245@ymail.com\"]\n",
    "\n",
    "df = pd.DataFrame({\"Details\":data})"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0e5b2bcd",
   "metadata": {},
   "source": [
    "### Showing Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "71cd2ff1",
   "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>Details</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>kumod1234287423@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>hema@7654874537gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ra9637452637hul@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>rupanshi@yahoo.com8347658382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>deepanshu345@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>387@gmail9567848567.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>shashank786@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7698457382kirti456@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>prince34@ymail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>bhanu@9456738454gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ANKiT@8576893945gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>mo56@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>345@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>LaXMi456@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>567@yahoo.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>abhi345nash@ymail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>komal@34gmail7896453678.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>deepak@345gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>345@yahoo.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>manu9845673245@ymail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Details\n",
       "0      kumod1234287423@gmail.com\n",
       "1       hema@7654874537gmail.com\n",
       "2      ra9637452637hul@gmail.com\n",
       "3   rupanshi@yahoo.com8347658382\n",
       "4         deepanshu345@gmail.com\n",
       "5        387@gmail9567848567.com\n",
       "6          shashank786@gmail.com\n",
       "7   7698457382kirti456@gmail.com\n",
       "8             prince34@ymail.com\n",
       "9      bhanu@9456738454gmail.com\n",
       "10     ANKiT@8576893945gmail.com\n",
       "11                mo56@gmail.com\n",
       "12                 345@gmail.com\n",
       "13            LaXMi456@gmail.com\n",
       "14                 567@yahoo.com\n",
       "15         abhi345nash@ymail.com\n",
       "16   komal@34gmail7896453678.com\n",
       "17           deepak@345gmail.com\n",
       "18                 345@yahoo.com\n",
       "19      manu9845673245@ymail.com"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4639513f",
   "metadata": {},
   "source": [
    "### Separating Contact Using Details Given in DataFrame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "e23819ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "contact = []\n",
    "\n",
    "for i in df[\"Details\"]:\n",
    "\n",
    "    x = i\n",
    "    for j in range(len(i)):\n",
    "        if i[j].isalpha():\n",
    "            x = x.replace(i[j],\",\")\n",
    "            \n",
    "    x = x.replace(\"@\",\"\")\n",
    "    x = x.replace(\".\",\"\")\n",
    "    y = x.split(\",\")\n",
    "    z = sorted(y,reverse=True)\n",
    "    #print(z)\n",
    "    \n",
    "    for i in z:\n",
    "        if len(i)==10:\n",
    "            if (i[0]==\"9\") or (i[0]==\"8\") or (i[0]==\"7\"):\n",
    "                #print(i)\n",
    "                contact.append(i)\n",
    "                break\n",
    "            else:\n",
    "                #print(\"No Contact\")\n",
    "                contact.append(\"No Contact\")\n",
    "                break\n",
    "        else:\n",
    "            #print(\"No Contact\")\n",
    "            contact.append(\"No Contact\")\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "f1024395",
   "metadata": {},
   "outputs": [],
   "source": [
    "#print(contact)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "553ba256",
   "metadata": {},
   "source": [
    "### Adding Contact Column in The Datafreame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "f2d3a179",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"Contact\"] = contact"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "3564cd09",
   "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>Details</th>\n",
       "      <th>Contact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>kumod1234287423@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>hema@7654874537gmail.com</td>\n",
       "      <td>7654874537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ra9637452637hul@gmail.com</td>\n",
       "      <td>9637452637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>rupanshi@yahoo.com8347658382</td>\n",
       "      <td>8347658382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>deepanshu345@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>387@gmail9567848567.com</td>\n",
       "      <td>9567848567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>shashank786@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7698457382kirti456@gmail.com</td>\n",
       "      <td>7698457382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>prince34@ymail.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>bhanu@9456738454gmail.com</td>\n",
       "      <td>9456738454</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ANKiT@8576893945gmail.com</td>\n",
       "      <td>8576893945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>mo56@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>345@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>LaXMi456@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>567@yahoo.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>abhi345nash@ymail.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>komal@34gmail7896453678.com</td>\n",
       "      <td>7896453678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>deepak@345gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>345@yahoo.com</td>\n",
       "      <td>No Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>manu9845673245@ymail.com</td>\n",
       "      <td>9845673245</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Details     Contact\n",
       "0      kumod1234287423@gmail.com  No Contact\n",
       "1       hema@7654874537gmail.com  7654874537\n",
       "2      ra9637452637hul@gmail.com  9637452637\n",
       "3   rupanshi@yahoo.com8347658382  8347658382\n",
       "4         deepanshu345@gmail.com  No Contact\n",
       "5        387@gmail9567848567.com  9567848567\n",
       "6          shashank786@gmail.com  No Contact\n",
       "7   7698457382kirti456@gmail.com  7698457382\n",
       "8             prince34@ymail.com  No Contact\n",
       "9      bhanu@9456738454gmail.com  9456738454\n",
       "10     ANKiT@8576893945gmail.com  8576893945\n",
       "11                mo56@gmail.com  No Contact\n",
       "12                 345@gmail.com  No Contact\n",
       "13            LaXMi456@gmail.com  No Contact\n",
       "14                 567@yahoo.com  No Contact\n",
       "15         abhi345nash@ymail.com  No Contact\n",
       "16   komal@34gmail7896453678.com  7896453678\n",
       "17           deepak@345gmail.com  No Contact\n",
       "18                 345@yahoo.com  No Contact\n",
       "19      manu9845673245@ymail.com  9845673245"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "19b7bbd2",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "65de3346",
   "metadata": {},
   "outputs": [],
   "source": [
    "mail = []\n",
    "\n",
    "for i in df[\"Details\"]:\n",
    "    for j in df[\"Contact\"]:\n",
    "        if j in i:\n",
    "            i = i.replace(j,\"\")\n",
    "            mail.append(i)\n",
    "    if i not in mail:   \n",
    "        mail.append(i)\n",
    "    \n",
    "        \n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "b1899b2a",
   "metadata": {},
   "outputs": [],
   "source": [
    "#print(mail)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "67c3c677",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"Mail Id\"] = mail"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "4e7ecee5",
   "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>Details</th>\n",
       "      <th>Contact</th>\n",
       "      <th>Mail Id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>kumod1234287423@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>kumod1234287423@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>hema@7654874537gmail.com</td>\n",
       "      <td>7654874537</td>\n",
       "      <td>hema@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ra9637452637hul@gmail.com</td>\n",
       "      <td>9637452637</td>\n",
       "      <td>rahul@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>rupanshi@yahoo.com8347658382</td>\n",
       "      <td>8347658382</td>\n",
       "      <td>rupanshi@yahoo.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>deepanshu345@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>deepanshu345@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>387@gmail9567848567.com</td>\n",
       "      <td>9567848567</td>\n",
       "      <td>387@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>shashank786@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>shashank786@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7698457382kirti456@gmail.com</td>\n",
       "      <td>7698457382</td>\n",
       "      <td>kirti456@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>prince34@ymail.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>prince34@ymail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>bhanu@9456738454gmail.com</td>\n",
       "      <td>9456738454</td>\n",
       "      <td>bhanu@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ANKiT@8576893945gmail.com</td>\n",
       "      <td>8576893945</td>\n",
       "      <td>ANKiT@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>mo56@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>mo56@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>345@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>345@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>LaXMi456@gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>LaXMi456@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>567@yahoo.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>567@yahoo.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>abhi345nash@ymail.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>abhi345nash@ymail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>komal@34gmail7896453678.com</td>\n",
       "      <td>7896453678</td>\n",
       "      <td>komal@34gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>deepak@345gmail.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>deepak@345gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>345@yahoo.com</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>345@yahoo.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>manu9845673245@ymail.com</td>\n",
       "      <td>9845673245</td>\n",
       "      <td>manu@ymail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Details     Contact                    Mail Id\n",
       "0      kumod1234287423@gmail.com  No Contact  kumod1234287423@gmail.com\n",
       "1       hema@7654874537gmail.com  7654874537             hema@gmail.com\n",
       "2      ra9637452637hul@gmail.com  9637452637            rahul@gmail.com\n",
       "3   rupanshi@yahoo.com8347658382  8347658382         rupanshi@yahoo.com\n",
       "4         deepanshu345@gmail.com  No Contact     deepanshu345@gmail.com\n",
       "5        387@gmail9567848567.com  9567848567              387@gmail.com\n",
       "6          shashank786@gmail.com  No Contact      shashank786@gmail.com\n",
       "7   7698457382kirti456@gmail.com  7698457382         kirti456@gmail.com\n",
       "8             prince34@ymail.com  No Contact         prince34@ymail.com\n",
       "9      bhanu@9456738454gmail.com  9456738454            bhanu@gmail.com\n",
       "10     ANKiT@8576893945gmail.com  8576893945            ANKiT@gmail.com\n",
       "11                mo56@gmail.com  No Contact             mo56@gmail.com\n",
       "12                 345@gmail.com  No Contact              345@gmail.com\n",
       "13            LaXMi456@gmail.com  No Contact         LaXMi456@gmail.com\n",
       "14                 567@yahoo.com  No Contact              567@yahoo.com\n",
       "15         abhi345nash@ymail.com  No Contact      abhi345nash@ymail.com\n",
       "16   komal@34gmail7896453678.com  7896453678          komal@34gmail.com\n",
       "17           deepak@345gmail.com  No Contact        deepak@345gmail.com\n",
       "18                 345@yahoo.com  No Contact              345@yahoo.com\n",
       "19      manu9845673245@ymail.com  9845673245             manu@ymail.com"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "a37c1f5c",
   "metadata": {},
   "outputs": [],
   "source": [
    "name = []\n",
    "\n",
    "for i in df[\"Mail Id\"]:\n",
    "    a = i.split(\"@\")\n",
    "    b = a[0]\n",
    "    \n",
    "    for j in b:\n",
    "        if j.isdigit():\n",
    "            b = b.replace(j,\"\")\n",
    "    if len(b)>1:\n",
    "        name.append(b.title())\n",
    "    else:\n",
    "        name.append(\"No Name\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "a5f260e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "#print(name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "aabfeca9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.insert(1,\"Name\",name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "c5c2be20",
   "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>Details</th>\n",
       "      <th>Name</th>\n",
       "      <th>Contact</th>\n",
       "      <th>Mail Id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>kumod1234287423@gmail.com</td>\n",
       "      <td>Kumod</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>kumod1234287423@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>hema@7654874537gmail.com</td>\n",
       "      <td>Hema</td>\n",
       "      <td>7654874537</td>\n",
       "      <td>hema@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ra9637452637hul@gmail.com</td>\n",
       "      <td>Rahul</td>\n",
       "      <td>9637452637</td>\n",
       "      <td>rahul@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>rupanshi@yahoo.com8347658382</td>\n",
       "      <td>Rupanshi</td>\n",
       "      <td>8347658382</td>\n",
       "      <td>rupanshi@yahoo.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>deepanshu345@gmail.com</td>\n",
       "      <td>Deepanshu</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>deepanshu345@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>387@gmail9567848567.com</td>\n",
       "      <td>No Name</td>\n",
       "      <td>9567848567</td>\n",
       "      <td>387@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>shashank786@gmail.com</td>\n",
       "      <td>Shashank</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>shashank786@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7698457382kirti456@gmail.com</td>\n",
       "      <td>Kirti</td>\n",
       "      <td>7698457382</td>\n",
       "      <td>kirti456@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>prince34@ymail.com</td>\n",
       "      <td>Prince</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>prince34@ymail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>bhanu@9456738454gmail.com</td>\n",
       "      <td>Bhanu</td>\n",
       "      <td>9456738454</td>\n",
       "      <td>bhanu@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ANKiT@8576893945gmail.com</td>\n",
       "      <td>Ankit</td>\n",
       "      <td>8576893945</td>\n",
       "      <td>ANKiT@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>mo56@gmail.com</td>\n",
       "      <td>Mo</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>mo56@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>345@gmail.com</td>\n",
       "      <td>No Name</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>345@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>LaXMi456@gmail.com</td>\n",
       "      <td>Laxmi</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>LaXMi456@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>567@yahoo.com</td>\n",
       "      <td>No Name</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>567@yahoo.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>abhi345nash@ymail.com</td>\n",
       "      <td>Abhinash</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>abhi345nash@ymail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>komal@34gmail7896453678.com</td>\n",
       "      <td>Komal</td>\n",
       "      <td>7896453678</td>\n",
       "      <td>komal@34gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>deepak@345gmail.com</td>\n",
       "      <td>Deepak</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>deepak@345gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>345@yahoo.com</td>\n",
       "      <td>No Name</td>\n",
       "      <td>No Contact</td>\n",
       "      <td>345@yahoo.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>manu9845673245@ymail.com</td>\n",
       "      <td>Manu</td>\n",
       "      <td>9845673245</td>\n",
       "      <td>manu@ymail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Details       Name     Contact  \\\n",
       "0      kumod1234287423@gmail.com      Kumod  No Contact   \n",
       "1       hema@7654874537gmail.com       Hema  7654874537   \n",
       "2      ra9637452637hul@gmail.com      Rahul  9637452637   \n",
       "3   rupanshi@yahoo.com8347658382   Rupanshi  8347658382   \n",
       "4         deepanshu345@gmail.com  Deepanshu  No Contact   \n",
       "5        387@gmail9567848567.com    No Name  9567848567   \n",
       "6          shashank786@gmail.com   Shashank  No Contact   \n",
       "7   7698457382kirti456@gmail.com      Kirti  7698457382   \n",
       "8             prince34@ymail.com     Prince  No Contact   \n",
       "9      bhanu@9456738454gmail.com      Bhanu  9456738454   \n",
       "10     ANKiT@8576893945gmail.com      Ankit  8576893945   \n",
       "11                mo56@gmail.com         Mo  No Contact   \n",
       "12                 345@gmail.com    No Name  No Contact   \n",
       "13            LaXMi456@gmail.com      Laxmi  No Contact   \n",
       "14                 567@yahoo.com    No Name  No Contact   \n",
       "15         abhi345nash@ymail.com   Abhinash  No Contact   \n",
       "16   komal@34gmail7896453678.com      Komal  7896453678   \n",
       "17           deepak@345gmail.com     Deepak  No Contact   \n",
       "18                 345@yahoo.com    No Name  No Contact   \n",
       "19      manu9845673245@ymail.com       Manu  9845673245   \n",
       "\n",
       "                      Mail Id  \n",
       "0   kumod1234287423@gmail.com  \n",
       "1              hema@gmail.com  \n",
       "2             rahul@gmail.com  \n",
       "3          rupanshi@yahoo.com  \n",
       "4      deepanshu345@gmail.com  \n",
       "5               387@gmail.com  \n",
       "6       shashank786@gmail.com  \n",
       "7          kirti456@gmail.com  \n",
       "8          prince34@ymail.com  \n",
       "9             bhanu@gmail.com  \n",
       "10            ANKiT@gmail.com  \n",
       "11             mo56@gmail.com  \n",
       "12              345@gmail.com  \n",
       "13         LaXMi456@gmail.com  \n",
       "14              567@yahoo.com  \n",
       "15      abhi345nash@ymail.com  \n",
       "16          komal@34gmail.com  \n",
       "17        deepak@345gmail.com  \n",
       "18              345@yahoo.com  \n",
       "19             manu@ymail.com  "
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}