2022_html_creator.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "smart-margin",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import datetime\n",
    "from datetime import timedelta\n",
    "import numpy as np\n",
    "from ics import Calendar,Event "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "plastic-nelson",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('schedule-2022_SB_PD.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "innovative-evanescence",
   "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>Date</th>\n",
       "      <th>Session</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>StartTime</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>EndTime</th>\n",
       "      <th>Invited</th>\n",
       "      <th>Presenter</th>\n",
       "      <th>Presenter's Affiliation</th>\n",
       "      <th>In-Person/Remote</th>\n",
       "      <th>Coauthors</th>\n",
       "      <th>Coauthors affiliation</th>\n",
       "      <th>Paper Title</th>\n",
       "      <th>Abstract</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:00 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:30 PM</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Christopher Fischer</td>\n",
       "      <td>University of Kansas</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Sarah Rush</td>\n",
       "      <td>University of Kansas</td>\n",
       "      <td>Helping traditionally under-served populations...</td>\n",
       "      <td>We have developed a new curriculum for introdu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:30 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:45 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Arbin Thapaliya</td>\n",
       "      <td>Franklin College</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Jessica Mahoney;</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Teaching ultrasound to undergraduates using pr...</td>\n",
       "      <td>In this talk, we will present about a unique c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:45 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:00 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Puskar Chapgain</td>\n",
       "      <td>Southern Arkansas University</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Nabin Malakar; Suman Neupane; Dipak Rimal; Lav...</td>\n",
       "      <td>Worcester State University; Middle Tennessee S...</td>\n",
       "      <td>Does Peer-Assisted Instruction for University ...</td>\n",
       "      <td>Supplemental Instruction (SI) is a teaching me...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:00 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:15 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Simon Rees</td>\n",
       "      <td>WPI Student, Rudra Kafle</td>\n",
       "      <td>Remote</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Supplementing the Learning of Physics with the...</td>\n",
       "      <td>Graphicacy, or proficiency in using and making...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:15 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:30 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Anna Mederer</td>\n",
       "      <td>Worcester Polytechnic Institute</td>\n",
       "      <td>Remote</td>\n",
       "      <td>L Dana</td>\n",
       "      <td>Worcester Polytechnic Institute</td>\n",
       "      <td>Scaffolding Writing in Physics Labs</td>\n",
       "      <td>Communicating physics is an essential learning...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Data Science, Quantum Computing, Artificial In...</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:45 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>8:15 PM</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Bikalpa Neupane</td>\n",
       "      <td>Takeda Pharmaceuticals</td>\n",
       "      <td>Remote</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Transition from a Physicist to a Data Scientist</td>\n",
       "      <td>If you are thinking of an alternative career p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Data Science, Quantum Computing, Artificial In...</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>8:15 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>8:30 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Pratik Kafle</td>\n",
       "      <td>Reed College</td>\n",
       "      <td>Remote</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>On Schrodinger-Newton equation in 2-dimension</td>\n",
       "      <td>Numerical solutions to the Schr�dinger-Newton ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Date                                            Session StartDate  \\\n",
       "0  07/15/22                         Physics Education Research  07/15/22   \n",
       "1  07/15/22                         Physics Education Research  07/15/22   \n",
       "2  07/15/22                         Physics Education Research  07/15/22   \n",
       "3  07/15/22                         Physics Education Research  07/15/22   \n",
       "4  07/15/22                         Physics Education Research  07/15/22   \n",
       "5  07/15/22  Data Science, Quantum Computing, Artificial In...  07/15/22   \n",
       "6  07/15/22  Data Science, Quantum Computing, Artificial In...  07/15/22   \n",
       "\n",
       "  StartTime   EndDate  EndTime  Invited            Presenter  \\\n",
       "0   6:00 PM  07/15/22  6:30 PM      1.0  Christopher Fischer   \n",
       "1   6:30 PM  07/15/22  6:45 PM      NaN      Arbin Thapaliya   \n",
       "2   6:45 PM  07/15/22  7:00 PM      NaN      Puskar Chapgain   \n",
       "3   7:00 PM  07/15/22  7:15 PM      NaN           Simon Rees   \n",
       "4   7:15 PM  07/15/22  7:30 PM      NaN         Anna Mederer   \n",
       "5   7:45 PM  07/15/22  8:15 PM      1.0      Bikalpa Neupane   \n",
       "6   8:15 PM  07/15/22  8:30 PM      NaN         Pratik Kafle   \n",
       "\n",
       "           Presenter's Affiliation In-Person/Remote  \\\n",
       "0             University of Kansas           Remote   \n",
       "1                 Franklin College           Remote   \n",
       "2     Southern Arkansas University           Remote   \n",
       "3         WPI Student, Rudra Kafle           Remote   \n",
       "4  Worcester Polytechnic Institute           Remote   \n",
       "5           Takeda Pharmaceuticals           Remote   \n",
       "6                     Reed College           Remote   \n",
       "\n",
       "                                           Coauthors  \\\n",
       "0                                         Sarah Rush   \n",
       "1                                   Jessica Mahoney;   \n",
       "2  Nabin Malakar; Suman Neupane; Dipak Rimal; Lav...   \n",
       "3                                                NaN   \n",
       "4                                             L Dana   \n",
       "5                                                NaN   \n",
       "6                                                NaN   \n",
       "\n",
       "                               Coauthors affiliation  \\\n",
       "0                               University of Kansas   \n",
       "1                                                NaN   \n",
       "2  Worcester State University; Middle Tennessee S...   \n",
       "3                                                NaN   \n",
       "4                    Worcester Polytechnic Institute   \n",
       "5                                                NaN   \n",
       "6                                                NaN   \n",
       "\n",
       "                                         Paper Title  \\\n",
       "0  Helping traditionally under-served populations...   \n",
       "1  Teaching ultrasound to undergraduates using pr...   \n",
       "2  Does Peer-Assisted Instruction for University ...   \n",
       "3  Supplementing the Learning of Physics with the...   \n",
       "4                Scaffolding Writing in Physics Labs   \n",
       "5    Transition from a Physicist to a Data Scientist   \n",
       "6      On Schrodinger-Newton equation in 2-dimension   \n",
       "\n",
       "                                            Abstract  \n",
       "0  We have developed a new curriculum for introdu...  \n",
       "1  In this talk, we will present about a unique c...  \n",
       "2  Supplemental Instruction (SI) is a teaching me...  \n",
       "3  Graphicacy, or proficiency in using and making...  \n",
       "4  Communicating physics is an essential learning...  \n",
       "5  If you are thinking of an alternative career p...  \n",
       "6  Numerical solutions to the Schr�dinger-Newton ...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(7)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "noticed-choir",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Date', 'Session', 'StartDate', 'StartTime', 'EndDate', 'EndTime',\n",
       "       'Invited', 'Presenter', 'Presenter's Affiliation', 'In-Person/Remote',\n",
       "       'Coauthors', 'Coauthors affiliation', 'Paper Title', 'Abstract'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "residential-mother",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_remote = df.loc[df['In-Person/Remote']=='Remote']\n",
    "df_inperson = df.loc[df['In-Person/Remote']!='Remote']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "surprising-damages",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((73, 14), (62, 14), (11, 14))"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape,df_remote.shape, df_inperson.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "nervous-clinic",
   "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>Date</th>\n",
       "      <th>Session</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>StartTime</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>EndTime</th>\n",
       "      <th>Invited</th>\n",
       "      <th>Presenter</th>\n",
       "      <th>Presenter's Affiliation</th>\n",
       "      <th>In-Person/Remote</th>\n",
       "      <th>Coauthors</th>\n",
       "      <th>Coauthors affiliation</th>\n",
       "      <th>Paper Title</th>\n",
       "      <th>Abstract</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>07/17/22</td>\n",
       "      <td>Condensed Matter Physics and Material Science</td>\n",
       "      <td>07/17/22</td>\n",
       "      <td>11:00 AM</td>\n",
       "      <td>07/17/22</td>\n",
       "      <td>11:15 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Robert Smith</td>\n",
       "      <td>University of Central Florida</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Robert Smith; Firoza Kabir; Randall Filippone;...</td>\n",
       "      <td>Department of Physics, University of Central F...</td>\n",
       "      <td>Unusual magnetic and transport properties in H...</td>\n",
       "      <td>With intricate lattice structures, kagome mate...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>07/17/22</td>\n",
       "      <td>Condensed Matter Physics and Material Science</td>\n",
       "      <td>07/17/22</td>\n",
       "      <td>11:15 AM</td>\n",
       "      <td>07/17/22</td>\n",
       "      <td>11:30 AM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hari Bhandari</td>\n",
       "      <td>Graduate Student, George Mason University</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Peter Siegfried; Igor Mazin; Yanliu Dang; Albe...</td>\n",
       "      <td>George Mason University, Quantum Materials Sci...</td>\n",
       "      <td>Tuning of Magnetism via Doping in Kagome Magne...</td>\n",
       "      <td>Kagome lattice magnets are an interesting clas...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>07/17/22</td>\n",
       "      <td>Condensed Matter Physics and Material Science</td>\n",
       "      <td>07/17/22</td>\n",
       "      <td>11:45 AM</td>\n",
       "      <td>07/17/22</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dr. Anup Pradhan Sakhya</td>\n",
       "      <td>University of Central Florida</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Cheng-Yi Huang; Gyanendra Dhakal; Xue-Jian Gao...</td>\n",
       "      <td>Department of Physics, Northeastern University...</td>\n",
       "      <td>Observation of Fermi-arcs and Weyl nodes in a ...</td>\n",
       "      <td>Weyl semimetal (WSM), a novel state of quantum...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>07/17/22</td>\n",
       "      <td>Condensed Matter Physics and Material Science</td>\n",
       "      <td>07/17/22</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>07/17/22</td>\n",
       "      <td>12:15 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ganesh Pokharel</td>\n",
       "      <td>University of California Santa Barbara</td>\n",
       "      <td>Remote</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Evolution of field-induced and impurity-induce...</td>\n",
       "      <td>Two-dimensional triangular-lattices of rare-ea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>07/17/22</td>\n",
       "      <td>Condensed Matter Physics and Material Science</td>\n",
       "      <td>07/17/22</td>\n",
       "      <td>12:15 PM</td>\n",
       "      <td>07/17/22</td>\n",
       "      <td>12:30 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Raj K. Rai</td>\n",
       "      <td>Central Department of Physics, Tribhuvan Unive...</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Gopi Chandra Kaphle</td>\n",
       "      <td>Central Department of Physics, Tribhuvan Unive...</td>\n",
       "      <td>NUMERICAL ANALYTIC CONTINUATION TO PROBE THE E...</td>\n",
       "      <td>We present a mathematical tool to extract the ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Date                                        Session StartDate  \\\n",
       "68  07/17/22  Condensed Matter Physics and Material Science  07/17/22   \n",
       "69  07/17/22  Condensed Matter Physics and Material Science  07/17/22   \n",
       "70  07/17/22  Condensed Matter Physics and Material Science  07/17/22   \n",
       "71  07/17/22  Condensed Matter Physics and Material Science  07/17/22   \n",
       "72  07/17/22  Condensed Matter Physics and Material Science  07/17/22   \n",
       "\n",
       "   StartTime   EndDate    EndTime  Invited                Presenter  \\\n",
       "68  11:00 AM  07/17/22   11:15 AM      NaN             Robert Smith   \n",
       "69  11:15 AM  07/17/22   11:30 AM      NaN           Hari Bhandari    \n",
       "70  11:45 AM  07/17/22   12:00 PM      NaN  Dr. Anup Pradhan Sakhya   \n",
       "71  12:00 PM  07/17/22   12:15 PM      NaN          Ganesh Pokharel   \n",
       "72  12:15 PM  07/17/22   12:30 PM      NaN               Raj K. Rai   \n",
       "\n",
       "                              Presenter's Affiliation In-Person/Remote  \\\n",
       "68                      University of Central Florida           Remote   \n",
       "69          Graduate Student, George Mason University           Remote   \n",
       "70                      University of Central Florida           Remote   \n",
       "71             University of California Santa Barbara           Remote   \n",
       "72  Central Department of Physics, Tribhuvan Unive...           Remote   \n",
       "\n",
       "                                            Coauthors  \\\n",
       "68  Robert Smith; Firoza Kabir; Randall Filippone;...   \n",
       "69  Peter Siegfried; Igor Mazin; Yanliu Dang; Albe...   \n",
       "70  Cheng-Yi Huang; Gyanendra Dhakal; Xue-Jian Gao...   \n",
       "71                                                NaN   \n",
       "72                                Gopi Chandra Kaphle   \n",
       "\n",
       "                                Coauthors affiliation  \\\n",
       "68  Department of Physics, University of Central F...   \n",
       "69  George Mason University, Quantum Materials Sci...   \n",
       "70  Department of Physics, Northeastern University...   \n",
       "71                                                NaN   \n",
       "72  Central Department of Physics, Tribhuvan Unive...   \n",
       "\n",
       "                                          Paper Title  \\\n",
       "68  Unusual magnetic and transport properties in H...   \n",
       "69  Tuning of Magnetism via Doping in Kagome Magne...   \n",
       "70  Observation of Fermi-arcs and Weyl nodes in a ...   \n",
       "71  Evolution of field-induced and impurity-induce...   \n",
       "72  NUMERICAL ANALYTIC CONTINUATION TO PROBE THE E...   \n",
       "\n",
       "                                             Abstract  \n",
       "68  With intricate lattice structures, kagome mate...  \n",
       "69  Kagome lattice magnets are an interesting clas...  \n",
       "70  Weyl semimetal (WSM), a novel state of quantum...  \n",
       "71  Two-dimensional triangular-lattices of rare-ea...  \n",
       "72  We present a mathematical tool to extract the ...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "exact-logging",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Assign abstract Number\n",
    "#Assign Abstract number in format ANPA2020_0001\n",
    "ab_num =[]\n",
    "for i in range(len(df)):\n",
    "    ab_num.append(\"ANPA2022_0\"+str(i+101).zfill(3))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "dependent-given",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Physics Education Research',\n",
       "       'Data Science, Quantum Computing, Artificial Intelligence',\n",
       "       'Applied and Engineering Physics',\n",
       "       'Condensed Matter Physics and Material Science',\n",
       "       'Astronomy and Cosmology', 'Atmospheric and Space Physics',\n",
       "       'Atomic, Molecular, Optical and Plasma Physics',\n",
       "       'High Energy, Particle, and Nuclear Physics', 'Keynote',\n",
       "       'Biological and Chemical Physics'], dtype=object)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Abstract Number']=ab_num\n",
    "df['Session'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "disciplinary-worth",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df.Session=='Data Science, Quantum Computing, Artificial Intellegence']='Data Science, Quantum Computing, Artificial Intelligence'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "australian-payday",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Physics Education Research',\n",
       "       'Data Science, Quantum Computing, Artificial Intelligence',\n",
       "       'Applied and Engineering Physics',\n",
       "       'Condensed Matter Physics and Material Science',\n",
       "       'Astronomy and Cosmology', 'Atmospheric and Space Physics',\n",
       "       'Atomic, Molecular, Optical and Plasma Physics',\n",
       "       'High Energy, Particle, and Nuclear Physics', 'Keynote',\n",
       "       'Biological and Chemical Physics'], dtype=object)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.Session.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "welsh-minnesota",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 73 entries, 0 to 72\n",
      "Data columns (total 15 columns):\n",
      " #   Column                   Non-Null Count  Dtype \n",
      "---  ------                   --------------  ----- \n",
      " 0   Date                     73 non-null     object\n",
      " 1   Session                  73 non-null     object\n",
      " 2   StartDate                73 non-null     object\n",
      " 3   StartTime                73 non-null     object\n",
      " 4   EndDate                  73 non-null     object\n",
      " 5   EndTime                  73 non-null     object\n",
      " 6   Invited                  15 non-null     object\n",
      " 7   Presenter                73 non-null     object\n",
      " 8   Presenter's Affiliation  73 non-null     object\n",
      " 9   In-Person/Remote         73 non-null     object\n",
      " 10  Coauthors                50 non-null     object\n",
      " 11  Coauthors affiliation    46 non-null     object\n",
      " 12  Paper Title              73 non-null     object\n",
      " 13  Abstract                 71 non-null     object\n",
      " 14  Abstract Number          73 non-null     object\n",
      "dtypes: object(15)\n",
      "memory usage: 8.7+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "silver-million",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Date/Time']=df['StartDate']+' '+df['StartTime']\n",
    "df['Date/Time'] = pd.to_datetime(df['Date/Time'],format=('%m/%d/%y  %I:%M %p'))\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": 14,
   "id": "sixth-senate",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "df[\"Author_I\"]=np.where(df['Invited']==1,df[\"Presenter\"]+\" (Invited)\",df[\"Presenter\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "utility-parking",
   "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>Date</th>\n",
       "      <th>Session</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>StartTime</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>EndTime</th>\n",
       "      <th>Invited</th>\n",
       "      <th>Presenter</th>\n",
       "      <th>Presenter's Affiliation</th>\n",
       "      <th>In-Person/Remote</th>\n",
       "      <th>Coauthors</th>\n",
       "      <th>Coauthors affiliation</th>\n",
       "      <th>Paper Title</th>\n",
       "      <th>Abstract</th>\n",
       "      <th>Abstract Number</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>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:00 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:30 PM</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Christopher Fischer</td>\n",
       "      <td>University of Kansas</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Sarah Rush</td>\n",
       "      <td>University of Kansas</td>\n",
       "      <td>Helping traditionally under-served populations...</td>\n",
       "      <td>We have developed a new curriculum for introdu...</td>\n",
       "      <td>ANPA2022_0101</td>\n",
       "      <td>2022-07-15 18:00:00</td>\n",
       "      <td>2022-07-16 03:45:00</td>\n",
       "      <td>Christopher Fischer (Invited)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:30 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:45 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Arbin Thapaliya</td>\n",
       "      <td>Franklin College</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Jessica Mahoney;</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Teaching ultrasound to undergraduates using pr...</td>\n",
       "      <td>In this talk, we will present about a unique c...</td>\n",
       "      <td>ANPA2022_0102</td>\n",
       "      <td>2022-07-15 18:30:00</td>\n",
       "      <td>2022-07-16 04:15:00</td>\n",
       "      <td>Arbin Thapaliya</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:45 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:00 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Puskar Chapgain</td>\n",
       "      <td>Southern Arkansas University</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Nabin Malakar; Suman Neupane; Dipak Rimal; Lav...</td>\n",
       "      <td>Worcester State University; Middle Tennessee S...</td>\n",
       "      <td>Does Peer-Assisted Instruction for University ...</td>\n",
       "      <td>Supplemental Instruction (SI) is a teaching me...</td>\n",
       "      <td>ANPA2022_0103</td>\n",
       "      <td>2022-07-15 18:45:00</td>\n",
       "      <td>2022-07-16 04:30:00</td>\n",
       "      <td>Puskar Chapgain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:00 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:15 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Simon Rees</td>\n",
       "      <td>WPI Student, Rudra Kafle</td>\n",
       "      <td>Remote</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Supplementing the Learning of Physics with the...</td>\n",
       "      <td>Graphicacy, or proficiency in using and making...</td>\n",
       "      <td>ANPA2022_0104</td>\n",
       "      <td>2022-07-15 19:00:00</td>\n",
       "      <td>2022-07-16 04:45:00</td>\n",
       "      <td>Simon Rees</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:15 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:30 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Anna Mederer</td>\n",
       "      <td>Worcester Polytechnic Institute</td>\n",
       "      <td>Remote</td>\n",
       "      <td>L Dana</td>\n",
       "      <td>Worcester Polytechnic Institute</td>\n",
       "      <td>Scaffolding Writing in Physics Labs</td>\n",
       "      <td>Communicating physics is an essential learning...</td>\n",
       "      <td>ANPA2022_0105</td>\n",
       "      <td>2022-07-15 19:15:00</td>\n",
       "      <td>2022-07-16 05:00:00</td>\n",
       "      <td>Anna Mederer</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Date                     Session StartDate StartTime   EndDate  \\\n",
       "0  07/15/22  Physics Education Research  07/15/22   6:00 PM  07/15/22   \n",
       "1  07/15/22  Physics Education Research  07/15/22   6:30 PM  07/15/22   \n",
       "2  07/15/22  Physics Education Research  07/15/22   6:45 PM  07/15/22   \n",
       "3  07/15/22  Physics Education Research  07/15/22   7:00 PM  07/15/22   \n",
       "4  07/15/22  Physics Education Research  07/15/22   7:15 PM  07/15/22   \n",
       "\n",
       "   EndTime Invited            Presenter          Presenter's Affiliation  \\\n",
       "0  6:30 PM     1.0  Christopher Fischer             University of Kansas   \n",
       "1  6:45 PM     NaN      Arbin Thapaliya                 Franklin College   \n",
       "2  7:00 PM     NaN      Puskar Chapgain     Southern Arkansas University   \n",
       "3  7:15 PM     NaN           Simon Rees         WPI Student, Rudra Kafle   \n",
       "4  7:30 PM     NaN         Anna Mederer  Worcester Polytechnic Institute   \n",
       "\n",
       "  In-Person/Remote                                          Coauthors  \\\n",
       "0           Remote                                         Sarah Rush   \n",
       "1           Remote                                   Jessica Mahoney;   \n",
       "2           Remote  Nabin Malakar; Suman Neupane; Dipak Rimal; Lav...   \n",
       "3           Remote                                                NaN   \n",
       "4           Remote                                             L Dana   \n",
       "\n",
       "                               Coauthors affiliation  \\\n",
       "0                               University of Kansas   \n",
       "1                                                NaN   \n",
       "2  Worcester State University; Middle Tennessee S...   \n",
       "3                                                NaN   \n",
       "4                    Worcester Polytechnic Institute   \n",
       "\n",
       "                                         Paper Title  \\\n",
       "0  Helping traditionally under-served populations...   \n",
       "1  Teaching ultrasound to undergraduates using pr...   \n",
       "2  Does Peer-Assisted Instruction for University ...   \n",
       "3  Supplementing the Learning of Physics with the...   \n",
       "4                Scaffolding Writing in Physics Labs   \n",
       "\n",
       "                                            Abstract Abstract Number  \\\n",
       "0  We have developed a new curriculum for introdu...   ANPA2022_0101   \n",
       "1  In this talk, we will present about a unique c...   ANPA2022_0102   \n",
       "2  Supplemental Instruction (SI) is a teaching me...   ANPA2022_0103   \n",
       "3  Graphicacy, or proficiency in using and making...   ANPA2022_0104   \n",
       "4  Communicating physics is an essential learning...   ANPA2022_0105   \n",
       "\n",
       "            Date/Time     Nepal Date/Time                       Author_I  \n",
       "0 2022-07-15 18:00:00 2022-07-16 03:45:00  Christopher Fischer (Invited)  \n",
       "1 2022-07-15 18:30:00 2022-07-16 04:15:00                Arbin Thapaliya  \n",
       "2 2022-07-15 18:45:00 2022-07-16 04:30:00                Puskar Chapgain  \n",
       "3 2022-07-15 19:00:00 2022-07-16 04:45:00                     Simon Rees  \n",
       "4 2022-07-15 19:15:00 2022-07-16 05:00:00                   Anna Mederer  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "manufactured-variable",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Physics Education Research',\n",
       "       'Data Science, Quantum Computing, Artificial Intelligence',\n",
       "       'Applied and Engineering Physics',\n",
       "       'Condensed Matter Physics and Material Science',\n",
       "       'Astronomy and Cosmology', 'Atmospheric and Space Physics',\n",
       "       'Atomic, Molecular, Optical and Plasma Physics',\n",
       "       'High Energy, Particle, and Nuclear Physics', 'Keynote',\n",
       "       'Biological and Chemical Physics'], dtype=object)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.Session.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "descending-pakistan",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_data=df.loc[df['Session'].str.contains('Data Science')].sort_values(by='Date/Time')\n",
    "df_PER=df.loc[df['Session'].str.contains('Physics Education')].sort_values(by='Date/Time')\n",
    "df_Condensed=df.loc[df['Session'].str.contains('Condensed')].sort_values(by='Date/Time')\n",
    "df_Bio=df.loc[df['Session'].str.contains('Biological')].sort_values(by='Date/Time')\n",
    "df_Plasma=df.loc[df['Session'].str.contains('Plasma')].sort_values(by='Date/Time')\n",
    "df_HEP=df.loc[df['Session'].str.contains('High Energy')].sort_values(by='Date/Time')\n",
    "df_Astro=df.loc[df['Session'].str.contains('Astronomy')].sort_values(by='Date/Time')\n",
    "df_Atmos = df.loc[df['Session'].str.contains('Atmospheric')].sort_values(by='Date/Time')\n",
    "df_Applied=df.loc[df['Session'].str.contains('Applied')].sort_values(by='Date/Time')\n",
    "df_InPerson=df.loc[df['In-Person/Remote']!='Remote'].sort_values(by='Date/Time')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "wanted-orientation",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((3, 18),\n",
       " (5, 18),\n",
       " (25, 18),\n",
       " (8, 18),\n",
       " (4, 18),\n",
       " (9, 18),\n",
       " (7, 18),\n",
       " (5, 18),\n",
       " (6, 18))"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_data.shape, df_PER.shape, df_Condensed.shape,df_Bio.shape,df_Atmos.shape,df_Plasma.shape, df_HEP.shape,df_Astro.shape,df_Applied.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "later-compound",
   "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": 20,
   "id": "educated-mandate",
   "metadata": {},
   "outputs": [],
   "source": [
    "def prep_list(df):\n",
    "    Names_L= df['Author_I'].values\n",
    "    title_L = df['Paper Title'].values\n",
    "    affiliations_L = df[\"Presenter's Affiliation\"].values\n",
    "    abstract_L = df['Abstract'].values\n",
    "    abstract_n_L=df['Abstract Number'].values\n",
    "    Date_L=df['Date/Time'].values\n",
    "    Date_L_N=df['Nepal Date/Time'].values\n",
    "    return Names_L,affiliations_L,title_L,abstract_L,abstract_n_L,Date_L,Date_L_N"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "becoming-journal",
   "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=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",
    "\n",
    "        html_code = '''\n",
    "\n",
    "        <!-- ########################################################################## -->\n",
    "\n",
    "        <tr>\n",
    "                    <td width=\"158\" colspan=\"2\">\n",
    "                        <p> Date/Time: <br>\n",
    "                            ET: {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> <strong>Title: </strong>{title_}</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_)\n",
    "        fo.write(html_code)\n",
    "\n",
    "    fo = open(html_name, 'a+',encoding=\"utf-8\")\n",
    "    fo.write(postpend)\n",
    "\n",
    "\n",
    "\n",
    "    fo.close()\n",
    "\n",
    "    \n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "infrared-fossil",
   "metadata": {},
   "outputs": [],
   "source": [
    "create_html(df_data,html_name='html_code_2022_data.html')\n",
    "create_html(df_PER,html_name='html_code_2022_PER.html')\n",
    "create_html(df_Condensed,html_name='html_code_2022_Condensed.html')\n",
    "create_html(df_Bio,html_name='html_code_2022_Bio.html')\n",
    "create_html(df_Plasma,html_name='html_code_2022_Plasma.html')\n",
    "create_html(df_HEP,html_name='html_code_2022_HEP.html')\n",
    "create_html(df_Applied,html_name='html_code_2022_Applied.html')\n",
    "create_html(df_Astro,html_name='html_code_2022_Astro.html')\n",
    "create_html(df_Atmos,html_name='html_code_2022_Atmospheric.html')\n",
    "create_html(df_InPerson,html_name='html_code_2022_InPerson.html')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "worth-cleveland",
   "metadata": {},
   "source": [
    "# Create Calendar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "asian-subsection",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Start_DateTime']=df['StartDate']+' '+df['StartTime']\n",
    "df['Start_DateTime'] = pd.to_datetime(df['Start_DateTime'],format=('%m/%d/%y  %I:%M %p'))\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['EndDate']+' '+df['EndTime']\n",
    "df['End_DateTime'] = pd.to_datetime(df['End_DateTime'],format=('%m/%d/%y  %I:%M %p'))\n",
    "df['End_DateTime'] = df['End_DateTime'] + timedelta(hours=4)#.dt.tz_localize('UTC')#.dt.tz_convert('US/Eastern')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "handled-payroll",
   "metadata": {},
   "outputs": [],
   "source": [
    "# for i,j in enumerate(df['End_DateTime'].values):\n",
    "#     print (i,pd.to_datetime(j,format=('%m/%d/%y  %I:%M %p')))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "experienced-dimension",
   "metadata": {},
   "outputs": [],
   "source": [
    "def prep_list(df):\n",
    "    Names_L= df['Author_I'].values\n",
    "    title_L = df['Paper 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": 26,
   "id": "upper-softball",
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-07-15 22:00:00</td>\n",
       "      <td>2022-07-15 22:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-07-15 22:30:00</td>\n",
       "      <td>2022-07-15 22:45:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-07-15 22:45:00</td>\n",
       "      <td>2022-07-15 23:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-07-15 23:00:00</td>\n",
       "      <td>2022-07-15 23:15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-07-15 23:15:00</td>\n",
       "      <td>2022-07-15 23:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2022-07-17 15:00:00</td>\n",
       "      <td>2022-07-17 15:15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2022-07-17 15:15:00</td>\n",
       "      <td>2022-07-17 15:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2022-07-17 15:45:00</td>\n",
       "      <td>2022-07-17 16:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>2022-07-17 16:00:00</td>\n",
       "      <td>2022-07-17 16:15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>2022-07-17 16:15:00</td>\n",
       "      <td>2022-07-17 16:30:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>73 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Start_DateTime        End_DateTime\n",
       "0  2022-07-15 22:00:00 2022-07-15 22:30:00\n",
       "1  2022-07-15 22:30:00 2022-07-15 22:45:00\n",
       "2  2022-07-15 22:45:00 2022-07-15 23:00:00\n",
       "3  2022-07-15 23:00:00 2022-07-15 23:15:00\n",
       "4  2022-07-15 23:15:00 2022-07-15 23:30:00\n",
       "..                 ...                 ...\n",
       "68 2022-07-17 15:00:00 2022-07-17 15:15:00\n",
       "69 2022-07-17 15:15:00 2022-07-17 15:30:00\n",
       "70 2022-07-17 15:45:00 2022-07-17 16:00:00\n",
       "71 2022-07-17 16:00:00 2022-07-17 16:15:00\n",
       "72 2022-07-17 16:15:00 2022-07-17 16:30:00\n",
       "\n",
       "[73 rows x 2 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['Start_DateTime','End_DateTime']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "fourth-correlation",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{<Event 'Ram Babu Ray' begin:2022-07-15T04:00:00+00:00 end:2022-07-16T04:15:00+00:00>,\n",
       " <Event 'Christopher Fischer (Invited)' begin:2022-07-15T22:00:00+00:00 end:2022-07-15T22:30:00+00:00>,\n",
       " <Event 'Arbin Thapaliya' begin:2022-07-15T22:30:00+00:00 end:2022-07-15T22:45:00+00:00>,\n",
       " <Event 'Puskar Chapgain' begin:2022-07-15T22:45:00+00:00 end:2022-07-15T23:00:00+00:00>,\n",
       " <Event 'Simon Rees' begin:2022-07-15T23:00:00+00:00 end:2022-07-15T23:15:00+00:00>,\n",
       " <Event 'Rajendra Dahal (Invited)' begin:2022-07-15T23:00:00+00:00 end:2022-07-15T23:30:00+00:00>,\n",
       " <Event 'Anna Mederer' begin:2022-07-15T23:15:00+00:00 end:2022-07-15T23:30:00+00:00>,\n",
       " <Event 'Iftakhar Bin Elius' begin:2022-07-15T23:30:00+00:00 end:2022-07-15T23:45:00+00:00>,\n",
       " <Event 'Dipendra Dahal' begin:2022-07-15T23:45:00+00:00 end:2022-07-16T00:00:00+00:00>,\n",
       " <Event 'Bikalpa Neupane (Invited)' begin:2022-07-15T23:45:00+00:00 end:2022-07-16T00:15:00+00:00>,\n",
       " <Event 'Niraj Aryal' begin:2022-07-16T00:00:00+00:00 end:2022-07-16T00:15:00+00:00>,\n",
       " <Event 'Pratik Kafle' begin:2022-07-16T00:15:00+00:00 end:2022-07-16T00:30:00+00:00>,\n",
       " <Event 'Yangyang Liu' begin:2022-07-16T00:15:00+00:00 end:2022-07-16T00:30:00+00:00>,\n",
       " <Event 'Kamal R Dhakal' begin:2022-07-16T00:30:00+00:00 end:2022-07-16T00:45:00+00:00>,\n",
       " <Event 'Amba Datt Pant' begin:2022-07-16T00:30:00+00:00 end:2022-07-16T00:45:00+00:00>,\n",
       " <Event 'Sumit Paudyal (Invited)' begin:2022-07-16T01:00:00+00:00 end:2022-07-16T01:30:00+00:00>,\n",
       " <Event 'Jagannath Devkota' begin:2022-07-16T01:30:00+00:00 end:2022-07-16T01:45:00+00:00>,\n",
       " <Event 'Bivek Pokhrel' begin:2022-07-16T01:45:00+00:00 end:2022-07-16T02:00:00+00:00>,\n",
       " <Event 'Aayush Gautam' begin:2022-07-16T02:15:00+00:00 end:2022-07-16T02:30:00+00:00>,\n",
       " <Event 'Bhawani Datt Joshi (Invited)' begin:2022-07-16T02:15:00+00:00 end:2022-07-16T02:45:00+00:00>,\n",
       " <Event 'Prajwal Poudyal' begin:2022-07-16T02:45:00+00:00 end:2022-07-16T03:00:00+00:00>,\n",
       " <Event 'Sujan Shrestha' begin:2022-07-16T02:45:00+00:00 end:2022-07-16T03:00:00+00:00>,\n",
       " <Event 'Daya Nidhi Chhatkuli' begin:2022-07-16T03:00:00+00:00 end:2022-07-16T03:15:00+00:00>,\n",
       " <Event 'Jhulan Powrel' begin:2022-07-16T03:00:00+00:00 end:2022-07-16T03:15:00+00:00>,\n",
       " <Event 'Yogesh Singh Maharjan' begin:2022-07-16T03:15:00+00:00 end:2022-07-16T03:30:00+00:00>,\n",
       " <Event 'Sanjay Rijal' begin:2022-07-16T03:15:00+00:00 end:2022-07-16T03:30:00+00:00>,\n",
       " <Event 'Sabin Regmi' begin:2022-07-16T03:30:00+00:00 end:2022-07-16T03:45:00+00:00>,\n",
       " <Event 'Sushila Sigdel' begin:2022-07-16T03:30:00+00:00 end:2022-07-16T03:45:00+00:00>,\n",
       " <Event 'Tibendra Adhikari' begin:2022-07-16T03:45:00+00:00 end:2022-07-16T04:00:00+00:00>,\n",
       " <Event 'Srikanthan Ramachandran (Invited)' begin:2022-07-16T11:15:00+00:00 end:2022-07-16T11:45:00+00:00>,\n",
       " <Event 'Nabin Malakar' begin:2022-07-16T11:45:00+00:00 end:2022-07-16T12:00:00+00:00>,\n",
       " <Event 'Santosh Sapkota' begin:2022-07-16T12:00:00+00:00 end:2022-07-16T12:15:00+00:00>,\n",
       " <Event 'Tirtha Raj Joshi (Invited)' begin:2022-07-16T12:00:00+00:00 end:2022-07-16T12:30:00+00:00>,\n",
       " <Event 'Prakash Man Shrestha' begin:2022-07-16T12:15:00+00:00 end:2022-07-16T12:30:00+00:00>,\n",
       " <Event 'Roshan Chalise' begin:2022-07-16T12:30:00+00:00 end:2022-07-16T12:45:00+00:00>,\n",
       " <Event 'Santosh Dhungana' begin:2022-07-16T12:45:00+00:00 end:2022-07-16T13:00:00+00:00>,\n",
       " <Event 'Rakshya Khatiwada (Invited)' begin:2022-07-16T12:45:00+00:00 end:2022-07-16T13:15:00+00:00>,\n",
       " <Event 'Chandra Adhikari' begin:2022-07-16T13:00:00+00:00 end:2022-07-16T13:15:00+00:00>,\n",
       " <Event 'Shiva Bikram Thapa' begin:2022-07-16T13:15:00+00:00 end:2022-07-16T13:30:00+00:00>,\n",
       " <Event 'Devendra Raj Upadhyay' begin:2022-07-16T13:15:00+00:00 end:2022-07-16T13:30:00+00:00>,\n",
       " <Event 'Num Prasad Acharya' begin:2022-07-16T13:30:00+00:00 end:2022-07-16T13:45:00+00:00>,\n",
       " <Event 'Niraj Dhital (Invited)' begin:2022-07-16T13:30:00+00:00 end:2022-07-16T14:00:00+00:00>,\n",
       " <Event 'Tika R Kafle' begin:2022-07-16T13:45:00+00:00 end:2022-07-16T14:00:00+00:00>,\n",
       " <Event 'Qaisar Shafi (Invited)' begin:2022-07-16T14:15:00+00:00 end:2022-07-16T15:15:00+00:00>,\n",
       " <Event 'Todd Satogata (Invited)' begin:2022-07-16T15:30:00+00:00 end:2022-07-16T16:00:00+00:00>,\n",
       " <Event 'Ishwari Prasad Parajuli' begin:2022-07-16T16:00:00+00:00 end:2022-07-16T16:15:00+00:00>,\n",
       " <Event 'Ashok Timsina' begin:2022-07-16T16:15:00+00:00 end:2022-07-16T16:30:00+00:00>,\n",
       " <Event 'Joan Marler (Invited)' begin:2022-07-16T18:00:00+00:00 end:2022-07-16T18:30:00+00:00>,\n",
       " <Event 'Tikaram Neupane' begin:2022-07-16T18:30:00+00:00 end:2022-07-16T18:45:00+00:00>,\n",
       " <Event 'Sunil K. Karna' begin:2022-07-16T18:45:00+00:00 end:2022-07-16T19:00:00+00:00>,\n",
       " <Event 'Trailokya Bhattarai' begin:2022-07-16T19:00:00+00:00 end:2022-07-16T19:15:00+00:00>,\n",
       " <Event 'Bibek Singh Dhami' begin:2022-07-16T19:30:00+00:00 end:2022-07-16T19:45:00+00:00>,\n",
       " <Event 'Nabin Kumar Raut' begin:2022-07-16T19:45:00+00:00 end:2022-07-16T20:00:00+00:00>,\n",
       " <Event 'Bishnu Datt Pandey' begin:2022-07-16T20:00:00+00:00 end:2022-07-16T20:15:00+00:00>,\n",
       " <Event 'Puspa Pandey' begin:2022-07-16T20:15:00+00:00 end:2022-07-16T20:30:00+00:00>,\n",
       " <Event 'Bashu Dev Khanal' begin:2022-07-16T20:30:00+00:00 end:2022-07-16T20:45:00+00:00>,\n",
       " <Event 'Indra D. Sahu (Invited)' begin:2022-07-16T23:00:00+00:00 end:2022-07-16T23:30:00+00:00>,\n",
       " <Event 'Nawal Kishore Khadka' begin:2022-07-16T23:30:00+00:00 end:2022-07-16T23:45:00+00:00>,\n",
       " <Event 'Raju Timsina' begin:2022-07-16T23:45:00+00:00 end:2022-07-17T00:00:00+00:00>,\n",
       " <Event 'Leona Choi' begin:2022-07-17T00:00:00+00:00 end:2022-07-17T00:15:00+00:00>,\n",
       " <Event 'Prem Chapagain (Invited)' begin:2022-07-17T00:30:00+00:00 end:2022-07-17T00:45:00+00:00>,\n",
       " <Event 'Bhim M Adhikari' begin:2022-07-17T00:45:00+00:00 end:2022-07-17T01:00:00+00:00>,\n",
       " <Event 'BISHAL PANTHI' begin:2022-07-17T01:00:00+00:00 end:2022-07-17T01:15:00+00:00>,\n",
       " <Event 'Bidhya Thapa' begin:2022-07-17T01:15:00+00:00 end:2022-07-17T01:30:00+00:00>,\n",
       " <Event 'Madhab Neupane (Invited)' begin:2022-07-17T13:30:00+00:00 end:2022-07-17T14:00:00+00:00>,\n",
       " <Event 'Milo Sprague' begin:2022-07-17T14:00:00+00:00 end:2022-07-17T14:15:00+00:00>,\n",
       " <Event 'Gyanendra Dhakal' begin:2022-07-17T14:30:00+00:00 end:2022-07-17T14:45:00+00:00>,\n",
       " <Event 'Dipendra Banjara' begin:2022-07-17T14:45:00+00:00 end:2022-07-17T15:00:00+00:00>,\n",
       " <Event 'Robert Smith' begin:2022-07-17T15:00:00+00:00 end:2022-07-17T15:15:00+00:00>,\n",
       " <Event 'Hari Bhandari ' begin:2022-07-17T15:15:00+00:00 end:2022-07-17T15:30:00+00:00>,\n",
       " <Event 'Dr. Anup Pradhan Sakhya' begin:2022-07-17T15:45:00+00:00 end:2022-07-17T16:00:00+00:00>,\n",
       " <Event 'Ganesh Pokharel' begin:2022-07-17T16:00:00+00:00 end:2022-07-17T16:15:00+00:00>,\n",
       " <Event 'Raj K. Rai' begin:2022-07-17T16:15:00+00:00 end:2022-07-17T16:30:00+00:00>}"
      ]
     },
     "execution_count": 27,
     "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": 28,
   "id": "signal-morris",
   "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>Date</th>\n",
       "      <th>Session</th>\n",
       "      <th>StartDate</th>\n",
       "      <th>StartTime</th>\n",
       "      <th>EndDate</th>\n",
       "      <th>EndTime</th>\n",
       "      <th>Invited</th>\n",
       "      <th>Presenter</th>\n",
       "      <th>Presenter's Affiliation</th>\n",
       "      <th>In-Person/Remote</th>\n",
       "      <th>Coauthors</th>\n",
       "      <th>Coauthors affiliation</th>\n",
       "      <th>Paper Title</th>\n",
       "      <th>Abstract</th>\n",
       "      <th>Abstract Number</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:00 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:30 PM</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Christopher Fischer</td>\n",
       "      <td>University of Kansas</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Sarah Rush</td>\n",
       "      <td>University of Kansas</td>\n",
       "      <td>Helping traditionally under-served populations...</td>\n",
       "      <td>We have developed a new curriculum for introdu...</td>\n",
       "      <td>ANPA2022_0101</td>\n",
       "      <td>2022-07-15 18:00:00</td>\n",
       "      <td>2022-07-16 03:45:00</td>\n",
       "      <td>Christopher Fischer (Invited)</td>\n",
       "      <td>2022-07-15 22:00:00</td>\n",
       "      <td>2022-07-15 22:30:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:30 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:45 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Arbin Thapaliya</td>\n",
       "      <td>Franklin College</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Jessica Mahoney;</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Teaching ultrasound to undergraduates using pr...</td>\n",
       "      <td>In this talk, we will present about a unique c...</td>\n",
       "      <td>ANPA2022_0102</td>\n",
       "      <td>2022-07-15 18:30:00</td>\n",
       "      <td>2022-07-16 04:15:00</td>\n",
       "      <td>Arbin Thapaliya</td>\n",
       "      <td>2022-07-15 22:30:00</td>\n",
       "      <td>2022-07-15 22:45:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>6:45 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:00 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Puskar Chapgain</td>\n",
       "      <td>Southern Arkansas University</td>\n",
       "      <td>Remote</td>\n",
       "      <td>Nabin Malakar; Suman Neupane; Dipak Rimal; Lav...</td>\n",
       "      <td>Worcester State University; Middle Tennessee S...</td>\n",
       "      <td>Does Peer-Assisted Instruction for University ...</td>\n",
       "      <td>Supplemental Instruction (SI) is a teaching me...</td>\n",
       "      <td>ANPA2022_0103</td>\n",
       "      <td>2022-07-15 18:45:00</td>\n",
       "      <td>2022-07-16 04:30:00</td>\n",
       "      <td>Puskar Chapgain</td>\n",
       "      <td>2022-07-15 22:45:00</td>\n",
       "      <td>2022-07-15 23:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:00 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:15 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Simon Rees</td>\n",
       "      <td>WPI Student, Rudra Kafle</td>\n",
       "      <td>Remote</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Supplementing the Learning of Physics with the...</td>\n",
       "      <td>Graphicacy, or proficiency in using and making...</td>\n",
       "      <td>ANPA2022_0104</td>\n",
       "      <td>2022-07-15 19:00:00</td>\n",
       "      <td>2022-07-16 04:45:00</td>\n",
       "      <td>Simon Rees</td>\n",
       "      <td>2022-07-15 23:00:00</td>\n",
       "      <td>2022-07-15 23:15:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>07/15/22</td>\n",
       "      <td>Physics Education Research</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:15 PM</td>\n",
       "      <td>07/15/22</td>\n",
       "      <td>7:30 PM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Anna Mederer</td>\n",
       "      <td>Worcester Polytechnic Institute</td>\n",
       "      <td>Remote</td>\n",
       "      <td>L Dana</td>\n",
       "      <td>Worcester Polytechnic Institute</td>\n",
       "      <td>Scaffolding Writing in Physics Labs</td>\n",
       "      <td>Communicating physics is an essential learning...</td>\n",
       "      <td>ANPA2022_0105</td>\n",
       "      <td>2022-07-15 19:15:00</td>\n",
       "      <td>2022-07-16 05:00:00</td>\n",
       "      <td>Anna Mederer</td>\n",
       "      <td>2022-07-15 23:15:00</td>\n",
       "      <td>2022-07-15 23:30:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Date                     Session StartDate StartTime   EndDate  \\\n",
       "0  07/15/22  Physics Education Research  07/15/22   6:00 PM  07/15/22   \n",
       "1  07/15/22  Physics Education Research  07/15/22   6:30 PM  07/15/22   \n",
       "2  07/15/22  Physics Education Research  07/15/22   6:45 PM  07/15/22   \n",
       "3  07/15/22  Physics Education Research  07/15/22   7:00 PM  07/15/22   \n",
       "4  07/15/22  Physics Education Research  07/15/22   7:15 PM  07/15/22   \n",
       "\n",
       "   EndTime Invited            Presenter          Presenter's Affiliation  \\\n",
       "0  6:30 PM     1.0  Christopher Fischer             University of Kansas   \n",
       "1  6:45 PM     NaN      Arbin Thapaliya                 Franklin College   \n",
       "2  7:00 PM     NaN      Puskar Chapgain     Southern Arkansas University   \n",
       "3  7:15 PM     NaN           Simon Rees         WPI Student, Rudra Kafle   \n",
       "4  7:30 PM     NaN         Anna Mederer  Worcester Polytechnic Institute   \n",
       "\n",
       "  In-Person/Remote                                          Coauthors  \\\n",
       "0           Remote                                         Sarah Rush   \n",
       "1           Remote                                   Jessica Mahoney;   \n",
       "2           Remote  Nabin Malakar; Suman Neupane; Dipak Rimal; Lav...   \n",
       "3           Remote                                                NaN   \n",
       "4           Remote                                             L Dana   \n",
       "\n",
       "                               Coauthors affiliation  \\\n",
       "0                               University of Kansas   \n",
       "1                                                NaN   \n",
       "2  Worcester State University; Middle Tennessee S...   \n",
       "3                                                NaN   \n",
       "4                    Worcester Polytechnic Institute   \n",
       "\n",
       "                                         Paper Title  \\\n",
       "0  Helping traditionally under-served populations...   \n",
       "1  Teaching ultrasound to undergraduates using pr...   \n",
       "2  Does Peer-Assisted Instruction for University ...   \n",
       "3  Supplementing the Learning of Physics with the...   \n",
       "4                Scaffolding Writing in Physics Labs   \n",
       "\n",
       "                                            Abstract Abstract Number  \\\n",
       "0  We have developed a new curriculum for introdu...   ANPA2022_0101   \n",
       "1  In this talk, we will present about a unique c...   ANPA2022_0102   \n",
       "2  Supplemental Instruction (SI) is a teaching me...   ANPA2022_0103   \n",
       "3  Graphicacy, or proficiency in using and making...   ANPA2022_0104   \n",
       "4  Communicating physics is an essential learning...   ANPA2022_0105   \n",
       "\n",
       "            Date/Time     Nepal Date/Time                       Author_I  \\\n",
       "0 2022-07-15 18:00:00 2022-07-16 03:45:00  Christopher Fischer (Invited)   \n",
       "1 2022-07-15 18:30:00 2022-07-16 04:15:00                Arbin Thapaliya   \n",
       "2 2022-07-15 18:45:00 2022-07-16 04:30:00                Puskar Chapgain   \n",
       "3 2022-07-15 19:00:00 2022-07-16 04:45:00                     Simon Rees   \n",
       "4 2022-07-15 19:15:00 2022-07-16 05:00:00                   Anna Mederer   \n",
       "\n",
       "       Start_DateTime        End_DateTime  \n",
       "0 2022-07-15 22:00:00 2022-07-15 22:30:00  \n",
       "1 2022-07-15 22:30:00 2022-07-15 22:45:00  \n",
       "2 2022-07-15 22:45:00 2022-07-15 23:00:00  \n",
       "3 2022-07-15 23:00:00 2022-07-15 23:15:00  \n",
       "4 2022-07-15 23:15:00 2022-07-15 23:30:00  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "interstate-shipping",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('ANPA Conference Calendar.ics', 'w', encoding=\"utf-8\") as f:\n",
    "    f.write(str(c))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "surprised-rugby",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}