Calc_df_Algo.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "def calc_df(co):\n",
    "    try:\n",
    "        dfbs = pd.read_csv(f\"../NSE/BS/NonFinancial/{co}_stnd_BS.csv\")\n",
    "        dfpl = pd.read_csv(f\"../NSE/PL/NonFinancial/{co}_stnd_PL.csv\")\n",
    "        if len(dfbs.columns) == 8 and len(dfpl.columns) == 8:\n",
    "            dfbs.drop(['Unnamed: 0', '6'],axis=1, inplace=True)\n",
    "            dfpl.drop(['Unnamed: 0', '6'],axis=1, inplace=True)\n",
    "\n",
    "            dfbs.set_index('0', inplace=True)\n",
    "            dfpl.set_index('0', inplace=True)\n",
    "\n",
    "            dfbs.columns = dfbs.iloc[0]\n",
    "            dfpl.columns = dfpl.iloc[0]\n",
    "\n",
    "            dfbs = dfbs.transpose()\n",
    "            dfpl = dfpl.transpose()\n",
    "\n",
    "            dfbs.columns = dfbs.columns.fillna('to_drop')\n",
    "            dfbs.drop('to_drop', axis=1, inplace=True)\n",
    "\n",
    "            dfpl.columns = dfpl.columns.fillna('to_drop')\n",
    "            dfpl.drop('to_drop', axis=1, inplace=True)\n",
    "\n",
    "\n",
    "            cd = dfbs.filter(regex=(\"Balance Sheet\"),axis=1)\n",
    "            dfbs.drop(cd, axis=1, inplace=True)\n",
    "\n",
    "            cd2 = dfpl.filter(regex=(\"Profit & Loss\"), axis=1)\n",
    "            dfpl.drop(cd2,axis=1, inplace=True)\n",
    "\n",
    "            dfbs.replace(to_replace='--', value=0, inplace=True)\n",
    "            dfpl.replace(to_replace='--', value=0, inplace=True)\n",
    "\n",
    "            dfbs.fillna(0, inplace=True)\n",
    "            dfpl.fillna(0, inplace=True)\n",
    "\n",
    "            indx = dfpl.index.name\n",
    "            df = dfbs.join(dfpl, rsuffix=\"_pl\")\n",
    "            cols = []\n",
    "            for d in df.columns:\n",
    "                cols.append(d)\n",
    "                \n",
    "            for d in df.columns:\n",
    "                df[d] = df[d].astype(float)\n",
    "\n",
    "\n",
    "            df['EBITDA'] = (df['Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax'] + df['Finance Costs'] + df['Depreciation And Amortisation Expenses'])\n",
    "            df['EBIT'] = df['Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax'] + df['Finance Costs']\n",
    "            df['Total Debt'] = df['Long Term Borrowings'] +  df['Short Term Borrowings']\n",
    "            \n",
    "            df['DE'] = (df['Long Term Borrowings'] +  df['Short Term Borrowings']  )  /df['Total Reserves and Surplus']\n",
    "            df['R/P'] = df['Trade Receivables'] / df['Trade Payables']\n",
    "            df['CR'] = df['Total Current Assets'] / df['Total Current Liabilities']\n",
    "            df['CCR'] = df['Cash And Cash Equivalents'] / df['Total Current Assets']\n",
    "            df['Eq_Assets'] = df['Total Shareholders Funds'] / df['Total Capital And Liabilities']\n",
    "            df['FA_Assets'] = df['Fixed Assets'] / df['Total Assets']\n",
    "            df['NC_Assets'] = df['Total Non-Current Assets'] / df['Total Assets'] \n",
    "            df['C_Assets'] = df['Total Current Assets'] / df['Total Assets'] \n",
    "\n",
    "            df['EBITDA_Mgn'] = (df['Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax'] + df['Finance Costs'] + df['Depreciation And Amortisation Expenses']) / df['Total Revenue']\n",
    "            df['EBIT_Mgn'] = (df['Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax'] + df['Finance Costs'] ) / df['Total Revenue']\n",
    "            df['PBT_Mgn'] = df['Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax'] / df['Total Revenue']\n",
    "            df['NPM'] = df['Profit/Loss For The Period']/df['Total Revenue']\n",
    "            df['OPR_Rev'] = df['Total Operating Revenues'] / df['Total Revenue']\n",
    "            df['RONW'] = df['Profit/Loss For The Period'] / df['Total Shareholders Funds']\n",
    "            df['ROA'] = df['Profit/Loss For The Period'] / df['Total Assets']\n",
    "            df['ITR'] = df['Total Revenue']/ df['Inventories']\n",
    "            df['cred_sales_ratio'] =  df['Total Revenue']/ df['Trade Receivables']\n",
    "            \n",
    "            dfm = df.copy()\n",
    "            \n",
    "            for c  in cols:\n",
    "                dfm.drop(c, axis=1, inplace=True)\n",
    "\n",
    "            df.to_csv(f'../Cleaned/NSE/PL_BS/{co}_plbs.csv')\n",
    "            dfbs.to_csv(f'../Cleaned/NSE/BS/{co}_BS.csv')\n",
    "            dfpl.to_csv(f'../Cleaned/NSE/PL/{co}_PL.csv')\n",
    "            dfm.to_csv(f'../Cleaned/NSE/Ratios/{co}_ratios.csv')\n",
    "            print(f'data saved for {co}')\n",
    "        else:\n",
    "            print(f'inconsistent data for {co}')\n",
    "    except FileNotFoundError:\n",
    "        print(f'file not found for {co}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "data saved for 3MINDIA\n",
      "data saved for ABB\n",
      "file not found for POWERINDIA\n",
      "data saved for ACC\n",
      "data saved for AIAENG\n",
      "data saved for APLAPOLLO\n",
      "file not found for AUBANK\n",
      "file not found for AARTIDRUGS\n",
      "data saved for AARTIIND\n",
      "file not found for AAVAS\n",
      "data saved for ABBOTINDIA\n",
      "file not found for ADANIENT\n",
      "data saved for ADANIGREEN\n",
      "data saved for ADANIPORTS\n",
      "inconsistent data for ATGL\n",
      "data saved for ADANITRANS\n",
      "file not found for ABCAPITAL\n",
      "data saved for ABFRL\n",
      "data saved for ADVENZYMES\n",
      "data saved for AEGISCHEM\n",
      "data saved for AFFLE\n",
      "data saved for AJANTPHARM\n",
      "data saved for AKZOINDIA\n",
      "file not found for ALEMBICLTD\n",
      "data saved for APLLTD\n",
      "data saved for ALKEM\n",
      "data saved for ALKYLAMINE\n",
      "file not found for ALOKINDS\n",
      "data saved for AMARAJABAT\n",
      "data saved for AMBER\n",
      "data saved for AMBUJACEM\n",
      "file not found for ANGELBRKG\n",
      "data saved for APOLLOHOSP\n",
      "data saved for APOLLOTYRE\n",
      "data saved for ASAHIINDIA\n",
      "data saved for ASHOKLEY\n",
      "data saved for ASHOKA\n",
      "data saved for ASIANPAINT\n",
      "data saved for ASTERDM\n",
      "data saved for ASTRAZEN\n",
      "data saved for ASTRAL\n",
      "data saved for ATUL\n",
      "data saved for AUROPHARMA\n",
      "data saved for AVANTIFEED\n",
      "data saved for DMART\n",
      "file not found for AXISBANK\n",
      "data saved for BASF\n",
      "data saved for BEML\n",
      "file not found for BSE\n",
      "data saved for BAJAJ-AUTO\n",
      "data saved for BAJAJCON\n",
      "data saved for BAJAJELEC\n",
      "file not found for BAJFINANCE\n",
      "file not found for BAJAJFINSV\n",
      "file not found for BAJAJHLDNG\n",
      "file not found for BALAMINES\n",
      "data saved for BALKRISIND\n",
      "data saved for BALMLAWRIE\n",
      "data saved for BALRAMCHIN\n",
      "file not found for BANDHANBNK\n",
      "file not found for BANKBARODA\n",
      "file not found for BANKINDIA\n",
      "file not found for MAHABANK\n",
      "data saved for BATAINDIA\n",
      "data saved for BAYERCROP\n",
      "data saved for BERGEPAINT\n",
      "data saved for BDL\n",
      "data saved for BEL\n",
      "data saved for BHARATFORG\n",
      "data saved for BHEL\n",
      "data saved for BPCL\n",
      "data saved for BHARATRAS\n",
      "data saved for BHARTIARTL\n",
      "data saved for BIOCON\n",
      "data saved for BIRLACORPN\n",
      "data saved for BSOFT\n",
      "data saved for BLISSGVS\n",
      "data saved for BLUEDART\n",
      "data saved for BLUESTARCO\n",
      "data saved for BBTC\n",
      "data saved for BOSCHLTD\n",
      "data saved for BRIGADE\n",
      "data saved for BRITANNIA\n",
      "file not found for BURGERKING\n",
      "data saved for CCL\n",
      "data saved for CESC\n",
      "file not found for CRISIL\n",
      "file not found for CSBBANK\n",
      "data saved for CADILAHC\n",
      "file not found for CANFINHOME\n",
      "file not found for CANBK\n",
      "data saved for CAPLIPOINT\n",
      "file not found for CGCL\n",
      "data saved for CARBORUNIV\n",
      "data saved for CASTROLIND\n",
      "data saved for CEATLTD\n",
      "file not found for CENTRALBK\n",
      "file not found for CDSL\n",
      "data saved for CENTURYPLY\n",
      "data saved for CENTURYTEX\n",
      "data saved for CERA\n",
      "file not found for CHALET\n",
      "data saved for CHAMBLFERT\n",
      "file not found for CHOLAHLDNG\n",
      "file not found for CHOLAFIN\n",
      "data saved for CIPLA\n",
      "file not found for CUB\n",
      "data saved for COALINDIA\n",
      "data saved for COCHINSHIP\n",
      "data saved for COFORGE\n",
      "data saved for COLPAL\n",
      "file not found for CAMS\n",
      "data saved for CONCOR\n",
      "data saved for COROMANDEL\n",
      "file not found for CREDITACC\n",
      "data saved for CROMPTON\n",
      "data saved for CUMMINSIND\n",
      "data saved for CYIENT\n",
      "file not found for DCBBANK\n",
      "data saved for DCMSHRIRAM\n",
      "data saved for DLF\n",
      "data saved for DABUR\n",
      "file not found for DALBHARAT\n",
      "data saved for DEEPAKNTR\n",
      "data saved for DELTACORP\n",
      "file not found for DHANI\n",
      "data saved for DHANUKA\n",
      "data saved for DBL\n",
      "data saved for DISHTV\n",
      "data saved for DCAL\n",
      "data saved for DIVISLAB\n",
      "data saved for DIXON\n",
      "data saved for LALPATHLAB\n",
      "data saved for DRREDDY\n",
      "data saved for EIDPARRY\n",
      "data saved for EIHOTEL\n",
      "data saved for EPL\n",
      "file not found for EDELWEISS\n",
      "data saved for EICHERMOT\n",
      "data saved for ELGIEQUIP\n",
      "data saved for EMAMILTD\n",
      "data saved for ENDURANCE\n",
      "data saved for ENGINERSIN\n",
      "file not found for EQUITAS\n",
      "data saved for ERIS\n",
      "data saved for ESCORTS\n",
      "data saved for EXIDEIND\n",
      "data saved for FDC\n",
      "file not found for FEDERALBNK\n",
      "data saved for FINEORG\n",
      "data saved for FINCABLES\n",
      "data saved for FINPIPE\n",
      "data saved for FSL\n",
      "data saved for FORTIS\n",
      "data saved for FCONSUMER\n",
      "data saved for FRETAIL\n",
      "data saved for GAIL\n",
      "data saved for GEPIL\n",
      "data saved for GMMPFAUDLR\n",
      "data saved for GMRINFRA\n",
      "data saved for GALAXYSURF\n",
      "data saved for GRSE\n",
      "data saved for GARFIBRES\n",
      "file not found for GICRE\n",
      "data saved for GILLETTE\n",
      "data saved for GLAXO\n",
      "data saved for GLENMARK\n",
      "data saved for GODFRYPHLP\n",
      "data saved for GODREJAGRO\n",
      "data saved for GODREJCP\n",
      "data saved for GODREJIND\n",
      "data saved for GODREJPROP\n",
      "data saved for GRANULES\n",
      "data saved for GRAPHITE\n",
      "data saved for GRASIM\n",
      "data saved for GESHIP\n",
      "data saved for GREAVESCOT\n",
      "data saved for GRINDWELL\n",
      "data saved for GUJALKALI\n",
      "file not found for GAEL\n",
      "inconsistent data for FLUOROCHEM\n",
      "data saved for GUJGASLTD\n",
      "data saved for GNFC\n",
      "data saved for GPPL\n",
      "data saved for GSFC\n",
      "data saved for GSPL\n",
      "data saved for GULFOILLUB\n",
      "data saved for HEG\n",
      "data saved for HCLTECH\n",
      "file not found for HDFCAMC\n",
      "file not found for HDFCBANK\n",
      "file not found for HDFCLIFE\n",
      "data saved for HFCL\n",
      "file not found for HAPPSTMNDS\n",
      "data saved for HATSUN\n",
      "data saved for HAVELLS\n",
      "data saved for HEIDELBERG\n",
      "file not found for HEMIPROP\n",
      "data saved for HEROMOTOCO\n",
      "data saved for HSCL\n",
      "data saved for HINDALCO\n",
      "data saved for HAL\n",
      "data saved for HINDCOPPER\n",
      "data saved for HINDPETRO\n",
      "data saved for HINDUNILVR\n",
      "data saved for HINDZINC\n",
      "data saved for HONAUT\n",
      "file not found for HUDCO\n",
      "file not found for HDFC\n",
      "file not found for HUHTAMAKI\n",
      "file not found for ICICIBANK\n",
      "file not found for ICICIGI\n",
      "file not found for ICICIPRULI\n",
      "file not found for ISEC\n",
      "file not found for IDBI\n",
      "file not found for IDFCFIRSTB\n",
      "file not found for IDFC\n",
      "data saved for IFBIND\n",
      "file not found for IIFL\n",
      "file not found for IIFLWAM\n",
      "file not found for IOLCP\n",
      "data saved for IRB\n",
      "data saved for IRCON\n",
      "data saved for ITC\n",
      "data saved for ITI\n",
      "data saved for INDIACEM\n",
      "file not found for IBULHSGFIN\n",
      "data saved for IBREALEST\n",
      "data saved for INDIAMART\n",
      "file not found for INDIANB\n",
      "file not found for IEX\n",
      "data saved for INDHOTEL\n",
      "data saved for IOC\n",
      "file not found for IOB\n",
      "data saved for IRCTC\n",
      "file not found for ICIL\n",
      "data saved for INDOCO\n",
      "data saved for IGL\n",
      "data saved for INDUSTOWER\n",
      "file not found for INDUSINDBK\n",
      "data saved for INFIBEAM\n",
      "data saved for NAUKRI\n",
      "data saved for INFY\n",
      "data saved for INGERRAND\n",
      "data saved for INOXLEISUR\n",
      "data saved for INTELLECT\n",
      "data saved for INDIGO\n",
      "data saved for IPCALAB\n",
      "data saved for JBCHEPHARM\n",
      "data saved for JKCEMENT\n",
      "data saved for JKLAKSHMI\n",
      "data saved for JKPAPER\n",
      "data saved for JKTYRE\n",
      "file not found for JMFINANCIL\n",
      "data saved for JSWENERGY\n",
      "data saved for JSWSTEEL\n",
      "file not found for JTEKTINDIA\n",
      "data saved for JAMNAAUTO\n",
      "data saved for JINDALSAW\n",
      "data saved for JSLHISAR\n",
      "data saved for JSL\n",
      "data saved for JINDALSTEL\n",
      "data saved for JCHAC\n",
      "data saved for JUBLFOOD\n",
      "data saved for JUSTDIAL\n",
      "data saved for JYOTHYLAB\n",
      "data saved for KPRMILL\n",
      "data saved for KEI\n",
      "data saved for KNRCON\n",
      "inconsistent data for KPITTECH\n",
      "data saved for KRBL\n",
      "data saved for KSB\n",
      "data saved for KAJARIACER\n",
      "data saved for KALPATPOWR\n",
      "data saved for KANSAINER\n",
      "file not found for KARURVYSYA\n",
      "data saved for KSCL\n",
      "data saved for KEC\n",
      "file not found for KOTAKBANK\n",
      "file not found for L&TFH\n",
      "data saved for LTTS\n",
      "file not found for LICHSGFIN\n",
      "data saved for LAOPALA\n",
      "data saved for LAXMIMACH\n",
      "data saved for LTI\n",
      "file not found for LT\n",
      "data saved for LAURUSLABS\n",
      "data saved for LEMONTREE\n",
      "data saved for LINDEINDIA\n",
      "data saved for LUPIN\n",
      "data saved for LUXIND\n",
      "file not found for MASFIN\n",
      "data saved for MMTC\n",
      "data saved for MOIL\n",
      "data saved for MRF\n",
      "data saved for MGL\n",
      "file not found for MAHSCOOTER\n",
      "data saved for MAHSEAMLES\n",
      "file not found for M&MFIN\n",
      "data saved for M&M\n",
      "data saved for MAHINDCIE\n",
      "data saved for MHRIL\n",
      "data saved for MAHLOG\n",
      "file not found for MANAPPURAM\n",
      "data saved for MRPL\n",
      "data saved for MARICO\n",
      "data saved for MARUTI\n",
      "file not found for MFSL\n",
      "file not found for MAXHEALTH\n",
      "file not found for MAZDOCK\n",
      "data saved for METROPOLIS\n",
      "data saved for MINDTREE\n",
      "data saved for MINDACORP\n",
      "data saved for MINDAIND\n",
      "data saved for MIDHANI\n",
      "data saved for MOTHERSUMI\n",
      "file not found for MOTILALOFS\n",
      "data saved for MPHASIS\n",
      "file not found for MCX\n",
      "file not found for MUTHOOTFIN\n",
      "data saved for NATCOPHARM\n",
      "data saved for NBCC\n",
      "data saved for NCC\n",
      "data saved for NESCO\n",
      "data saved for NHPC\n",
      "data saved for NLCINDIA\n",
      "data saved for NMDC\n",
      "file not found for NOCIL\n",
      "data saved for NTPC\n",
      "data saved for NH\n",
      "data saved for NATIONALUM\n",
      "data saved for NFL\n",
      "data saved for NAVINFLUOR\n",
      "data saved for NESTLEIND\n",
      "file not found for NETWORK18\n",
      "data saved for NILKAMAL\n",
      "file not found for NAM-INDIA\n",
      "data saved for OBEROIRLTY\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "data saved for ONGC\n",
      "data saved for OIL\n",
      "data saved for OFSS\n",
      "data saved for ORIENTELEC\n",
      "data saved for ORIENTREF\n",
      "data saved for PIIND\n",
      "file not found for PNBHOUSING\n",
      "file not found for PNCINFRA\n",
      "data saved for PVR\n",
      "data saved for PAGEIND\n",
      "data saved for PERSISTENT\n",
      "data saved for PETRONET\n",
      "data saved for PFIZER\n",
      "data saved for PHILIPCARB\n",
      "data saved for PHOENIXLTD\n",
      "data saved for PIDILITIND\n",
      "file not found for PEL\n",
      "data saved for POLYMED\n",
      "data saved for POLYCAB\n",
      "file not found for POLYPLEX\n",
      "file not found for PFC\n",
      "data saved for POWERGRID\n",
      "data saved for PRESTIGE\n",
      "file not found for PRINCEPIPE\n",
      "data saved for PRSMJOHNSN\n",
      "data saved for PGHL\n",
      "data saved for PGHH\n",
      "file not found for PNB\n",
      "data saved for QUESS\n",
      "file not found for RBLBANK\n",
      "file not found for RECLTD\n",
      "data saved for RITES\n",
      "data saved for RADICO\n",
      "data saved for RVNL\n",
      "data saved for RAIN\n",
      "data saved for RAJESHEXPO\n",
      "data saved for RALLIS\n",
      "data saved for RCF\n",
      "data saved for RATNAMANI\n",
      "data saved for RAYMOND\n",
      "data saved for REDINGTON\n",
      "data saved for RELAXO\n",
      "file not found for RELIANCE\n",
      "file not found for RESPONIND\n",
      "file not found for ROSSARI\n",
      "file not found for ROUTE\n",
      "file not found for SBICARD\n",
      "file not found for SBILIFE\n",
      "data saved for SIS\n",
      "data saved for SJVN\n",
      "data saved for SKFINDIA\n",
      "data saved for SRF\n",
      "data saved for SANOFI\n",
      "data saved for SCHAEFFLER\n",
      "data saved for SCHNEIDER\n",
      "data saved for SEQUENT\n",
      "file not found for SHARDACROP\n",
      "data saved for SFL\n",
      "file not found for SHILPAMED\n",
      "data saved for SCI\n",
      "data saved for SHOPERSTOP\n",
      "data saved for SHREECEM\n",
      "file not found for SHRIRAMCIT\n",
      "file not found for SRTRANSFIN\n",
      "data saved for SIEMENS\n",
      "data saved for SOBHA\n",
      "data saved for SOLARINDS\n",
      "file not found for SOLARA\n",
      "data saved for SONATSOFTW\n",
      "file not found for SPANDANA\n",
      "data saved for SPICEJET\n",
      "data saved for STARCEMENT\n",
      "file not found for SBIN\n",
      "data saved for SAIL\n",
      "inconsistent data for SWSOLAR\n",
      "data saved for STLTECH\n",
      "data saved for STAR\n",
      "data saved for SUDARSCHEM\n",
      "data saved for SUMICHEM\n",
      "data saved for SPARC\n",
      "data saved for SUNPHARMA\n",
      "data saved for SUNTV\n",
      "file not found for SUNCLAYLTD\n",
      "file not found for SUNDARMFIN\n",
      "data saved for SUNDRMFAST\n",
      "data saved for SUNTECK\n",
      "data saved for SUPRAJIT\n",
      "data saved for SUPREMEIND\n",
      "file not found for SUPPETRO\n",
      "file not found for SUVENPHAR\n",
      "data saved for SUZLON\n",
      "data saved for SWANENERGY\n",
      "data saved for SYMPHONY\n",
      "data saved for SYNGENE\n",
      "data saved for TCIEXP\n",
      "data saved for TCNSBRANDS\n",
      "data saved for TTKPRESTIG\n",
      "data saved for TV18BRDCST\n",
      "data saved for TVSMOTOR\n",
      "file not found for TANLA\n",
      "data saved for TASTYBITE\n",
      "file not found for TATACHEM\n",
      "file not found for TATACOFFEE\n",
      "data saved for TATACOMM\n",
      "data saved for TCS\n",
      "data saved for TATACONSUM\n",
      "data saved for TATAELXSI\n",
      "file not found for TATAINVEST\n",
      "data saved for TATAMTRDVR\n",
      "data saved for TATAMOTORS\n",
      "data saved for TATAPOWER\n",
      "data saved for TATASTEEL\n",
      "data saved for TEAMLEASE\n",
      "data saved for TECHM\n",
      "file not found for NIACL\n",
      "data saved for RAMCOCEM\n",
      "data saved for THERMAX\n",
      "data saved for THYROCARE\n",
      "data saved for TIMKEN\n",
      "data saved for TITAN\n",
      "data saved for TORNTPHARM\n",
      "data saved for TORNTPOWER\n",
      "data saved for TRENT\n",
      "data saved for TRIDENT\n",
      "file not found for TRITURBINE\n",
      "data saved for TIINDIA\n",
      "file not found for UCOBANK\n",
      "data saved for UFLEX\n",
      "data saved for UPL\n",
      "file not found for UTIAMC\n",
      "file not found for UJJIVAN\n",
      "file not found for UJJIVANSFB\n",
      "data saved for ULTRACEMCO\n",
      "file not found for UNIONBANK\n",
      "data saved for UBL\n",
      "data saved for MCDOWELL-N\n",
      "data saved for VGUARD\n",
      "data saved for VMART\n",
      "data saved for VIPIND\n",
      "data saved for VSTIND\n",
      "data saved for VAIBHAVGBL\n",
      "data saved for VAKRANGEE\n",
      "file not found for VALIANTORG\n",
      "data saved for VTL\n",
      "data saved for VARROC\n",
      "data saved for VBL\n",
      "data saved for VEDL\n",
      "data saved for VENKEYS\n",
      "data saved for VINATIORGA\n",
      "data saved for IDEA\n",
      "data saved for VOLTAS\n",
      "data saved for WABCOINDIA\n",
      "data saved for WELCORP\n",
      "data saved for WELSPUNIND\n",
      "data saved for WESTLIFE\n",
      "data saved for WHIRLPOOL\n",
      "data saved for WIPRO\n",
      "data saved for WOCKPHARMA\n",
      "file not found for YESBANK\n",
      "data saved for ZEEL\n",
      "data saved for ZENSARTECH\n",
      "file not found for ZYDUSWELL\n",
      "data saved for ECLERX\n"
     ]
    }
   ],
   "source": [
    "co_df = pd.read_csv('nifty500list.csv')\n",
    "for i,r in co_df.iterrows():\n",
    "    calc_df(r['Symbol'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}