tnea_app.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Python Libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import dash\n",
    "import dash_html_components as html\n",
    "import dash_core_components as dcc\n",
    "from dash.dependencies import Input, Output\n",
    "import dash_table\n",
    "import pandas as pd\n",
    "\n",
    "import dash_bootstrap_components as dbc\n",
    "import json\n",
    "\n",
    "from dash.dependencies import Input, Output, State\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Csv Data files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Joined data of allotted list of all 4 rounds of anna university counselling, branch info and college info\n",
    "tnea_csv_file_19 = \"assets/csv/joined_table_2019.csv\"\n",
    "tnea_csv_file_20 = \"assets/csv/joined_table_2020.csv\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Read csv to a pandas dataframe and format it"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "alloted_list_df_20 = pd.read_csv(tnea_csv_file_20)\n",
    "alloted_list_df_20.drop('S.NO', axis=1, inplace=True)\n",
    "alloted_list_df_20[\"COLLEGE CODE\"] = pd.to_numeric(alloted_list_df_20[\"COLLEGE CODE\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "alloted_list_df_19 = pd.read_csv(tnea_csv_file_19)\n",
    "alloted_list_df_19.drop('S.NO', axis=1, inplace=True)\n",
    "alloted_list_df_19[\"COLLEGE CODE\"] = pd.to_numeric(alloted_list_df_19[\"COLLEGE CODE\"])\n",
    "alloted_list_df_19[\"OVER ALL RANK\"] = pd.to_numeric(alloted_list_df_19[\"OVER ALL RANK\"], errors='coerce')\n",
    "alloted_list_df_19.fillna(method='ffill', inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "alloted_list_df = alloted_list_df_20"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Generates plotly Data table which shows the cut off details"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "def generate_plotly_data_table(df,radio_button_value,radio_button_year_value):\n",
    "    '''\n",
    "    table = dbc.Table.from_dataframe(df, \n",
    "                                     striped=True, \n",
    "                                     bordered=True, \n",
    "                                     hover=True,\n",
    "                                     dark=True,\n",
    "                                     responsive=True)\n",
    "    return table\n",
    "    \n",
    "    \n",
    "    '''\n",
    "    #heading_string = 'Max Mark = ' + str(df['AGGR MARK'].iloc[0]) + ' | ' + \"Min Mark = \" + str(df['AGGR MARK'].iloc[-1])\n",
    "    \n",
    "    \n",
    "    if radio_button_value == \"Cut Off Marks\":\n",
    "        heading_string = \"TNEA \"+str(radio_button_year_value)+\" CUT OFF MARKS\"\n",
    "    else:\n",
    "        heading_string = \"TNEA \"+str(radio_button_year_value)+' - Total Students = '+ str(df.shape[0])\n",
    "    return html.Div(children=[\n",
    "                        #html.H4(children='Student Count = '+str(df.shape[0]),style={\n",
    "                                                    #'text-align': 'center',\n",
    "                                                    #'color' : 'green',\n",
    "                                                    #'padding':'4px'\n",
    "                                                  #}), \n",
    "                        html.H4(children=heading_string,style={\n",
    "                                                    'text-align': 'center',\n",
    "                                                    'color' : 'green',\n",
    "                                                    'padding':'4px'\n",
    "                                                  }),\n",
    "                        dash_table.DataTable(\n",
    "                                            id='datatable-interactivity',\n",
    "                                            style_data={'whiteSpace': 'normal'},\n",
    "                                            css=[{\n",
    "                                                'selector': '.dash-cell div.dash-cell-value',\n",
    "                                                'rule': 'display: inline; white-space: inherit; overflow: inherit; text-overflow: inherit;'\n",
    "                                            }],\n",
    "                                            columns=[\n",
    "                                                {\"name\": i, \"id\": i, \"deletable\": True} for i in df.columns\n",
    "                                            ],\n",
    "                                            \n",
    "                                            style_header={\n",
    "                                                'backgroundColor': '#3DC2ED',\n",
    "                                                'fontWeight': 'bold',\n",
    "                                                'white-space': 'pre-wrap'\n",
    "                                            },\n",
    "\n",
    "                                            data=df.to_dict('records'),\n",
    "                                            #editable=True,\n",
    "                                            filter_action=\"native\",\n",
    "                                            sort_action=\"native\",\n",
    "                                            sort_mode=\"multi\",\n",
    "                                            #row_selectable=\"multi\",\n",
    "                                            #row_deletable=True,\n",
    "                                            #selected_rows=[],\n",
    "                                            page_action=\"native\",\n",
    "                                            page_current= 0,\n",
    "                                            page_size= 18,\n",
    "                                            style_data_conditional=[{\n",
    "                                                'if': {'column_id': 'CUT OFF MARK'},\n",
    "                                                'backgroundColor': '#3D9970',\n",
    "                                                'color': 'white',\n",
    "                                            }]\n",
    "                                        ),\n",
    "                        html.Div(id='datatable-interactivity-container')\n",
    "                        ])\n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Adding meta tags to app to be discovered by google crawler"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "app_meta_tags =[\n",
    "                    # A description of the app, used by e.g.\n",
    "                    # search engines when displaying search results.\n",
    "                    {\n",
    "                        'name': 'description',\n",
    "                        'content': 'tnea 2020 cut off , anna university 2020 cut off , tamil nadu engineering admissions 2020 cut offs, tnea 2020 cut off marks, anna university counselling cut off marks, tnea 2020 cut off marks, tnea previous year cut off marks, anna university previous year cut off'\n",
    "                    },\n",
    "                    {\n",
    "                        'name': 'keywords',\n",
    "                        'content': 'tnea 2020 cut off,anna university 2020 cut off, anna university cut off , 2020 cut off for anna university, anna university 2020 cut off, tnea 2020 cut off, tnea 2020 cut off marks,tnea 2020 cut off , anna university 2020 cut off , tamil nadu engineering admissions 2020 cut offs, tnea 2020 cut off marks, anna university counselling cut off marks, tnea 2020 cut off marks, tnea previous year cut off marks, anna university previous year cut off'\n",
    "                    },\n",
    "                    {\n",
    "                        'name': 'google-site-verification',\n",
    "                        'content': 'X7KxETg-LS3TyR1O4AWzv30G0M-xVQKEgmuOjhXfOB0'\n",
    "                    },\n",
    "                    # A tag that tells Internet Explorer (IE)\n",
    "                    # to use the latest renderer version available\n",
    "                    # to that browser (e.g. Edge)\n",
    "                    {\n",
    "                        'http-equiv': 'X-UA-Compatible',\n",
    "                        'content': 'IE=edge'\n",
    "                    },\n",
    "                    # A tag that tells the browser not to scale\n",
    "                    # desktop widths to fit mobile screens.\n",
    "                    # Sets the width of the viewport (browser)\n",
    "                    # to the width of the device, and the zoom level\n",
    "                    # (initial scale) to 1.\n",
    "                    #\n",
    "                    # Necessary for \"true\" mobile support.\n",
    "                    {\n",
    "                      'name': 'viewport',\n",
    "                      'content': 'width=device-width, initial-scale=1.0'\n",
    "                    }\n",
    "                ]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# External css for the app"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# external CSS stylesheets\n",
    "external_stylesheets = [\n",
    "    \"https://unpkg.com/tachyons@4.10.0/css/tachyons.min.css\",\n",
    "    \"/assets/css/tnea.css\"\n",
    "]\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Initialise dash app"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "app = dash.Dash(__name__,meta_tags=app_meta_tags,external_stylesheets=external_stylesheets)\n",
    "app.title='Tnea 2020 cut off marks - Anna University 2020 cut off marks'\n",
    "server = app.server\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# App Layout Design Details"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "app.layout = dcc.Loading(\n",
    "    children=[html.Div(children=[\n",
    "                                html.H1(children='TNEA 2020 Cut Off Marks',style={\n",
    "                                                    'text-align': 'center',\n",
    "                                                    'background-color': '#5274a0',\n",
    "                                                    'color' : 'white',\n",
    "                                                    'padding':'18px'\n",
    "                                                  }),\n",
    "                                \n",
    "                \n",
    "                                #html.H4(children='TNEA 2020 Cut Offs'),\n",
    "    \n",
    "                                html.P(children='Filter by College Code :',style={'padding':'4px',\n",
    "                                                                                 'font-weight': 'bold',\n",
    "                                                                                'color': '#2c1fcc'\n",
    "                                                  }),\n",
    "    \n",
    "                                html.P(id='college_label',style={\n",
    "                                                    'text-align': 'center',\n",
    "                                                    'color' : 'green',\n",
    "                                                    'padding':'4px'\n",
    "                                                  }),\n",
    "    \n",
    "    \n",
    "                                dcc.Dropdown(id='dropdown',\n",
    "                                             options=[\n",
    "                                                        {'label': i, 'value': i} for i in sorted(alloted_list_df['COLLEGE CODE'].unique())\n",
    "                                                    ], \n",
    "                                             multi=False, \n",
    "                                             placeholder='Filter by College Code...'),\n",
    "    \n",
    "                                \n",
    "    \n",
    "                                html.P(children='Filter by College Name :',style={'padding':'4px',\n",
    "                                                                                 'font-weight': 'bold',\n",
    "                                                                                'color': '#2c1fcc'\n",
    "                                                  }),\n",
    "    \n",
    "                                dcc.Dropdown(id='dropdown5',\n",
    "                                             options=[\n",
    "                                                        {'label': i, 'value': i} for i in sorted(alloted_list_df['COLL_NAME'].unique())\n",
    "                                                    ], \n",
    "                                             value='University Departments of Anna University, Chennai - CEG Campus, Sardar Patel Road, Guindy, Chennai 600 025', \n",
    "                                             multi=False,\n",
    "                                             #optionHeight=120,\n",
    "                                             placeholder='Filter by College Name...'),\n",
    "    \n",
    "                                html.P(children='Filter by Branch Code :',style={'padding':'4px',\n",
    "                                                                                 'font-weight': 'bold',\n",
    "                                                                                'color': '#2c1fcc'\n",
    "                                                  }),\n",
    "    \n",
    "                                 html.P(id='branch_label',style={\n",
    "                                                    'text-align': 'center',\n",
    "                                                    'color' : 'green',\n",
    "                                                    'padding':'4px'\n",
    "                                                  }),\n",
    "    \n",
    "    \n",
    "                                dcc.Dropdown(id='dropdown3',\n",
    "                                             options=[\n",
    "                                                        {'label': i, 'value': i} for i in sorted(alloted_list_df['BRANCH CODE'].unique())\n",
    "                                                    ], \n",
    "                                             multi=True, \n",
    "                                             placeholder='Filter by Branch Code...'),\n",
    "    \n",
    "                               \n",
    "    \n",
    "                                html.P(children='Filter by Branch Name :',style={'padding':'4px',\n",
    "                                                                                 'font-weight': 'bold',\n",
    "                                                                                'color': '#2c1fcc'\n",
    "                                                  }),\n",
    "                                dcc.Dropdown(id='dropdown4',\n",
    "                                             options=[\n",
    "                                                        {'label': i, 'value': i} for i in sorted(alloted_list_df['BRANCH_NAME'].unique())\n",
    "                                                    ], \n",
    "                                             multi=True, \n",
    "                                             placeholder='Filter by Branch Name...'),\n",
    "    \n",
    "                                html.P(children='Filter by Community Code :',style={'padding':'4px',\n",
    "                                                                                 'font-weight': 'bold',\n",
    "                                                                                'color': '#2c1fcc'\n",
    "                                                  }),\n",
    "    \n",
    "                                html.P(id='community_label',style={\n",
    "                                                    'text-align': 'center',\n",
    "                                                    'color' : 'green',\n",
    "                                                    'padding':'4px'\n",
    "                                                  }),\n",
    "    \n",
    "    \n",
    "                                dcc.Dropdown(id='dropdown2',\n",
    "                                             options=[\n",
    "                                                        {'label': i, 'value': i} for i in sorted(alloted_list_df['ALLOTTED CATEGORY'].unique())\n",
    "                                                    ], \n",
    "                                             multi=False, \n",
    "                                             value='OC',\n",
    "                                             placeholder='Filter by Community Code...'),\n",
    "        \n",
    "        \n",
    "                                html.P(children='Filter by Cut Off Mark :',style={'padding':'4px',\n",
    "                                                                                 'font-weight': 'bold',\n",
    "                                                                                'color': '#2c1fcc'\n",
    "                                                  }),\n",
    "        \n",
    "                             html.P(id='mark_label',style={\n",
    "                                                    'text-align': 'center',\n",
    "                                                    'color' : 'green',\n",
    "                                                    'padding':'4px'\n",
    "                                                  }),\n",
    "                               dcc.Dropdown(id='mark_filter',\n",
    "                                            \n",
    "                                             options=[\n",
    "                                                        {'label': i, 'value': i} for i in sorted([x * 0.25 for x in range(1, 801)], reverse=True)\n",
    "\n",
    "                                                    ], \n",
    "                                             multi=False, \n",
    "                                             value=200,\n",
    "                                             placeholder='Filter by Cut Off Mark...'),\n",
    "                                \n",
    "    \n",
    "        \n",
    "    \n",
    "                                dcc.RadioItems(id='radio_button',\n",
    "                                                style={\n",
    "                                                    'text-align': 'center',\n",
    "                                                    'color' : 'green',\n",
    "                                                    'padding':'4px',\n",
    "                                                    'font-weight': 'bold',\n",
    "                                                    'margin-top':'20px',\n",
    "                                                  },\n",
    "                                                inputStyle={\n",
    "                                                    \"margin-right\": \"5px\", \n",
    "                                                    \"margin-left\": \"15px\",\n",
    "                                                },\n",
    "                                                options=[\n",
    "                                                        {'label': 'Cut Off Marks', 'value': 'Cut Off Marks'},\n",
    "                                                        {'label': 'Full Student List', 'value': 'Full Student List'},\n",
    "                                                ],\n",
    "                                                value='Cut Off Marks',\n",
    "                                                labelStyle={'display': 'inline-block'}\n",
    "                                                ),  \n",
    "        \n",
    "                                 dcc.RadioItems(id='radio_button_year',\n",
    "                                                style={\n",
    "                                                    'text-align': 'center',\n",
    "                                                    'color' : 'green',\n",
    "                                                    'padding':'4px',\n",
    "                                                    'font-weight': 'bold',\n",
    "                                                    'margin-top':'20px',\n",
    "                                                  },\n",
    "                                                inputStyle={\n",
    "                                                    \"margin-right\": \"5px\", \n",
    "                                                    \"margin-left\": \"15px\",\n",
    "                                                },\n",
    "                                                options=[\n",
    "                                                        {'label': '2019', 'value': '2019'},\n",
    "                                                        {'label': '2020', 'value': '2020'},\n",
    "                                                ],\n",
    "                                                value='2020',\n",
    "                                                labelStyle={'display': 'inline-block'}\n",
    "                                                ), \n",
    "                              \n",
    "    \n",
    "                                html.Div(id='table-container'),\n",
    "                                #html.Div(id='bootstrap-table-container'),\n",
    "                                html.H4(children='Downloads - 2020'),\n",
    "                                html.A(\n",
    "                                            'Sports Alloted List',\n",
    "                                            download=\"sports_allotted_list.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2020/sports_allotted_list.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "                                html.A(\n",
    "                                            'Ex-Servicemen Allotted List',\n",
    "                                            download=\"ex-servicemen_Allotted_List.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2020/ex-servicemen_Allotted_List.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "                                html.A(\n",
    "                                            'Differently Abled Allotted List',\n",
    "                                            download=\"differently_abled_allotted_list.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2020/differently_abled_allotted_list.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "                                html.A(\n",
    "                                            'Allotted List Round 1',\n",
    "                                            download=\"allotted_list_round_1.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2020/allotted_list_round_1.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "                                html.A(\n",
    "                                            'Allotted List Round 2',\n",
    "                                            download=\"allotted_list_round_2.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2020/allotted_list_round_2.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "    \n",
    "                                html.A(\n",
    "                                            'Allotted List Round 3',\n",
    "                                            download=\"allotted_list_round_3.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2020/allotted_list_round_3.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                      ),\n",
    "                                html.A(\n",
    "                                            'Allotted List Round 4',\n",
    "                                            download=\"allotted_list_round_4.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2020/allotted_list_round_4.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "                                html.A(\n",
    "                                            'Vocational Alllotted List',\n",
    "                                            download=\"vocational_allotments.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2020/vocational_allotments.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "        \n",
    "                                html.H4(children='Downloads - 2019'),\n",
    "                                html.A(\n",
    "                                            'Sports Alloted List',\n",
    "                                            download=\"sports_allotted_list.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2019/sports_allotted_list.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "                                html.A(\n",
    "                                            'Ex-Servicemen Allotted List',\n",
    "                                            id='Ex-Servicemen Allotted List',\n",
    "                                            download=\"ex-servicemen_Allotted_List.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2019/ex-servicemen_Allotted_List.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "                                html.A(\n",
    "                                            'Differently Abled Allotted List',\n",
    "                                            download=\"differently_abled_allotted_list.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2019/differently_abled_allotted_list.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "                                html.A(\n",
    "                                            'Allotted List Round 1',\n",
    "                                            download=\"allotted_list_round_1.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2019/allotted_list_round_1.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "                                html.A(\n",
    "                                            'Allotted List Round 2',\n",
    "                                            download=\"allotted_list_round_2.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2019/allotted_list_round_2.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "    \n",
    "                                html.A(\n",
    "                                            'Allotted List Round 3',\n",
    "                                            download=\"allotted_list_round_3.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2019/allotted_list_round_3.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                      ),\n",
    "                                html.A(\n",
    "                                            'Allotted List Round 4',\n",
    "                                            download=\"allotted_list_round_4.pdf\",\n",
    "                                            href=app.get_asset_url('./pdf/2019/allotted_list_round_4.pdf'),\n",
    "                                            target=\"_blank\"\n",
    "                                        ),\n",
    "                            ])], type='cube', fullscreen=True)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Handle filter option for mark"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "@app.callback(\n",
    "            dash.dependencies.Output('mark_label', 'children'),\n",
    "            [dash.dependencies.Input('mark_filter', 'value')])\n",
    "def drop_down_value1(mark_filter_value):\n",
    "    mark_label = None\n",
    "    if mark_filter_value is not None:\n",
    "        mark_label = mark_filter_value\n",
    "    return mark_label"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Handle filter option for college"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "@app.callback(\n",
    "            dash.dependencies.Output('college_label', 'children'),\n",
    "            [dash.dependencies.Input('dropdown', 'value')])\n",
    "def drop_down_value1(dropdown_value):\n",
    "    college_name = None\n",
    "    if dropdown_value is not None:\n",
    "        college_name_df = alloted_list_df.loc[alloted_list_df['COLLEGE CODE'] == dropdown_value]\n",
    "        if college_name_df.shape[0] > 0:\n",
    "            college_name = college_name_df['COLL_NAME'].iloc[0]\n",
    "    return college_name"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Handle filter option for branch"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "@app.callback(\n",
    "            dash.dependencies.Output('branch_label', 'children'),\n",
    "            [dash.dependencies.Input('dropdown3', 'value')])\n",
    "def drop_down_value2(dropdown_value):\n",
    "    branch_name = []\n",
    "    if dropdown_value is not None:\n",
    "        branch_name_df = alloted_list_df.loc[alloted_list_df['BRANCH CODE'].isin(dropdown_value)]\n",
    "        if branch_name_df.shape[0] > 0:\n",
    "            branch_name = branch_name_df['BRANCH_NAME'].unique().tolist()\n",
    "    return ', '.join(branch_name)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Handle filter option for Community"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "@app.callback(\n",
    "            dash.dependencies.Output('community_label', 'children'),\n",
    "            [dash.dependencies.Input('dropdown2', 'value')])\n",
    "def drop_down_value3(dropdown_value):\n",
    "    return dropdown_value"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Update college code when college name is changed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "@app.callback(\n",
    "            dash.dependencies.Output('dropdown', 'value'),\n",
    "            [dash.dependencies.Input('dropdown5', 'value')])\n",
    "def drop_down_value4(dropdown_value):\n",
    "    if dropdown_value is not None:\n",
    "        college_code = alloted_list_df.loc[alloted_list_df['COLL_NAME'] == dropdown_value]['COLLEGE CODE'].iloc[0]\n",
    "        return college_code\n",
    "    else:\n",
    "        return None"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Update Branch codes when branch names are changed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "@app.callback(\n",
    "            dash.dependencies.Output('dropdown3', 'value'),\n",
    "            [dash.dependencies.Input('dropdown4', 'value'),\n",
    "            dash.dependencies.Input('dropdown4', 'options')])\n",
    "def drop_down_value5(dropdown_value,dropdown4_options):\n",
    "    if dropdown_value is not None:\n",
    "        dropdown4_list = []\n",
    "        for x in dropdown4_options:\n",
    "            dropdown4_list.append(x['value'])\n",
    "        dropdown_value = list(set(dropdown_value) & set(dropdown4_list))\n",
    "        if len(dropdown_value)>0:\n",
    "            branch_code = alloted_list_df.loc[alloted_list_df['BRANCH_NAME'].isin(dropdown_value)]['BRANCH CODE'].unique().tolist()\n",
    "            return branch_code\n",
    "        else:\n",
    "            return None\n",
    "    else:\n",
    "        return None\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# List branch codes that are available in the selected college"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "@app.callback(\n",
    "            dash.dependencies.Output('dropdown3', 'options'),\n",
    "            [dash.dependencies.Input('dropdown', 'value')])\n",
    "def drop_down3_options(dropdown_value):\n",
    "    \n",
    "    if dropdown_value is not None:\n",
    "        filtered_df = alloted_list_df.loc[alloted_list_df['COLLEGE CODE'] == dropdown_value]\n",
    "        options=[\n",
    "                {\"label\": i, \"value\": i} for i in sorted(filtered_df['BRANCH CODE'].unique())\n",
    "            ]\n",
    "        \n",
    "        return options\n",
    "    else:\n",
    "        options=[\n",
    "                    {\"label\": i, \"value\": i} for i in sorted(alloted_list_df['BRANCH CODE'].unique())\n",
    "                ]\n",
    "        return options\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# List branch names that are available in the selected college"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "@app.callback(\n",
    "            dash.dependencies.Output('dropdown4', 'options'),\n",
    "            [dash.dependencies.Input('dropdown', 'value')])\n",
    "def drop_down4_options(dropdown_value):\n",
    "    if dropdown_value is not None:\n",
    "        filtered_df = alloted_list_df.loc[alloted_list_df['COLLEGE CODE'] == dropdown_value]\n",
    "        options=[\n",
    "                {\"label\": i, \"value\": i} for i in sorted(filtered_df['BRANCH_NAME'].unique())\n",
    "            ]\n",
    "        \n",
    "        return options\n",
    "    else:\n",
    "        options=[\n",
    "                    {\"label\": i, \"value\": i} for i in sorted(alloted_list_df['BRANCH_NAME'].unique())\n",
    "                ]\n",
    "        return options\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Update plotly data-table based on the filtered options"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "@app.callback(\n",
    "            dash.dependencies.Output('table-container', 'children'),\n",
    "            [dash.dependencies.Input('dropdown', 'value'),\n",
    "             dash.dependencies.Input('dropdown2', 'value'),\n",
    "             dash.dependencies.Input('dropdown3', 'value'),\n",
    "             dash.dependencies.Input('radio_button', 'value'),\n",
    "             dash.dependencies.Input('radio_button_year', 'value'),\n",
    "             dash.dependencies.Input('mark_filter', 'value'),\n",
    "            ])\n",
    "def display_table(dropdown_value,dropdown_value2,dropdown_value3,radio_button_value,radio_button_year_value,mark_filter_value):\n",
    "    \n",
    "    if radio_button_year_value == \"2020\":\n",
    "        filtered_df = alloted_list_df_20\n",
    "    else:\n",
    "        filtered_df = alloted_list_df_19\n",
    "        \n",
    "    if mark_filter_value is not None:\n",
    "        filtered_df = filtered_df.loc[filtered_df['AGGR MARK'] <= mark_filter_value]\n",
    "    if dropdown_value is not None:\n",
    "        filtered_df = filtered_df.loc[filtered_df['COLLEGE CODE'] == dropdown_value]\n",
    "    if dropdown_value2 is not None:\n",
    "        filtered_df = filtered_df.loc[filtered_df['ALLOTTED CATEGORY'] == dropdown_value2]\n",
    "    if dropdown_value3 is not None:\n",
    "        #filtered_df = filtered_df.loc[filtered_df['BRANCH CODE'] == dropdown_value3]\n",
    "        if len(dropdown_value3) > 0:\n",
    "            filtered_df = filtered_df.loc[filtered_df['BRANCH CODE'].isin(dropdown_value3)]\n",
    "        \n",
    "    if radio_button_value == \"Cut Off Marks\":\n",
    "        filtered_df[\"OVER ALL RANK\"] = pd.to_numeric(filtered_df[\"OVER ALL RANK\"], errors='coerce')\n",
    "        #print(filtered_df.shape,filtered_df['OVER ALL RANK'].isna().sum())\n",
    "        \n",
    "        filtered_df = filtered_df.loc[filtered_df.groupby([\"COLLEGE CODE\",\"ALLOTTED CATEGORY\",\"BRANCH CODE\"])[\"OVER ALL RANK\"].idxmax()]\n",
    "        #filtered_df.reset_index(drop=True, inplace=True)\n",
    "        #filtered_df[\"OVER ALL RANK\"] = filtered_df['OVER ALL RANK'].astype(int)\n",
    "        #filtered_df[\"OVER ALL RANK\"] = pd.to_numeric(filtered_df[\"OVER ALL RANK\"], errors='coerce')\n",
    "        filtered_df = filtered_df.sort_values(by=['OVER ALL RANK'],ascending=True)\n",
    "        '''\n",
    "        filtered_df = filtered_df.drop_duplicates(subset =[\"COLLEGE CODE\",\"ALLOTTED CATEGORY\",\"BRANCH CODE\"], \n",
    "                                         keep = \"last\", \n",
    "                                         inplace = False)\n",
    "        '''\n",
    "        #print(filtered_df)\n",
    "        if dropdown_value2 == 'OC':\n",
    "            filtered_df = filtered_df[['COLLEGE CODE','COLL_NAME',\n",
    "               #'COMMUNITY',\n",
    "                                   \n",
    "                                   'BRANCH CODE', 'BRANCH_NAME',\n",
    "                                       'ALLOTTED CATEGORY',\n",
    "                                   'OVER ALL RANK', \n",
    "                                   #'COMMUNITY RANK', \n",
    "                                   'AGGR MARK','COUNSELLING ROUND']]\n",
    "        else:\n",
    "            filtered_df = filtered_df[['COLLEGE CODE','COLL_NAME',\n",
    "                                       'BRANCH CODE', 'BRANCH_NAME',\n",
    "                                       'ALLOTTED CATEGORY',\n",
    "                                       'OVER ALL RANK', 'COMMUNITY RANK', \n",
    "                                       'AGGR MARK','COUNSELLING ROUND']]\n",
    "        filtered_df.rename({'ALLOTTED CATEGORY': 'COMMUNITY'}, axis=1, inplace=True)\n",
    "    else:\n",
    "        filtered_df[\"OVER ALL RANK\"] = pd.to_numeric(filtered_df[\"OVER ALL RANK\"], errors='coerce')\n",
    "        filtered_df = filtered_df.sort_values(by=['OVER ALL RANK'],ascending=True)\n",
    "        if radio_button_year_value == \"2020\":\n",
    "            filtered_df = filtered_df[['APP NO',\n",
    "                                       'NAME OF THE CANDIDATE',\n",
    "                                       'COLLEGE CODE','COLL_NAME',\n",
    "                                       'BRANCH CODE', 'BRANCH_NAME',\n",
    "                                       'COMMUNITY','ALLOTTED CATEGORY',\n",
    "                                       'OVER ALL RANK', 'COMMUNITY RANK', \n",
    "                                        'AGGR MARK','COUNSELLING ROUND']]\n",
    "        else:\n",
    "            filtered_df = filtered_df[['APP NO',\n",
    "                                       #'NAME OF THE CANDIDATE',\n",
    "                                       'COLLEGE CODE','COLL_NAME',\n",
    "                                       'BRANCH CODE', 'BRANCH_NAME',\n",
    "                                       'COMMUNITY','ALLOTTED CATEGORY',\n",
    "                                       'OVER ALL RANK', 'COMMUNITY RANK', \n",
    "                                        'AGGR MARK','COUNSELLING ROUND']]\n",
    "        \n",
    "        \n",
    "        \n",
    "\n",
    "    #print(dropdown_value,dropdown_value2,dropdown_value3,radio_button_value)\n",
    "    #print(filtered_df.shape,alloted_list_df.shape)\n",
    "    filtered_df.rename({'AGGR MARK': 'CUT OFF MARK'}, axis=1, inplace=True)\n",
    "    return generate_plotly_data_table(filtered_df,radio_button_value,radio_button_year_value)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Start the app"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "if __name__ == '__main__':\n",
    "    app.run_server(debug=False,threaded=True,port=9007)"
   ]
  },
  {
   "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.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}