AMFI_MF_NAV_Complete.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b4dc2c33",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from mftool import Mftool\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "from IPython.display import clear_output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "a89b9278",
   "metadata": {},
   "outputs": [],
   "source": [
    "mf = Mftool()\n",
    "\n",
    "# Get scheme codes\n",
    "scheme_codes = mf.get_scheme_codes()\n",
    "scheme_code_list_main = [x for x in scheme_codes.keys()]\n",
    "\n",
    "# Query scheme codes for mid, small and flexi cap\n",
    "scheme_code_list = [k for k, v in scheme_codes.items() if 'mid' in v.lower()]\n",
    "scheme_code_list = scheme_code_list+[k for k, v in scheme_codes.items() if 'flexi' in v.lower()]\n",
    "scheme_code_list = scheme_code_list+[k for k, v in scheme_codes.items() if 'small' in v.lower()]\n",
    "\n",
    "\n",
    "# Comment the queries and uncomment this line to get all the schemes\n",
    "# scheme_code_list = scheme_code_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "df16836e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "690"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(scheme_code_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "id": "836557d9",
   "metadata": {},
   "outputs": [],
   "source": [
    "def HistoricalNav(scheme_code_list, start_date, end_date):\n",
    "    count = 0\n",
    "    main_df = pd.DataFrame()\n",
    "    for schemes in scheme_code_list:\n",
    "        count=count+1\n",
    "#         print('='*25)\n",
    "#         print(schemes)\n",
    "        data = mf.get_scheme_historical_nav_for_dates(schemes, start_date, end_date) # requesting NAV data from the api.\n",
    "        df = pd.DataFrame(data['data']) \n",
    "        df['scheme_code'] = pd.Series([data['scheme_code'] for x in range(len(df.index))]) #adding Pandas Series(scheme_code) as a column in Pandas Dataframe.\n",
    "        df['scheme_name'] = pd.Series([data['scheme_name'] for x in range(len(df.index))]) #adding Pandas Series(scheme_name) as a column in Pandas Dataframe.\n",
    "        try:\n",
    "            df = df.sort_values(by = 'date')\n",
    "            main_df = main_df.append(df)\n",
    "#             print(\"Data Fetched!\")\n",
    "        except:\n",
    "            print('Data doesnt exist of selected date.')\n",
    "#         print('='*25)\n",
    "        print(str((count/len(scheme_code_list))*100)+'%')\n",
    "        clear_output(wait=True)\n",
    "\n",
    "    main_df = main_df[['scheme_code', 'scheme_name', 'date', 'nav']] #creating names of dataframe columns \n",
    "    main_df.reset_index(drop = True, inplace = True) \n",
    "    return main_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "id": "a32a36df",
   "metadata": {},
   "outputs": [],
   "source": [
    "def NAV_Data(start,end): \n",
    "    try:\n",
    "        values_df = HistoricalNav(scheme_code_list = scheme_code_list[0:], start_date= start, end_date= end) #to get the data\n",
    "        return values_df\n",
    "    except KeyError:\n",
    "        start=datetime.strptime(start, '%d-%m-%Y') - timedelta(1)\n",
    "        return NAV_Data(start.strftime(\"%d-%m-%Y\"),end)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "id": "7fa4f8da",
   "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>scheme_code</th>\n",
       "      <th>scheme_name</th>\n",
       "      <th>date</th>\n",
       "      <th>nav</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>01-02-2023</td>\n",
       "      <td>20.18000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>01-03-2023</td>\n",
       "      <td>20.04000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>02-01-2023</td>\n",
       "      <td>20.92000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>02-02-2023</td>\n",
       "      <td>20.20000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>02-03-2023</td>\n",
       "      <td>19.95000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38029</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>28-03-2023</td>\n",
       "      <td>21.94490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38030</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>29-03-2023</td>\n",
       "      <td>22.24770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38031</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>30-01-2023</td>\n",
       "      <td>21.98370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38032</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>31-01-2023</td>\n",
       "      <td>22.34730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38033</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>31-03-2023</td>\n",
       "      <td>22.45020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>38034 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       scheme_code                                        scheme_name  \\\n",
       "0           110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "1           110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "2           110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "3           110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "4           110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "...            ...                                                ...   \n",
       "38029       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "38030       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "38031       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "38032       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "38033       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "\n",
       "             date       nav  \n",
       "0      01-02-2023  20.18000  \n",
       "1      01-03-2023  20.04000  \n",
       "2      02-01-2023  20.92000  \n",
       "3      02-02-2023  20.20000  \n",
       "4      02-03-2023  19.95000  \n",
       "...           ...       ...  \n",
       "38029  28-03-2023  21.94490  \n",
       "38030  29-03-2023  22.24770  \n",
       "38031  30-01-2023  21.98370  \n",
       "38032  31-01-2023  22.34730  \n",
       "38033  31-03-2023  22.45020  \n",
       "\n",
       "[38034 rows x 4 columns]"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "start_date= \"01-01-2023\"\n",
    "end_date = \"08-04-2023\"\n",
    "values_df = NAV_Data(start_date,end_date)\n",
    "values_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "id": "c0640b83",
   "metadata": {},
   "outputs": [],
   "source": [
    "# add datetime, sort and drop duplicates\n",
    "values_df['datetime'] = pd.to_datetime(values_df['date'], format='%d-%m-%Y')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "id": "94ad9e15",
   "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>scheme_code</th>\n",
       "      <th>scheme_name</th>\n",
       "      <th>date</th>\n",
       "      <th>nav</th>\n",
       "      <th>datetime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>01-02-2023</td>\n",
       "      <td>20.18000</td>\n",
       "      <td>2023-02-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>01-03-2023</td>\n",
       "      <td>20.04000</td>\n",
       "      <td>2023-03-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>02-01-2023</td>\n",
       "      <td>20.92000</td>\n",
       "      <td>2023-01-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>02-02-2023</td>\n",
       "      <td>20.20000</td>\n",
       "      <td>2023-02-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>02-03-2023</td>\n",
       "      <td>19.95000</td>\n",
       "      <td>2023-03-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38029</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>28-03-2023</td>\n",
       "      <td>21.94490</td>\n",
       "      <td>2023-03-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38030</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>29-03-2023</td>\n",
       "      <td>22.24770</td>\n",
       "      <td>2023-03-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38031</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>30-01-2023</td>\n",
       "      <td>21.98370</td>\n",
       "      <td>2023-01-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38032</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>31-01-2023</td>\n",
       "      <td>22.34730</td>\n",
       "      <td>2023-01-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38033</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>31-03-2023</td>\n",
       "      <td>22.45020</td>\n",
       "      <td>2023-03-31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>38034 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       scheme_code                                        scheme_name  \\\n",
       "0           110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "1           110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "2           110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "3           110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "4           110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "...            ...                                                ...   \n",
       "38029       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "38030       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "38031       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "38032       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "38033       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "\n",
       "             date       nav   datetime  \n",
       "0      01-02-2023  20.18000 2023-02-01  \n",
       "1      01-03-2023  20.04000 2023-03-01  \n",
       "2      02-01-2023  20.92000 2023-01-02  \n",
       "3      02-02-2023  20.20000 2023-02-02  \n",
       "4      02-03-2023  19.95000 2023-03-02  \n",
       "...           ...       ...        ...  \n",
       "38029  28-03-2023  21.94490 2023-03-28  \n",
       "38030  29-03-2023  22.24770 2023-03-29  \n",
       "38031  30-01-2023  21.98370 2023-01-30  \n",
       "38032  31-01-2023  22.34730 2023-01-31  \n",
       "38033  31-03-2023  22.45020 2023-03-31  \n",
       "\n",
       "[38034 rows x 5 columns]"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "values_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "id": "0bc711bb",
   "metadata": {},
   "outputs": [],
   "source": [
    "# get unique scheme names\n",
    "schemes = values_df['scheme_name'].explode().unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "id": "29b95ce5",
   "metadata": {},
   "outputs": [],
   "source": [
    "# keep only latest records.. skip this cell if you want to keep all the records\n",
    "final_df = pd.DataFrame()\n",
    "for scheme in schemes:\n",
    "    chunk_df = temp[temp['scheme_name']==scheme]\n",
    "    chunk_df = chunk_df.sort_values(by='datetime')    \n",
    "    final_df =final_df.append(chunk_df.iloc[-1], ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "id": "08321fbe",
   "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>scheme_code</th>\n",
       "      <th>scheme_name</th>\n",
       "      <th>date</th>\n",
       "      <th>nav</th>\n",
       "      <th>datetime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>110598</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap  Equity Fund Reg...</td>\n",
       "      <td>06-04-2023</td>\n",
       "      <td>20.14000</td>\n",
       "      <td>2023-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>119349</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap Equity Fund Dire...</td>\n",
       "      <td>06-04-2023</td>\n",
       "      <td>17.24000</td>\n",
       "      <td>2023-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>119300</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap Equity Fund Dire...</td>\n",
       "      <td>06-04-2023</td>\n",
       "      <td>32.03000</td>\n",
       "      <td>2023-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>119350</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap Equity Fund Dire...</td>\n",
       "      <td>06-04-2023</td>\n",
       "      <td>61.99000</td>\n",
       "      <td>2023-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>119346</td>\n",
       "      <td>BANK OF INDIA Large &amp; Mid Cap Equity Fund Dire...</td>\n",
       "      <td>06-04-2023</td>\n",
       "      <td>16.98000</td>\n",
       "      <td>2023-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>583</th>\n",
       "      <td>144727</td>\n",
       "      <td>Sundaram Emerging Small Cap Series VI Regular ...</td>\n",
       "      <td>06-04-2023</td>\n",
       "      <td>21.19680</td>\n",
       "      <td>2023-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>584</th>\n",
       "      <td>144989</td>\n",
       "      <td>Sundaram Emerging Small Cap Series VII Direct ...</td>\n",
       "      <td>06-04-2023</td>\n",
       "      <td>21.46200</td>\n",
       "      <td>2023-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585</th>\n",
       "      <td>144987</td>\n",
       "      <td>Sundaram Emerging Small Cap Series VII Regular...</td>\n",
       "      <td>06-04-2023</td>\n",
       "      <td>22.39990</td>\n",
       "      <td>2023-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>586</th>\n",
       "      <td>144986</td>\n",
       "      <td>Sundaram Emerging Small Cap Series VII Regular...</td>\n",
       "      <td>06-04-2023</td>\n",
       "      <td>21.00690</td>\n",
       "      <td>2023-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>587</th>\n",
       "      <td>144988</td>\n",
       "      <td>Sundaram Emerging Small Cap VII Direct Plan - ...</td>\n",
       "      <td>06-04-2023</td>\n",
       "      <td>22.86600</td>\n",
       "      <td>2023-04-06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>588 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     scheme_code                                        scheme_name  \\\n",
       "0         110598  BANK OF INDIA Large & Mid Cap  Equity Fund Reg...   \n",
       "1         119349  BANK OF INDIA Large & Mid Cap Equity Fund Dire...   \n",
       "2         119300  BANK OF INDIA Large & Mid Cap Equity Fund Dire...   \n",
       "3         119350  BANK OF INDIA Large & Mid Cap Equity Fund Dire...   \n",
       "4         119346  BANK OF INDIA Large & Mid Cap Equity Fund Dire...   \n",
       "..           ...                                                ...   \n",
       "583       144727  Sundaram Emerging Small Cap Series VI Regular ...   \n",
       "584       144989  Sundaram Emerging Small Cap Series VII Direct ...   \n",
       "585       144987  Sundaram Emerging Small Cap Series VII Regular...   \n",
       "586       144986  Sundaram Emerging Small Cap Series VII Regular...   \n",
       "587       144988  Sundaram Emerging Small Cap VII Direct Plan - ...   \n",
       "\n",
       "           date       nav   datetime  \n",
       "0    06-04-2023  20.14000 2023-04-06  \n",
       "1    06-04-2023  17.24000 2023-04-06  \n",
       "2    06-04-2023  32.03000 2023-04-06  \n",
       "3    06-04-2023  61.99000 2023-04-06  \n",
       "4    06-04-2023  16.98000 2023-04-06  \n",
       "..          ...       ...        ...  \n",
       "583  06-04-2023  21.19680 2023-04-06  \n",
       "584  06-04-2023  21.46200 2023-04-06  \n",
       "585  06-04-2023  22.39990 2023-04-06  \n",
       "586  06-04-2023  21.00690 2023-04-06  \n",
       "587  06-04-2023  22.86600 2023-04-06  \n",
       "\n",
       "[588 rows x 5 columns]"
      ]
     },
     "execution_count": 160,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "id": "957d81d0",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df.drop(['datetime'],axis=1, inplace = True)\n",
    "final_df.to_csv('MF_NAV_DATA.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "52c1c986",
   "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.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}