practicepython.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "7fdd7630",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "df11c38d",
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'pd' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-1-5db9a9688610>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      4\u001b[0m     \u001b[1;34m\"email\"\u001b[0m\u001b[1;33m:\u001b[0m \u001b[1;33m[\u001b[0m\u001b[1;34m\"chaplin@gmail.com\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'JaneDoes@email.com'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'ben@email.com'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      5\u001b[0m }\n\u001b[1;32m----> 6\u001b[1;33m \u001b[0mpersons\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mDataFrame\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mperson\u001b[0m\u001b[1;33m,\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'one'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m'two'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m'three'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      7\u001b[0m \u001b[0mpersons\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mNameError\u001b[0m: name 'pd' is not defined"
     ]
    }
   ],
   "source": [
    "person = {\n",
    "    \"first\": [\"Charlie\", 'Jane', 'Uncle'], \n",
    "    \"last\": [\"Chaplin\", 'Does', 'Ben'], \n",
    "    \"email\": [\"chaplin@gmail.com\", 'JaneDoes@email.com', 'ben@email.com']\n",
    "}\n",
    "persons = pd.DataFrame(person,index=['one','two','three'])\n",
    "persons"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "deac1303",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.series.Series"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(persons['email'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "a417452b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "email    kpbaa@gmail.com\n",
       "first               K.P.\n",
       "last                 Oli\n",
       "dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newrow1=pd.Series({'email':'kpbaa@gmail.com','first': 'K.P.', 'last': 'Oli'})\n",
    "newrow1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e27b768c",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     first     last               email\n",
       "0  Charlie  Chaplin   chaplin@gmail.com\n",
       "1     Jane     Does  JaneDoes@email.com\n",
       "2    Uncle      Ben       ben@email.com\n",
       "3     K.P.      Oli     kpbaa@gmail.com"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "person1=persons.append(newrow1,ignore_index=True)  #ignore_index=True (reset labelled index)\n",
    "person1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "0c65017d",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first     last               email\n",
       "one    Charlie  Chaplin   chaplin@gmail.com\n",
       "two       Jane     Does  JaneDoes@email.com\n",
       "three    Uncle      Ben       ben@email.com\n",
       "four      K.P.      Oli     kpbaa@gmail.com"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newrow2=pd.Series({'email':'kpbaa@gmail.com','first': 'K.P.', 'last': 'Oli'},name='four')\n",
    "person2=persons.append(newrow2)\n",
    "person2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "15b0bbd5",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first     last               email\n",
       "one    Charlie  Chaplin   chaplin@gmail.com\n",
       "two       Jane     Does  JaneDoes@email.com\n",
       "three    Uncle      Ben       ben@email.com"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "persons"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "6017bad1",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first     last               email\n",
       "one    Charlie  Chaplin   chaplin@gmail.com\n",
       "two       Jane     Does  JaneDoes@email.com\n",
       "three    Uncle      Ben       ben@email.com\n",
       "four      K.P.      Oli     kpbaa@gmail.com\n",
       "four       XYZ      BLC   newmail@gmail.com"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newrow3=pd.Series({'email':'newmail@gmail.com','first': 'XYZ', 'last': 'BLC'},name='four')\n",
    "person2=person2.append(newrow3)\n",
    "person2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "bd6c0546",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['one', 'two', 'three', 'four', 'four'], dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "person2.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "cb98b9f5",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     first last              email\n",
       "four  K.P.  Oli    kpbaa@gmail.com\n",
       "four   XYZ  BLC  newmail@gmail.com"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "person2.loc['four']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "4eaa4868",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "first               K.P.\n",
       "last                 Oli\n",
       "email    kpbaa@gmail.com\n",
       "Name: four, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "person2.iloc[3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "4fe17a46",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first     last               email\n",
       "one    Charlie  Chaplin   chaplin@gmail.com\n",
       "two       Jane     Does  JaneDoes@email.com\n",
       "three    Uncle      Ben       ben@email.com\n",
       "four      K.P.      Oli     kpbaa@gmail.com\n",
       "four       XYZ      BLC   newmail@gmail.com"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "personf = person2\n",
    "personf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "a01579aa",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    first      last email age\n",
       "0     Raj  Bhandari          \n",
       "1    Snow     White          \n",
       "2  Marlon    Samuel          "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newDF = pd.DataFrame({\"first\": [\"Raj\", 'Snow', 'Marlon'], \n",
    "    \"last\": [\"Bhandari\", 'White', 'Samuel'], \n",
    "    \"email\": ['','',''],\n",
    "    \"age\": ['','','']})\n",
    "newDF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "9a5148be",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first      last               email  age\n",
       "one    Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two       Jane      Does  JaneDoes@email.com  NaN\n",
       "three    Uncle       Ben       ben@email.com  NaN\n",
       "four      K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "four       XYZ       BLC   newmail@gmail.com  NaN\n",
       "0          Raj  Bhandari                         \n",
       "1         Snow     White                         \n",
       "2       Marlon    Samuel                         "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "personf=personf.append(newDF)\n",
    "personf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "2d75269c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "first     Snow\n",
       "last     White\n",
       "email         \n",
       "age           \n",
       "Name: 1, dtype: object"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "personf.loc[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "982f7d31",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "first                  Jane\n",
       "last                   Does\n",
       "email    JaneDoes@email.com\n",
       "age                     NaN\n",
       "Name: two, dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "personf.iloc[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "10226261",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['one', 'two', 'three', 'four', 'four'], dtype='object')"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "person2.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "74856f81",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([False, False, False, False,  True])"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "person2.index.duplicated()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "5a477899",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['one', 'two', 'three', 'four', 'four', 0, 1, 2], dtype='object')"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "personf.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "ce529035",
   "metadata": {},
   "outputs": [],
   "source": [
    "persondf = personf.rename(index={0:'zero',1:'newone',2:'newtwo'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "465f9c90",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "one     Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "four        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "persondf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "5acac665",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "one     Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "four        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=persondf\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "53a5c75d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>one</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>two</td>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>three</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>four</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>four</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>zero</td>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>newone</td>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>newtwo</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index    first      last               email  age\n",
       "0     one  Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "1     two     Jane      Does  JaneDoes@email.com  NaN\n",
       "2   three    Uncle       Ben       ben@email.com  NaN\n",
       "3    four     K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "4    four      XYZ       BLC   newmail@gmail.com  NaN\n",
       "5    zero      Raj  Bhandari                         \n",
       "6  newone     Snow     White                         \n",
       "7  newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.reset_index(inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "8283801f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['index', 'first', 'last', 'email', 'age'], dtype='object')"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "a213f649",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "index               four\n",
       "first               K.P.\n",
       "last                 Oli\n",
       "email    kpbaa@gmail.com\n",
       "age                  NaN\n",
       "Name: 3, dtype: object"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "9fb0b867",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'four'"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[4,'index']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "018f7719",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[4,'index']='five'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "6874439c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>one</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>two</td>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>three</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>four</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>five</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>zero</td>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>newone</td>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>newtwo</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index    first      last               email  age\n",
       "0     one  Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "1     two     Jane      Does  JaneDoes@email.com  NaN\n",
       "2   three    Uncle       Ben       ben@email.com  NaN\n",
       "3    four     K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "4    five      XYZ       BLC   newmail@gmail.com  NaN\n",
       "5    zero      Raj  Bhandari                         \n",
       "6  newone     Snow     White                         \n",
       "7  newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "77cb825e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.set_index(df['index'],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "c873b767",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>one</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>two</td>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>three</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>four</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>five</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>zero</td>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>newone</td>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>newtwo</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         index    first      last               email  age\n",
       "index                                                     \n",
       "one        one  Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        two     Jane      Does  JaneDoes@email.com  NaN\n",
       "three    three    Uncle       Ben       ben@email.com  NaN\n",
       "four      four     K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "five      five      XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero      zero      Raj  Bhandari                         \n",
       "newone  newone     Snow     White                         \n",
       "newtwo  newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "12972e05",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>zero</td>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>newone</td>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>newtwo</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         index   first      last email age\n",
       "index                                     \n",
       "zero      zero     Raj  Bhandari          \n",
       "newone  newone    Snow     White          \n",
       "newtwo  newtwo  Marlon    Samuel          "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "1598a1b4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>one</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>two</td>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>three</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>four</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>five</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>zero</td>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>newone</td>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>newtwo</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         index    first      last               email  age\n",
       "index                                                     \n",
       "one        one  Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        two     Jane      Does  JaneDoes@email.com  NaN\n",
       "three    three    Uncle       Ben       ben@email.com  NaN\n",
       "four      four     K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "five      five      XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero      zero      Raj  Bhandari                         \n",
       "newone  newone     Snow     White                         \n",
       "newtwo  newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "efd65507",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>zero</td>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>newone</td>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>newtwo</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         index   first      last email age\n",
       "index                                     \n",
       "zero      zero     Raj  Bhandari          \n",
       "newone  newone    Snow     White          \n",
       "newtwo  newtwo  Marlon    Samuel          "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna(axis=0,subset=['age'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "81747b19",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop('index',1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "5fbf7349",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "one     Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "fd41a2b2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['one', 'two', 'three', 'four', 'five', 'zero', 'newone', 'newtwo'], dtype='object', name='index')"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "61068fd7",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>test1</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>test2</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "one     Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         \n",
       "test1      K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "test2      K.P.       Oli     kpbaa@gmail.com  NaN"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=df.append(pd.Series({'email':'kpbaa@gmail.com','first': 'K.P.', 'last': 'Oli'},name='test1'))\n",
    "df=df.append(pd.Series({'email':'kpbaa@gmail.com','first': 'K.P.', 'last': 'Oli'},name='test2'))\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "3e5965c6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop_duplicates(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "304d7bc6",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "one     Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "d828f805",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop_duplicates(subset=['last'],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "6dd23eed",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "one     Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "4a0284bc",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tests2</th>\n",
       "      <td>Peter2</td>\n",
       "      <td>Bro2</td>\n",
       "      <td>peter2@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tests</th>\n",
       "      <td>Peter</td>\n",
       "      <td>Bro</td>\n",
       "      <td>peter@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "one     Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         \n",
       "tests2   Peter2      Bro2    peter2@gmail.com  NaN\n",
       "tests     Peter       Bro     peter@gmail.com  NaN"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=df.append(pd.Series({'email':'peter2@gmail.com','first': 'Peter2', 'last': 'Bro2'},name='tests2'))\n",
    "df=df.append(pd.Series({'email':'peter@gmail.com','first': 'Peter', 'last': 'Bro'},name='tests'))\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "704b416b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['tests'], dtype='object', name='index')"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "condition=df['email'] =='peter@gmail.com'\n",
    "df[condition].index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "3fcb9987",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tests2</th>\n",
       "      <td>Peter2</td>\n",
       "      <td>Bro2</td>\n",
       "      <td>peter2@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "one     Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         \n",
       "tests2   Peter2      Bro2    peter2@gmail.com  NaN"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "condition=df['email'] =='peter@gmail.com'\n",
    "df.drop(index=df[condition].index,inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "dcc9d4d1",
   "metadata": {},
   "outputs": [],
   "source": [
    "condition = df['email'].filter(regex='\\w\\d+')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "d770d676",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "index\n",
       "tests2    peter2@gmail.com\n",
       "Name: email, dtype: object"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "condition"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "cfcfd3e0",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "one     Charlie   Chaplin   chaplin@gmail.com  NaN\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com  NaN\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(index=condition.index,inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "47b48fdc",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc['one','age']=89\n",
    "df.loc['four','age']=78"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "f0d266e8",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "one     Charlie   Chaplin   chaplin@gmail.com   89\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com   78\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "00d3be4d",
   "metadata": {},
   "outputs": [],
   "source": [
    "def update_email(email):\n",
    "    return email.upper()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "76e88708",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "index\n",
       "one        CHAPLIN@GMAIL.COM\n",
       "two       JANEDOES@EMAIL.COM\n",
       "three          BEN@EMAIL.COM\n",
       "four         KPBAA@GMAIL.COM\n",
       "five       NEWMAIL@GMAIL.COM\n",
       "zero                        \n",
       "newone                      \n",
       "newtwo                      \n",
       "Name: email, dtype: object"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['email'].apply(update_email)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "01e8d896",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1=df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "69c86d7d",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "one     Charlie   Chaplin   chaplin@gmail.com   89\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com   78\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN\n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         "
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "efdf3601",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "zero        Raj  Bhandari                         \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         \n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "one     Charlie   Chaplin   chaplin@gmail.com   89\n",
       "four       K.P.       Oli     kpbaa@gmail.com   78\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.sort_values(by='email',ascending=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "f998bc3b",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         \n",
       "four       K.P.       Oli     kpbaa@gmail.com   78\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "one     Charlie   Chaplin   chaplin@gmail.com   89\n",
       "zero        Raj  Bhandari                         \n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "five        XYZ       BLC   newmail@gmail.com  NaN"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.sort_values(by=['last','first'],ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "27d87bea",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          first      last               email  age\n",
       "index                                             \n",
       "five        XYZ       BLC   newmail@gmail.com  NaN\n",
       "four       K.P.       Oli     kpbaa@gmail.com   78\n",
       "newone     Snow     White                         \n",
       "newtwo   Marlon    Samuel                         \n",
       "one     Charlie   Chaplin   chaplin@gmail.com   89\n",
       "three     Uncle       Ben       ben@email.com  NaN\n",
       "two        Jane      Does  JaneDoes@email.com  NaN\n",
       "zero        Raj  Bhandari                         "
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.sort_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "5b5fde98",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email  age\n",
       "index                                             \n",
       "one      Chaplin  Charlie   chaplin@gmail.com   89\n",
       "two         Does     Jane  JaneDoes@email.com  NaN\n",
       "three        Ben    Uncle       ben@email.com  NaN\n",
       "four         Oli     K.P.     kpbaa@gmail.com   78\n",
       "five         BLC      XYZ   newmail@gmail.com  NaN\n",
       "zero    Bhandari      Raj                         \n",
       "newone     White     Snow                         \n",
       "newtwo    Samuel   Marlon                         "
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.sort_index(axis=1, inplace=True,ascending=False)\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "c16b955e",
   "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>age</th>\n",
       "      <th>email</th>\n",
       "      <th>first</th>\n",
       "      <th>last</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>89</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>NaN</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>NaN</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>78</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>Oli</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>NaN</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>BLC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Raj</td>\n",
       "      <td>Bhandari</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Snow</td>\n",
       "      <td>White</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Marlon</td>\n",
       "      <td>Samuel</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        age               email    first      last\n",
       "index                                             \n",
       "one      89   chaplin@gmail.com  Charlie   Chaplin\n",
       "two     NaN  JaneDoes@email.com     Jane      Does\n",
       "three   NaN       ben@email.com    Uncle       Ben\n",
       "four     78     kpbaa@gmail.com     K.P.       Oli\n",
       "five    NaN   newmail@gmail.com      XYZ       BLC\n",
       "zero                                 Raj  Bhandari\n",
       "newone                              Snow     White\n",
       "newtwo                            Marlon    Samuel"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1[sorted(df1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "9c80c53c",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          last    first               email  age\n",
       "index                                           \n",
       "one    Chaplin  Charlie   chaplin@gmail.com   89\n",
       "two       Does     Jane  JaneDoes@email.com  NaN\n",
       "three      Ben    Uncle       ben@email.com  NaN\n",
       "four       Oli     K.P.     kpbaa@gmail.com   78\n",
       "five       BLC      XYZ   newmail@gmail.com  NaN"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "e768e9ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['last', 'first', 'email', 'age'], dtype='object')"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2=df1\n",
    "df2.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "659c46c8",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2['midName']=[x[0] for x in df2['last']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "b34a3631",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email  age midName\n",
       "index                                                     \n",
       "one      Chaplin  Charlie   chaplin@gmail.com   89       C\n",
       "two         Does     Jane  JaneDoes@email.com  NaN       D\n",
       "three        Ben    Uncle       ben@email.com  NaN       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com   78       O\n",
       "five         BLC      XYZ   newmail@gmail.com  NaN       B\n",
       "zero    Bhandari      Raj                                B\n",
       "newone     White     Snow                                W\n",
       "newtwo    Samuel   Marlon                                S"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "dcfdce2f",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email  age midName\n",
       "index                                                     \n",
       "one      Chaplin  Charlie   chaplin@gmail.com   89       C\n",
       "two         Does     Jane  JaneDoes@email.com  NaN       D\n",
       "three        Ben    Uncle       ben@email.com  NaN       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com   78       O\n",
       "five         BLC      XYZ   newmail@gmail.com  NaN       B\n",
       "zero    Bhandari      Raj                                B\n",
       "newone     White     Snow                                W\n",
       "newtwo    Samuel   Marlon                                S"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4=df2\n",
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "873fdde4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "last       8\n",
       "first      8\n",
       "email      8\n",
       "age        5\n",
       "midName    8\n",
       "dtype: int64"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4[df4.notna()].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "d1abc101",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first              email age midName\n",
       "index                                                   \n",
       "one      Chaplin  Charlie  chaplin@gmail.com  89       C\n",
       "four         Oli     K.P.    kpbaa@gmail.com  78       O\n",
       "zero    Bhandari      Raj                              B\n",
       "newone     White     Snow                              W\n",
       "newtwo    Samuel   Marlon                              S"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "e583749f",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email  age midName\n",
       "index                                                     \n",
       "one      Chaplin  Charlie   chaplin@gmail.com   89       C\n",
       "two         Does     Jane  JaneDoes@email.com  NaN       D\n",
       "three        Ben    Uncle       ben@email.com  NaN       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com   78       O\n",
       "five         BLC      XYZ   newmail@gmail.com  NaN       B\n",
       "zero    Bhandari      Raj                                B\n",
       "newone     White     Snow                                W\n",
       "newtwo    Samuel   Marlon                                S"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "abe310b5",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>0</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email age midName\n",
       "index                                                    \n",
       "one      Chaplin  Charlie   chaplin@gmail.com  89       C\n",
       "two         Does     Jane  JaneDoes@email.com   0       D\n",
       "three        Ben    Uncle       ben@email.com   0       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com  78       O\n",
       "five         BLC      XYZ   newmail@gmail.com   0       B\n",
       "zero    Bhandari      Raj                               B\n",
       "newone     White     Snow                               W\n",
       "newtwo    Samuel   Marlon                               S"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "35fef36d",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email   age midName\n",
       "index                                                      \n",
       "one      Chaplin  Charlie   chaplin@gmail.com  89.0       C\n",
       "two         Does     Jane  JaneDoes@email.com   NaN       D\n",
       "three        Ben    Uncle       ben@email.com   NaN       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com  78.0       O\n",
       "five         BLC      XYZ   newmail@gmail.com   NaN       B\n",
       "zero    Bhandari      Raj                 NaN   NaN       B\n",
       "newone     White     Snow                 NaN   NaN       W\n",
       "newtwo    Samuel   Marlon                 NaN   NaN       S"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4 = df4.replace(r'^\\s*$', np.nan, regex=True) #\\s: space/empty, *: 0 or more\n",
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "c7346ae5",
   "metadata": {},
   "outputs": [],
   "source": [
    "df4.email = df4.email.fillna('x@y.z')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "9abee14c",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email   age midName\n",
       "index                                                      \n",
       "one      Chaplin  Charlie   chaplin@gmail.com  89.0       C\n",
       "two         Does     Jane  JaneDoes@email.com   NaN       D\n",
       "three        Ben    Uncle       ben@email.com   NaN       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com  78.0       O\n",
       "five         BLC      XYZ   newmail@gmail.com   NaN       B\n",
       "zero    Bhandari      Raj               x@y.z   NaN       B\n",
       "newone     White     Snow               x@y.z   NaN       W\n",
       "newtwo    Samuel   Marlon               x@y.z   NaN       S"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "1964ed72",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>0.0</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>0.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>0.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>0.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>0.0</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>0.0</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email   age midName\n",
       "index                                                      \n",
       "one      Chaplin  Charlie   chaplin@gmail.com  89.0       C\n",
       "two         Does     Jane  JaneDoes@email.com   0.0       D\n",
       "three        Ben    Uncle       ben@email.com   0.0       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com  78.0       O\n",
       "five         BLC      XYZ   newmail@gmail.com   0.0       B\n",
       "zero    Bhandari      Raj               x@y.z   0.0       B\n",
       "newone     White     Snow               x@y.z   0.0       W\n",
       "newtwo    Samuel   Marlon               x@y.z   0.0       S"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "ba7deb90",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "last        object\n",
       "first       object\n",
       "email       object\n",
       "age        float64\n",
       "midName     object\n",
       "dtype: object"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "f066256b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "index\n",
       "one        89.0\n",
       "two         NaN\n",
       "three       NaN\n",
       "four      167.0\n",
       "five        NaN\n",
       "zero        NaN\n",
       "newone      NaN\n",
       "newtwo      NaN\n",
       "Name: age, dtype: float64"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4['age'].cumsum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "1bb1b1c8",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email   age midName\n",
       "index                                                      \n",
       "one      Chaplin  Charlie   chaplin@gmail.com  89.0       C\n",
       "two         Does     Jane  JaneDoes@email.com   NaN       D\n",
       "three        Ben    Uncle       ben@email.com   NaN       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com  78.0       O\n",
       "five         BLC      XYZ   newmail@gmail.com   NaN       B\n",
       "zero    Bhandari      Raj               x@y.z   NaN       B\n",
       "newone     White     Snow               x@y.z   NaN       W\n",
       "newtwo    Samuel   Marlon               x@y.z   NaN       S"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "04773b40",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>78.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>78.0</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>78.0</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email   age midName\n",
       "index                                                      \n",
       "one      Chaplin  Charlie   chaplin@gmail.com  89.0       C\n",
       "two         Does     Jane  JaneDoes@email.com  89.0       D\n",
       "three        Ben    Uncle       ben@email.com  89.0       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com  78.0       O\n",
       "five         BLC      XYZ   newmail@gmail.com  78.0       B\n",
       "zero    Bhandari      Raj               x@y.z  78.0       B\n",
       "newone     White     Snow               x@y.z  78.0       W\n",
       "newtwo    Samuel   Marlon               x@y.z  78.0       S"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4.fillna(method='ffill')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "a2c6d9ee",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email   age midName\n",
       "index                                                      \n",
       "one      Chaplin  Charlie   chaplin@gmail.com  89.0       C\n",
       "two         Does     Jane  JaneDoes@email.com  78.0       D\n",
       "three        Ben    Uncle       ben@email.com  78.0       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com  78.0       O\n",
       "five         BLC      XYZ   newmail@gmail.com   NaN       B\n",
       "zero    Bhandari      Raj               x@y.z   NaN       B\n",
       "newone     White     Snow               x@y.z   NaN       W\n",
       "newtwo    Samuel   Marlon               x@y.z   NaN       S"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df5 = df4.fillna(method='bfill')\n",
    "df5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "6bb79d9e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "84"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "val=round(df4['age'].astype(float).mean())\n",
    "val"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "178be1bf",
   "metadata": {},
   "outputs": [],
   "source": [
    "df4['age']=df4['age'].fillna(val)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "02117486",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>84.0</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>84.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>84.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>84.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>84.0</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>84.0</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email   age midName\n",
       "index                                                      \n",
       "one      Chaplin  Charlie   chaplin@gmail.com  89.0       C\n",
       "two         Does     Jane  JaneDoes@email.com  84.0       D\n",
       "three        Ben    Uncle       ben@email.com  84.0       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com  78.0       O\n",
       "five         BLC      XYZ   newmail@gmail.com  84.0       B\n",
       "zero    Bhandari      Raj               x@y.z  84.0       B\n",
       "newone     White     Snow               x@y.z  84.0       W\n",
       "newtwo    Samuel   Marlon               x@y.z  84.0       S"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "fa17ee0f",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>84.0</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>84.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>84.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>84.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>84.0</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>84.0</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email   age midName\n",
       "index                                                      \n",
       "four         Oli     K.P.     kpbaa@gmail.com  78.0       O\n",
       "two         Does     Jane  JaneDoes@email.com  84.0       D\n",
       "three        Ben    Uncle       ben@email.com  84.0       B\n",
       "five         BLC      XYZ   newmail@gmail.com  84.0       B\n",
       "zero    Bhandari      Raj               x@y.z  84.0       B\n",
       "newone     White     Snow               x@y.z  84.0       W\n",
       "newtwo    Samuel   Marlon               x@y.z  84.0       S\n",
       "one      Chaplin  Charlie   chaplin@gmail.com  89.0       C"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4.sort_values(by='age')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "9b0abfbb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "84.0    6\n",
       "89.0    1\n",
       "78.0    1\n",
       "Name: age, dtype: int64"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4['age'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "68878afd",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>89.0</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>78.0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email   age midName\n",
       "index                                                      \n",
       "one      Chaplin  Charlie   chaplin@gmail.com  89.0       C\n",
       "two         Does     Jane  JaneDoes@email.com  78.0       D\n",
       "three        Ben    Uncle       ben@email.com  78.0       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com  78.0       O\n",
       "five         BLC      XYZ   newmail@gmail.com   NaN       B\n",
       "zero    Bhandari      Raj               x@y.z   NaN       B\n",
       "newone     White     Snow               x@y.z   NaN       W\n",
       "newtwo    Samuel   Marlon               x@y.z   NaN       S"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "95127694",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['one', 'two', 'three', 'four']"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "l=list(df5.index[df5.age>50])\n",
    "l"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "a8a27d4f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df5.loc[l,'age']=60"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "dfa4c2e5",
   "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>last</th>\n",
       "      <th>first</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>midName</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>one</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>60.0</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>two</th>\n",
       "      <td>Does</td>\n",
       "      <td>Jane</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>60.0</td>\n",
       "      <td>D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>three</th>\n",
       "      <td>Ben</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>60.0</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>four</th>\n",
       "      <td>Oli</td>\n",
       "      <td>K.P.</td>\n",
       "      <td>kpbaa@gmail.com</td>\n",
       "      <td>60.0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>five</th>\n",
       "      <td>BLC</td>\n",
       "      <td>XYZ</td>\n",
       "      <td>newmail@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zero</th>\n",
       "      <td>Bhandari</td>\n",
       "      <td>Raj</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newone</th>\n",
       "      <td>White</td>\n",
       "      <td>Snow</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>W</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>newtwo</th>\n",
       "      <td>Samuel</td>\n",
       "      <td>Marlon</td>\n",
       "      <td>x@y.z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            last    first               email   age midName\n",
       "index                                                      \n",
       "one      Chaplin  Charlie   chaplin@gmail.com  60.0       C\n",
       "two         Does     Jane  JaneDoes@email.com  60.0       D\n",
       "three        Ben    Uncle       ben@email.com  60.0       B\n",
       "four         Oli     K.P.     kpbaa@gmail.com  60.0       O\n",
       "five         BLC      XYZ   newmail@gmail.com   NaN       B\n",
       "zero    Bhandari      Raj               x@y.z   NaN       B\n",
       "newone     White     Snow               x@y.z   NaN       W\n",
       "newtwo    Samuel   Marlon               x@y.z   NaN       S"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "2362c137",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "index\n",
       "one       60.0\n",
       "two       60.0\n",
       "three     60.0\n",
       "four      60.0\n",
       "five       NaN\n",
       "zero       NaN\n",
       "newone     NaN\n",
       "newtwo     NaN\n",
       "Name: age, dtype: float64"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df5.age"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "fae14b32",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([], dtype='object', name='index')"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df5.index[df5.age<50]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "bac0e2f5",
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'df5' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-2-b1a1ffb69411>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdf5\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mlo\u001b[0m\u001b[1;33m;\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'five'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m'zero'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m'newone'\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m'newtwo'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'df5' is not defined"
     ]
    }
   ],
   "source": [
    "df5.lo;[['five','zero','newone','newtwo']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "6a396db0",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "01c189c6",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     first     last               email\n",
       "0  Charlie  Chaplin   chaplin@gmail.com\n",
       "1     Jane     Does  JaneDoes@email.com\n",
       "2    Uncle      Ben       ben@email.com"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "people = {\n",
    "    \"first\": [\"Charlie\", 'Jane', 'Uncle'], \n",
    "    \"last\": [\"Chaplin\", 'Does', 'Ben'], \n",
    "    \"email\": [\"chaplin@gmail.com\", 'JaneDoes@email.com', 'ben@email.com']\n",
    "}\n",
    "df1=pd.DataFrame(people)\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3ad8d55c",
   "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>first</th>\n",
       "      <th>age</th>\n",
       "      <th>country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>30</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>40</td>\n",
       "      <td>Trinidad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>50</td>\n",
       "      <td>UK</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     first  age   country\n",
       "0  Charlie   30       USA\n",
       "1     Jane   40  Trinidad\n",
       "2    Uncle   50        UK"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "people2 = {\n",
    "    \"first\": [\"Charlie\", 'Jane', 'Uncle'], \n",
    "    \"age\": [30, 40, 50], \n",
    "    \"country\": [\"USA\", 'Trinidad', 'UK']\n",
    "}\n",
    "df2=pd.DataFrame(people2)\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "e67a6d32",
   "metadata": {},
   "outputs": [],
   "source": [
    "final = df1.merge(df2,on='first')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "1d7af151",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>30</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>40</td>\n",
       "      <td>Trinidad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>50</td>\n",
       "      <td>UK</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     first     last               email  age   country\n",
       "0  Charlie  Chaplin   chaplin@gmail.com   30       USA\n",
       "1     Jane     Does  JaneDoes@email.com   40  Trinidad\n",
       "2    Uncle      Ben       ben@email.com   50        UK"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "14b002db",
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "      <th>age</th>\n",
       "      <th>country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Chaplin</td>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Does</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>Ben</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>USA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>Trinidad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Uncle</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.0</td>\n",
       "      <td>UK</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     first     last               email   age   country\n",
       "0  Charlie  Chaplin   chaplin@gmail.com   NaN       NaN\n",
       "1     Jane     Does  JaneDoes@email.com   NaN       NaN\n",
       "2    Uncle      Ben       ben@email.com   NaN       NaN\n",
       "0  Charlie      NaN                 NaN  30.0       USA\n",
       "1     Jane      NaN                 NaN  40.0  Trinidad\n",
       "2    Uncle      NaN                 NaN  50.0        UK"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "finalNew = pd.concat([df1,df2])\n",
    "finalNew"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "4f717d0c",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>first</th>\n",
       "      <td>Charlie</td>\n",
       "      <td>Jane</td>\n",
       "      <td>Uncle</td>\n",
       "      <td>Charlie</td>\n",
       "      <td>Jane</td>\n",
       "      <td>Uncle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>last</th>\n",
       "      <td>Chaplin</td>\n",
       "      <td>Does</td>\n",
       "      <td>Ben</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>email</th>\n",
       "      <td>chaplin@gmail.com</td>\n",
       "      <td>JaneDoes@email.com</td>\n",
       "      <td>ben@email.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>age</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>country</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>USA</td>\n",
       "      <td>Trinidad</td>\n",
       "      <td>UK</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         0                   1              2        0  \\\n",
       "first              Charlie                Jane          Uncle  Charlie   \n",
       "last               Chaplin                Does            Ben      NaN   \n",
       "email    chaplin@gmail.com  JaneDoes@email.com  ben@email.com      NaN   \n",
       "age                    NaN                 NaN            NaN     30.0   \n",
       "country                NaN                 NaN            NaN      USA   \n",
       "\n",
       "                1      2  \n",
       "first        Jane  Uncle  \n",
       "last          NaN    NaN  \n",
       "email         NaN    NaN  \n",
       "age          40.0   50.0  \n",
       "country  Trinidad     UK  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "xyz=finalNew\n",
    "xyz.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d5b7f63a",
   "metadata": {},
   "outputs": [],
   "source": [
    "xyz.T."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}