Nifty_500_detailed.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "8c0ee5a6",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Import the Libraries\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "import plotly.graph_objects as go\n",
    "import plotly.express as px\n",
    "\n",
    "\n",
    "from warnings import filterwarnings\n",
    "filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d1e3a615",
   "metadata": {},
   "outputs": [],
   "source": [
    "df =pd.read_csv('ind_nifty500list.csv')\n",
    "df_all = pd.read_csv('All_listed_Mar2023.csv')\n",
    "df=df.merge(df_all, on='Symbol')\n",
    "df.sort_values(by='Market capitalization as on March 31, 2023\\n(Rs in Lakhs)', ascending=False)\n",
    "df.rename(columns={'Market capitalization as on March 31, 2023\\n(Rs in Lakhs)':'Mcap_Mar23'}, inplace=True)\n",
    "df['Mcap_Mar23']=df['Mcap_Mar23'].astype('float')\n",
    "df=df.reset_index()\n",
    "df=df.drop(columns='index')\n",
    "df=df.drop(columns='Sr. No.')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "bb625d85",
   "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>Company Name_x</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Series</th>\n",
       "      <th>ISIN Code</th>\n",
       "      <th>Company Name_y</th>\n",
       "      <th>Mcap_Mar23</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>360 ONE WAM Ltd.</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>360ONE</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE466L01038</td>\n",
       "      <td>360 ONE WAM LIMITED</td>\n",
       "      <td>1533603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3M India Ltd.</td>\n",
       "      <td>Diversified</td>\n",
       "      <td>3MINDIA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE470A01017</td>\n",
       "      <td>3M India Limited</td>\n",
       "      <td>2586894.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ABB India Ltd.</td>\n",
       "      <td>Capital Goods</td>\n",
       "      <td>ABB</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE117A01022</td>\n",
       "      <td>ABB India Limited</td>\n",
       "      <td>7131035.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ACC Ltd.</td>\n",
       "      <td>Construction Materials</td>\n",
       "      <td>ACC</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE012A01025</td>\n",
       "      <td>ACC Limited</td>\n",
       "      <td>3130789.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AIA Engineering Ltd.</td>\n",
       "      <td>Capital Goods</td>\n",
       "      <td>AIAENG</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE212H01026</td>\n",
       "      <td>AIA Engineering Limited</td>\n",
       "      <td>2738215.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>Zensar Technolgies Ltd.</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>ZENSARTECH</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE520A01027</td>\n",
       "      <td>Zensar Technologies Limited</td>\n",
       "      <td>621067.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>Zomato Ltd.</td>\n",
       "      <td>Consumer Services</td>\n",
       "      <td>ZOMATO</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE758T01015</td>\n",
       "      <td>Zomato Limited</td>\n",
       "      <td>4362290.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>Zydus Lifesciences Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>ZYDUSLIFE</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE010B01027</td>\n",
       "      <td>Zydus Lifesciences Limited</td>\n",
       "      <td>4975489.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>Zydus Wellness Ltd.</td>\n",
       "      <td>Fast Moving Consumer Goods</td>\n",
       "      <td>ZYDUSWELL</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE768C01010</td>\n",
       "      <td>Zydus Wellness Limited</td>\n",
       "      <td>986489.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>eClerx Services Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>ECLERX</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE738I01010</td>\n",
       "      <td>eClerx Services Limited</td>\n",
       "      <td>632623.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>486 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Company Name_x                    Industry      Symbol Series  \\\n",
       "0           360 ONE WAM Ltd.          Financial Services      360ONE     EQ   \n",
       "1              3M India Ltd.                 Diversified     3MINDIA     EQ   \n",
       "2             ABB India Ltd.               Capital Goods         ABB     EQ   \n",
       "3                   ACC Ltd.      Construction Materials         ACC     EQ   \n",
       "4       AIA Engineering Ltd.               Capital Goods      AIAENG     EQ   \n",
       "..                       ...                         ...         ...    ...   \n",
       "481  Zensar Technolgies Ltd.      Information Technology  ZENSARTECH     EQ   \n",
       "482              Zomato Ltd.           Consumer Services      ZOMATO     EQ   \n",
       "483  Zydus Lifesciences Ltd.                  Healthcare   ZYDUSLIFE     EQ   \n",
       "484      Zydus Wellness Ltd.  Fast Moving Consumer Goods   ZYDUSWELL     EQ   \n",
       "485     eClerx Services Ltd.                    Services      ECLERX     EQ   \n",
       "\n",
       "        ISIN Code               Company Name_y  Mcap_Mar23  \n",
       "0    INE466L01038          360 ONE WAM LIMITED   1533603.0  \n",
       "1    INE470A01017             3M India Limited   2586894.0  \n",
       "2    INE117A01022            ABB India Limited   7131035.0  \n",
       "3    INE012A01025                  ACC Limited   3130789.0  \n",
       "4    INE212H01026      AIA Engineering Limited   2738215.0  \n",
       "..            ...                          ...         ...  \n",
       "481  INE520A01027  Zensar Technologies Limited    621067.0  \n",
       "482  INE758T01015               Zomato Limited   4362290.0  \n",
       "483  INE010B01027   Zydus Lifesciences Limited   4975489.0  \n",
       "484  INE768C01010       Zydus Wellness Limited    986489.0  \n",
       "485  INE738I01010      eClerx Services Limited    632623.0  \n",
       "\n",
       "[486 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "25eef45d",
   "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>Industry</th>\n",
       "      <th>counts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Financial Services</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Capital Goods</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Healthcare</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Chemicals</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fast Moving Consumer Goods</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Consumer Durables</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Consumer Services</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Information Technology</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Oil Gas &amp; Consumable Fuels</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Services</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Metals &amp; Mining</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Construction Materials</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Construction</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Realty</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Power</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Telecommunication</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Textiles</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Media Entertainment &amp; Publication</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Diversified</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Forest Materials</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Industry  counts\n",
       "9                  Financial Services      86\n",
       "1                       Capital Goods      56\n",
       "11                         Healthcare      44\n",
       "2                           Chemicals      39\n",
       "0      Automobile and Auto Components      30\n",
       "8          Fast Moving Consumer Goods      29\n",
       "5                   Consumer Durables      29\n",
       "6                   Consumer Services      26\n",
       "12             Information Technology      25\n",
       "15         Oil Gas & Consumable Fuels      17\n",
       "18                           Services      16\n",
       "14                    Metals & Mining      14\n",
       "4              Construction Materials      13\n",
       "3                        Construction      12\n",
       "17                             Realty      11\n",
       "16                              Power      11\n",
       "19                  Telecommunication      10\n",
       "20                           Textiles       7\n",
       "13  Media Entertainment & Publication       6\n",
       "7                         Diversified       3\n",
       "10                   Forest Materials       2"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_industry=df.groupby(by='Industry').size().reset_index(name='counts').sort_values(by='counts', ascending=False)\n",
    "df_industry"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "d08d7807",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_Autocomp=df[df['Industry']=='Automobile and Auto Components']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "89cbfb2f",
   "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>Company Name_x</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Series</th>\n",
       "      <th>ISIN Code</th>\n",
       "      <th>Company Name_y</th>\n",
       "      <th>Mcap_Mar23</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Apollo Tyres Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>APOLLOTYRE</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE438A01022</td>\n",
       "      <td>Apollo Tyres Limited</td>\n",
       "      <td>2031688.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Asahi India Glass Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>ASAHIINDIA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE439A01020</td>\n",
       "      <td>Asahi India Glass Limited</td>\n",
       "      <td>1099131.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Bajaj Auto Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>BAJAJ-AUTO</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE917I01010</td>\n",
       "      <td>Bajaj Auto Limited</td>\n",
       "      <td>10992186.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Balkrishna Industries Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>BALKRISIND</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE787D01026</td>\n",
       "      <td>Balkrishna Industries Limited</td>\n",
       "      <td>3772488.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Bosch Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>BOSCHLTD</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE323A01026</td>\n",
       "      <td>Bosch Limited</td>\n",
       "      <td>5712889.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Ceat Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>CEATLTD</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE482A01020</td>\n",
       "      <td>CEAT Limited</td>\n",
       "      <td>586749.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Craftsman Automation Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>CRAFTSMAN</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE00LO01017</td>\n",
       "      <td>Craftsman Automation Limited</td>\n",
       "      <td>687790.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>Eicher Motors Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>EICHERMOT</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE066A01021</td>\n",
       "      <td>Eicher Motors Limited</td>\n",
       "      <td>8064561.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>Endurance Technologies Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>ENDURANCE</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE913H01037</td>\n",
       "      <td>Endurance Technologies Limited</td>\n",
       "      <td>1746540.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Exide Industries Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>EXIDEIND</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE302A01020</td>\n",
       "      <td>Exide Industries Limited</td>\n",
       "      <td>1512575.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>Hero MotoCorp Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>HEROMOTOCO</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE158A01026</td>\n",
       "      <td>Hero MotoCorp Limited</td>\n",
       "      <td>4690938.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>JBM Auto Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>JBMA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE927D01044</td>\n",
       "      <td>JBM Auto Limited</td>\n",
       "      <td>761512.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>Jamna Auto Industries Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>JAMNAAUTO</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE039C01032</td>\n",
       "      <td>Jamna Auto Industries Limited</td>\n",
       "      <td>397228.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>MRF Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>MRF</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE883A01011</td>\n",
       "      <td>MRF Limited</td>\n",
       "      <td>3564562.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>Mahindra &amp; Mahindra Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>M&amp;M</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE101A01026</td>\n",
       "      <td>Mahindra &amp; Mahindra Limited</td>\n",
       "      <td>14408769.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>Maruti Suzuki India Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>MARUTI</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE585B01010</td>\n",
       "      <td>Maruti Suzuki India Limited</td>\n",
       "      <td>25048932.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>Minda Corporation Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>MINDACORP</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE842C01021</td>\n",
       "      <td>Minda Corporation Limited</td>\n",
       "      <td>514379.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>Motherson Sumi Wiring India Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>MSUMI</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE0FS801015</td>\n",
       "      <td>Motherson Sumi Wiring India Limited</td>\n",
       "      <td>2133185.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>Olectra Greentech Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>OLECTRA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE260D01016</td>\n",
       "      <td>Olectra Greentech Limited</td>\n",
       "      <td>508285.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>Samvardhana Motherson International Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>MOTHERSON</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE775A01035</td>\n",
       "      <td>Samvardhana Motherson International Limited</td>\n",
       "      <td>4546979.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>Schaeffler India Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>SCHAEFFLER</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE513A01022</td>\n",
       "      <td>Schaeffler India Limited</td>\n",
       "      <td>4482086.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>401</th>\n",
       "      <td>Sona BLW Precision Forgings Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>SONACOMS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE073K01018</td>\n",
       "      <td>Sona BLW Precision Forgings Limited</td>\n",
       "      <td>2420648.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>Sundram Fasteners Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>SUNDRMFAST</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE387A01021</td>\n",
       "      <td>Sundram Fasteners Limited</td>\n",
       "      <td>2055055.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>Suprajit Engineering Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>SUPRAJIT</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE399C01030</td>\n",
       "      <td>Suprajit Engineering Limited</td>\n",
       "      <td>477178.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>TVS Motor Company Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>TVSMOTOR</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE494B01023</td>\n",
       "      <td>TVS Motor Company Limited</td>\n",
       "      <td>5117638.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>Tata Motors Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>TATAMOTORS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE155A01022</td>\n",
       "      <td>Tata Motors Limited</td>\n",
       "      <td>13976217.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>Tube Investments of India Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>TIINDIA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE974X01010</td>\n",
       "      <td>Tube Investments of India Limited</td>\n",
       "      <td>4917996.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>UNO Minda Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>UNOMINDA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE405E01023</td>\n",
       "      <td>UNO Minda Limited</td>\n",
       "      <td>2755450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>Varroc Engineering Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>VARROC</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE665L01035</td>\n",
       "      <td>Varroc Engineering Limited</td>\n",
       "      <td>380973.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>ZF Commercial Vehicle Control Systems India Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>ZFCVINDIA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE342J01019</td>\n",
       "      <td>ZF Commercial Vehicle Control Systems India Li...</td>\n",
       "      <td>1974307.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Company Name_x  \\\n",
       "33                                  Apollo Tyres Ltd.   \n",
       "36                             Asahi India Glass Ltd.   \n",
       "49                                    Bajaj Auto Ltd.   \n",
       "54                         Balkrishna Industries Ltd.   \n",
       "76                                         Bosch Ltd.   \n",
       "92                                          Ceat Ltd.   \n",
       "113                         Craftsman Automation Ltd.   \n",
       "136                                Eicher Motors Ltd.   \n",
       "139                       Endurance Technologies Ltd.   \n",
       "144                             Exide Industries Ltd.   \n",
       "195                                Hero MotoCorp Ltd.   \n",
       "241                                     JBM Auto Ltd.   \n",
       "247                        Jamna Auto Industries Ltd.   \n",
       "286                                          MRF Ltd.   \n",
       "291                          Mahindra & Mahindra Ltd.   \n",
       "297                          Maruti Suzuki India Ltd.   \n",
       "305                            Minda Corporation Ltd.   \n",
       "306                  Motherson Sumi Wiring India Ltd.   \n",
       "328                            Olectra Greentech Ltd.   \n",
       "386          Samvardhana Motherson International Ltd.   \n",
       "390                             Schaeffler India Ltd.   \n",
       "401                  Sona BLW Precision Forgings Ltd.   \n",
       "413                            Sundram Fasteners Ltd.   \n",
       "415                         Suprajit Engineering Ltd.   \n",
       "425                            TVS Motor Company Ltd.   \n",
       "433                                  Tata Motors Ltd.   \n",
       "451                    Tube Investments of India Ltd.   \n",
       "453                                    UNO Minda Ltd.   \n",
       "467                           Varroc Engineering Ltd.   \n",
       "479  ZF Commercial Vehicle Control Systems India Ltd.   \n",
       "\n",
       "                           Industry      Symbol Series     ISIN Code  \\\n",
       "33   Automobile and Auto Components  APOLLOTYRE     EQ  INE438A01022   \n",
       "36   Automobile and Auto Components  ASAHIINDIA     EQ  INE439A01020   \n",
       "49   Automobile and Auto Components  BAJAJ-AUTO     EQ  INE917I01010   \n",
       "54   Automobile and Auto Components  BALKRISIND     EQ  INE787D01026   \n",
       "76   Automobile and Auto Components    BOSCHLTD     EQ  INE323A01026   \n",
       "92   Automobile and Auto Components     CEATLTD     EQ  INE482A01020   \n",
       "113  Automobile and Auto Components   CRAFTSMAN     EQ  INE00LO01017   \n",
       "136  Automobile and Auto Components   EICHERMOT     EQ  INE066A01021   \n",
       "139  Automobile and Auto Components   ENDURANCE     EQ  INE913H01037   \n",
       "144  Automobile and Auto Components    EXIDEIND     EQ  INE302A01020   \n",
       "195  Automobile and Auto Components  HEROMOTOCO     EQ  INE158A01026   \n",
       "241  Automobile and Auto Components        JBMA     EQ  INE927D01044   \n",
       "247  Automobile and Auto Components   JAMNAAUTO     EQ  INE039C01032   \n",
       "286  Automobile and Auto Components         MRF     EQ  INE883A01011   \n",
       "291  Automobile and Auto Components         M&M     EQ  INE101A01026   \n",
       "297  Automobile and Auto Components      MARUTI     EQ  INE585B01010   \n",
       "305  Automobile and Auto Components   MINDACORP     EQ  INE842C01021   \n",
       "306  Automobile and Auto Components       MSUMI     EQ  INE0FS801015   \n",
       "328  Automobile and Auto Components     OLECTRA     EQ  INE260D01016   \n",
       "386  Automobile and Auto Components   MOTHERSON     EQ  INE775A01035   \n",
       "390  Automobile and Auto Components  SCHAEFFLER     EQ  INE513A01022   \n",
       "401  Automobile and Auto Components    SONACOMS     EQ  INE073K01018   \n",
       "413  Automobile and Auto Components  SUNDRMFAST     EQ  INE387A01021   \n",
       "415  Automobile and Auto Components    SUPRAJIT     EQ  INE399C01030   \n",
       "425  Automobile and Auto Components    TVSMOTOR     EQ  INE494B01023   \n",
       "433  Automobile and Auto Components  TATAMOTORS     EQ  INE155A01022   \n",
       "451  Automobile and Auto Components     TIINDIA     EQ  INE974X01010   \n",
       "453  Automobile and Auto Components    UNOMINDA     EQ  INE405E01023   \n",
       "467  Automobile and Auto Components      VARROC     EQ  INE665L01035   \n",
       "479  Automobile and Auto Components   ZFCVINDIA     EQ  INE342J01019   \n",
       "\n",
       "                                        Company Name_y  Mcap_Mar23  \n",
       "33                                Apollo Tyres Limited   2031688.0  \n",
       "36                           Asahi India Glass Limited   1099131.0  \n",
       "49                                  Bajaj Auto Limited  10992186.0  \n",
       "54                       Balkrishna Industries Limited   3772488.0  \n",
       "76                                       Bosch Limited   5712889.0  \n",
       "92                                        CEAT Limited    586749.0  \n",
       "113                       Craftsman Automation Limited    687790.0  \n",
       "136                              Eicher Motors Limited   8064561.0  \n",
       "139                     Endurance Technologies Limited   1746540.0  \n",
       "144                           Exide Industries Limited   1512575.0  \n",
       "195                              Hero MotoCorp Limited   4690938.0  \n",
       "241                                   JBM Auto Limited    761512.0  \n",
       "247                      Jamna Auto Industries Limited    397228.0  \n",
       "286                                        MRF Limited   3564562.0  \n",
       "291                        Mahindra & Mahindra Limited  14408769.0  \n",
       "297                        Maruti Suzuki India Limited  25048932.0  \n",
       "305                          Minda Corporation Limited    514379.0  \n",
       "306                Motherson Sumi Wiring India Limited   2133185.0  \n",
       "328                          Olectra Greentech Limited    508285.0  \n",
       "386        Samvardhana Motherson International Limited   4546979.0  \n",
       "390                           Schaeffler India Limited   4482086.0  \n",
       "401                Sona BLW Precision Forgings Limited   2420648.0  \n",
       "413                          Sundram Fasteners Limited   2055055.0  \n",
       "415                       Suprajit Engineering Limited    477178.0  \n",
       "425                          TVS Motor Company Limited   5117638.0  \n",
       "433                                Tata Motors Limited  13976217.0  \n",
       "451                  Tube Investments of India Limited   4917996.0  \n",
       "453                                  UNO Minda Limited   2755450.0  \n",
       "467                         Varroc Engineering Limited    380973.0  \n",
       "479  ZF Commercial Vehicle Control Systems India Li...   1974307.0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Autocomp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "f5e7d415",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Company Name_x     object\n",
       "Industry           object\n",
       "Symbol             object\n",
       "Series             object\n",
       "ISIN Code          object\n",
       "Company Name_y     object\n",
       "Mcap_Mar23        float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Autocomp.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "3e51b8fa",
   "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>Company Name_x</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Series</th>\n",
       "      <th>ISIN Code</th>\n",
       "      <th>Company Name_y</th>\n",
       "      <th>Mcap_Mar23</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>Maruti Suzuki India Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>MARUTI</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE585B01010</td>\n",
       "      <td>Maruti Suzuki India Limited</td>\n",
       "      <td>25048932.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>Mahindra &amp; Mahindra Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>M&amp;M</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE101A01026</td>\n",
       "      <td>Mahindra &amp; Mahindra Limited</td>\n",
       "      <td>14408769.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>Tata Motors Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>TATAMOTORS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE155A01022</td>\n",
       "      <td>Tata Motors Limited</td>\n",
       "      <td>13976217.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Bajaj Auto Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>BAJAJ-AUTO</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE917I01010</td>\n",
       "      <td>Bajaj Auto Limited</td>\n",
       "      <td>10992186.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>Eicher Motors Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>EICHERMOT</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE066A01021</td>\n",
       "      <td>Eicher Motors Limited</td>\n",
       "      <td>8064561.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Bosch Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>BOSCHLTD</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE323A01026</td>\n",
       "      <td>Bosch Limited</td>\n",
       "      <td>5712889.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>TVS Motor Company Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>TVSMOTOR</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE494B01023</td>\n",
       "      <td>TVS Motor Company Limited</td>\n",
       "      <td>5117638.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>Tube Investments of India Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>TIINDIA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE974X01010</td>\n",
       "      <td>Tube Investments of India Limited</td>\n",
       "      <td>4917996.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>Hero MotoCorp Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>HEROMOTOCO</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE158A01026</td>\n",
       "      <td>Hero MotoCorp Limited</td>\n",
       "      <td>4690938.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>Samvardhana Motherson International Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>MOTHERSON</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE775A01035</td>\n",
       "      <td>Samvardhana Motherson International Limited</td>\n",
       "      <td>4546979.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>Schaeffler India Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>SCHAEFFLER</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE513A01022</td>\n",
       "      <td>Schaeffler India Limited</td>\n",
       "      <td>4482086.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Balkrishna Industries Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>BALKRISIND</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE787D01026</td>\n",
       "      <td>Balkrishna Industries Limited</td>\n",
       "      <td>3772488.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>MRF Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>MRF</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE883A01011</td>\n",
       "      <td>MRF Limited</td>\n",
       "      <td>3564562.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>UNO Minda Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>UNOMINDA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE405E01023</td>\n",
       "      <td>UNO Minda Limited</td>\n",
       "      <td>2755450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>401</th>\n",
       "      <td>Sona BLW Precision Forgings Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>SONACOMS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE073K01018</td>\n",
       "      <td>Sona BLW Precision Forgings Limited</td>\n",
       "      <td>2420648.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>Motherson Sumi Wiring India Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>MSUMI</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE0FS801015</td>\n",
       "      <td>Motherson Sumi Wiring India Limited</td>\n",
       "      <td>2133185.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>Sundram Fasteners Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>SUNDRMFAST</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE387A01021</td>\n",
       "      <td>Sundram Fasteners Limited</td>\n",
       "      <td>2055055.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Apollo Tyres Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>APOLLOTYRE</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE438A01022</td>\n",
       "      <td>Apollo Tyres Limited</td>\n",
       "      <td>2031688.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>ZF Commercial Vehicle Control Systems India Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>ZFCVINDIA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE342J01019</td>\n",
       "      <td>ZF Commercial Vehicle Control Systems India Li...</td>\n",
       "      <td>1974307.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>Endurance Technologies Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>ENDURANCE</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE913H01037</td>\n",
       "      <td>Endurance Technologies Limited</td>\n",
       "      <td>1746540.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>Exide Industries Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>EXIDEIND</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE302A01020</td>\n",
       "      <td>Exide Industries Limited</td>\n",
       "      <td>1512575.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Asahi India Glass Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>ASAHIINDIA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE439A01020</td>\n",
       "      <td>Asahi India Glass Limited</td>\n",
       "      <td>1099131.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>JBM Auto Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>JBMA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE927D01044</td>\n",
       "      <td>JBM Auto Limited</td>\n",
       "      <td>761512.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Craftsman Automation Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>CRAFTSMAN</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE00LO01017</td>\n",
       "      <td>Craftsman Automation Limited</td>\n",
       "      <td>687790.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Ceat Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>CEATLTD</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE482A01020</td>\n",
       "      <td>CEAT Limited</td>\n",
       "      <td>586749.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>Minda Corporation Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>MINDACORP</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE842C01021</td>\n",
       "      <td>Minda Corporation Limited</td>\n",
       "      <td>514379.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>Olectra Greentech Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>OLECTRA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE260D01016</td>\n",
       "      <td>Olectra Greentech Limited</td>\n",
       "      <td>508285.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>Suprajit Engineering Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>SUPRAJIT</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE399C01030</td>\n",
       "      <td>Suprajit Engineering Limited</td>\n",
       "      <td>477178.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>Jamna Auto Industries Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>JAMNAAUTO</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE039C01032</td>\n",
       "      <td>Jamna Auto Industries Limited</td>\n",
       "      <td>397228.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>Varroc Engineering Ltd.</td>\n",
       "      <td>Automobile and Auto Components</td>\n",
       "      <td>VARROC</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE665L01035</td>\n",
       "      <td>Varroc Engineering Limited</td>\n",
       "      <td>380973.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Company Name_x  \\\n",
       "297                          Maruti Suzuki India Ltd.   \n",
       "291                          Mahindra & Mahindra Ltd.   \n",
       "433                                  Tata Motors Ltd.   \n",
       "49                                    Bajaj Auto Ltd.   \n",
       "136                                Eicher Motors Ltd.   \n",
       "76                                         Bosch Ltd.   \n",
       "425                            TVS Motor Company Ltd.   \n",
       "451                    Tube Investments of India Ltd.   \n",
       "195                                Hero MotoCorp Ltd.   \n",
       "386          Samvardhana Motherson International Ltd.   \n",
       "390                             Schaeffler India Ltd.   \n",
       "54                         Balkrishna Industries Ltd.   \n",
       "286                                          MRF Ltd.   \n",
       "453                                    UNO Minda Ltd.   \n",
       "401                  Sona BLW Precision Forgings Ltd.   \n",
       "306                  Motherson Sumi Wiring India Ltd.   \n",
       "413                            Sundram Fasteners Ltd.   \n",
       "33                                  Apollo Tyres Ltd.   \n",
       "479  ZF Commercial Vehicle Control Systems India Ltd.   \n",
       "139                       Endurance Technologies Ltd.   \n",
       "144                             Exide Industries Ltd.   \n",
       "36                             Asahi India Glass Ltd.   \n",
       "241                                     JBM Auto Ltd.   \n",
       "113                         Craftsman Automation Ltd.   \n",
       "92                                          Ceat Ltd.   \n",
       "305                            Minda Corporation Ltd.   \n",
       "328                            Olectra Greentech Ltd.   \n",
       "415                         Suprajit Engineering Ltd.   \n",
       "247                        Jamna Auto Industries Ltd.   \n",
       "467                           Varroc Engineering Ltd.   \n",
       "\n",
       "                           Industry      Symbol Series     ISIN Code  \\\n",
       "297  Automobile and Auto Components      MARUTI     EQ  INE585B01010   \n",
       "291  Automobile and Auto Components         M&M     EQ  INE101A01026   \n",
       "433  Automobile and Auto Components  TATAMOTORS     EQ  INE155A01022   \n",
       "49   Automobile and Auto Components  BAJAJ-AUTO     EQ  INE917I01010   \n",
       "136  Automobile and Auto Components   EICHERMOT     EQ  INE066A01021   \n",
       "76   Automobile and Auto Components    BOSCHLTD     EQ  INE323A01026   \n",
       "425  Automobile and Auto Components    TVSMOTOR     EQ  INE494B01023   \n",
       "451  Automobile and Auto Components     TIINDIA     EQ  INE974X01010   \n",
       "195  Automobile and Auto Components  HEROMOTOCO     EQ  INE158A01026   \n",
       "386  Automobile and Auto Components   MOTHERSON     EQ  INE775A01035   \n",
       "390  Automobile and Auto Components  SCHAEFFLER     EQ  INE513A01022   \n",
       "54   Automobile and Auto Components  BALKRISIND     EQ  INE787D01026   \n",
       "286  Automobile and Auto Components         MRF     EQ  INE883A01011   \n",
       "453  Automobile and Auto Components    UNOMINDA     EQ  INE405E01023   \n",
       "401  Automobile and Auto Components    SONACOMS     EQ  INE073K01018   \n",
       "306  Automobile and Auto Components       MSUMI     EQ  INE0FS801015   \n",
       "413  Automobile and Auto Components  SUNDRMFAST     EQ  INE387A01021   \n",
       "33   Automobile and Auto Components  APOLLOTYRE     EQ  INE438A01022   \n",
       "479  Automobile and Auto Components   ZFCVINDIA     EQ  INE342J01019   \n",
       "139  Automobile and Auto Components   ENDURANCE     EQ  INE913H01037   \n",
       "144  Automobile and Auto Components    EXIDEIND     EQ  INE302A01020   \n",
       "36   Automobile and Auto Components  ASAHIINDIA     EQ  INE439A01020   \n",
       "241  Automobile and Auto Components        JBMA     EQ  INE927D01044   \n",
       "113  Automobile and Auto Components   CRAFTSMAN     EQ  INE00LO01017   \n",
       "92   Automobile and Auto Components     CEATLTD     EQ  INE482A01020   \n",
       "305  Automobile and Auto Components   MINDACORP     EQ  INE842C01021   \n",
       "328  Automobile and Auto Components     OLECTRA     EQ  INE260D01016   \n",
       "415  Automobile and Auto Components    SUPRAJIT     EQ  INE399C01030   \n",
       "247  Automobile and Auto Components   JAMNAAUTO     EQ  INE039C01032   \n",
       "467  Automobile and Auto Components      VARROC     EQ  INE665L01035   \n",
       "\n",
       "                                        Company Name_y  Mcap_Mar23  \n",
       "297                        Maruti Suzuki India Limited  25048932.0  \n",
       "291                        Mahindra & Mahindra Limited  14408769.0  \n",
       "433                                Tata Motors Limited  13976217.0  \n",
       "49                                  Bajaj Auto Limited  10992186.0  \n",
       "136                              Eicher Motors Limited   8064561.0  \n",
       "76                                       Bosch Limited   5712889.0  \n",
       "425                          TVS Motor Company Limited   5117638.0  \n",
       "451                  Tube Investments of India Limited   4917996.0  \n",
       "195                              Hero MotoCorp Limited   4690938.0  \n",
       "386        Samvardhana Motherson International Limited   4546979.0  \n",
       "390                           Schaeffler India Limited   4482086.0  \n",
       "54                       Balkrishna Industries Limited   3772488.0  \n",
       "286                                        MRF Limited   3564562.0  \n",
       "453                                  UNO Minda Limited   2755450.0  \n",
       "401                Sona BLW Precision Forgings Limited   2420648.0  \n",
       "306                Motherson Sumi Wiring India Limited   2133185.0  \n",
       "413                          Sundram Fasteners Limited   2055055.0  \n",
       "33                                Apollo Tyres Limited   2031688.0  \n",
       "479  ZF Commercial Vehicle Control Systems India Li...   1974307.0  \n",
       "139                     Endurance Technologies Limited   1746540.0  \n",
       "144                           Exide Industries Limited   1512575.0  \n",
       "36                           Asahi India Glass Limited   1099131.0  \n",
       "241                                   JBM Auto Limited    761512.0  \n",
       "113                       Craftsman Automation Limited    687790.0  \n",
       "92                                        CEAT Limited    586749.0  \n",
       "305                          Minda Corporation Limited    514379.0  \n",
       "328                          Olectra Greentech Limited    508285.0  \n",
       "415                       Suprajit Engineering Limited    477178.0  \n",
       "247                      Jamna Auto Industries Limited    397228.0  \n",
       "467                         Varroc Engineering Limited    380973.0  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Autocomp.sort_values(by='Mcap_Mar23', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "6a786da4",
   "metadata": {},
   "outputs": [],
   "source": [
    " df_Financial=df[df['Industry']=='Financial Services']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "bed545c6",
   "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>Company Name_x</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Series</th>\n",
       "      <th>ISIN Code</th>\n",
       "      <th>Company Name_y</th>\n",
       "      <th>Mcap_Mar23</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>HDFC Bank Ltd.</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>HDFCBANK</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE040A01034</td>\n",
       "      <td>HDFC Bank Limited</td>\n",
       "      <td>89808750.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>ICICI Bank Ltd.</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>ICICIBANK</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE090A01021</td>\n",
       "      <td>ICICI Bank Limited</td>\n",
       "      <td>61248250.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>State Bank of India</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>SBIN</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE062A01020</td>\n",
       "      <td>State Bank of India</td>\n",
       "      <td>46742655.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>Kotak Mahindra Bank Ltd.</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>KOTAKBANK</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE237A01028</td>\n",
       "      <td>Kotak Mahindra Bank Limited</td>\n",
       "      <td>34423149.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Bajaj Finance Ltd.</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>BAJFINANCE</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE296A01024</td>\n",
       "      <td>Bajaj Finance Limited</td>\n",
       "      <td>34005446.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>Ujjivan Small Finance Bank Ltd.</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>UJJIVANSFB</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE551W01018</td>\n",
       "      <td>Ujjivan Small Finance Bank Limited</td>\n",
       "      <td>493535.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>Kfin Technologies Ltd.</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>KFINTECH</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE138Y01010</td>\n",
       "      <td>Kfin Technologies Limited</td>\n",
       "      <td>474263.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>Indiabulls Housing Finance Ltd.</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>IBULHSGFIN</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE148I01020</td>\n",
       "      <td>Indiabulls Housing Finance Limited</td>\n",
       "      <td>459099.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>CSB Bank Ltd.</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>CSBBANK</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE679A01013</td>\n",
       "      <td>CSB Bank Limited</td>\n",
       "      <td>425214.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>Infibeam Avenues Ltd.</td>\n",
       "      <td>Financial Services</td>\n",
       "      <td>INFIBEAM</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE483S01020</td>\n",
       "      <td>Infibeam Avenues Limited</td>\n",
       "      <td>378906.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>86 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Company Name_x            Industry      Symbol Series  \\\n",
       "189                   HDFC Bank Ltd.  Financial Services    HDFCBANK     EQ   \n",
       "206                  ICICI Bank Ltd.  Financial Services   ICICIBANK     EQ   \n",
       "404              State Bank of India  Financial Services        SBIN     EQ   \n",
       "269         Kotak Mahindra Bank Ltd.  Financial Services   KOTAKBANK     EQ   \n",
       "50                Bajaj Finance Ltd.  Financial Services  BAJFINANCE     EQ   \n",
       "..                               ...                 ...         ...    ...   \n",
       "456  Ujjivan Small Finance Bank Ltd.  Financial Services  UJJIVANSFB     EQ   \n",
       "268           Kfin Technologies Ltd.  Financial Services    KFINTECH     EQ   \n",
       "219  Indiabulls Housing Finance Ltd.  Financial Services  IBULHSGFIN     EQ   \n",
       "85                     CSB Bank Ltd.  Financial Services     CSBBANK     EQ   \n",
       "232            Infibeam Avenues Ltd.  Financial Services    INFIBEAM     EQ   \n",
       "\n",
       "        ISIN Code                      Company Name_y  Mcap_Mar23  \n",
       "189  INE040A01034                   HDFC Bank Limited  89808750.0  \n",
       "206  INE090A01021                  ICICI Bank Limited  61248250.0  \n",
       "404  INE062A01020                 State Bank of India  46742655.0  \n",
       "269  INE237A01028         Kotak Mahindra Bank Limited  34423149.0  \n",
       "50   INE296A01024               Bajaj Finance Limited  34005446.0  \n",
       "..            ...                                 ...         ...  \n",
       "456  INE551W01018  Ujjivan Small Finance Bank Limited    493535.0  \n",
       "268  INE138Y01010           Kfin Technologies Limited    474263.0  \n",
       "219  INE148I01020  Indiabulls Housing Finance Limited    459099.0  \n",
       "85   INE679A01013                    CSB Bank Limited    425214.0  \n",
       "232  INE483S01020            Infibeam Avenues Limited    378906.0  \n",
       "\n",
       "[86 rows x 7 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Financial.sort_values(by='Mcap_Mar23', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "0da46e58",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_Healthcare=df[df['Industry']=='Healthcare']\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "e09ca8db",
   "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>Company Name_x</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Series</th>\n",
       "      <th>ISIN Code</th>\n",
       "      <th>Company Name_y</th>\n",
       "      <th>Mcap_Mar23</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>Sun Pharmaceutical Industries Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>SUNPHARMA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE044A01036</td>\n",
       "      <td>Sun Pharmaceutical Industries Limited</td>\n",
       "      <td>23587862.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>Dr. Reddy's Laboratories Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>DRREDDY</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE089A01023</td>\n",
       "      <td>Dr. Reddy's Laboratories Limited</td>\n",
       "      <td>7698120.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>Divi's Laboratories Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>DIVISLAB</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE361B01024</td>\n",
       "      <td>Divi's Laboratories Limited</td>\n",
       "      <td>7495107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>Cipla Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>CIPLA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE059A01026</td>\n",
       "      <td>Cipla Limited</td>\n",
       "      <td>7268331.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Apollo Hospitals Enterprise Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>APOLLOHOSP</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE437A01024</td>\n",
       "      <td>Apollo Hospitals Enterprise Limited</td>\n",
       "      <td>6198413.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>Torrent Pharmaceuticals Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>TORNTPHARM</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE685A01028</td>\n",
       "      <td>Torrent Pharmaceuticals Limited</td>\n",
       "      <td>5202414.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>Zydus Lifesciences Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>ZYDUSLIFE</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE010B01027</td>\n",
       "      <td>Zydus Lifesciences Limited</td>\n",
       "      <td>4975489.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>Max Healthcare Institute Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>MAXHEALTH</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE027H01010</td>\n",
       "      <td>Max Healthcare Institute Limited</td>\n",
       "      <td>4282467.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Alkem Laboratories Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>ALKEM</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE540L01014</td>\n",
       "      <td>Alkem Laboratories Limited</td>\n",
       "      <td>4060547.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Aurobindo Pharma Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>AUROPHARMA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE406A01037</td>\n",
       "      <td>Aurobindo Pharma Limited</td>\n",
       "      <td>3035748.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>Lupin Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>LUPIN</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE326A01037</td>\n",
       "      <td>Lupin Limited</td>\n",
       "      <td>2950099.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Biocon Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>BIOCON</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE376G01013</td>\n",
       "      <td>Biocon Limited</td>\n",
       "      <td>2477438.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>Syngene International Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>SYNGENE</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE398R01022</td>\n",
       "      <td>Syngene International Limited</td>\n",
       "      <td>2386528.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>Glaxosmithkline Pharmaceuticals Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>GLAXO</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE159A01016</td>\n",
       "      <td>GlaxoSmithKline Pharmaceuticals Limited</td>\n",
       "      <td>2244206.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>Gland Pharma Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>GLAND</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE068V01023</td>\n",
       "      <td>Gland Pharma Limited</td>\n",
       "      <td>2088684.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>Ipca Laboratories Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>IPCALAB</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE571A01038</td>\n",
       "      <td>IPCA Laboratories Limited</td>\n",
       "      <td>2055892.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>Fortis Healthcare Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>FORTIS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE061F01013</td>\n",
       "      <td>Fortis Healthcare Limited</td>\n",
       "      <td>1962136.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>Pfizer Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>PFIZER</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE182A01018</td>\n",
       "      <td>Pfizer Limited</td>\n",
       "      <td>1586142.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>Narayana Hrudayalaya Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>NH</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE410P01011</td>\n",
       "      <td>Narayana Hrudayalaya Ltd.</td>\n",
       "      <td>1582059.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>Laurus Labs Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>LAURUSLABS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE947Q01028</td>\n",
       "      <td>Laurus Labs Limited</td>\n",
       "      <td>1577978.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Ajanta Pharmaceuticals Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>AJANTPHARM</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE031B01049</td>\n",
       "      <td>Ajanta Pharma Limited</td>\n",
       "      <td>1548777.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>J.B. Chemicals &amp; Pharmaceuticals Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>JBCHEPHARM</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE572A01036</td>\n",
       "      <td>JB Chemicals &amp; Pharmaceuticals Limited</td>\n",
       "      <td>1529252.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>Dr. Lal Path Labs Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>LALPATHLAB</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE600L01024</td>\n",
       "      <td>Dr. Lal Path Labs Ltd.</td>\n",
       "      <td>1524048.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>Global Health Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>MEDANTA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE474Q01031</td>\n",
       "      <td>Global Health Limited</td>\n",
       "      <td>1413200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>Sanofi India Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>SANOFI</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE058A01010</td>\n",
       "      <td>Sanofi India Limited</td>\n",
       "      <td>1320898.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>Glenmark Pharmaceuticals Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>GLENMARK</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE935A01035</td>\n",
       "      <td>Glenmark Pharmaceuticals Limited</td>\n",
       "      <td>1311235.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>Suven Pharmaceuticals Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>SUVENPHAR</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE03QK01018</td>\n",
       "      <td>Suven Pharmaceuticals Limited</td>\n",
       "      <td>1202565.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Aster DM Healthcare Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>ASTERDM</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE914M01019</td>\n",
       "      <td>Aster DM Healthcare Limited</td>\n",
       "      <td>1202328.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>Krishna Institute of Medical Sciences Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>KIMS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE967H01017</td>\n",
       "      <td>Krishna Institute of Medical Sciences Limited</td>\n",
       "      <td>1121549.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>NATCO Pharma Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>NATCOPHARM</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE987B01026</td>\n",
       "      <td>Natco Pharma Limited</td>\n",
       "      <td>1028436.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Alembic Pharmaceuticals Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>APLLTD</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE901L01018</td>\n",
       "      <td>Alembic Pharmaceuticals Limited</td>\n",
       "      <td>975641.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>Poly Medicure Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>POLYMED</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE205C01021</td>\n",
       "      <td>Poly Medicure Limited</td>\n",
       "      <td>914014.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>Piramal Pharma Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>PPLPHARMA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE0DK501011</td>\n",
       "      <td>Piramal Pharma Limited</td>\n",
       "      <td>816827.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>Eris Lifesciences Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>ERIS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE406M01024</td>\n",
       "      <td>Eris Lifesciences Limited</td>\n",
       "      <td>778012.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>Procter &amp; Gamble Health Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>PGHL</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE199A01012</td>\n",
       "      <td>Procter &amp; Gamble Health Limited</td>\n",
       "      <td>777855.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <td>Rainbow Childrens Medicare Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>RAINBOW</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE961O01016</td>\n",
       "      <td>Rainbow Childrens Medicare Limited</td>\n",
       "      <td>741470.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>Granules India Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>GRANULES</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE101D01020</td>\n",
       "      <td>Granules India Limited</td>\n",
       "      <td>703618.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>Metropolis Healthcare Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>METROPOLIS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE112L01020</td>\n",
       "      <td>Metropolis Healthcare Limited</td>\n",
       "      <td>639263.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>Sun Pharma Advanced Research Company Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>SPARC</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE232I01014</td>\n",
       "      <td>Sun Pharma Advanced Research Company Limited</td>\n",
       "      <td>581990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>Glenmark Life Sciences Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>GLS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE03Q201024</td>\n",
       "      <td>Glenmark Life Sciences Limited</td>\n",
       "      <td>481409.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>Jubilant Pharmova Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>JUBLPHARMA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE700A01033</td>\n",
       "      <td>Jubilant Pharmova Limited</td>\n",
       "      <td>444155.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>FDC Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>FDC</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE258B01022</td>\n",
       "      <td>FDC Limited</td>\n",
       "      <td>425228.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>Vijaya Diagnostic Centre Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>VIJAYA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE043W01024</td>\n",
       "      <td>Vijaya Diagnostic Centre Limited</td>\n",
       "      <td>399405.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Aarti Drugs Ltd.</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>AARTIDRUGS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE767A01016</td>\n",
       "      <td>Aarti Drugs Limited</td>\n",
       "      <td>312757.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Company Name_x    Industry      Symbol  \\\n",
       "410          Sun Pharmaceutical Industries Ltd.  Healthcare   SUNPHARMA   \n",
       "131               Dr. Reddy's Laboratories Ltd.  Healthcare     DRREDDY   \n",
       "128                    Divi's Laboratories Ltd.  Healthcare    DIVISLAB   \n",
       "103                                  Cipla Ltd.  Healthcare       CIPLA   \n",
       "32             Apollo Hospitals Enterprise Ltd.  Healthcare  APOLLOHOSP   \n",
       "445                Torrent Pharmaceuticals Ltd.  Healthcare  TORNTPHARM   \n",
       "483                     Zydus Lifesciences Ltd.  Healthcare   ZYDUSLIFE   \n",
       "300               Max Healthcare Institute Ltd.  Healthcare   MAXHEALTH   \n",
       "23                      Alkem Laboratories Ltd.  Healthcare       ALKEM   \n",
       "42                        Aurobindo Pharma Ltd.  Healthcare  AUROPHARMA   \n",
       "283                                  Lupin Ltd.  Healthcare       LUPIN   \n",
       "69                                  Biocon Ltd.  Healthcare      BIOCON   \n",
       "421                  Syngene International Ltd.  Healthcare     SYNGENE   \n",
       "163        Glaxosmithkline Pharmaceuticals Ltd.  Healthcare       GLAXO   \n",
       "162                           Gland Pharma Ltd.  Healthcare       GLAND   \n",
       "238                      Ipca Laboratories Ltd.  Healthcare     IPCALAB   \n",
       "154                      Fortis Healthcare Ltd.  Healthcare      FORTIS   \n",
       "341                                 Pfizer Ltd.  Healthcare      PFIZER   \n",
       "318                   Narayana Hrudayalaya Ltd.  Healthcare          NH   \n",
       "278                            Laurus Labs Ltd.  Healthcare  LAURUSLABS   \n",
       "21                  Ajanta Pharmaceuticals Ltd.  Healthcare  AJANTPHARM   \n",
       "239       J.B. Chemicals & Pharmaceuticals Ltd.  Healthcare  JBCHEPHARM   \n",
       "130                      Dr. Lal Path Labs Ltd.  Healthcare  LALPATHLAB   \n",
       "166                          Global Health Ltd.  Healthcare     MEDANTA   \n",
       "387                           Sanofi India Ltd.  Healthcare      SANOFI   \n",
       "165               Glenmark Pharmaceuticals Ltd.  Healthcare    GLENMARK   \n",
       "417                  Suven Pharmaceuticals Ltd.  Healthcare   SUVENPHAR   \n",
       "39                     Aster DM Healthcare Ltd.  Healthcare     ASTERDM   \n",
       "270  Krishna Institute of Medical Sciences Ltd.  Healthcare        KIMS   \n",
       "310                           NATCO Pharma Ltd.  Healthcare  NATCOPHARM   \n",
       "22                 Alembic Pharmaceuticals Ltd.  Healthcare      APLLTD   \n",
       "346                          Poly Medicure Ltd.  Healthcare     POLYMED   \n",
       "345                         Piramal Pharma Ltd.  Healthcare   PPLPHARMA   \n",
       "142                      Eris Lifesciences Ltd.  Healthcare        ERIS   \n",
       "356                Procter & Gamble Health Ltd.  Healthcare        PGHL   \n",
       "367             Rainbow Childrens Medicare Ltd.  Healthcare     RAINBOW   \n",
       "173                         Granules India Ltd.  Healthcare    GRANULES   \n",
       "304                  Metropolis Healthcare Ltd.  Healthcare  METROPOLIS   \n",
       "409   Sun Pharma Advanced Research Company Ltd.  Healthcare       SPARC   \n",
       "164                 Glenmark Life Sciences Ltd.  Healthcare         GLS   \n",
       "253                      Jubilant Pharmova Ltd.  Healthcare  JUBLPHARMA   \n",
       "145                                    FDC Ltd.  Healthcare         FDC   \n",
       "471               Vijaya Diagnostic Centre Ltd.  Healthcare      VIJAYA   \n",
       "7                              Aarti Drugs Ltd.  Healthcare  AARTIDRUGS   \n",
       "\n",
       "    Series     ISIN Code                                 Company Name_y  \\\n",
       "410     EQ  INE044A01036          Sun Pharmaceutical Industries Limited   \n",
       "131     EQ  INE089A01023               Dr. Reddy's Laboratories Limited   \n",
       "128     EQ  INE361B01024                    Divi's Laboratories Limited   \n",
       "103     EQ  INE059A01026                                  Cipla Limited   \n",
       "32      EQ  INE437A01024            Apollo Hospitals Enterprise Limited   \n",
       "445     EQ  INE685A01028                Torrent Pharmaceuticals Limited   \n",
       "483     EQ  INE010B01027                     Zydus Lifesciences Limited   \n",
       "300     EQ  INE027H01010               Max Healthcare Institute Limited   \n",
       "23      EQ  INE540L01014                     Alkem Laboratories Limited   \n",
       "42      EQ  INE406A01037                       Aurobindo Pharma Limited   \n",
       "283     EQ  INE326A01037                                  Lupin Limited   \n",
       "69      EQ  INE376G01013                                 Biocon Limited   \n",
       "421     EQ  INE398R01022                  Syngene International Limited   \n",
       "163     EQ  INE159A01016        GlaxoSmithKline Pharmaceuticals Limited   \n",
       "162     EQ  INE068V01023                           Gland Pharma Limited   \n",
       "238     EQ  INE571A01038                      IPCA Laboratories Limited   \n",
       "154     EQ  INE061F01013                      Fortis Healthcare Limited   \n",
       "341     EQ  INE182A01018                                 Pfizer Limited   \n",
       "318     EQ  INE410P01011                      Narayana Hrudayalaya Ltd.   \n",
       "278     EQ  INE947Q01028                            Laurus Labs Limited   \n",
       "21      EQ  INE031B01049                          Ajanta Pharma Limited   \n",
       "239     EQ  INE572A01036         JB Chemicals & Pharmaceuticals Limited   \n",
       "130     EQ  INE600L01024                         Dr. Lal Path Labs Ltd.   \n",
       "166     EQ  INE474Q01031                          Global Health Limited   \n",
       "387     EQ  INE058A01010                           Sanofi India Limited   \n",
       "165     EQ  INE935A01035               Glenmark Pharmaceuticals Limited   \n",
       "417     EQ  INE03QK01018                  Suven Pharmaceuticals Limited   \n",
       "39      EQ  INE914M01019                    Aster DM Healthcare Limited   \n",
       "270     EQ  INE967H01017  Krishna Institute of Medical Sciences Limited   \n",
       "310     EQ  INE987B01026                           Natco Pharma Limited   \n",
       "22      EQ  INE901L01018                Alembic Pharmaceuticals Limited   \n",
       "346     EQ  INE205C01021                          Poly Medicure Limited   \n",
       "345     EQ  INE0DK501011                         Piramal Pharma Limited   \n",
       "142     EQ  INE406M01024                      Eris Lifesciences Limited   \n",
       "356     EQ  INE199A01012                Procter & Gamble Health Limited   \n",
       "367     EQ  INE961O01016             Rainbow Childrens Medicare Limited   \n",
       "173     EQ  INE101D01020                         Granules India Limited   \n",
       "304     EQ  INE112L01020                  Metropolis Healthcare Limited   \n",
       "409     EQ  INE232I01014   Sun Pharma Advanced Research Company Limited   \n",
       "164     EQ  INE03Q201024                 Glenmark Life Sciences Limited   \n",
       "253     EQ  INE700A01033                      Jubilant Pharmova Limited   \n",
       "145     EQ  INE258B01022                                    FDC Limited   \n",
       "471     EQ  INE043W01024               Vijaya Diagnostic Centre Limited   \n",
       "7       EQ  INE767A01016                            Aarti Drugs Limited   \n",
       "\n",
       "     Mcap_Mar23  \n",
       "410  23587862.0  \n",
       "131   7698120.0  \n",
       "128   7495107.0  \n",
       "103   7268331.0  \n",
       "32    6198413.0  \n",
       "445   5202414.0  \n",
       "483   4975489.0  \n",
       "300   4282467.0  \n",
       "23    4060547.0  \n",
       "42    3035748.0  \n",
       "283   2950099.0  \n",
       "69    2477438.0  \n",
       "421   2386528.0  \n",
       "163   2244206.0  \n",
       "162   2088684.0  \n",
       "238   2055892.0  \n",
       "154   1962136.0  \n",
       "341   1586142.0  \n",
       "318   1582059.0  \n",
       "278   1577978.0  \n",
       "21    1548777.0  \n",
       "239   1529252.0  \n",
       "130   1524048.0  \n",
       "166   1413200.0  \n",
       "387   1320898.0  \n",
       "165   1311235.0  \n",
       "417   1202565.0  \n",
       "39    1202328.0  \n",
       "270   1121549.0  \n",
       "310   1028436.0  \n",
       "22     975641.0  \n",
       "346    914014.0  \n",
       "345    816827.0  \n",
       "142    778012.0  \n",
       "356    777855.0  \n",
       "367    741470.0  \n",
       "173    703618.0  \n",
       "304    639263.0  \n",
       "409    581990.0  \n",
       "164    481409.0  \n",
       "253    444155.0  \n",
       "145    425228.0  \n",
       "471    399405.0  \n",
       "7      312757.0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Healthcare=df_Healthcare.sort_values(by='Mcap_Mar23',ascending=False)\n",
    "df_Healthcare"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "ed4b2816",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_Services=df[df['Industry']=='Services']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "7b64b6cb",
   "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>Company Name_x</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Series</th>\n",
       "      <th>ISIN Code</th>\n",
       "      <th>Company Name_y</th>\n",
       "      <th>Mcap_Mar23</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Adani Ports and Special Economic Zone Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>ADANIPORTS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE742F01042</td>\n",
       "      <td>Adani Ports and Special Economic Zone Limited</td>\n",
       "      <td>13649918.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Allcargo Logistics Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>ALLCARGO</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE418H01029</td>\n",
       "      <td>Allcargo Logistics Limited</td>\n",
       "      <td>873816.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Blue Dart Express Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>BLUEDART</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE233B01017</td>\n",
       "      <td>Blue Dart Express Limited</td>\n",
       "      <td>1474205.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Container Corporation of India Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>CONCOR</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE111A01025</td>\n",
       "      <td>Container Corporation of India Limited</td>\n",
       "      <td>3535430.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>Delhivery Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>DELHIVERY</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE148O01028</td>\n",
       "      <td>Delhivery Limited</td>\n",
       "      <td>2416784.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>Firstsource Solutions Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>FSL</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE684F01012</td>\n",
       "      <td>Firstsource Solutions Limited</td>\n",
       "      <td>735325.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>GMR Airports Infrastructure Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>GMRINFRA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE776C01039</td>\n",
       "      <td>GMR Airports Infrastructure Limited</td>\n",
       "      <td>2447576.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>Great Eastern Shipping Co. Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>GESHIP</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE017A01032</td>\n",
       "      <td>The Great Eastern Shipping Company Limited</td>\n",
       "      <td>920206.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Gujarat Pipavav Port Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>GPPL</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE517F01014</td>\n",
       "      <td>Gujarat Pipavav Port Limited</td>\n",
       "      <td>562966.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>InterGlobe Aviation Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>INDIGO</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE646L01027</td>\n",
       "      <td>InterGlobe Aviation Limited</td>\n",
       "      <td>7366456.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>MMTC Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>MMTC</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE123F01029</td>\n",
       "      <td>MMTC Limited</td>\n",
       "      <td>418500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>Quess Corp Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>QUESS</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE615P01015</td>\n",
       "      <td>Quess Corp Limited</td>\n",
       "      <td>547804.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>RattanIndia Enterprises Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>RTNINDIA</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE834M01019</td>\n",
       "      <td>RattanIndia Enterprises Limited</td>\n",
       "      <td>485868.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>Redington Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>REDINGTON</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE891D01026</td>\n",
       "      <td>Redington Limited</td>\n",
       "      <td>1302471.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>Teamlease Services Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>TEAMLEASE</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE985S01024</td>\n",
       "      <td>Teamlease Services Limited</td>\n",
       "      <td>382874.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>eClerx Services Ltd.</td>\n",
       "      <td>Services</td>\n",
       "      <td>ECLERX</td>\n",
       "      <td>EQ</td>\n",
       "      <td>INE738I01010</td>\n",
       "      <td>eClerx Services Limited</td>\n",
       "      <td>632623.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 Company Name_x  Industry      Symbol Series  \\\n",
       "12   Adani Ports and Special Economic Zone Ltd.  Services  ADANIPORTS     EQ   \n",
       "25                      Allcargo Logistics Ltd.  Services    ALLCARGO     EQ   \n",
       "72                       Blue Dart Express Ltd.  Services    BLUEDART     EQ   \n",
       "111         Container Corporation of India Ltd.  Services      CONCOR     EQ   \n",
       "125                              Delhivery Ltd.  Services   DELHIVERY     EQ   \n",
       "152                  Firstsource Solutions Ltd.  Services         FSL     EQ   \n",
       "158            GMR Airports Infrastructure Ltd.  Services    GMRINFRA     EQ   \n",
       "176             Great Eastern Shipping Co. Ltd.  Services      GESHIP     EQ   \n",
       "183                   Gujarat Pipavav Port Ltd.  Services        GPPL     EQ   \n",
       "237                    InterGlobe Aviation Ltd.  Services      INDIGO     EQ   \n",
       "285                                   MMTC Ltd.  Services        MMTC     EQ   \n",
       "359                             Quess Corp Ltd.  Services       QUESS     EQ   \n",
       "372                RattanIndia Enterprises Ltd.  Services    RTNINDIA     EQ   \n",
       "374                              Redington Ltd.  Services   REDINGTON     EQ   \n",
       "437                     Teamlease Services Ltd.  Services   TEAMLEASE     EQ   \n",
       "485                        eClerx Services Ltd.  Services      ECLERX     EQ   \n",
       "\n",
       "        ISIN Code                                 Company Name_y  Mcap_Mar23  \n",
       "12   INE742F01042  Adani Ports and Special Economic Zone Limited  13649918.0  \n",
       "25   INE418H01029                     Allcargo Logistics Limited    873816.0  \n",
       "72   INE233B01017                      Blue Dart Express Limited   1474205.0  \n",
       "111  INE111A01025         Container Corporation of India Limited   3535430.0  \n",
       "125  INE148O01028                              Delhivery Limited   2416784.0  \n",
       "152  INE684F01012                  Firstsource Solutions Limited    735325.0  \n",
       "158  INE776C01039            GMR Airports Infrastructure Limited   2447576.0  \n",
       "176  INE017A01032     The Great Eastern Shipping Company Limited    920206.0  \n",
       "183  INE517F01014                   Gujarat Pipavav Port Limited    562966.0  \n",
       "237  INE646L01027                    InterGlobe Aviation Limited   7366456.0  \n",
       "285  INE123F01029                                   MMTC Limited    418500.0  \n",
       "359  INE615P01015                             Quess Corp Limited    547804.0  \n",
       "372  INE834M01019                RattanIndia Enterprises Limited    485868.0  \n",
       "374  INE891D01026                              Redington Limited   1302471.0  \n",
       "437  INE985S01024                     Teamlease Services Limited    382874.0  \n",
       "485  INE738I01010                        eClerx Services Limited    632623.0  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Services"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "b17fc694",
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'DataFrame' object has no attribute 'sort'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "Input \u001b[1;32mIn [15]\u001b[0m, in \u001b[0;36m<cell line: 1>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[0m \u001b[43mdf\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43msort\u001b[49m\n",
      "File \u001b[1;32m~\\.conda\\lib\\site-packages\\pandas\\core\\generic.py:5575\u001b[0m, in \u001b[0;36mNDFrame.__getattr__\u001b[1;34m(self, name)\u001b[0m\n\u001b[0;32m   5568\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m (\n\u001b[0;32m   5569\u001b[0m     name \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_internal_names_set\n\u001b[0;32m   5570\u001b[0m     \u001b[38;5;129;01mand\u001b[39;00m name \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_metadata\n\u001b[0;32m   5571\u001b[0m     \u001b[38;5;129;01mand\u001b[39;00m name \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_accessors\n\u001b[0;32m   5572\u001b[0m     \u001b[38;5;129;01mand\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_info_axis\u001b[38;5;241m.\u001b[39m_can_hold_identifiers_and_holds_name(name)\n\u001b[0;32m   5573\u001b[0m ):\n\u001b[0;32m   5574\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m[name]\n\u001b[1;32m-> 5575\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mobject\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[38;5;21;43m__getattribute__\u001b[39;49m\u001b[43m(\u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mname\u001b[49m\u001b[43m)\u001b[49m\n",
      "\u001b[1;31mAttributeError\u001b[0m: 'DataFrame' object has no attribute 'sort'"
     ]
    }
   ],
   "source": [
    "df.sort"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "751e596a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}