swot_analyzer.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_excel(\"overallData_latest.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'Moving Averages', 'Technical Indicators',\n",
       "       'Moving Averages Crossovers', 'symbol_url', 'Market Cap (Rs Cr.)',\n",
       "       'P/E', 'Book Value (Rs)', 'Dividend (%)', 'Market Lot', 'Industry P/E',\n",
       "       'EPS (TTM)', 'P/C', 'Price/Book', 'Dividend Yield.(%)',\n",
       "       'Face Value (RS)', 'Sentiment', 'Symbol', 'Strengths', 'Weaknesses',\n",
       "       'Opportunities', 'Threats', 'swot_url'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = df.drop(['Moving Averages', 'Technical Indicators',\n",
    "       'Moving Averages Crossovers', 'symbol_url', 'Market Cap (Rs Cr.)',\n",
    "       'P/E', 'Book Value (Rs)', 'Dividend (%)', 'Market Lot', 'Industry P/E',\n",
    "       'EPS (TTM)', 'P/C', 'Price/Book', 'Dividend Yield.(%)',\n",
    "       'Face Value (RS)', 'swot_url'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'Sentiment', 'Symbol', 'Strengths', 'Weaknesses',\n",
       "       'Opportunities', 'Threats'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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 Names</th>\n",
       "      <th>Sentiment</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Strengths</th>\n",
       "      <th>Weaknesses</th>\n",
       "      <th>Opportunities</th>\n",
       "      <th>Threats</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3M India</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>3MINDIA</td>\n",
       "      <td>['Company with Low Debt', 'Company with Zero P...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Positive breakout Third resistance ( LTP &gt; R...</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AAVAS Financier</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>AAVAS</td>\n",
       "      <td>['Annual Net Profits improving for last 2 year...</td>\n",
       "      <td>['Promoter holding decreased by more than -2% ...</td>\n",
       "      <td>['RSI indicating price strength']</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AB Capital</td>\n",
       "      <td>60% BUY</td>\n",
       "      <td>ABCAPITAL</td>\n",
       "      <td>['Effectively using Shareholders fund - Return...</td>\n",
       "      <td>['Red Flag: High Interest Payments Compared to...</td>\n",
       "      <td>No Opportunities found</td>\n",
       "      <td>['Increase in Provisions in Recent Results']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Abbott India</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>ABBOTINDIA</td>\n",
       "      <td>Exception, No Strengths found</td>\n",
       "      <td>Exception, No Weaknesses found</td>\n",
       "      <td>Exception, No Opportunities found</td>\n",
       "      <td>Exception, No Threat found</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ACC</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>ACC</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Adani Enterpris</td>\n",
       "      <td>50% BUY</td>\n",
       "      <td>ADANIENT</td>\n",
       "      <td>['High Piotroski Score - Companies with strong...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Big Deal (Insider and SAST) buys last month ...</td>\n",
       "      <td>['Red Flags: Firms linked to ongoing regulator...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Adani Ports</td>\n",
       "      <td>0% BUY</td>\n",
       "      <td>ADANIPORTS</td>\n",
       "      <td>['Promoters increasing shareholding', 'Strong ...</td>\n",
       "      <td>['Inefficient use of shareholder funds - ROE d...</td>\n",
       "      <td>['Big Deal (Insider and SAST) buys last month ...</td>\n",
       "      <td>['Companies where promoters have increased the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Adani Power</td>\n",
       "      <td>67% BUY</td>\n",
       "      <td>ADANIPOWER</td>\n",
       "      <td>['Strong cash generating ability from core bus...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Big Deal (Insider and SAST) buys last month ...</td>\n",
       "      <td>['Companies where promoters have increased the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Adani Trans</td>\n",
       "      <td>33% BUY</td>\n",
       "      <td>ADANITRANS</td>\n",
       "      <td>['Increasing Revenue every quarter for the pas...</td>\n",
       "      <td>['Decline in Net Profit (QoQ)', 'Decline in Qu...</td>\n",
       "      <td>['Big Deal (Insider and SAST) buys last month ...</td>\n",
       "      <td>['Companies where promoters have increased the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Aditya Birla F</td>\n",
       "      <td>93% BUY</td>\n",
       "      <td>ABFRL</td>\n",
       "      <td>['Company with Zero Promoter Pledge']</td>\n",
       "      <td>['Red Flag: High Interest Payments Compared to...</td>\n",
       "      <td>['Stock with Low PE (PE &lt; = 10)']</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Advanced Enzyme</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>ADVENZYMES</td>\n",
       "      <td>['Promoters increasing shareholding', 'Company...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['RSI indicating price strength']</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Aegis Logistics</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>AEGISCHEM</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['Negative Breakdown First support (LTP &lt; S1)'...</td>\n",
       "      <td>No Opportunities found</td>\n",
       "      <td>['Company with negative growth and promoters d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AFL</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>ARVINDFASN</td>\n",
       "      <td>['MACD Crossover Above Signal Line', 'Effectiv...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Stock with Low PE (PE &lt; = 10)', 'RSI indicat...</td>\n",
       "      <td>['Company with negative growth and promoters d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>AGL</td>\n",
       "      <td>73% BUY</td>\n",
       "      <td>ADANIGAS</td>\n",
       "      <td>['Company with high TTM EPS Growth', 'Growth i...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Highest Recovery from 52 Week Low']</td>\n",
       "      <td>['Increasing Trend in Non-Core Income', 'Stock...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AIA Engineering</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>AIAENG</td>\n",
       "      <td>['Company with Low Debt', 'Annual Net Profits ...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>No Threat found</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Ajanta Pharma</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>AJANTPHARM</td>\n",
       "      <td>['Company with high TTM EPS Growth', 'Good qua...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Companies where promoters have increased the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Akzo Nobel</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>AKZOINDIA</td>\n",
       "      <td>['Effectively using its capital to generate pr...</td>\n",
       "      <td>['Decline in Net Profit (QoQ)', 'Decline in Qu...</td>\n",
       "      <td>No Opportunities found</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Alembic Pharma</td>\n",
       "      <td>75% BUY</td>\n",
       "      <td>APLLTD</td>\n",
       "      <td>['High Piotroski Score - Companies with strong...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Increasing Trend in Non-Core Income']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Alkem Lab</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>ALKEM</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Alkyl Amines</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>ALKYLAMINE</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Increasing Trend in Non-Core Income']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Allcargo</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>ALLCARGO</td>\n",
       "      <td>['Growth in Quarterly Net Profit with increasi...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Companies with current TTM PE Ratio less tha...</td>\n",
       "      <td>No Threat found</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Amara Raja Batt</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>AMARAJABAT</td>\n",
       "      <td>['Bullish Harami  (Bullish Reversal)', 'Growth...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Amber Enterpris</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>AMBER</td>\n",
       "      <td>['Strong Annual EPS Growth', 'Effectively usin...</td>\n",
       "      <td>['Bearish Engulfing (Bearish Reversal)', 'Poor...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>No Threat found</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Ambuja Cements</td>\n",
       "      <td>67% BUY</td>\n",
       "      <td>AMBUJACEM</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>APL Apollo</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>APLAPOLLO</td>\n",
       "      <td>['Promoters increasing shareholding', 'Rising ...</td>\n",
       "      <td>['Negative Breakdown First support (LTP &lt; S1)'...</td>\n",
       "      <td>['Street Favorite: High Analyst Rating with at...</td>\n",
       "      <td>No Threat found</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Apollo Hospital</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>APOLLOHOSP</td>\n",
       "      <td>['High Piotroski Score - Companies with strong...</td>\n",
       "      <td>['Negative Breakdown Second support S2 (LTP &lt; ...</td>\n",
       "      <td>No Opportunities found</td>\n",
       "      <td>['Stocks with high PE (PE &gt; 40)']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Apollo Tyres</td>\n",
       "      <td>97% BUY</td>\n",
       "      <td>APOLLOTYRE</td>\n",
       "      <td>['Company with Low Debt', 'Book Value per shar...</td>\n",
       "      <td>['Inefficient use of shareholder funds - ROE d...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Companies where promoters have increased the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Ashok Leyland</td>\n",
       "      <td>64% BUY</td>\n",
       "      <td>ASHOKLEY</td>\n",
       "      <td>['Promoters increasing shareholding', 'Growth ...</td>\n",
       "      <td>['Red Flag: High Interest Payments Compared to...</td>\n",
       "      <td>No Opportunities found</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Ashoka Buildcon</td>\n",
       "      <td>86% BUY</td>\n",
       "      <td>ASHOKA</td>\n",
       "      <td>['Promoters increasing shareholding', 'Effecti...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['RSI indicating price strength']</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Asian Paints</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>ASIANPAINT</td>\n",
       "      <td>['Growth in Quarterly Net Profit with increasi...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</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>465</th>\n",
       "      <td>Ujjivan Financi</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>UJJIVAN</td>\n",
       "      <td>['Company with high TTM EPS Growth', 'Strong A...</td>\n",
       "      <td>['Red Flag: High Interest Payments Compared to...</td>\n",
       "      <td>['Positive breakout Second resistance  ( LTP &gt;...</td>\n",
       "      <td>['Increase in Provisions in Recent Results']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>UltraTechCement</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>ULTRACEMCO</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['Inefficient use of assets to generate profit...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>Union Bank</td>\n",
       "      <td>87% BUY</td>\n",
       "      <td>UNIONBANK</td>\n",
       "      <td>['Company with Zero Promoter Pledge', 'Stock g...</td>\n",
       "      <td>['Red Flag: High Interest Payments Compared to...</td>\n",
       "      <td>['Stock with Low PE (PE &lt; = 10)', 'RSI indicat...</td>\n",
       "      <td>['Red Flag: Large Swings Between Profit and Lo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>United Brewerie</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>UBL</td>\n",
       "      <td>['Effectively using Shareholders fund - Return...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Rising Delivery Percentage Compared to Previ...</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>UPL</td>\n",
       "      <td>56% BUY</td>\n",
       "      <td>UPL</td>\n",
       "      <td>['Company with high TTM EPS Growth', 'Good qua...</td>\n",
       "      <td>['Inefficient use of shareholder funds - ROE d...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Companies where promoters have increased the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>V-Guard Ind</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>VGUARD</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>V-Mart Retail</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>VMART</td>\n",
       "      <td>['Company with No Debt', 'Book Value per share...</td>\n",
       "      <td>['Bearish Engulfing (Bearish Reversal)', 'Decl...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Red Flag: Large Swings Between Profit and Lo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>Va Tech Wabag</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>WABAG</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Companies with current TTM PE Ratio less tha...</td>\n",
       "      <td>No Threat found</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>Vaibhav Global</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>VAIBHAVGBL</td>\n",
       "      <td>['Promoters increasing shareholding', 'Rising ...</td>\n",
       "      <td>['Decline in Net Profit (QoQ)', 'Decline in Ne...</td>\n",
       "      <td>['Individual Superstar Investors raised stake ...</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>Vardhman Text</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>VTL</td>\n",
       "      <td>['Company with Low Debt', 'Book Value per shar...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Stock with Low PE (PE &lt; = 10)']</td>\n",
       "      <td>['Company with negative growth and promoters d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>Varroc Engineer</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>VARROC</td>\n",
       "      <td>['Company with Zero Promoter Pledge', 'High di...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['RSI indicating price strength']</td>\n",
       "      <td>['Profit to Loss Companies', 'Degrowth in Reve...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>Varun Beverages</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>VBL</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['Big Deal (Insider and SAST) sells last month...</td>\n",
       "      <td>['Rising Delivery Percentage Compared to Previ...</td>\n",
       "      <td>['Stocks with high PE (PE &gt; 40)', 'Insiders so...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>Vedanta</td>\n",
       "      <td>88% BUY</td>\n",
       "      <td>VEDL</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Stock with Low PE (PE &lt; = 10)', 'RSI indicat...</td>\n",
       "      <td>['Red Flags: Firms linked to ongoing regulator...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>Venkys</td>\n",
       "      <td>67% BUY</td>\n",
       "      <td>VENKEYS</td>\n",
       "      <td>['Company with Low Debt', 'Book Value per shar...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Results Screener: Stocks with upcoming resul...</td>\n",
       "      <td>['Profit to Loss Companies']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>Vinati Organics</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>VINATIORGA</td>\n",
       "      <td>['Promoters increasing shareholding', 'Growth ...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Negative to Positive growth in Sales and Pro...</td>\n",
       "      <td>No Threat found</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>VIP Industries</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>VIPIND</td>\n",
       "      <td>['Company with Low Debt', 'Book Value per shar...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Individual Superstar Investors raised stake ...</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>Vodafone Idea</td>\n",
       "      <td>75% BUY</td>\n",
       "      <td>IDEA</td>\n",
       "      <td>['Growth in Net Profit with increasing Profit ...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Positive breakout ( LTP &gt; R1)', 'Negative to...</td>\n",
       "      <td>No Threat found</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>Voltas</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>VOLTAS</td>\n",
       "      <td>['Growth in Net Profit with increasing Profit ...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>VRL Logistics</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>VRLLOG</td>\n",
       "      <td>['Company with Low Debt', 'Book Value per shar...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['RSI indicating price strength']</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>VST</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>VSTIND</td>\n",
       "      <td>['Company with high TTM EPS Growth', 'Effectiv...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Individual Superstar Investors raised stake ...</td>\n",
       "      <td>['Increasing Trend in Non-Core Income']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>WABCO India</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>WABCOINDIA</td>\n",
       "      <td>['Company with No Debt', 'Book Value per share...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['RSI indicating price strength']</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>486</th>\n",
       "      <td>Welspun Corp</td>\n",
       "      <td>78% BUY</td>\n",
       "      <td>WELCORP</td>\n",
       "      <td>['Growth in Quarterly Net Profit with increasi...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Stock with Low PE (PE &lt; = 10)', 'RSI indicat...</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>487</th>\n",
       "      <td>Welspun India</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>WELSPUNIND</td>\n",
       "      <td>['Promoters increasing shareholding', 'Rising ...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Results Screener: Stocks with upcoming resul...</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>488</th>\n",
       "      <td>Westlife Dev</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>WESTLIFE</td>\n",
       "      <td>['Effectively using Shareholders fund - Return...</td>\n",
       "      <td>['Red Flag: High Interest Payments Compared to...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Profit to Loss Companies', 'Degrowth in Reve...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489</th>\n",
       "      <td>Whirlpool</td>\n",
       "      <td>50% BUY</td>\n",
       "      <td>WHIRLPOOL</td>\n",
       "      <td>['Growth in Net Profit with increasing Profit ...</td>\n",
       "      <td>['Decline in Quarterly Net Profit (YoY)', 'Dec...</td>\n",
       "      <td>['Rising Delivery Percentage Compared to Previ...</td>\n",
       "      <td>['Stocks with high PE (PE &gt; 40)']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>Wipro</td>\n",
       "      <td>71% BUY</td>\n",
       "      <td>WIPRO</td>\n",
       "      <td>['Rising Net Cash Flow and Cash from Operating...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491</th>\n",
       "      <td>Wockhardt</td>\n",
       "      <td>100% BUY</td>\n",
       "      <td>WOCKPHARMA</td>\n",
       "      <td>['Growth in Net Profit with increasing Profit ...</td>\n",
       "      <td>['Red Flag: Downgrade by Credit Rating Agency'...</td>\n",
       "      <td>['Stock with Low PE (PE &lt; = 10)', 'RSI indicat...</td>\n",
       "      <td>['Companies where promoters have increased the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>Zee Entertain</td>\n",
       "      <td>99% BUY</td>\n",
       "      <td>ZEEL</td>\n",
       "      <td>['Effectively using its capital to generate pr...</td>\n",
       "      <td>['MFs decreased their shareholding last quarte...</td>\n",
       "      <td>['Companies with current TTM PE Ratio less tha...</td>\n",
       "      <td>['Degrowth in Revenue, Profits and Operating P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>493</th>\n",
       "      <td>Zensar Tech</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>ZENSARTECH</td>\n",
       "      <td>['Promoters increasing shareholding', 'MACD Cr...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Recent broker downgrades in reco or target p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>Zydus Wellness</td>\n",
       "      <td>Data Unavailable</td>\n",
       "      <td>ZYDUSWELL</td>\n",
       "      <td>['Promoters increasing shareholding', 'Rising ...</td>\n",
       "      <td>['Companies with growing costs YoY for long te...</td>\n",
       "      <td>['Brokers upgraded recommendation or target pr...</td>\n",
       "      <td>['Stocks with high PE (PE &gt; 40)']</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>495 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Company Names         Sentiment      Symbol  \\\n",
       "0           3M India          100% BUY     3MINDIA   \n",
       "1    AAVAS Financier  Data Unavailable       AAVAS   \n",
       "2         AB Capital           60% BUY   ABCAPITAL   \n",
       "3       Abbott India          100% BUY  ABBOTINDIA   \n",
       "4                ACC  Data Unavailable         ACC   \n",
       "..               ...               ...         ...   \n",
       "490            Wipro           71% BUY       WIPRO   \n",
       "491        Wockhardt          100% BUY  WOCKPHARMA   \n",
       "492    Zee Entertain           99% BUY        ZEEL   \n",
       "493      Zensar Tech  Data Unavailable  ZENSARTECH   \n",
       "494   Zydus Wellness  Data Unavailable   ZYDUSWELL   \n",
       "\n",
       "                                             Strengths  \\\n",
       "0    ['Company with Low Debt', 'Company with Zero P...   \n",
       "1    ['Annual Net Profits improving for last 2 year...   \n",
       "2    ['Effectively using Shareholders fund - Return...   \n",
       "3                        Exception, No Strengths found   \n",
       "4    ['Rising Net Cash Flow and Cash from Operating...   \n",
       "..                                                 ...   \n",
       "490  ['Rising Net Cash Flow and Cash from Operating...   \n",
       "491  ['Growth in Net Profit with increasing Profit ...   \n",
       "492  ['Effectively using its capital to generate pr...   \n",
       "493  ['Promoters increasing shareholding', 'MACD Cr...   \n",
       "494  ['Promoters increasing shareholding', 'Rising ...   \n",
       "\n",
       "                                            Weaknesses  \\\n",
       "0    ['Companies with growing costs YoY for long te...   \n",
       "1    ['Promoter holding decreased by more than -2% ...   \n",
       "2    ['Red Flag: High Interest Payments Compared to...   \n",
       "3                       Exception, No Weaknesses found   \n",
       "4    ['MFs decreased their shareholding last quarte...   \n",
       "..                                                 ...   \n",
       "490  ['Companies with growing costs YoY for long te...   \n",
       "491  ['Red Flag: Downgrade by Credit Rating Agency'...   \n",
       "492  ['MFs decreased their shareholding last quarte...   \n",
       "493  ['Companies with growing costs YoY for long te...   \n",
       "494  ['Companies with growing costs YoY for long te...   \n",
       "\n",
       "                                         Opportunities  \\\n",
       "0    ['Positive breakout Third resistance ( LTP > R...   \n",
       "1                    ['RSI indicating price strength']   \n",
       "2                               No Opportunities found   \n",
       "3                    Exception, No Opportunities found   \n",
       "4    ['Brokers upgraded recommendation or target pr...   \n",
       "..                                                 ...   \n",
       "490  ['Brokers upgraded recommendation or target pr...   \n",
       "491  ['Stock with Low PE (PE < = 10)', 'RSI indicat...   \n",
       "492  ['Companies with current TTM PE Ratio less tha...   \n",
       "493  ['Brokers upgraded recommendation or target pr...   \n",
       "494  ['Brokers upgraded recommendation or target pr...   \n",
       "\n",
       "                                               Threats  \n",
       "0    ['Degrowth in Revenue, Profits and Operating P...  \n",
       "1    ['Degrowth in Revenue, Profits and Operating P...  \n",
       "2         ['Increase in Provisions in Recent Results']  \n",
       "3                           Exception, No Threat found  \n",
       "4    ['Recent broker downgrades in reco or target p...  \n",
       "..                                                 ...  \n",
       "490  ['Recent broker downgrades in reco or target p...  \n",
       "491  ['Companies where promoters have increased the...  \n",
       "492  ['Degrowth in Revenue, Profits and Operating P...  \n",
       "493  ['Recent broker downgrades in reco or target p...  \n",
       "494                  ['Stocks with high PE (PE > 40)']  \n",
       "\n",
       "[495 rows x 7 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.rename(columns={\"Unnamed: 0\": \"Company Names\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "import ast\n",
    "\n",
    "def get_unique_strenghts_and_count(swot):\n",
    "    allSwot = {}\n",
    "    \n",
    "    aggregate = list(swot)\n",
    "    \n",
    "    for row in aggregate:\n",
    "        try:\n",
    "            if type(row) == str and not row.endswith(\"found\") and row != \"Data Not Available\":\n",
    "                points = ast.literal_eval(row)\n",
    "                \n",
    "                for point in points:\n",
    "                    if point not in allSwot.keys():\n",
    "                        allSwot[point] = 1\n",
    "                    else:\n",
    "                        allSwot[point] += 1\n",
    "                    \n",
    "        except:\n",
    "            print(row)\n",
    "            raise Exception\n",
    "    \n",
    "    return allSwot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Strengths 50\n",
      "Weaknesses 46\n",
      "Opportunities 21\n",
      "Threats 20\n"
     ]
    }
   ],
   "source": [
    "swot_types = [\"Strengths\", \"Weaknesses\", \"Opportunities\", \"Threats\"]\n",
    "analyser = {}\n",
    "for type_ in swot_types:\n",
    "    analyser[type_] = get_unique_strenghts_and_count(data[type_])\n",
    "    print(type_, len(analyser[type_]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "def analyze_swot(swot):\n",
    "    tempdf = pd.DataFrame()\n",
    "    tempdf[\"Points\"] = swot.keys()\n",
    "    tempdf[\"Counts\"] = swot.values()\n",
    "    return tempdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "writer = pd.ExcelWriter('swot_analysis.xlsx', engine='xlsxwriter')\n",
    "\n",
    "for type_ in swot_types:\n",
    "    new_df = analyze_swot(analyser[type_])\n",
    "    new_df.to_excel(writer, sheet_name=type_, index=False)\n",
    "    \n",
    "writer.save()"
   ]
  },
  {
   "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.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}