gen_abstract_htmls_final.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from datetime import timedelta\n",
    "from ics import Calendar,Event "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Timestamp', 'Session', 'Start Date', 'Start Time', 'End Date',\n",
       "       'End Time', 'Type', 'Presenter', 'Email Address',\n",
       "       'Presenter's Full Name ', 'Presenter's Affiliation', 'CDP/FIU/Remote',\n",
       "       'Do you wish to attend the workshop on manuscript writing during the conference? (Priority will be given to PhD students).',\n",
       "       'Co-authors ', 'Email of all Co-authors (separated by (;))',\n",
       "       'Affiliation of all Co-authors (separated by (;))',\n",
       "       'I have a supervisor for this project.', 'Supervisor's Full Name (s)',\n",
       "       'Supervisor's Email Address. Please enter multiple ones separated by a semicolon  ; ',\n",
       "       'Supervisor's Affiliation(s)',\n",
       "       'My supervisor(s) and all co-authors (if any) have reviewed and approved the abstract to be submitted.',\n",
       "       'I agree my abstract to be included in the ANPA abstract booklet. ',\n",
       "       'I would like to receive certificate of participation for my record.',\n",
       "       'Please choose the most appropriate session your abstract should be considered for:',\n",
       "       'Presentation Title', 'Abstract',\n",
       "       'Do you intend to submit a manuscript based on this presentation for publication in a special issue of Journal of Nepal Physical Society?',\n",
       "       'The standard format for the contributed papers is 12+3 minutes long oral presentation. Would you be interested in a shorter, 5-min flash talk if available?',\n",
       "       'I understand that once I submit this form, I will not be able to edit the entries. If any change is needed, I will resubmit and email ANPA (events@anpaglobal.org) to get the previous submission removed.  ',\n",
       "       'Corresponding Author's Email (if different than the person who is submitting the abstract.)',\n",
       "       'Invited', 'abstract_id'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_excel(\"abstracts_2023.xlsx\")\n",
    "## Assign AbstractID\n",
    "df['abstract_id'] = ['ANPA2023-N000'+str(x) for x in range(1,len(df)+1)]\n",
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>Session</th>\n",
       "      <th>Start Date</th>\n",
       "      <th>Start Time</th>\n",
       "      <th>End Date</th>\n",
       "      <th>abstract_id</th>\n",
       "      <th>End Time</th>\n",
       "      <th>Type</th>\n",
       "      <th>Presenter</th>\n",
       "      <th>Email Address</th>\n",
       "      <th>Co-authors</th>\n",
       "      <th>Affiliation of all Co-authors (separated by (;))</th>\n",
       "      <th>Presenter's Full Name</th>\n",
       "      <th>Presenter's Affiliation</th>\n",
       "      <th>CDP/FIU/Remote</th>\n",
       "      <th>Presentation Title</th>\n",
       "      <th>Abstract</th>\n",
       "      <th>Invited</th>\n",
       "      <th>Please choose the most appropriate session your abstract should be considered for:</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>07:00:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0001</td>\n",
       "      <td>07:15:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Sujan Bhandari</td>\n",
       "      <td>sujannbhandari@gmail.com</td>\n",
       "      <td>Kirti Bir Rajguru ; Chhabi Lal Gnawali ; Bhadr...</td>\n",
       "      <td>Department of Applied Sciences and Chemical En...</td>\n",
       "      <td>Sujan Bhandari</td>\n",
       "      <td>Central Department of Physics</td>\n",
       "      <td>Central Department of Physics, T.U., Nepal</td>\n",
       "      <td>Comparative study of preparation and character...</td>\n",
       "      <td>Phosporic Acid (H_3PO_4) can be used to activa...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>07:45:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0002</td>\n",
       "      <td>08:00:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Keshab Pandey</td>\n",
       "      <td>keshavpandey48@gmail.com</td>\n",
       "      <td>Professor Hae Kyung Jeong</td>\n",
       "      <td>aDepartment of Physics, Daegu University, Gyeo...</td>\n",
       "      <td>Keshab Pandey</td>\n",
       "      <td>Department of Physics, Daegu University, Gyeon...</td>\n",
       "      <td>Central Department of Physics, T.U., Nepal</td>\n",
       "      <td>Synthesis of Tungsten Disulfide for Electroche...</td>\n",
       "      <td>Transition metal dichalcogenides, such as tung...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>16:15:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0003</td>\n",
       "      <td>16:30:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Trailokya Bhattarai</td>\n",
       "      <td>tbhattar@uncc.edu</td>\n",
       "      <td>M. Yasin Akhtar Raja; Abasifreke Ebong</td>\n",
       "      <td>UNC Charlotte</td>\n",
       "      <td>Trailokya Bhattarai</td>\n",
       "      <td>UNC Charlotte</td>\n",
       "      <td>Florida International University, FL, USA</td>\n",
       "      <td>Cost-effective III-Nitride Quantum Wells-Based...</td>\n",
       "      <td>Title: Cost-effective III-Nitride Quantum Well...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0004</td>\n",
       "      <td>12:15:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Bibandhan Poudyal</td>\n",
       "      <td>bpoudyal@ur.rochester.edu</td>\n",
       "      <td>Gourab Ghoshal ; Alec Kirkley</td>\n",
       "      <td>University of Rochester ; University of Hong Kong</td>\n",
       "      <td>Bibandhan Poudyal</td>\n",
       "      <td>University of Rochester</td>\n",
       "      <td>Florida International University, FL, USA</td>\n",
       "      <td>Measuring the Directness of Accessibility to C...</td>\n",
       "      <td>Accessibility in general is an abstract concep...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>20:45:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0005</td>\n",
       "      <td>21:15:00</td>\n",
       "      <td>Invited</td>\n",
       "      <td>Tara Dhakal</td>\n",
       "      <td>tdhakal@binghamton.edu</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tara Dhakal</td>\n",
       "      <td>Electrical and Computer Engineering Department...</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Pseudocapacitive Manganese Oxide/Carbon Nanotu...</td>\n",
       "      <td>In recent years, supercapacitors are fetching ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Session Start Date Start Time   End Date  \\\n",
       "0  Applied and Engineering Physics 2023-07-15   07:00:00 2023-07-15   \n",
       "1  Applied and Engineering Physics 2023-07-15   07:45:00 2023-07-15   \n",
       "2  Applied and Engineering Physics 2023-07-15   16:15:00 2023-07-15   \n",
       "3  Applied and Engineering Physics 2023-07-15   12:00:00 2023-07-15   \n",
       "4  Applied and Engineering Physics 2023-07-15   20:45:00 2023-07-15   \n",
       "\n",
       "      abstract_id  End Time         Type            Presenter  \\\n",
       "0  ANPA2023-N0001  07:15:00  Contributed       Sujan Bhandari   \n",
       "1  ANPA2023-N0002  08:00:00  Contributed        Keshab Pandey   \n",
       "2  ANPA2023-N0003  16:30:00  Contributed  Trailokya Bhattarai   \n",
       "3  ANPA2023-N0004  12:15:00  Contributed    Bibandhan Poudyal   \n",
       "4  ANPA2023-N0005  21:15:00      Invited          Tara Dhakal   \n",
       "\n",
       "               Email Address  \\\n",
       "0   sujannbhandari@gmail.com   \n",
       "1   keshavpandey48@gmail.com   \n",
       "2          tbhattar@uncc.edu   \n",
       "3  bpoudyal@ur.rochester.edu   \n",
       "4    tdhakal@binghamton.edu    \n",
       "\n",
       "                                         Co-authors   \\\n",
       "0  Kirti Bir Rajguru ; Chhabi Lal Gnawali ; Bhadr...   \n",
       "1                          Professor Hae Kyung Jeong   \n",
       "2             M. Yasin Akhtar Raja; Abasifreke Ebong   \n",
       "3                      Gourab Ghoshal ; Alec Kirkley   \n",
       "4                                                NaN   \n",
       "\n",
       "    Affiliation of all Co-authors (separated by (;)) Presenter's Full Name   \\\n",
       "0  Department of Applied Sciences and Chemical En...         Sujan Bhandari   \n",
       "1  aDepartment of Physics, Daegu University, Gyeo...          Keshab Pandey   \n",
       "2                                      UNC Charlotte    Trailokya Bhattarai   \n",
       "3  University of Rochester ; University of Hong Kong      Bibandhan Poudyal   \n",
       "4                                                NaN            Tara Dhakal   \n",
       "\n",
       "                             Presenter's Affiliation  \\\n",
       "0                      Central Department of Physics   \n",
       "1  Department of Physics, Daegu University, Gyeon...   \n",
       "2                                      UNC Charlotte   \n",
       "3                            University of Rochester   \n",
       "4  Electrical and Computer Engineering Department...   \n",
       "\n",
       "                               CDP/FIU/Remote  \\\n",
       "0  Central Department of Physics, T.U., Nepal   \n",
       "1  Central Department of Physics, T.U., Nepal   \n",
       "2   Florida International University, FL, USA   \n",
       "3   Florida International University, FL, USA   \n",
       "4                                      Remote   \n",
       "\n",
       "                                  Presentation Title  \\\n",
       "0  Comparative study of preparation and character...   \n",
       "1  Synthesis of Tungsten Disulfide for Electroche...   \n",
       "2  Cost-effective III-Nitride Quantum Wells-Based...   \n",
       "3  Measuring the Directness of Accessibility to C...   \n",
       "4  Pseudocapacitive Manganese Oxide/Carbon Nanotu...   \n",
       "\n",
       "                                            Abstract  Invited  \\\n",
       "0  Phosporic Acid (H_3PO_4) can be used to activa...        0   \n",
       "1  Transition metal dichalcogenides, such as tung...        0   \n",
       "2  Title: Cost-effective III-Nitride Quantum Well...        0   \n",
       "3  Accessibility in general is an abstract concep...        0   \n",
       "4  In recent years, supercapacitors are fetching ...        1   \n",
       "\n",
       "  Please choose the most appropriate session your abstract should be considered for:  \n",
       "0                    Applied and Engineering Physics                                  \n",
       "1                    Applied and Engineering Physics                                  \n",
       "2                    Applied and Engineering Physics                                  \n",
       "3                    Applied and Engineering Physics                                  \n",
       "4                    Applied and Engineering Physics                                  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cols_needed = ['Session', 'Start Date', 'Start Time', 'End Date','abstract_id',\n",
    "       'End Time', 'Type', 'Presenter', 'Email Address','Co-authors ',\"Affiliation of all Co-authors (separated by (;))\",\n",
    "       \"Presenter's Full Name \", \"Presenter's Affiliation\", 'CDP/FIU/Remote','Presentation Title', 'Abstract','Invited','Please choose the most appropriate session your abstract should be considered for:']\n",
    "df = df[cols_needed]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(95, 18)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Session</th>\n",
       "      <th>Start Date</th>\n",
       "      <th>Start Time</th>\n",
       "      <th>End Date</th>\n",
       "      <th>abstract_id</th>\n",
       "      <th>End Time</th>\n",
       "      <th>Type</th>\n",
       "      <th>Presenter</th>\n",
       "      <th>Email Address</th>\n",
       "      <th>Co-authors</th>\n",
       "      <th>Affiliation of all Co-authors (separated by (;))</th>\n",
       "      <th>Presenter's Full Name</th>\n",
       "      <th>Presenter's Affiliation</th>\n",
       "      <th>CDP/FIU/Remote</th>\n",
       "      <th>Presentation Title</th>\n",
       "      <th>Abstract</th>\n",
       "      <th>Invited</th>\n",
       "      <th>Please choose the most appropriate session your abstract should be considered for:</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>07:00:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0001</td>\n",
       "      <td>07:15:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Sujan Bhandari</td>\n",
       "      <td>sujannbhandari@gmail.com</td>\n",
       "      <td>Kirti Bir Rajguru ; Chhabi Lal Gnawali ; Bhadr...</td>\n",
       "      <td>Department of Applied Sciences and Chemical En...</td>\n",
       "      <td>Sujan Bhandari</td>\n",
       "      <td>Central Department of Physics</td>\n",
       "      <td>Central Department of Physics, T.U., Nepal</td>\n",
       "      <td>Comparative study of preparation and character...</td>\n",
       "      <td>Phosporic Acid (H_3PO_4) can be used to activa...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Session Start Date Start Time   End Date  \\\n",
       "0  Applied and Engineering Physics 2023-07-15   07:00:00 2023-07-15   \n",
       "\n",
       "      abstract_id  End Time         Type       Presenter  \\\n",
       "0  ANPA2023-N0001  07:15:00  Contributed  Sujan Bhandari   \n",
       "\n",
       "              Email Address  \\\n",
       "0  sujannbhandari@gmail.com   \n",
       "\n",
       "                                         Co-authors   \\\n",
       "0  Kirti Bir Rajguru ; Chhabi Lal Gnawali ; Bhadr...   \n",
       "\n",
       "    Affiliation of all Co-authors (separated by (;)) Presenter's Full Name   \\\n",
       "0  Department of Applied Sciences and Chemical En...         Sujan Bhandari   \n",
       "\n",
       "         Presenter's Affiliation                              CDP/FIU/Remote  \\\n",
       "0  Central Department of Physics  Central Department of Physics, T.U., Nepal   \n",
       "\n",
       "                                  Presentation Title  \\\n",
       "0  Comparative study of preparation and character...   \n",
       "\n",
       "                                            Abstract  Invited  \\\n",
       "0  Phosporic Acid (H_3PO_4) can be used to activa...        0   \n",
       "\n",
       "  Please choose the most appropriate session your abstract should be considered for:  \n",
       "0                    Applied and Engineering Physics                                  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "col_mapping = {\n",
    "    'Presentation Title':'presentation_title',\n",
    "    \"Presenter's Full Name \":'author_name',\n",
    "    \"Presenter's Affiliation\":'author_aff',\n",
    "    \"Co-authors \":'coauthor_names',\n",
    "    \"Affiliation of all Co-authors (separated by (;))\":'coauthor_affiliations',\n",
    "    \"Abstract\":\"abstract_text\",\n",
    "    'Please choose the most appropriate session your abstract should be considered for:':\"division\",\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Session</th>\n",
       "      <th>Start Date</th>\n",
       "      <th>Start Time</th>\n",
       "      <th>End Date</th>\n",
       "      <th>abstract_id</th>\n",
       "      <th>End Time</th>\n",
       "      <th>Type</th>\n",
       "      <th>Presenter</th>\n",
       "      <th>Email Address</th>\n",
       "      <th>coauthor_names</th>\n",
       "      <th>coauthor_affiliations</th>\n",
       "      <th>author_name</th>\n",
       "      <th>author_aff</th>\n",
       "      <th>CDP/FIU/Remote</th>\n",
       "      <th>presentation_title</th>\n",
       "      <th>abstract_text</th>\n",
       "      <th>Invited</th>\n",
       "      <th>division</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>07:00:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0001</td>\n",
       "      <td>07:15:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Sujan Bhandari</td>\n",
       "      <td>sujannbhandari@gmail.com</td>\n",
       "      <td>Kirti Bir Rajguru ; Chhabi Lal Gnawali ; Bhadr...</td>\n",
       "      <td>Department of Applied Sciences and Chemical En...</td>\n",
       "      <td>Sujan Bhandari</td>\n",
       "      <td>Central Department of Physics</td>\n",
       "      <td>Central Department of Physics, T.U., Nepal</td>\n",
       "      <td>Comparative study of preparation and character...</td>\n",
       "      <td>Phosporic Acid (H_3PO_4) can be used to activa...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>07:45:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0002</td>\n",
       "      <td>08:00:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Keshab Pandey</td>\n",
       "      <td>keshavpandey48@gmail.com</td>\n",
       "      <td>Professor Hae Kyung Jeong</td>\n",
       "      <td>aDepartment of Physics, Daegu University, Gyeo...</td>\n",
       "      <td>Keshab Pandey</td>\n",
       "      <td>Department of Physics, Daegu University, Gyeon...</td>\n",
       "      <td>Central Department of Physics, T.U., Nepal</td>\n",
       "      <td>Synthesis of Tungsten Disulfide for Electroche...</td>\n",
       "      <td>Transition metal dichalcogenides, such as tung...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>16:15:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0003</td>\n",
       "      <td>16:30:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Trailokya Bhattarai</td>\n",
       "      <td>tbhattar@uncc.edu</td>\n",
       "      <td>M. Yasin Akhtar Raja; Abasifreke Ebong</td>\n",
       "      <td>UNC Charlotte</td>\n",
       "      <td>Trailokya Bhattarai</td>\n",
       "      <td>UNC Charlotte</td>\n",
       "      <td>Florida International University, FL, USA</td>\n",
       "      <td>Cost-effective III-Nitride Quantum Wells-Based...</td>\n",
       "      <td>Title: Cost-effective III-Nitride Quantum Well...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0004</td>\n",
       "      <td>12:15:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Bibandhan Poudyal</td>\n",
       "      <td>bpoudyal@ur.rochester.edu</td>\n",
       "      <td>Gourab Ghoshal ; Alec Kirkley</td>\n",
       "      <td>University of Rochester ; University of Hong Kong</td>\n",
       "      <td>Bibandhan Poudyal</td>\n",
       "      <td>University of Rochester</td>\n",
       "      <td>Florida International University, FL, USA</td>\n",
       "      <td>Measuring the Directness of Accessibility to C...</td>\n",
       "      <td>Accessibility in general is an abstract concep...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>20:45:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0005</td>\n",
       "      <td>21:15:00</td>\n",
       "      <td>Invited</td>\n",
       "      <td>Tara Dhakal</td>\n",
       "      <td>tdhakal@binghamton.edu</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Tara Dhakal</td>\n",
       "      <td>Electrical and Computer Engineering Department...</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Pseudocapacitive Manganese Oxide/Carbon Nanotu...</td>\n",
       "      <td>In recent years, supercapacitors are fetching ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Session Start Date Start Time   End Date  \\\n",
       "0  Applied and Engineering Physics 2023-07-15   07:00:00 2023-07-15   \n",
       "1  Applied and Engineering Physics 2023-07-15   07:45:00 2023-07-15   \n",
       "2  Applied and Engineering Physics 2023-07-15   16:15:00 2023-07-15   \n",
       "3  Applied and Engineering Physics 2023-07-15   12:00:00 2023-07-15   \n",
       "4  Applied and Engineering Physics 2023-07-15   20:45:00 2023-07-15   \n",
       "\n",
       "      abstract_id  End Time         Type            Presenter  \\\n",
       "0  ANPA2023-N0001  07:15:00  Contributed       Sujan Bhandari   \n",
       "1  ANPA2023-N0002  08:00:00  Contributed        Keshab Pandey   \n",
       "2  ANPA2023-N0003  16:30:00  Contributed  Trailokya Bhattarai   \n",
       "3  ANPA2023-N0004  12:15:00  Contributed    Bibandhan Poudyal   \n",
       "4  ANPA2023-N0005  21:15:00      Invited          Tara Dhakal   \n",
       "\n",
       "               Email Address  \\\n",
       "0   sujannbhandari@gmail.com   \n",
       "1   keshavpandey48@gmail.com   \n",
       "2          tbhattar@uncc.edu   \n",
       "3  bpoudyal@ur.rochester.edu   \n",
       "4    tdhakal@binghamton.edu    \n",
       "\n",
       "                                      coauthor_names  \\\n",
       "0  Kirti Bir Rajguru ; Chhabi Lal Gnawali ; Bhadr...   \n",
       "1                          Professor Hae Kyung Jeong   \n",
       "2             M. Yasin Akhtar Raja; Abasifreke Ebong   \n",
       "3                      Gourab Ghoshal ; Alec Kirkley   \n",
       "4                                                      \n",
       "\n",
       "                               coauthor_affiliations          author_name  \\\n",
       "0  Department of Applied Sciences and Chemical En...       Sujan Bhandari   \n",
       "1  aDepartment of Physics, Daegu University, Gyeo...        Keshab Pandey   \n",
       "2                                      UNC Charlotte  Trailokya Bhattarai   \n",
       "3  University of Rochester ; University of Hong Kong    Bibandhan Poudyal   \n",
       "4                                                             Tara Dhakal   \n",
       "\n",
       "                                          author_aff  \\\n",
       "0                      Central Department of Physics   \n",
       "1  Department of Physics, Daegu University, Gyeon...   \n",
       "2                                      UNC Charlotte   \n",
       "3                            University of Rochester   \n",
       "4  Electrical and Computer Engineering Department...   \n",
       "\n",
       "                               CDP/FIU/Remote  \\\n",
       "0  Central Department of Physics, T.U., Nepal   \n",
       "1  Central Department of Physics, T.U., Nepal   \n",
       "2   Florida International University, FL, USA   \n",
       "3   Florida International University, FL, USA   \n",
       "4                                      Remote   \n",
       "\n",
       "                                  presentation_title  \\\n",
       "0  Comparative study of preparation and character...   \n",
       "1  Synthesis of Tungsten Disulfide for Electroche...   \n",
       "2  Cost-effective III-Nitride Quantum Wells-Based...   \n",
       "3  Measuring the Directness of Accessibility to C...   \n",
       "4  Pseudocapacitive Manganese Oxide/Carbon Nanotu...   \n",
       "\n",
       "                                       abstract_text  Invited  \\\n",
       "0  Phosporic Acid (H_3PO_4) can be used to activa...        0   \n",
       "1  Transition metal dichalcogenides, such as tung...        0   \n",
       "2  Title: Cost-effective III-Nitride Quantum Well...        0   \n",
       "3  Accessibility in general is an abstract concep...        0   \n",
       "4  In recent years, supercapacitors are fetching ...        1   \n",
       "\n",
       "                          division  \n",
       "0  Applied and Engineering Physics  \n",
       "1  Applied and Engineering Physics  \n",
       "2  Applied and Engineering Physics  \n",
       "3  Applied and Engineering Physics  \n",
       "4  Applied and Engineering Physics  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.rename(columns=col_mapping)\n",
    "#df  = df.astype(str)\n",
    "df[['coauthor_names','coauthor_affiliations']] = df[['coauthor_names','coauthor_affiliations']].fillna(\" \")\n",
    "df.head(5)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Generate individual HTML files for SFTP server"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "def single_function_html_v2(abstract_id, presentation_title, author_name, author_aff,\n",
    "                          coauthor_names,coauthor_affiliations, abstract_text, Division, year):\n",
    "    \n",
    "    name_list = coauthor_names.split(';')\n",
    "    name_list.insert(0,author_name)\n",
    "    aff_list = coauthor_affiliations.split(';') \n",
    "    aff_list.insert(0,author_aff)\n",
    "    max_len = max(len(name_list),len(aff_list))\n",
    "    name_list_new = name_list +[\" \"]*(max_len -len(name_list))\n",
    "    aff_list_new = aff_list +[\" \"]*(max_len -len(aff_list))\n",
    "\n",
    "    str1 = f\"\"\"\n",
    "    <body>\n",
    "    <main class=\"container\">\n",
    "    <div class=\"row\">\n",
    "      <div class=\"col mt-5\">\n",
    "            <h2>Bulletin of ANPA </h2>\n",
    "            <h3>Abstract submitted to ANPA Conference July 14&#8211;16, {year}</h3>\n",
    "            <h3>Volume 5, Number 1</h3>\n",
    "                <h5>{Division}</h5>\n",
    "                <h6>Abstract ID: {abstract_id}</h6>\n",
    "                <h4 class=\"mt-4\">Abstract:</h4>\n",
    "        <p>\n",
    "                <span title=\"{abstract_id}\">{abstract_id}: </span>\n",
    "                {presentation_title}\n",
    "                </p>\n",
    "            <h4 class=\"mt-4\">Authors:</h4>\n",
    "    \"\"\"\n",
    "    str2 =[]\n",
    "    for name,aff in zip(name_list_new,aff_list_new):\n",
    "        if (name!=\" \") or (aff!=\" \"):\n",
    "            str2.append(f\"\"\"\n",
    "        <ul>\n",
    "            <li>{name}; {aff}</li>\n",
    "        </ul>           \n",
    "    \"\"\")\n",
    "        \n",
    "    str3 = f\"\"\"\n",
    "    <p class=\"my-4\">\n",
    "            {abstract_text}\n",
    "            </p>\n",
    "    <p><small>To cite this abstract, use the following reference: https://anpaglobal.org/conference/{year}/{abstract_id}</small></p>\n",
    "                </div>\n",
    "            </div>     \n",
    "        </main>\n",
    "    </body>\n",
    "    </html>\"\"\"\n",
    "\n",
    "    str4 = f\"\"\"\n",
    "    <!DOCTYPE html>\n",
    "    <html lang=\"en\">\n",
    "\n",
    "    <head>\n",
    "        <meta charset=\"UTF-8\">\n",
    "        <title>ANPA Conference {year} - {str(presentation_title)} </title>\n",
    "        <meta name=\"citation_conference\" content=\"Abstract submitted to ANPA Conference 2023\">\n",
    "        <meta name=\"citation_publisher\" content=\"Association of Nepali Physicists in America\">\n",
    "\n",
    "        <meta name=\"citation_title\" content={str(presentation_title)}>\n",
    "        <meta name=\"citation_author\" content={str(author_name)}>\n",
    "    \"\"\"\n",
    "    str5 = []\n",
    "    for name in name_list:\n",
    "        str5.append(f\"\"\" \n",
    "        <meta name=\"citation_author\" content={str(name)}>\n",
    "        \"\"\")\n",
    "        \n",
    "    str6 = f\"\"\"\n",
    "        <meta name=\"citation_publication_date\" content=\"{year}/07/14\">\n",
    "        <meta name=\"citation_conference_title\" content=\"Proceedings of ANPA Conference {year}\">\n",
    "        <meta name=\"citation_volume\" content=\"{year}\">\n",
    "        <meta name=\"citation_issue\" content=\"1\">\n",
    "        <meta name=\"citation_pdf_url\" content=\"https://www.anpaglobal.org/conferences/{year}/abstract_booklet_full.pdf\">\n",
    "        \n",
    "        <link rel=\"stylesheet\" href=\"https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css\">\n",
    "        <link rel=\"icon\" href=\"https://anpaglobal.org/wp-content/uploads/2021/05/favicon.ico\" type=\"image/x-icon\">\n",
    "  </head>\n",
    "           \"\"\"\n",
    "    \n",
    "    return \" \".join([str4, ''.join(str5), str6,\n",
    "                     str1,''.join(str2), str3]\n",
    "                     )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Session                                    Applied and Engineering Physics\n",
       "Start Date                                             2023-07-15 00:00:00\n",
       "Start Time                                                        16:15:00\n",
       "End Date                                               2023-07-15 00:00:00\n",
       "abstract_id                                                 ANPA2023-N0003\n",
       "End Time                                                          16:30:00\n",
       "Type                                                           Contributed\n",
       "Presenter                                              Trailokya Bhattarai\n",
       "Email Address                                            tbhattar@uncc.edu\n",
       "coauthor_names                      M. Yasin Akhtar Raja; Abasifreke Ebong\n",
       "coauthor_affiliations                                        UNC Charlotte\n",
       "author_name                                            Trailokya Bhattarai\n",
       "author_aff                                                   UNC Charlotte\n",
       "CDP/FIU/Remote                   Florida International University, FL, USA\n",
       "presentation_title       Cost-effective III-Nitride Quantum Wells-Based...\n",
       "abstract_text            Title: Cost-effective III-Nitride Quantum Well...\n",
       "Invited                                                                  0\n",
       "division                                   Applied and Engineering Physics\n",
       "Name: 2, dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test = df.loc[2]\n",
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# filename_str = test['abstract_id']\n",
    "# with open(f'./html_collections/{filename_str}.html', 'w') as f:\n",
    "#     print(single_function_html_v2(abstract_id=test['abstract_id'], \n",
    "#                      presentation_title= test['presentation_title'], \n",
    "#                      author_name=test['author_name'], \n",
    "#                      author_aff=test[\"author_aff\"],\n",
    "#                      coauthor_names=test[\"coauthor_names\"],\n",
    "#                      coauthor_affiliations=test[\"coauthor_affiliations\"], \n",
    "#                      abstract_text=test['abstract_text'],\n",
    "#                      Division = test[\"division\"],\n",
    "#              year=2023), \n",
    "#           file=f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(df)):\n",
    "    test = df.loc[i]\n",
    "    filename_str = test['abstract_id']\n",
    "    with open(f'./html_collections/{filename_str}.html', 'w') as f:\n",
    "        print(single_function_html_v2(abstract_id=test['abstract_id'], \n",
    "                        presentation_title= test['presentation_title'], \n",
    "                        author_name=test['author_name'], \n",
    "                        author_aff=test[\"author_aff\"],\n",
    "                        coauthor_names=test[\"coauthor_names\"],\n",
    "                        coauthor_affiliations=test[\"coauthor_affiliations\"], \n",
    "                        abstract_text=test['abstract_text'],\n",
    "                        Division = test[\"division\"],\n",
    "                year=2023), \n",
    "            file=f)\n",
    "    \n",
    "    "
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Generate HTML for individual Symposia Page"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Session', 'Start Date', 'Start Time', 'End Date', 'abstract_id',\n",
       "       'End Time', 'Type', 'Presenter', 'Email Address', 'coauthor_names',\n",
       "       'coauthor_affiliations', 'author_name', 'author_aff', 'CDP/FIU/Remote',\n",
       "       'presentation_title', 'abstract_text', 'Invited', 'division'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Remote                                        50\n",
       "Central Department of Physics, T.U., Nepal    26\n",
       "Florida International University, FL, USA     19\n",
       "Name: CDP/FIU/Remote, dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['CDP/FIU/Remote'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Contributed        78\n",
       "Invited            12\n",
       "Plenary             2\n",
       "Special Session     2\n",
       "KeyNote             1\n",
       "Name: Type, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Type'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Date'] = df['Start Date']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Condensed Matter Physics and Material Science               32\n",
       "Biological, Medical, Soft Matter and Chemical Physics       19\n",
       "Astronomy /Space Science /Cosmo Science/ Atmospheric        10\n",
       "Atomic, Molecular, Optical and Plasma Physics               10\n",
       "Data Science, Quantum Computing, Artificial Intelligence     6\n",
       "High Energy, Particle, and Nuclear Physics                   6\n",
       "Applied and Engineering Physics                              5\n",
       "Physics Education Research                                   4\n",
       "Special Session                                              2\n",
       "Key Note                                                     1\n",
       "Name: division, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.division.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    78\n",
       "1    17\n",
       "Name: Invited, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.Invited.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Session', 'Start Date', 'Start Time', 'End Date', 'abstract_id',\n",
       "       'End Time', 'Type', 'Presenter', 'Email Address', 'coauthor_names',\n",
       "       'coauthor_affiliations', 'author_name', 'author_aff', 'CDP/FIU/Remote',\n",
       "       'presentation_title', 'abstract_text', 'Invited', 'division', 'Date'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2023-07-15    63\n",
       "2023-07-14    24\n",
       "2023-07-16     8\n",
       "Name: Start Date, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Start Date'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    2023-07-15\n",
       "1    2023-07-15\n",
       "2    2023-07-15\n",
       "3    2023-07-15\n",
       "4    2023-07-15\n",
       "        ...    \n",
       "90   2023-07-14\n",
       "91   2023-07-15\n",
       "92   2023-07-16\n",
       "93   2023-07-15\n",
       "94   2023-07-16\n",
       "Name: Start Date, Length: 95, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    " pd.to_datetime(df['Start Date'],format=('%B /%d, %Y'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Everything looks OK. Now creating date_time columns. \n",
    "df['Date/Time']=df['Start Date'].astype(str)+' '+df['Start Time'].astype(str)\n",
    "df['Date/Time'] = pd.to_datetime(df['Date/Time'],format=('%Y-%m-%d  %H:%M:%S'))\n",
    "df['Date/Time'] = [x.round('T') for x in df['Date/Time']]\n",
    "df[\"Nepal Date/Time\"]=df['Date/Time']+timedelta(hours=9.75)\n",
    "df['Nepal Date/Time'] = [x.round('T') for x in df['Nepal Date/Time']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"Author_I\"]=np.where(df['Invited']==1,df[\"Presenter\"]+\" (Invited)\",df[\"Presenter\"])\n",
    "df.loc[df['CDP/FIU/Remote']==\"Remote\",'CDP/FIU/Remote']=\"Virtual Presentation\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Condensed Matter Physics and Material Science               32\n",
       "Biological, Medical, Soft Matter and Chemical Physics       19\n",
       "Astronomy /Space Science /Cosmo Science/ Atmospheric        10\n",
       "Atomic, Molecular, Optical and Plasma Physics               10\n",
       "Data Science, Quantum Computing, Artificial Intelligence     6\n",
       "High Energy, Particle, and Nuclear Physics                   6\n",
       "Applied and Engineering Physics                              5\n",
       "Physics Education Research                                   4\n",
       "Special Session                                              2\n",
       "Key Note                                                     1\n",
       "Name: division, dtype: int64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.division.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_data=df.loc[df['division'].str.contains('Data Science')].sort_values(by='Date/Time')\n",
    "df_PER=df.loc[df['division'].str.contains('Physics Education')].sort_values(by='Date/Time')\n",
    "df_Condensed=df.loc[df['division'].str.contains('Condensed')].sort_values(by='Date/Time')\n",
    "df_Bio=df.loc[df['division'].str.contains('Biological')].sort_values(by='Date/Time')\n",
    "df_Plasma=df.loc[df['division'].str.contains('Atomic')].sort_values(by='Date/Time')\n",
    "df_HEP=df.loc[df['division'].str.contains('High Energy')].sort_values(by='Date/Time')\n",
    "df_Astro=df.loc[df['division'].str.contains('Astronomy')].sort_values(by='Date/Time')\n",
    "df_Applied=df.loc[df['division'].str.contains('Applied')].sort_values(by='Date/Time')\n",
    "\n",
    "## HTMLs based on location\n",
    "df_CDP = df.loc[df['CDP/FIU/Remote'].str.contains('Central')].sort_values(by='Date/Time')\n",
    "df_FIU = df.loc[df['CDP/FIU/Remote'].str.contains('Florida')].sort_values(by='Date/Time')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((6, 22),\n",
       " (4, 22),\n",
       " (32, 22),\n",
       " (19, 22),\n",
       " (10, 22),\n",
       " (6, 22),\n",
       " (10, 22),\n",
       " (5, 22),\n",
       " (26, 22),\n",
       " (19, 22))"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_data.shape, df_PER.shape, df_Condensed.shape,df_Bio.shape,df_Plasma.shape, df_HEP.shape,df_Astro.shape,df_Applied.shape, df_CDP.shape, df_FIU.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "prepend=\"\"\"\n",
    "<html>\n",
    "<head>\n",
    "<style>\n",
    "#anpatable {\n",
    "  font-family: \"Trebuchet MS\", Arial, Helvetica, sans-serif;\n",
    "  border-collapse: collapse;\n",
    "  width: 100%;\n",
    "}\n",
    "\n",
    "#anpatable td, #anpatable th {\n",
    "  border: 1px solid #ddd;\n",
    "  padding: 8px;\n",
    "}\n",
    "\n",
    "#anpatable tr:{background-color: #fff;}\n",
    "#anpatable tr:nth-child(odd) {background-color: #D5DBdb;}\n",
    "#anpatable tr:nth-child(even) {background-color: #e5e8e8;}\n",
    "\n",
    "#anpatable tr:hover {background-color: #f8f9f9;}\n",
    "\n",
    "#anpatable th {\n",
    "  padding-top: 8px;\n",
    "  padding-bottom: 8px;\n",
    "  text-align: left;\n",
    "  background-color: #4CAF50;\n",
    "  color: white;\n",
    "  width: 83px;\n",
    "}\n",
    "\n",
    "</style>\n",
    "</head>\n",
    "<body>\n",
    "<h3> Please look below for detailed schedule. </h3></br>\n",
    "\n",
    "\t<table border=\"1\" cellspacing=\"0\" id=\"anpatable\" cellpadding=\"2\" width=\"680\">\n",
    "    <tbody>\n",
    "\n",
    "\"\"\"\n",
    "\n",
    "\n",
    "postpend=\"\"\"\n",
    "</tbody>\n",
    "</table>\n",
    "\n",
    "</body>\n",
    "</html>\n",
    "\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>Session</th>\n",
       "      <th>Start Date</th>\n",
       "      <th>Start Time</th>\n",
       "      <th>End Date</th>\n",
       "      <th>abstract_id</th>\n",
       "      <th>End Time</th>\n",
       "      <th>Type</th>\n",
       "      <th>Presenter</th>\n",
       "      <th>Email Address</th>\n",
       "      <th>coauthor_names</th>\n",
       "      <th>...</th>\n",
       "      <th>author_aff</th>\n",
       "      <th>CDP/FIU/Remote</th>\n",
       "      <th>presentation_title</th>\n",
       "      <th>abstract_text</th>\n",
       "      <th>Invited</th>\n",
       "      <th>division</th>\n",
       "      <th>Date</th>\n",
       "      <th>Date/Time</th>\n",
       "      <th>Nepal Date/Time</th>\n",
       "      <th>Author_I</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>07:00:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0001</td>\n",
       "      <td>07:15:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Sujan Bhandari</td>\n",
       "      <td>sujannbhandari@gmail.com</td>\n",
       "      <td>Kirti Bir Rajguru ; Chhabi Lal Gnawali ; Bhadr...</td>\n",
       "      <td>...</td>\n",
       "      <td>Central Department of Physics</td>\n",
       "      <td>Central Department of Physics, T.U., Nepal</td>\n",
       "      <td>Comparative study of preparation and character...</td>\n",
       "      <td>Phosporic Acid (H_3PO_4) can be used to activa...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>2023-07-15 07:00:00</td>\n",
       "      <td>2023-07-15 16:45:00</td>\n",
       "      <td>Sujan Bhandari</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>07:45:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0002</td>\n",
       "      <td>08:00:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Keshab Pandey</td>\n",
       "      <td>keshavpandey48@gmail.com</td>\n",
       "      <td>Professor Hae Kyung Jeong</td>\n",
       "      <td>...</td>\n",
       "      <td>Department of Physics, Daegu University, Gyeon...</td>\n",
       "      <td>Central Department of Physics, T.U., Nepal</td>\n",
       "      <td>Synthesis of Tungsten Disulfide for Electroche...</td>\n",
       "      <td>Transition metal dichalcogenides, such as tung...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>2023-07-15 07:45:00</td>\n",
       "      <td>2023-07-15 17:30:00</td>\n",
       "      <td>Keshab Pandey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>16:15:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0003</td>\n",
       "      <td>16:30:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Trailokya Bhattarai</td>\n",
       "      <td>tbhattar@uncc.edu</td>\n",
       "      <td>M. Yasin Akhtar Raja; Abasifreke Ebong</td>\n",
       "      <td>...</td>\n",
       "      <td>UNC Charlotte</td>\n",
       "      <td>Florida International University, FL, USA</td>\n",
       "      <td>Cost-effective III-Nitride Quantum Wells-Based...</td>\n",
       "      <td>Title: Cost-effective III-Nitride Quantum Well...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>2023-07-15 16:15:00</td>\n",
       "      <td>2023-07-16 02:00:00</td>\n",
       "      <td>Trailokya Bhattarai</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0004</td>\n",
       "      <td>12:15:00</td>\n",
       "      <td>Contributed</td>\n",
       "      <td>Bibandhan Poudyal</td>\n",
       "      <td>bpoudyal@ur.rochester.edu</td>\n",
       "      <td>Gourab Ghoshal ; Alec Kirkley</td>\n",
       "      <td>...</td>\n",
       "      <td>University of Rochester</td>\n",
       "      <td>Florida International University, FL, USA</td>\n",
       "      <td>Measuring the Directness of Accessibility to C...</td>\n",
       "      <td>Accessibility in general is an abstract concep...</td>\n",
       "      <td>0</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>2023-07-15 12:00:00</td>\n",
       "      <td>2023-07-15 21:45:00</td>\n",
       "      <td>Bibandhan Poudyal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>20:45:00</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>ANPA2023-N0005</td>\n",
       "      <td>21:15:00</td>\n",
       "      <td>Invited</td>\n",
       "      <td>Tara Dhakal</td>\n",
       "      <td>tdhakal@binghamton.edu</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>Electrical and Computer Engineering Department...</td>\n",
       "      <td>Virtual Presentation</td>\n",
       "      <td>Pseudocapacitive Manganese Oxide/Carbon Nanotu...</td>\n",
       "      <td>In recent years, supercapacitors are fetching ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Applied and Engineering Physics</td>\n",
       "      <td>2023-07-15</td>\n",
       "      <td>2023-07-15 20:45:00</td>\n",
       "      <td>2023-07-16 06:30:00</td>\n",
       "      <td>Tara Dhakal (Invited)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Session Start Date Start Time   End Date  \\\n",
       "0  Applied and Engineering Physics 2023-07-15   07:00:00 2023-07-15   \n",
       "1  Applied and Engineering Physics 2023-07-15   07:45:00 2023-07-15   \n",
       "2  Applied and Engineering Physics 2023-07-15   16:15:00 2023-07-15   \n",
       "3  Applied and Engineering Physics 2023-07-15   12:00:00 2023-07-15   \n",
       "4  Applied and Engineering Physics 2023-07-15   20:45:00 2023-07-15   \n",
       "\n",
       "      abstract_id  End Time         Type            Presenter  \\\n",
       "0  ANPA2023-N0001  07:15:00  Contributed       Sujan Bhandari   \n",
       "1  ANPA2023-N0002  08:00:00  Contributed        Keshab Pandey   \n",
       "2  ANPA2023-N0003  16:30:00  Contributed  Trailokya Bhattarai   \n",
       "3  ANPA2023-N0004  12:15:00  Contributed    Bibandhan Poudyal   \n",
       "4  ANPA2023-N0005  21:15:00      Invited          Tara Dhakal   \n",
       "\n",
       "               Email Address  \\\n",
       "0   sujannbhandari@gmail.com   \n",
       "1   keshavpandey48@gmail.com   \n",
       "2          tbhattar@uncc.edu   \n",
       "3  bpoudyal@ur.rochester.edu   \n",
       "4    tdhakal@binghamton.edu    \n",
       "\n",
       "                                      coauthor_names  ...  \\\n",
       "0  Kirti Bir Rajguru ; Chhabi Lal Gnawali ; Bhadr...  ...   \n",
       "1                          Professor Hae Kyung Jeong  ...   \n",
       "2             M. Yasin Akhtar Raja; Abasifreke Ebong  ...   \n",
       "3                      Gourab Ghoshal ; Alec Kirkley  ...   \n",
       "4                                                     ...   \n",
       "\n",
       "                                          author_aff  \\\n",
       "0                      Central Department of Physics   \n",
       "1  Department of Physics, Daegu University, Gyeon...   \n",
       "2                                      UNC Charlotte   \n",
       "3                            University of Rochester   \n",
       "4  Electrical and Computer Engineering Department...   \n",
       "\n",
       "                               CDP/FIU/Remote  \\\n",
       "0  Central Department of Physics, T.U., Nepal   \n",
       "1  Central Department of Physics, T.U., Nepal   \n",
       "2   Florida International University, FL, USA   \n",
       "3   Florida International University, FL, USA   \n",
       "4                        Virtual Presentation   \n",
       "\n",
       "                                  presentation_title  \\\n",
       "0  Comparative study of preparation and character...   \n",
       "1  Synthesis of Tungsten Disulfide for Electroche...   \n",
       "2  Cost-effective III-Nitride Quantum Wells-Based...   \n",
       "3  Measuring the Directness of Accessibility to C...   \n",
       "4  Pseudocapacitive Manganese Oxide/Carbon Nanotu...   \n",
       "\n",
       "                                       abstract_text Invited  \\\n",
       "0  Phosporic Acid (H_3PO_4) can be used to activa...       0   \n",
       "1  Transition metal dichalcogenides, such as tung...       0   \n",
       "2  Title: Cost-effective III-Nitride Quantum Well...       0   \n",
       "3  Accessibility in general is an abstract concep...       0   \n",
       "4  In recent years, supercapacitors are fetching ...       1   \n",
       "\n",
       "                          division       Date           Date/Time  \\\n",
       "0  Applied and Engineering Physics 2023-07-15 2023-07-15 07:00:00   \n",
       "1  Applied and Engineering Physics 2023-07-15 2023-07-15 07:45:00   \n",
       "2  Applied and Engineering Physics 2023-07-15 2023-07-15 16:15:00   \n",
       "3  Applied and Engineering Physics 2023-07-15 2023-07-15 12:00:00   \n",
       "4  Applied and Engineering Physics 2023-07-15 2023-07-15 20:45:00   \n",
       "\n",
       "      Nepal Date/Time               Author_I  \n",
       "0 2023-07-15 16:45:00         Sujan Bhandari  \n",
       "1 2023-07-15 17:30:00          Keshab Pandey  \n",
       "2 2023-07-16 02:00:00    Trailokya Bhattarai  \n",
       "3 2023-07-15 21:45:00      Bibandhan Poudyal  \n",
       "4 2023-07-16 06:30:00  Tara Dhakal (Invited)  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2023-07-15 07:00:00', '2023-07-15 07:45:00']"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date/Time'][0:2].astype(str).to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "def prep_list(df):\n",
    "    Names_L= df['Author_I'].values\n",
    "    title_L = df['presentation_title'].values\n",
    "    affiliations_L = df['author_aff'].values\n",
    "    abstract_L = df['abstract_text'].values\n",
    "    abstract_n_L=df['abstract_id'].values\n",
    "    Date_L=df['Date/Time'].astype(str).to_list()\n",
    "    Date_L_N=df['Nepal Date/Time'].astype(str).to_list()\n",
    "    Location_L = df['CDP/FIU/Remote'].values\n",
    "    return Names_L,affiliations_L,title_L,abstract_L,abstract_n_L,Date_L,Date_L_N, Location_L"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(array(['Shree Bhattarai', 'Svetlana Levitan (Invited)',\n",
       "        'Puskar Bhattarai', 'Kamal R Dhakal', 'Kirti Bir Rajguru',\n",
       "        'Ghanashyam Khanal'], dtype=object),\n",
       " array(['Torqata Data and Analytics', 'Walgreens Boots Alliance',\n",
       "        'Washington University in St. Louis', 'AbbVie Inc',\n",
       "        ' Department of Applied Sciences And Chemical Engineering IOE, Pulchowk campus ',\n",
       "        'Citigroup Inc.'], dtype=object),\n",
       " array(['Building end-to-end machine learning pipeline to predict tire attributes using Kubeflow',\n",
       "        'Data Science in Real Life: What Can Possibly Go Wrong?',\n",
       "        'Promises of imaging physics and machine learning in mental disorders',\n",
       "        'Segmentation of Retinal Nerve Fiber  Layer  using Deep Learning in experimental glaucoma model of Nonhuman Primates.',\n",
       "        'Comparative study of machine learning based prediction of capacitance of activated carbon prepared from bio based materials ',\n",
       "        'From Physicist to Quant: a Phase Transition'], dtype=object),\n",
       " array(['When a customer visits a tire shop to purchase/replace tire, the most important factors that come into play are whether (i) the size of the tire fits their vehicle? (ii) the tire design suits the surface they drive on? (Smooth road, Rough/Muddy road etc.), and (iii) it is suitable for the season (Winter, Summer etc.). This information is not readily available for all tires. Thus, our goal here was to build a ML model that would collect information from web search to build a classification model to extract these attributes.\\nDuring this presentation, we will be talking about our approach in designing a ML pipeline utilizing KubeFlow in Google Cloud Platform to predict above three tire attributes. We will further explain how KubeFlow helps making deployment of machine learning workflows on containerized applications simple, portable and scalable.',\n",
       "        'Data Science is now very popular, and many companies are making large investments into this area.\\n\\nUniversities and bootcamps keep adding programs to prepare more and more data scientists, and many people with careers in other fields elect to learn the skills and join the â€œSexiest job of the 21st Centuryâ€\\x9d (Harvard Business Review  October 2012). In some cases the investment pays off nicely, in others not so much. Even though everything should work fine in theory, many unexpected problems are encountered in practice. In this talk we will touch on various aspects of data science process, including data and model quality, model deployment and updates, and point out ways to mitigate some of the potential problems.\\n\\n',\n",
       "        'Magnetic resonance imaging (MRI) and positron emission tomography (PET) are some of the greatest inventions of physics and high-level engineering designs. MRI provides anatomical and functional information based on proton interactions with a strong magnetic field and radiofrequency pulses. PET offers the spatial distribution of positron-emitting radionuclides based on capturing the gamma rays emitted upon the annihilation of electron-positron pair, allowing the quantification of various physiological and molecular processes. These non-invasive techniques have revolutionized many fields, including neuroimaging of mental disorders. However, MRI and PET neuroimaging data are highly complex and difficult to interpret. This makes drawing clinical conclusions challenging that are critical for clinical diagnostics, prognostics, and precision medicine. To overcome such barriers, modern machine learning methods have shown great promise in characterizing neuroimaging data. The large-scale resources in mental disorders involve images from multiple sites, scanners, protocols, and diverse populations. One of the biggest challenges for using such research resources is that quantitative measures are not easily reproducible and are highly sensitive to PET and MRI acquisition differences and other sources of variance. Our team has been at the forefront of building machine learning and statistical harmonization methods to study brain patterns in various diseases, including Alzheimerâ€™s disease and schizophrenia. We will highlight various statistical harmonization and machine learning approaches, such as control-based regression, supervised learning, semi-supervised learning, feature importance, and dimensionality reduction, in the context of MRI and PET data. We will show their broad applications in detecting subtle structural and functional changes in the brain and identifying the novel relationships of these changes with behavioral, clinical, and genetic measures. Overall, our findings demonstrate that physics-based imaging technologies integrated with advanced machine learning approaches provide a multidisciplinary perspective in understanding neurobiological mechanisms in health and diseases, and aid in developing future computer-aided therapeutic efforts in mental disorders.',\n",
       "        'Glaucoma, a multifactorial neurodegenerative disease, is characterized by retinal ganglion cell loss during disease progression, which results in retinal nerve fiber layer (RNFL)  thinning. Segmentation of the retinal layers often fails in diseased eye conditions; therefore, manual correction is necessary, which is time-consuming and prone to errors and subjective bias. Erroneous segmentation of RNFL alters the measurements and adversely impacts the therapeutic results. Herein, we developed a deep learning (DL) model to accurately segment and quantify RNFL thicknesses obtained from OCT images of experimentally induced chronic ocular hypertension nonhuman primate (OHT NHP) glaucoma model.',\n",
       "        ' The performance of electrochemical double-layer capacitors (EDLCs) is evaluated by the capacitance of activated carbon (AC) electrodes. The capacitance of AC electrodes is influenced by many factors such as precursor type, activation method, pore structure, surface chemistry and electrolytic properties. In this paper, we present a comparative study of machine learning based prediction of capacitance of AC electrodes prepared from different precursors.\\n In this study, different machine learning (ML) models were used to predict the specific capacitance, surface area, mesopore volume, and total pore volume of activated carbon from different biomass in efficient manner. The ML models were trained on a dataset of experimental and synthetic data that included the activation temperature, methylene blue number and iodine number of the activated carbon (AC). The best performing ML model was random forest model which had an R2 score of 0.968 for specific capacitance. The analysis revealed temperature was the most significant factor in predicting capacitance. The results of this study can be used to optimize the production of activated carbon and improve its performance in energy storage applications.\\nKeywords: Machine Learning, Activated Carbon, Energy storage',\n",
       "        \"A Quant's primary responsibility is to build  financial models using various numerical methods in order to help the business desk make decisions on the millions of transactions they make everyday. In this presentation I will talk about my transition from a PhD in physics to my current role as a quant in a major US financial institution. I will draw parallels and also differentiate between the two positions and give ideas on how one can prepare for such transition.\"],\n",
       "       dtype=object),\n",
       " array(['ANPA2023-N00075', 'ANPA2023-N00079', 'ANPA2023-N00080',\n",
       "        'ANPA2023-N00077', 'ANPA2023-N00076', 'ANPA2023-N00078'],\n",
       "       dtype=object),\n",
       " ['2023-07-15 15:45:00',\n",
       "  '2023-07-15 19:00:00',\n",
       "  '2023-07-15 19:30:00',\n",
       "  '2023-07-15 19:45:00',\n",
       "  '2023-07-15 20:00:00',\n",
       "  '2023-07-15 20:15:00'],\n",
       " ['2023-07-16 01:30:00',\n",
       "  '2023-07-16 04:45:00',\n",
       "  '2023-07-16 05:15:00',\n",
       "  '2023-07-16 05:30:00',\n",
       "  '2023-07-16 05:45:00',\n",
       "  '2023-07-16 06:00:00'],\n",
       " array(['Florida International University, FL, USA',\n",
       "        'Virtual Presentation', 'Virtual Presentation',\n",
       "        'Virtual Presentation', 'Virtual Presentation',\n",
       "        'Virtual Presentation'], dtype=object))"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prep_list(df_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "def create_html(df_name,html_name):\n",
    "    Names_L,affiliations_L,title_L,abstract_L,abstract_n_L,Date_L,Date_L_N, Location_L =prep_list(df_name)\n",
    "    fo = open(html_name, 'w',encoding=\"utf-8\")\n",
    "    fo.write(prepend)\n",
    "    fo = open(html_name, 'a+',encoding=\"utf-8\")\n",
    "    for i in range(len(Names_L)):\n",
    "\n",
    "        names_ = Names_L[i]\n",
    "        title_ = title_L[i]\n",
    "        affil_ = affiliations_L[i]\n",
    "        abstract_ = abstract_L[i]\n",
    "        abstract_n_=abstract_n_L[i]\n",
    "        date_=Date_L[i]\n",
    "        nepaldate_=Date_L_N[i]\n",
    "        location_ = Location_L[i]\n",
    "\n",
    "        html_code = '''\n",
    "\n",
    "        <!-- ########################################################################## -->\n",
    "\n",
    "        <tr>\n",
    "                    <td width=\"158\" colspan=\"2\">\n",
    "                        <p> Date/Time: <br>\n",
    "                            ET:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{date_} </br>\n",
    "                            Nepal: {nepaldate_}\n",
    "                        </p>\n",
    "                    </td>\n",
    "\n",
    "        <td width=\"521\" colspan=\"6\">\n",
    "            <p>Abstract Number: {abstract_n_} </p>\n",
    "\n",
    "            <p>Presenting Author: {names_}\n",
    "            </p>\n",
    "            \n",
    "            <p>Presenter's Affiliation: {affil_}\n",
    "            </p>\n",
    "\n",
    "            <p><a href=\"https://anpaglobal.org/conference/2023/{abstract_n_}.html\"> <strong>Title: </strong>{title_}</a></p>\n",
    "\n",
    "            <p> <strong>Location: </strong>{location_}</p>\n",
    "\n",
    "            <p class=\"show_hide\">Show/Hide Abstract</p>\n",
    "            <div class=\"show_on_click\">{abstract_}</div>\n",
    "\n",
    "        </td>\n",
    "        </tr>\n",
    "\n",
    "    '''.format(date_=date_,nepaldate_=nepaldate_,abstract_n_=abstract_n_,affil_=affil_,names_=names_,\n",
    "               title_ = title_,abstract_=abstract_,location_=location_)\n",
    "        fo.write(html_code)\n",
    "\n",
    "    fo = open(html_name, 'a+',encoding=\"utf-8\")\n",
    "    fo.write(postpend)\n",
    "    fo.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "create_html(df_data,html_name='html_code_2023_data.html')\n",
    "create_html(df_PER,html_name='html_code_2023_PER.html')\n",
    "create_html(df_Condensed,html_name='html_code_2023_Condensed.html')\n",
    "create_html(df_Bio,html_name='html_code_2023_Bio.html')\n",
    "create_html(df_Plasma,html_name='html_code_2023_Plasma.html')\n",
    "create_html(df_HEP,html_name='html_code_2023_HEP.html')\n",
    "create_html(df_Applied,html_name='html_code_2023_Applied.html')\n",
    "create_html(df_Astro,html_name='html_code_2023_Astro.html')\n",
    "\n",
    "# Create HTML based on Location\n",
    "create_html(df_CDP,html_name='html_code_2023_CDP.html')\n",
    "create_html(df_FIU,html_name='html_code_2023_FIU.html')\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create Calendar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Session                          object\n",
       "Start Date               datetime64[ns]\n",
       "Start Time                       object\n",
       "End Date                 datetime64[ns]\n",
       "abstract_id                      object\n",
       "End Time                         object\n",
       "Type                             object\n",
       "Presenter                        object\n",
       "Email Address                    object\n",
       "coauthor_names                   object\n",
       "coauthor_affiliations            object\n",
       "author_name                      object\n",
       "author_aff                       object\n",
       "CDP/FIU/Remote                   object\n",
       "presentation_title               object\n",
       "abstract_text                    object\n",
       "Invited                           int64\n",
       "division                         object\n",
       "Date                     datetime64[ns]\n",
       "Date/Time                datetime64[ns]\n",
       "Nepal Date/Time          datetime64[ns]\n",
       "Author_I                         object\n",
       "dtype: object"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Start_DateTime']=df['Start Date'].astype(str)+' '+df['Start Time'].astype(str)\n",
    "df['Start_DateTime'] = pd.to_datetime(df['Start_DateTime'],format=('%Y-%m-%d  %H:%M:%S'))\n",
    "df['Start_DateTime'] = df['Start_DateTime'] + timedelta(hours=4)#.dt.tz_localize('UTC')#.dt.tz_convert('US/Eastern')\n",
    "\n",
    "df['End_DateTime']=  df['End Date'].astype(str)+' '+df['End Time'].astype(str)\n",
    "df['End_DateTime'] = pd.to_datetime(df['End_DateTime'],format=('%Y-%m-%d  %H:%M:%S'))\n",
    "df['End_DateTime'] = df['End_DateTime'] + timedelta(hours=4)#.dt.tz_localize('UTC')#.dt.tz_convert('US/Eastern')#"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "def prep_list(df):\n",
    "    Names_L= df['Author_I'].values\n",
    "    title_L = df['presentation_title'].values\n",
    "    Date_L=df['Start_DateTime'].values\n",
    "    EndDate_L=df['End_DateTime'].values\n",
    "    return Names_L,title_L,Date_L,EndDate_L"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>Start_DateTime</th>\n",
       "      <th>End_DateTime</th>\n",
       "      <th>abstract_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023-07-15 11:00:00</td>\n",
       "      <td>2023-07-15 11:15:00</td>\n",
       "      <td>ANPA2023-N0001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2023-07-15 11:45:00</td>\n",
       "      <td>2023-07-15 12:00:00</td>\n",
       "      <td>ANPA2023-N0002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2023-07-15 20:15:00</td>\n",
       "      <td>2023-07-15 20:30:00</td>\n",
       "      <td>ANPA2023-N0003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023-07-15 16:00:00</td>\n",
       "      <td>2023-07-15 16:15:00</td>\n",
       "      <td>ANPA2023-N0004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2023-07-16 00:45:00</td>\n",
       "      <td>2023-07-16 01:15:00</td>\n",
       "      <td>ANPA2023-N0005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>2023-07-14 19:00:00</td>\n",
       "      <td>2023-07-14 19:30:00</td>\n",
       "      <td>ANPA2023-N00091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>2023-07-15 14:00:00</td>\n",
       "      <td>2023-07-15 15:00:00</td>\n",
       "      <td>ANPA2023-N00092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>2023-07-16 12:30:00</td>\n",
       "      <td>2023-07-16 13:30:00</td>\n",
       "      <td>ANPA2023-N00093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2023-07-15 04:15:00</td>\n",
       "      <td>2023-07-15 04:45:00</td>\n",
       "      <td>ANPA2023-N00094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2023-07-16 16:40:00</td>\n",
       "      <td>2023-07-16 17:40:00</td>\n",
       "      <td>ANPA2023-N00095</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>95 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Start_DateTime        End_DateTime      abstract_id\n",
       "0  2023-07-15 11:00:00 2023-07-15 11:15:00   ANPA2023-N0001\n",
       "1  2023-07-15 11:45:00 2023-07-15 12:00:00   ANPA2023-N0002\n",
       "2  2023-07-15 20:15:00 2023-07-15 20:30:00   ANPA2023-N0003\n",
       "3  2023-07-15 16:00:00 2023-07-15 16:15:00   ANPA2023-N0004\n",
       "4  2023-07-16 00:45:00 2023-07-16 01:15:00   ANPA2023-N0005\n",
       "..                 ...                 ...              ...\n",
       "90 2023-07-14 19:00:00 2023-07-14 19:30:00  ANPA2023-N00091\n",
       "91 2023-07-15 14:00:00 2023-07-15 15:00:00  ANPA2023-N00092\n",
       "92 2023-07-16 12:30:00 2023-07-16 13:30:00  ANPA2023-N00093\n",
       "93 2023-07-15 04:15:00 2023-07-15 04:45:00  ANPA2023-N00094\n",
       "94 2023-07-16 16:40:00 2023-07-16 17:40:00  ANPA2023-N00095\n",
       "\n",
       "[95 rows x 3 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['Start_DateTime','End_DateTime','abstract_id']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    95\n",
       "Name: diff, dtype: int64"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['diff'] = (df['End_DateTime'] - df['Start_DateTime']).dt.days\n",
    "df['diff'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "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>Session</th>\n",
       "      <th>Start Date</th>\n",
       "      <th>Start Time</th>\n",
       "      <th>End Date</th>\n",
       "      <th>abstract_id</th>\n",
       "      <th>End Time</th>\n",
       "      <th>Type</th>\n",
       "      <th>Presenter</th>\n",
       "      <th>Email Address</th>\n",
       "      <th>coauthor_names</th>\n",
       "      <th>...</th>\n",
       "      <th>abstract_text</th>\n",
       "      <th>Invited</th>\n",
       "      <th>division</th>\n",
       "      <th>Date</th>\n",
       "      <th>Date/Time</th>\n",
       "      <th>Nepal Date/Time</th>\n",
       "      <th>Author_I</th>\n",
       "      <th>Start_DateTime</th>\n",
       "      <th>End_DateTime</th>\n",
       "      <th>diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>0 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Session, Start Date, Start Time, End Date, abstract_id, End Time, Type, Presenter, Email Address, coauthor_names, coauthor_affiliations, author_name, author_aff, CDP/FIU/Remote, presentation_title, abstract_text, Invited, division, Date, Date/Time, Nepal Date/Time, Author_I, Start_DateTime, End_DateTime, diff]\n",
       "Index: []\n",
       "\n",
       "[0 rows x 25 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['diff']==-2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{<Event 'Diana Sachmpazidi (Invited)' begin:2023-07-14T19:00:00+00:00 end:2023-07-14T19:30:00+00:00>,\n",
       " <Event 'Qing Ryan (Invited)' begin:2023-07-14T19:30:00+00:00 end:2023-07-14T20:00:00+00:00>,\n",
       " <Event 'Umesh Silwal' begin:2023-07-14T20:00:00+00:00 end:2023-07-14T20:15:00+00:00>,\n",
       " <Event 'Ganga P Sharma' begin:2023-07-14T20:15:00+00:00 end:2023-07-14T20:30:00+00:00>,\n",
       " <Event 'Chetan Dhital (Invited)' begin:2023-07-14T21:00:00+00:00 end:2023-07-14T21:30:00+00:00>,\n",
       " <Event 'Nepal Rama Devi' begin:2023-07-14T21:30:00+00:00 end:2023-07-14T21:45:00+00:00>,\n",
       " <Event 'Suresh Gnawali' begin:2023-07-14T21:45:00+00:00 end:2023-07-14T22:00:00+00:00>,\n",
       " <Event 'Sunny Choudhary' begin:2023-07-14T22:00:00+00:00 end:2023-07-14T22:15:00+00:00>,\n",
       " <Event 'Prakash Khatri' begin:2023-07-14T22:15:00+00:00 end:2023-07-14T22:30:00+00:00>,\n",
       " <Event 'Da'Shawn M. Morris ' begin:2023-07-14T22:30:00+00:00 end:2023-07-14T22:45:00+00:00>,\n",
       " <Event 'Parashu Kharel' begin:2023-07-14T22:45:00+00:00 end:2023-07-14T23:00:00+00:00>,\n",
       " <Event 'Anup Pradhan Sakhya' begin:2023-07-14T23:00:00+00:00 end:2023-07-14T23:15:00+00:00>,\n",
       " <Event 'Resham Babu Regmi' begin:2023-07-14T23:30:00+00:00 end:2023-07-14T23:45:00+00:00>,\n",
       " <Event 'Hari Bhandari' begin:2023-07-14T23:45:00+00:00 end:2023-07-15T00:00:00+00:00>,\n",
       " <Event 'Alexis Jadiel Agosto' begin:2023-07-15T00:00:00+00:00 end:2023-07-15T00:15:00+00:00>,\n",
       " <Event 'Dipendra Kumar Sah' begin:2023-07-15T00:15:00+00:00 end:2023-07-15T00:30:00+00:00>,\n",
       " <Event 'Sabin Regmi' begin:2023-07-15T00:30:00+00:00 end:2023-07-15T00:45:00+00:00>,\n",
       " <Event 'Nathan Valadez' begin:2023-07-15T00:45:00+00:00 end:2023-07-15T01:00:00+00:00>,\n",
       " <Event 'Shambhu Bhandari Sharma' begin:2023-07-15T01:00:00+00:00 end:2023-07-15T01:15:00+00:00>,\n",
       " <Event 'Milo Sprague' begin:2023-07-15T01:15:00+00:00 end:2023-07-15T01:30:00+00:00>,\n",
       " <Event 'Iftakhar' begin:2023-07-15T01:30:00+00:00 end:2023-07-15T01:45:00+00:00>,\n",
       " <Event 'Lok N. Jha (Invited)' begin:2023-07-15T02:15:00+00:00 end:2023-07-15T03:15:00+00:00>,\n",
       " <Event 'Sitaram Byahut (Invited)' begin:2023-07-15T03:15:00+00:00 end:2023-07-15T03:45:00+00:00>,\n",
       " <Event 'Hari Prasad Lamichhane (Invited)' begin:2023-07-15T03:45:00+00:00 end:2023-07-15T04:15:00+00:00>,\n",
       " <Event 'Binil Aryal (Invited)' begin:2023-07-15T04:15:00+00:00 end:2023-07-15T04:45:00+00:00>,\n",
       " <Event 'Anjan Dahal' begin:2023-07-15T05:15:00+00:00 end:2023-07-15T05:30:00+00:00>,\n",
       " <Event 'Anup Shrestha' begin:2023-07-15T05:30:00+00:00 end:2023-07-15T05:45:00+00:00>,\n",
       " <Event 'Bidhya Thapa' begin:2023-07-15T05:45:00+00:00 end:2023-07-15T06:00:00+00:00>,\n",
       " <Event 'Chhabi Lal Gnawali' begin:2023-07-15T06:00:00+00:00 end:2023-07-15T06:15:00+00:00>,\n",
       " <Event 'Keshab Chaudhary' begin:2023-07-15T06:15:00+00:00 end:2023-07-15T06:30:00+00:00>,\n",
       " <Event 'Lok Nath Sharma ' begin:2023-07-15T06:30:00+00:00 end:2023-07-15T06:45:00+00:00>,\n",
       " <Event 'Narayan Gautam' begin:2023-07-15T07:45:00+00:00 end:2023-07-15T08:00:00+00:00>,\n",
       " <Event 'Num Prasad Acharya' begin:2023-07-15T08:00:00+00:00 end:2023-07-15T08:15:00+00:00>,\n",
       " <Event 'Pradeep Karki' begin:2023-07-15T08:15:00+00:00 end:2023-07-15T08:30:00+00:00>,\n",
       " <Event 'Prakash Man Shrestha' begin:2023-07-15T08:30:00+00:00 end:2023-07-15T08:45:00+00:00>,\n",
       " <Event 'Puranjan Kafle' begin:2023-07-15T08:45:00+00:00 end:2023-07-15T09:00:00+00:00>,\n",
       " <Event 'Purna Jyoti Shakya' begin:2023-07-15T09:00:00+00:00 end:2023-07-15T09:15:00+00:00>,\n",
       " <Event 'Rajan Ghimire' begin:2023-07-15T09:15:00+00:00 end:2023-07-15T09:30:00+00:00>,\n",
       " <Event 'Rajendra Neupane' begin:2023-07-15T09:30:00+00:00 end:2023-07-15T09:45:00+00:00>,\n",
       " <Event 'Ramesh Khanal and Rajan Ghimire' begin:2023-07-15T10:00:00+00:00 end:2023-07-15T10:15:00+00:00>,\n",
       " <Event 'Roshan Chalise' begin:2023-07-15T10:15:00+00:00 end:2023-07-15T10:30:00+00:00>,\n",
       " <Event 'Roshan Pudasaini' begin:2023-07-15T10:30:00+00:00 end:2023-07-15T10:45:00+00:00>,\n",
       " <Event 'Roshan Pudasaini' begin:2023-07-15T10:45:00+00:00 end:2023-07-15T11:00:00+00:00>,\n",
       " <Event 'Sujan Bhandari' begin:2023-07-15T11:00:00+00:00 end:2023-07-15T11:15:00+00:00>,\n",
       " <Event 'Suresh Basnet' begin:2023-07-15T11:15:00+00:00 end:2023-07-15T11:30:00+00:00>,\n",
       " <Event 'Saroj Pandeya' begin:2023-07-15T11:30:00+00:00 end:2023-07-15T11:45:00+00:00>,\n",
       " <Event 'Keshab Pandey' begin:2023-07-15T11:45:00+00:00 end:2023-07-15T12:00:00+00:00>,\n",
       " <Event 'Uddhab Chaulagain (Invited)' begin:2023-07-15T12:00:00+00:00 end:2023-07-15T12:30:00+00:00>,\n",
       " <Event 'Tikaram Neupane' begin:2023-07-15T12:30:00+00:00 end:2023-07-15T12:45:00+00:00>,\n",
       " <Event 'Suman Dhakal (Invited)' begin:2023-07-15T12:50:00+00:00 end:2023-07-15T13:20:00+00:00>,\n",
       " <Event 'Aayush Gautam' begin:2023-07-15T13:20:00+00:00 end:2023-07-15T13:35:00+00:00>,\n",
       " <Event 'Timothy O'leary' begin:2023-07-15T13:35:00+00:00 end:2023-07-15T13:50:00+00:00>,\n",
       " <Event 'Rudra Aryal' begin:2023-07-15T13:50:00+00:00 end:2023-07-15T14:05:00+00:00>,\n",
       " <Event 'Vivek N. Prakash (Invited)' begin:2023-07-15T14:00:00+00:00 end:2023-07-15T15:00:00+00:00>,\n",
       " <Event 'Abin shakya' begin:2023-07-15T15:00:00+00:00 end:2023-07-15T15:15:00+00:00>,\n",
       " <Event 'Amar B Karki' begin:2023-07-15T15:15:00+00:00 end:2023-07-15T15:30:00+00:00>,\n",
       " <Event 'Bashu Dev Khanal' begin:2023-07-15T15:30:00+00:00 end:2023-07-15T15:45:00+00:00>,\n",
       " <Event 'Bhanu Ghimire' begin:2023-07-15T15:45:00+00:00 end:2023-07-15T16:00:00+00:00>,\n",
       " <Event 'Bibandhan Poudyal' begin:2023-07-15T16:00:00+00:00 end:2023-07-15T16:15:00+00:00>,\n",
       " <Event 'Dipendra Khatri' begin:2023-07-15T16:15:00+00:00 end:2023-07-15T16:30:00+00:00>,\n",
       " <Event 'Hugo Perez' begin:2023-07-15T17:30:00+00:00 end:2023-07-15T17:45:00+00:00>,\n",
       " <Event 'Jose L. Parra' begin:2023-07-15T17:45:00+00:00 end:2023-07-15T18:00:00+00:00>,\n",
       " <Event 'Joseph Maerovitz' begin:2023-07-15T18:00:00+00:00 end:2023-07-15T18:15:00+00:00>,\n",
       " <Event 'Kyle J Cahill' begin:2023-07-15T18:15:00+00:00 end:2023-07-15T18:30:00+00:00>,\n",
       " <Event 'Michael D. Cioffi' begin:2023-07-15T18:30:00+00:00 end:2023-07-15T18:45:00+00:00>,\n",
       " <Event 'Nishchal Thapa Magar' begin:2023-07-15T18:45:00+00:00 end:2023-07-15T19:00:00+00:00>,\n",
       " <Event 'Puskar Chapagain' begin:2023-07-15T19:00:00+00:00 end:2023-07-15T19:15:00+00:00>,\n",
       " <Event 'Santosh Khatri' begin:2023-07-15T19:30:00+00:00 end:2023-07-15T19:45:00+00:00>,\n",
       " <Event 'Shree Bhattarai' begin:2023-07-15T19:45:00+00:00 end:2023-07-15T20:00:00+00:00>,\n",
       " <Event 'Tej Kumar Sharma' begin:2023-07-15T20:00:00+00:00 end:2023-07-15T20:15:00+00:00>,\n",
       " <Event 'Trailokya Bhattarai' begin:2023-07-15T20:15:00+00:00 end:2023-07-15T20:30:00+00:00>,\n",
       " <Event 'Yasir Mamun' begin:2023-07-15T20:30:00+00:00 end:2023-07-15T20:45:00+00:00>,\n",
       " <Event 'Bhim M. Adhikari (Invited)' begin:2023-07-15T21:00:00+00:00 end:2023-07-15T21:30:00+00:00>,\n",
       " <Event 'Nawal khadka' begin:2023-07-15T21:30:00+00:00 end:2023-07-15T21:45:00+00:00>,\n",
       " <Event 'Jose I.  Florentino ' begin:2023-07-15T21:45:00+00:00 end:2023-07-15T22:00:00+00:00>,\n",
       " <Event 'Saniya L. Lyles' begin:2023-07-15T22:00:00+00:00 end:2023-07-15T22:15:00+00:00>,\n",
       " <Event 'Amba Datt Pant' begin:2023-07-15T22:15:00+00:00 end:2023-07-15T22:30:00+00:00>,\n",
       " <Event 'Olivia Walsh' begin:2023-07-15T22:30:00+00:00 end:2023-07-15T22:45:00+00:00>,\n",
       " <Event 'Svetlana Levitan (Invited)' begin:2023-07-15T23:00:00+00:00 end:2023-07-15T23:30:00+00:00>,\n",
       " <Event 'Puskar Bhattarai' begin:2023-07-15T23:30:00+00:00 end:2023-07-15T23:45:00+00:00>,\n",
       " <Event 'Kamal R Dhakal' begin:2023-07-15T23:45:00+00:00 end:2023-07-16T00:00:00+00:00>,\n",
       " <Event 'Kirti Bir Rajguru' begin:2023-07-16T00:00:00+00:00 end:2023-07-16T00:15:00+00:00>,\n",
       " <Event 'Ghanashyam Khanal' begin:2023-07-16T00:15:00+00:00 end:2023-07-16T00:30:00+00:00>,\n",
       " <Event 'Tara Dhakal (Invited)' begin:2023-07-16T00:45:00+00:00 end:2023-07-16T01:15:00+00:00>,\n",
       " <Event 'Som Nath Paneru (Invited)' begin:2023-07-16T01:15:00+00:00 end:2023-07-16T01:45:00+00:00>,\n",
       " <Event 'Arif Ali' begin:2023-07-16T01:45:00+00:00 end:2023-07-16T02:00:00+00:00>,\n",
       " <Event 'Anita Mishra' begin:2023-07-16T02:00:00+00:00 end:2023-07-16T02:15:00+00:00>,\n",
       " <Event 'Tom N. Oder (Invited)' begin:2023-07-16T12:00:00+00:00 end:2023-07-16T12:30:00+00:00>,\n",
       " <Event 'Mim Lal Nakarmi (Invited)' begin:2023-07-16T12:30:00+00:00 end:2023-07-16T13:30:00+00:00>,\n",
       " <Event 'Peshal Pokharel' begin:2023-07-16T13:30:00+00:00 end:2023-07-16T13:45:00+00:00>,\n",
       " <Event 'Dinesh Thapa' begin:2023-07-16T13:45:00+00:00 end:2023-07-16T14:00:00+00:00>,\n",
       " <Event 'Mazharul Islam Mondal' begin:2023-07-16T14:00:00+00:00 end:2023-07-16T14:15:00+00:00>,\n",
       " <Event 'Mackenzie Songsart-Power' begin:2023-07-16T14:15:00+00:00 end:2023-07-16T14:30:00+00:00>,\n",
       " <Event 'Tej Bahadur Limbu' begin:2023-07-16T14:30:00+00:00 end:2023-07-16T14:45:00+00:00>,\n",
       " <Event 'Manh-Huong Phan (Invited)' begin:2023-07-16T16:40:00+00:00 end:2023-07-16T17:40:00+00:00>}"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "c=Calendar()\n",
    "Names_L,title_L,Date_L,EndDate_L=prep_list(df)\n",
    "str(Date_L[0])\n",
    "for i in range(len(Names_L)):\n",
    "    e=Event()\n",
    "    e.name=Names_L[i]\n",
    "    e.begin=str(Date_L[i])\n",
    "    e.end=str(EndDate_L[i])\n",
    "    e.description=title_L[i]\n",
    "    c.events.add(e)\n",
    "c.events"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\plasm\\AppData\\Roaming\\Python\\Python39\\site-packages\\ics\\component.py:85: FutureWarning: Behaviour of str(Component) will change in version 0.9 to only return a short description, NOT the ics representation. Use the explicit Component.serialize() to get the ics representation.\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "with open('ANPA Conference Calendar 2023.ics', 'w', encoding=\"utf-8\") as f:\n",
    "    f.write(str(c))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}