libcal_xml.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "f9b77d60-3721-4857-9ee9-bb1e86df92e8",
   "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>title</th>\n",
       "      <th>start</th>\n",
       "      <th>end</th>\n",
       "      <th>URL</th>\n",
       "      <th>categories</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3MT Slide Design and Presentation Skills Overv...</td>\n",
       "      <td>2024-01-22T16:00:00-05:00</td>\n",
       "      <td>2024-01-22T17:00:00-05:00</td>\n",
       "      <td>https://cmu.libcal.com/event/11620595</td>\n",
       "      <td>Writing and Publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Submitting Your Thesis or Dissertation to CMU ...</td>\n",
       "      <td>2024-01-24T12:00:00-05:00</td>\n",
       "      <td>2024-01-24T13:00:00-05:00</td>\n",
       "      <td>https://cmu.libcal.com/event/11622573</td>\n",
       "      <td>Open Science, Writing and Publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Open Science Framework (OSF) for Beginners</td>\n",
       "      <td>2024-01-26T13:00:00-05:00</td>\n",
       "      <td>2024-01-26T14:00:00-05:00</td>\n",
       "      <td>https://cmu.libcal.com/event/11721905</td>\n",
       "      <td>Open Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Data Carpentry: Introduction to Python</td>\n",
       "      <td>2024-01-29T09:00:00-05:00</td>\n",
       "      <td>2024-01-29T12:00:00-05:00</td>\n",
       "      <td>https://cmu.libcal.com/event/11732479</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Introduction to LaTeX and Overleaf</td>\n",
       "      <td>2024-01-29T12:00:00-05:00</td>\n",
       "      <td>2024-01-29T13:00:00-05:00</td>\n",
       "      <td>https://cmu.libcal.com/event/11622522</td>\n",
       "      <td>Writing and Publishing</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title  \\\n",
       "0  3MT Slide Design and Presentation Skills Overv...   \n",
       "1  Submitting Your Thesis or Dissertation to CMU ...   \n",
       "2         Open Science Framework (OSF) for Beginners   \n",
       "3             Data Carpentry: Introduction to Python   \n",
       "4                 Introduction to LaTeX and Overleaf   \n",
       "\n",
       "                       start                        end  \\\n",
       "0  2024-01-22T16:00:00-05:00  2024-01-22T17:00:00-05:00   \n",
       "1  2024-01-24T12:00:00-05:00  2024-01-24T13:00:00-05:00   \n",
       "2  2024-01-26T13:00:00-05:00  2024-01-26T14:00:00-05:00   \n",
       "3  2024-01-29T09:00:00-05:00  2024-01-29T12:00:00-05:00   \n",
       "4  2024-01-29T12:00:00-05:00  2024-01-29T13:00:00-05:00   \n",
       "\n",
       "                                     URL                            categories  \n",
       "0  https://cmu.libcal.com/event/11620595                Writing and Publishing  \n",
       "1  https://cmu.libcal.com/event/11622573  Open Science, Writing and Publishing  \n",
       "2  https://cmu.libcal.com/event/11721905                          Open Science  \n",
       "3  https://cmu.libcal.com/event/11732479       Open Science, Working With Data  \n",
       "4  https://cmu.libcal.com/event/11622522                Writing and Publishing  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import xml.etree.ElementTree as ET\n",
    "import pandas as pd\n",
    "\n",
    "tree = ET.parse('calendar_9148_1704824475_2024-01-09.xml')\n",
    "root = tree.getroot()\n",
    "\n",
    "data = []\n",
    "\n",
    "root_events = root.find('events')\n",
    "events_all = root_events.findall('event')\n",
    "\n",
    "for event in events_all:\n",
    "    event_data = {}\n",
    "    for tag in ['title', 'start', 'end', 'URL', 'categories']:\n",
    "        event_tag = event.find(tag)\n",
    "        if event_tag is not None:\n",
    "            if tag == 'categories':\n",
    "                categories = [cats.text for cats in event_tag.findall('category')]\n",
    "                event_data[tag] = ', '.join(categories)\n",
    "            else:\n",
    "                event_data[tag] = event_tag.text\n",
    "        else:\n",
    "            event_data[tag] = None\n",
    "    data.append(event_data)\n",
    "\n",
    "df = pd.DataFrame(data)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "ee608d6d-6353-4165-b9a0-e8795ae51e60",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "726c2397-67f5-45ab-a4be-6bc91e6d139c",
   "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>title</th>\n",
       "      <th>start</th>\n",
       "      <th>end</th>\n",
       "      <th>URL</th>\n",
       "      <th>categories</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Submitting Your Thesis or Dissertation to CMU ...</td>\n",
       "      <td>2024-01-24T12:00:00-05:00</td>\n",
       "      <td>2024-01-24T13:00:00-05:00</td>\n",
       "      <td>https://cmu.libcal.com/event/11622573</td>\n",
       "      <td>Open Science, Writing and Publishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Open Science Framework (OSF) for Beginners</td>\n",
       "      <td>2024-01-26T13:00:00-05:00</td>\n",
       "      <td>2024-01-26T14:00:00-05:00</td>\n",
       "      <td>https://cmu.libcal.com/event/11721905</td>\n",
       "      <td>Open Science</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Data Carpentry: Introduction to Python</td>\n",
       "      <td>2024-01-29T09:00:00-05:00</td>\n",
       "      <td>2024-01-29T12:00:00-05:00</td>\n",
       "      <td>https://cmu.libcal.com/event/11732479</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Data Carpentry: Introduction to Python</td>\n",
       "      <td>2024-01-30T09:00:00-05:00</td>\n",
       "      <td>2024-01-30T12:00:00-05:00</td>\n",
       "      <td>https://cmu.libcal.com/event/11732480</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Introduction to R Part 1: Getting started with...</td>\n",
       "      <td>2024-01-30T13:00:00-05:00</td>\n",
       "      <td>2024-01-30T14:30:00-05:00</td>\n",
       "      <td>https://cmu.libcal.com/event/11677891</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title  \\\n",
       "1  Submitting Your Thesis or Dissertation to CMU ...   \n",
       "2         Open Science Framework (OSF) for Beginners   \n",
       "3             Data Carpentry: Introduction to Python   \n",
       "5             Data Carpentry: Introduction to Python   \n",
       "7  Introduction to R Part 1: Getting started with...   \n",
       "\n",
       "                       start                        end  \\\n",
       "1  2024-01-24T12:00:00-05:00  2024-01-24T13:00:00-05:00   \n",
       "2  2024-01-26T13:00:00-05:00  2024-01-26T14:00:00-05:00   \n",
       "3  2024-01-29T09:00:00-05:00  2024-01-29T12:00:00-05:00   \n",
       "5  2024-01-30T09:00:00-05:00  2024-01-30T12:00:00-05:00   \n",
       "7  2024-01-30T13:00:00-05:00  2024-01-30T14:30:00-05:00   \n",
       "\n",
       "                                     URL                            categories  \n",
       "1  https://cmu.libcal.com/event/11622573  Open Science, Writing and Publishing  \n",
       "2  https://cmu.libcal.com/event/11721905                          Open Science  \n",
       "3  https://cmu.libcal.com/event/11732479       Open Science, Working With Data  \n",
       "5  https://cmu.libcal.com/event/11732480       Open Science, Working With Data  \n",
       "7  https://cmu.libcal.com/event/11677891       Open Science, Working With Data  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered_rows = df[df['categories'].apply(lambda cats: all(cat in cats.split(', ') for cat in ['Open Science']))]\n",
    "filtered_rows.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "8b5d6dae-6e2c-4d36-9361-30e84fdfdf5f",
   "metadata": {},
   "outputs": [],
   "source": [
    "workshops = filtered_rows.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "a9d47a67-6e88-4387-ab3b-753fcb79e42d",
   "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>title</th>\n",
       "      <th>start</th>\n",
       "      <th>end</th>\n",
       "      <th>URL</th>\n",
       "      <th>categories</th>\n",
       "      <th>date</th>\n",
       "      <th>formatted_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Submitting Your Thesis or Dissertation to CMU ...</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11622573</td>\n",
       "      <td>Open Science, Writing and Publishing</td>\n",
       "      <td>2024-01-24</td>\n",
       "      <td>January 24, 2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Open Science Framework (OSF) for Beginners</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>02:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11721905</td>\n",
       "      <td>Open Science</td>\n",
       "      <td>2024-01-26</td>\n",
       "      <td>January 26, 2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Data Carpentry: Introduction to Python</td>\n",
       "      <td>09:00 AM</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11732479</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-01-29</td>\n",
       "      <td>January 29, 2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Data Carpentry: Introduction to Python</td>\n",
       "      <td>09:00 AM</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11732480</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-01-30</td>\n",
       "      <td>January 30, 2024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Introduction to R Part 1: Getting started with...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>02:30 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11677891</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-01-30</td>\n",
       "      <td>January 30, 2024</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               title     start       end  \\\n",
       "1  Submitting Your Thesis or Dissertation to CMU ...  12:00 PM  01:00 PM   \n",
       "2         Open Science Framework (OSF) for Beginners  01:00 PM  02:00 PM   \n",
       "3             Data Carpentry: Introduction to Python  09:00 AM  12:00 PM   \n",
       "5             Data Carpentry: Introduction to Python  09:00 AM  12:00 PM   \n",
       "7  Introduction to R Part 1: Getting started with...  01:00 PM  02:30 PM   \n",
       "\n",
       "                                     URL  \\\n",
       "1  https://cmu.libcal.com/event/11622573   \n",
       "2  https://cmu.libcal.com/event/11721905   \n",
       "3  https://cmu.libcal.com/event/11732479   \n",
       "5  https://cmu.libcal.com/event/11732480   \n",
       "7  https://cmu.libcal.com/event/11677891   \n",
       "\n",
       "                             categories        date    formatted_date  \n",
       "1  Open Science, Writing and Publishing  2024-01-24  January 24, 2024  \n",
       "2                          Open Science  2024-01-26  January 26, 2024  \n",
       "3       Open Science, Working With Data  2024-01-29  January 29, 2024  \n",
       "5       Open Science, Working With Data  2024-01-30  January 30, 2024  \n",
       "7       Open Science, Working With Data  2024-01-30  January 30, 2024  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "workshops['date'] = pd.to_datetime(workshops['start'], format='%Y-%m-%d', utc=True).dt.date\n",
    "workshops['formatted_date'] = pd.to_datetime(workshops['date']).dt.strftime('%B %d, %Y')\n",
    "workshops['start'] = pd.to_datetime(workshops['start'], format='%Y-%m-%d %H:%M:%S', utc=True).dt.tz_convert('US/Eastern').dt.strftime('%I:%M %p')\n",
    "workshops['end'] = pd.to_datetime(workshops['end'], format='%Y-%m-%d %H:%M:%S', utc=True).dt.tz_convert('US/Eastern').dt.strftime('%I:%M %p')\n",
    "workshops.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "533332a4-a041-491a-a4a1-a42e51d5794c",
   "metadata": {},
   "outputs": [],
   "source": [
    "workshops.to_csv('workshops.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "7b153b6c-dcb2-48c6-8856-9af54871934b",
   "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>path</th>\n",
       "      <th>URL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>content/osf.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11721905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://datacarpentry.org/python-ecology-lesson/</td>\n",
       "      <td>https://cmu.libcal.com/event/11732479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://datacarpentry.org/python-ecology-lesson/</td>\n",
       "      <td>https://cmu.libcal.com/event/11732480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>IntroR_Materials/introR_pt1/00_introR_part1.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11677891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://datacarpentry.org/python-ecology-lesson/</td>\n",
       "      <td>https://cmu.libcal.com/event/11732481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Python_Series_Materials/part_1/part_1.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11690015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>cli/cli_main.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11722733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>IntroR_Materials/introR_pt2/00_introR_part2.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11677895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Python_Series_Materials/part_3/part_3.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11720589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Git_Materials/index.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11720611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>IntroR_Materials/introR_pt1/00_introR_part1.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11676663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Python_Series_Materials/part_3/part_3.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11720619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>content/openrefine.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11676509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>GH_Materials/index.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11720634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>IntroR_Materials/introR_pt2/00_introR_part2.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11676685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>content/git_github.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11720699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>content/code_ocean.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11720891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>cli/cli_main.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11722048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>content/osf.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11722088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Python_Series_Materials/part_1/part_1.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11720957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Python_Series_Materials/making_the_most_jupyte...</td>\n",
       "      <td>https://cmu.libcal.com/event/11722137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Python_Series_Materials/part_2/part_2.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11720984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Python_Series_Materials/python_harvesting/py_h...</td>\n",
       "      <td>https://cmu.libcal.com/event/11722162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Python_Series_Materials/part_3/part_3.md</td>\n",
       "      <td>https://cmu.libcal.com/event/11721033</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 path  \\\n",
       "0                                      content/osf.md   \n",
       "1    https://datacarpentry.org/python-ecology-lesson/   \n",
       "2    https://datacarpentry.org/python-ecology-lesson/   \n",
       "3      IntroR_Materials/introR_pt1/00_introR_part1.md   \n",
       "4    https://datacarpentry.org/python-ecology-lesson/   \n",
       "5            Python_Series_Materials/part_1/part_1.md   \n",
       "6                                     cli/cli_main.md   \n",
       "7      IntroR_Materials/introR_pt2/00_introR_part2.md   \n",
       "8            Python_Series_Materials/part_3/part_3.md   \n",
       "9                              Git_Materials/index.md   \n",
       "10     IntroR_Materials/introR_pt1/00_introR_part1.md   \n",
       "11           Python_Series_Materials/part_3/part_3.md   \n",
       "12                              content/openrefine.md   \n",
       "13                              GH_Materials/index.md   \n",
       "14     IntroR_Materials/introR_pt2/00_introR_part2.md   \n",
       "15                              content/git_github.md   \n",
       "16                              content/code_ocean.md   \n",
       "17                                    cli/cli_main.md   \n",
       "18                                     content/osf.md   \n",
       "19           Python_Series_Materials/part_1/part_1.md   \n",
       "20  Python_Series_Materials/making_the_most_jupyte...   \n",
       "21           Python_Series_Materials/part_2/part_2.md   \n",
       "22  Python_Series_Materials/python_harvesting/py_h...   \n",
       "23           Python_Series_Materials/part_3/part_3.md   \n",
       "\n",
       "                                      URL  \n",
       "0   https://cmu.libcal.com/event/11721905  \n",
       "1   https://cmu.libcal.com/event/11732479  \n",
       "2   https://cmu.libcal.com/event/11732480  \n",
       "3   https://cmu.libcal.com/event/11677891  \n",
       "4   https://cmu.libcal.com/event/11732481  \n",
       "5   https://cmu.libcal.com/event/11690015  \n",
       "6   https://cmu.libcal.com/event/11722733  \n",
       "7   https://cmu.libcal.com/event/11677895  \n",
       "8   https://cmu.libcal.com/event/11720589  \n",
       "9   https://cmu.libcal.com/event/11720611  \n",
       "10  https://cmu.libcal.com/event/11676663  \n",
       "11  https://cmu.libcal.com/event/11720619  \n",
       "12  https://cmu.libcal.com/event/11676509  \n",
       "13  https://cmu.libcal.com/event/11720634  \n",
       "14  https://cmu.libcal.com/event/11676685  \n",
       "15  https://cmu.libcal.com/event/11720699  \n",
       "16  https://cmu.libcal.com/event/11720891  \n",
       "17  https://cmu.libcal.com/event/11722048  \n",
       "18  https://cmu.libcal.com/event/11722088  \n",
       "19  https://cmu.libcal.com/event/11720957  \n",
       "20  https://cmu.libcal.com/event/11722137  \n",
       "21  https://cmu.libcal.com/event/11720984  \n",
       "22  https://cmu.libcal.com/event/11722162  \n",
       "23  https://cmu.libcal.com/event/11721033  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "paths = pd.read_csv('content_paths.csv').drop('title',axis=1)\n",
    "paths"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "6982c32b-7b4a-43ce-99bb-f3e1721b40c8",
   "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>title</th>\n",
       "      <th>start</th>\n",
       "      <th>end</th>\n",
       "      <th>URL</th>\n",
       "      <th>categories</th>\n",
       "      <th>date</th>\n",
       "      <th>formatted_date</th>\n",
       "      <th>path</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Submitting Your Thesis or Dissertation to CMU ...</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11622573</td>\n",
       "      <td>Open Science, Writing and Publishing</td>\n",
       "      <td>2024-01-24</td>\n",
       "      <td>January 24, 2024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Open Science Framework (OSF) for Beginners</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>02:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11721905</td>\n",
       "      <td>Open Science</td>\n",
       "      <td>2024-01-26</td>\n",
       "      <td>January 26, 2024</td>\n",
       "      <td>content/osf.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Data Carpentry: Introduction to Python</td>\n",
       "      <td>09:00 AM</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11732479</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-01-29</td>\n",
       "      <td>January 29, 2024</td>\n",
       "      <td>https://datacarpentry.org/python-ecology-lesson/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Data Carpentry: Introduction to Python</td>\n",
       "      <td>09:00 AM</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11732480</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-01-30</td>\n",
       "      <td>January 30, 2024</td>\n",
       "      <td>https://datacarpentry.org/python-ecology-lesson/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Introduction to R Part 1: Getting started with...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>02:30 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11677891</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-01-30</td>\n",
       "      <td>January 30, 2024</td>\n",
       "      <td>IntroR_Materials/introR_pt1/00_introR_part1.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Data Carpentry: Introduction to Python</td>\n",
       "      <td>09:00 AM</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11732481</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-01-31</td>\n",
       "      <td>January 31, 2024</td>\n",
       "      <td>https://datacarpentry.org/python-ecology-lesson/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Introduction to Python for Data Science: Intro...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>03:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11690015</td>\n",
       "      <td>Open Science, Open Science, Working With Data</td>\n",
       "      <td>2024-01-31</td>\n",
       "      <td>January 31, 2024</td>\n",
       "      <td>Python_Series_Materials/part_1/part_1.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Building your Programming Tool Box: Command Li...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>03:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11722733</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-02-05</td>\n",
       "      <td>February 05, 2024</td>\n",
       "      <td>cli/cli_main.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Introduction to R Part 2: Working with data in R</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>02:30 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11677895</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-02-06</td>\n",
       "      <td>February 06, 2024</td>\n",
       "      <td>IntroR_Materials/introR_pt2/00_introR_part2.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Introduction to Python for Data Science: Plott...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>03:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11720589</td>\n",
       "      <td>Open Science, Open Science, Working With Data</td>\n",
       "      <td>2024-02-07</td>\n",
       "      <td>February 07, 2024</td>\n",
       "      <td>Python_Series_Materials/part_3/part_3.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Building Your Programming Toolbox: Version Con...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>03:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11720611</td>\n",
       "      <td>Open Science, Open Science, Working With Data</td>\n",
       "      <td>2024-02-12</td>\n",
       "      <td>February 12, 2024</td>\n",
       "      <td>Git_Materials/index.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Introduction to Electronic Lab Notebooks</td>\n",
       "      <td>10:00 AM</td>\n",
       "      <td>11:00 AM</td>\n",
       "      <td>https://cmu.libcal.com/event/11622353</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-02-13</td>\n",
       "      <td>February 13, 2024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Introduction to R Part 1: Getting started with...</td>\n",
       "      <td>09:00 AM</td>\n",
       "      <td>10:30 AM</td>\n",
       "      <td>https://cmu.libcal.com/event/11676663</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-02-14</td>\n",
       "      <td>February 14, 2024</td>\n",
       "      <td>IntroR_Materials/introR_pt1/00_introR_part1.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Introduction to Python for Data Science: Analy...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>03:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11720619</td>\n",
       "      <td>Open Science, Open Science, Working With Data</td>\n",
       "      <td>2024-02-14</td>\n",
       "      <td>February 14, 2024</td>\n",
       "      <td>Python_Series_Materials/part_3/part_3.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Cleaning Untidy Data with OpenRefine</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>01:30 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11676509</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-02-15</td>\n",
       "      <td>February 15, 2024</td>\n",
       "      <td>content/openrefine.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Building Your Programming Toolbox: Collaborati...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>03:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11720634</td>\n",
       "      <td>Open Science, Open Science, Working With Data</td>\n",
       "      <td>2024-02-19</td>\n",
       "      <td>February 19, 2024</td>\n",
       "      <td>GH_Materials/index.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Introduction to R Part 2: Working with data in R</td>\n",
       "      <td>09:00 AM</td>\n",
       "      <td>10:30 AM</td>\n",
       "      <td>https://cmu.libcal.com/event/11676685</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-02-21</td>\n",
       "      <td>February 21, 2024</td>\n",
       "      <td>IntroR_Materials/introR_pt2/00_introR_part2.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Building Your Programming Toolbox: Creating We...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>03:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11720699</td>\n",
       "      <td>Open Science, Open Science, Working With Data,...</td>\n",
       "      <td>2024-02-26</td>\n",
       "      <td>February 26, 2024</td>\n",
       "      <td>content/git_github.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Easing the transition from MATLAB to Python wi...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>03:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11732026</td>\n",
       "      <td>Open Science</td>\n",
       "      <td>2024-02-27</td>\n",
       "      <td>February 27, 2024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Encapsulating Reproducible Computational Resea...</td>\n",
       "      <td>10:00 AM</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11720891</td>\n",
       "      <td>Open Science, Open Science, Working With Data,...</td>\n",
       "      <td>2024-02-28</td>\n",
       "      <td>February 28, 2024</td>\n",
       "      <td>content/code_ocean.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Command Line Crash Course for Beginners</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>03:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11722048</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-03-11</td>\n",
       "      <td>March 11, 2024</td>\n",
       "      <td>cli/cli_main.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Data Exploration with Python and SQL in Redivi...</td>\n",
       "      <td>11:00 AM</td>\n",
       "      <td>12:30 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11740185</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-03-13</td>\n",
       "      <td>March 13, 2024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Data Exploration with Python and SQL in Redivi...</td>\n",
       "      <td>11:00 AM</td>\n",
       "      <td>12:30 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11740329</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-03-20</td>\n",
       "      <td>March 20, 2024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Submitting Your Thesis or Dissertation to CMU ...</td>\n",
       "      <td>12:00 PM</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11622574</td>\n",
       "      <td>Open Science, Writing and Publishing</td>\n",
       "      <td>2024-03-20</td>\n",
       "      <td>March 20, 2024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Open Science Framework (OSF) for Beginners</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>02:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11722088</td>\n",
       "      <td>Open Science</td>\n",
       "      <td>2024-03-25</td>\n",
       "      <td>March 25, 2024</td>\n",
       "      <td>content/osf.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Regex 101: Fundamentals for Beginners</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>02:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11722604</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-04-01</td>\n",
       "      <td>April 01, 2024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Introduction to Python for Data Science: Intro...</td>\n",
       "      <td>09:00 AM</td>\n",
       "      <td>11:00 AM</td>\n",
       "      <td>https://cmu.libcal.com/event/11720957</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-04-09</td>\n",
       "      <td>April 09, 2024</td>\n",
       "      <td>Python_Series_Materials/part_1/part_1.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Making the Most with Jupyter Lab and Notebooks</td>\n",
       "      <td>11:00 AM</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11722137</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-04-10</td>\n",
       "      <td>April 10, 2024</td>\n",
       "      <td>Python_Series_Materials/making_the_most_jupyte...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Introduction to Python for Data Science: Plott...</td>\n",
       "      <td>09:00 AM</td>\n",
       "      <td>11:00 AM</td>\n",
       "      <td>https://cmu.libcal.com/event/11720984</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-04-16</td>\n",
       "      <td>April 16, 2024</td>\n",
       "      <td>Python_Series_Materials/part_2/part_2.md</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Easing the transition from MATLAB to Python wi...</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>03:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11732235</td>\n",
       "      <td>Open Science</td>\n",
       "      <td>2024-04-17</td>\n",
       "      <td>April 17, 2024</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Python for Harvesting Data on the Web (Interme...</td>\n",
       "      <td>11:00 AM</td>\n",
       "      <td>01:00 PM</td>\n",
       "      <td>https://cmu.libcal.com/event/11722162</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-04-19</td>\n",
       "      <td>April 19, 2024</td>\n",
       "      <td>Python_Series_Materials/python_harvesting/py_h...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Introduction to Python for Data Science: Analy...</td>\n",
       "      <td>09:00 AM</td>\n",
       "      <td>11:00 AM</td>\n",
       "      <td>https://cmu.libcal.com/event/11721033</td>\n",
       "      <td>Open Science, Working With Data</td>\n",
       "      <td>2024-04-23</td>\n",
       "      <td>April 23, 2024</td>\n",
       "      <td>Python_Series_Materials/part_3/part_3.md</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                title     start       end  \\\n",
       "0   Submitting Your Thesis or Dissertation to CMU ...  12:00 PM  01:00 PM   \n",
       "1          Open Science Framework (OSF) for Beginners  01:00 PM  02:00 PM   \n",
       "2              Data Carpentry: Introduction to Python  09:00 AM  12:00 PM   \n",
       "3              Data Carpentry: Introduction to Python  09:00 AM  12:00 PM   \n",
       "4   Introduction to R Part 1: Getting started with...  01:00 PM  02:30 PM   \n",
       "5              Data Carpentry: Introduction to Python  09:00 AM  12:00 PM   \n",
       "6   Introduction to Python for Data Science: Intro...  01:00 PM  03:00 PM   \n",
       "7   Building your Programming Tool Box: Command Li...  01:00 PM  03:00 PM   \n",
       "8    Introduction to R Part 2: Working with data in R  01:00 PM  02:30 PM   \n",
       "9   Introduction to Python for Data Science: Plott...  01:00 PM  03:00 PM   \n",
       "10  Building Your Programming Toolbox: Version Con...  01:00 PM  03:00 PM   \n",
       "11           Introduction to Electronic Lab Notebooks  10:00 AM  11:00 AM   \n",
       "12  Introduction to R Part 1: Getting started with...  09:00 AM  10:30 AM   \n",
       "13  Introduction to Python for Data Science: Analy...  01:00 PM  03:00 PM   \n",
       "14               Cleaning Untidy Data with OpenRefine  12:00 PM  01:30 PM   \n",
       "15  Building Your Programming Toolbox: Collaborati...  01:00 PM  03:00 PM   \n",
       "16   Introduction to R Part 2: Working with data in R  09:00 AM  10:30 AM   \n",
       "17  Building Your Programming Toolbox: Creating We...  01:00 PM  03:00 PM   \n",
       "18  Easing the transition from MATLAB to Python wi...  01:00 PM  03:00 PM   \n",
       "19  Encapsulating Reproducible Computational Resea...  10:00 AM  12:00 PM   \n",
       "20            Command Line Crash Course for Beginners  01:00 PM  03:00 PM   \n",
       "21  Data Exploration with Python and SQL in Redivi...  11:00 AM  12:30 PM   \n",
       "22  Data Exploration with Python and SQL in Redivi...  11:00 AM  12:30 PM   \n",
       "23  Submitting Your Thesis or Dissertation to CMU ...  12:00 PM  01:00 PM   \n",
       "24         Open Science Framework (OSF) for Beginners  01:00 PM  02:00 PM   \n",
       "25              Regex 101: Fundamentals for Beginners  01:00 PM  02:00 PM   \n",
       "26  Introduction to Python for Data Science: Intro...  09:00 AM  11:00 AM   \n",
       "27     Making the Most with Jupyter Lab and Notebooks  11:00 AM  01:00 PM   \n",
       "28  Introduction to Python for Data Science: Plott...  09:00 AM  11:00 AM   \n",
       "29  Easing the transition from MATLAB to Python wi...  01:00 PM  03:00 PM   \n",
       "30  Python for Harvesting Data on the Web (Interme...  11:00 AM  01:00 PM   \n",
       "31  Introduction to Python for Data Science: Analy...  09:00 AM  11:00 AM   \n",
       "\n",
       "                                      URL  \\\n",
       "0   https://cmu.libcal.com/event/11622573   \n",
       "1   https://cmu.libcal.com/event/11721905   \n",
       "2   https://cmu.libcal.com/event/11732479   \n",
       "3   https://cmu.libcal.com/event/11732480   \n",
       "4   https://cmu.libcal.com/event/11677891   \n",
       "5   https://cmu.libcal.com/event/11732481   \n",
       "6   https://cmu.libcal.com/event/11690015   \n",
       "7   https://cmu.libcal.com/event/11722733   \n",
       "8   https://cmu.libcal.com/event/11677895   \n",
       "9   https://cmu.libcal.com/event/11720589   \n",
       "10  https://cmu.libcal.com/event/11720611   \n",
       "11  https://cmu.libcal.com/event/11622353   \n",
       "12  https://cmu.libcal.com/event/11676663   \n",
       "13  https://cmu.libcal.com/event/11720619   \n",
       "14  https://cmu.libcal.com/event/11676509   \n",
       "15  https://cmu.libcal.com/event/11720634   \n",
       "16  https://cmu.libcal.com/event/11676685   \n",
       "17  https://cmu.libcal.com/event/11720699   \n",
       "18  https://cmu.libcal.com/event/11732026   \n",
       "19  https://cmu.libcal.com/event/11720891   \n",
       "20  https://cmu.libcal.com/event/11722048   \n",
       "21  https://cmu.libcal.com/event/11740185   \n",
       "22  https://cmu.libcal.com/event/11740329   \n",
       "23  https://cmu.libcal.com/event/11622574   \n",
       "24  https://cmu.libcal.com/event/11722088   \n",
       "25  https://cmu.libcal.com/event/11722604   \n",
       "26  https://cmu.libcal.com/event/11720957   \n",
       "27  https://cmu.libcal.com/event/11722137   \n",
       "28  https://cmu.libcal.com/event/11720984   \n",
       "29  https://cmu.libcal.com/event/11732235   \n",
       "30  https://cmu.libcal.com/event/11722162   \n",
       "31  https://cmu.libcal.com/event/11721033   \n",
       "\n",
       "                                           categories        date  \\\n",
       "0                Open Science, Writing and Publishing  2024-01-24   \n",
       "1                                        Open Science  2024-01-26   \n",
       "2                     Open Science, Working With Data  2024-01-29   \n",
       "3                     Open Science, Working With Data  2024-01-30   \n",
       "4                     Open Science, Working With Data  2024-01-30   \n",
       "5                     Open Science, Working With Data  2024-01-31   \n",
       "6       Open Science, Open Science, Working With Data  2024-01-31   \n",
       "7                     Open Science, Working With Data  2024-02-05   \n",
       "8                     Open Science, Working With Data  2024-02-06   \n",
       "9       Open Science, Open Science, Working With Data  2024-02-07   \n",
       "10      Open Science, Open Science, Working With Data  2024-02-12   \n",
       "11                    Open Science, Working With Data  2024-02-13   \n",
       "12                    Open Science, Working With Data  2024-02-14   \n",
       "13      Open Science, Open Science, Working With Data  2024-02-14   \n",
       "14                    Open Science, Working With Data  2024-02-15   \n",
       "15      Open Science, Open Science, Working With Data  2024-02-19   \n",
       "16                    Open Science, Working With Data  2024-02-21   \n",
       "17  Open Science, Open Science, Working With Data,...  2024-02-26   \n",
       "18                                       Open Science  2024-02-27   \n",
       "19  Open Science, Open Science, Working With Data,...  2024-02-28   \n",
       "20                    Open Science, Working With Data  2024-03-11   \n",
       "21                    Open Science, Working With Data  2024-03-13   \n",
       "22                    Open Science, Working With Data  2024-03-20   \n",
       "23               Open Science, Writing and Publishing  2024-03-20   \n",
       "24                                       Open Science  2024-03-25   \n",
       "25                    Open Science, Working With Data  2024-04-01   \n",
       "26                    Open Science, Working With Data  2024-04-09   \n",
       "27                    Open Science, Working With Data  2024-04-10   \n",
       "28                    Open Science, Working With Data  2024-04-16   \n",
       "29                                       Open Science  2024-04-17   \n",
       "30                    Open Science, Working With Data  2024-04-19   \n",
       "31                    Open Science, Working With Data  2024-04-23   \n",
       "\n",
       "       formatted_date                                               path  \n",
       "0    January 24, 2024                                                  0  \n",
       "1    January 26, 2024                                     content/osf.md  \n",
       "2    January 29, 2024   https://datacarpentry.org/python-ecology-lesson/  \n",
       "3    January 30, 2024   https://datacarpentry.org/python-ecology-lesson/  \n",
       "4    January 30, 2024     IntroR_Materials/introR_pt1/00_introR_part1.md  \n",
       "5    January 31, 2024   https://datacarpentry.org/python-ecology-lesson/  \n",
       "6    January 31, 2024           Python_Series_Materials/part_1/part_1.md  \n",
       "7   February 05, 2024                                    cli/cli_main.md  \n",
       "8   February 06, 2024     IntroR_Materials/introR_pt2/00_introR_part2.md  \n",
       "9   February 07, 2024           Python_Series_Materials/part_3/part_3.md  \n",
       "10  February 12, 2024                             Git_Materials/index.md  \n",
       "11  February 13, 2024                                                  0  \n",
       "12  February 14, 2024     IntroR_Materials/introR_pt1/00_introR_part1.md  \n",
       "13  February 14, 2024           Python_Series_Materials/part_3/part_3.md  \n",
       "14  February 15, 2024                              content/openrefine.md  \n",
       "15  February 19, 2024                              GH_Materials/index.md  \n",
       "16  February 21, 2024     IntroR_Materials/introR_pt2/00_introR_part2.md  \n",
       "17  February 26, 2024                              content/git_github.md  \n",
       "18  February 27, 2024                                                  0  \n",
       "19  February 28, 2024                              content/code_ocean.md  \n",
       "20     March 11, 2024                                    cli/cli_main.md  \n",
       "21     March 13, 2024                                                  0  \n",
       "22     March 20, 2024                                                  0  \n",
       "23     March 20, 2024                                                  0  \n",
       "24     March 25, 2024                                     content/osf.md  \n",
       "25     April 01, 2024                                                  0  \n",
       "26     April 09, 2024           Python_Series_Materials/part_1/part_1.md  \n",
       "27     April 10, 2024  Python_Series_Materials/making_the_most_jupyte...  \n",
       "28     April 16, 2024           Python_Series_Materials/part_2/part_2.md  \n",
       "29     April 17, 2024                                                  0  \n",
       "30     April 19, 2024  Python_Series_Materials/python_harvesting/py_h...  \n",
       "31     April 23, 2024           Python_Series_Materials/part_3/part_3.md  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "workshops_paths = pd.merge(left=workshops, right=paths, how='left', left_on='URL', right_on='URL')\n",
    "workshops_paths.fillna(0, inplace=True)\n",
    "workshops_paths"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "1e5b2a51-0ceb-4508-ba88-b2e57b6eb301",
   "metadata": {},
   "outputs": [],
   "source": [
    "table_head = \"\"\"| Day | Time | Title | Content  \n",
    "| --- | --- | --- | ---  \"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "66cc9441-b9ec-4a3a-bdf0-09c65e84a509",
   "metadata": {},
   "outputs": [],
   "source": [
    "table_body = \"\"\"\n",
    "\"\"\"\n",
    "\n",
    "for i, row in workshops_paths.iterrows():\n",
    "    table_entry = f\"| {row['formatted_date']} | {row['start']} - {row['end']} | {row['title']} | [Register Here]({row['URL']}) \"\n",
    "    if row['path'] != 0:\n",
    "        table_entry += f\"[Content]({row['path']}) \\n\"\n",
    "    else:\n",
    "        table_entry += \"\\n\"\n",
    "    \n",
    "    table_body += table_entry"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "512a01e2-2861-4bbe-be7b-219ced8f004f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "| January 24, 2024 | 12:00 PM - 01:00 PM | Submitting Your Thesis or Dissertation to CMU Libraries | [Register Here](https://cmu.libcal.com/event/11622573) \n",
      "| January 26, 2024 | 01:00 PM - 02:00 PM | Open Science Framework (OSF) for Beginners | [Register Here](https://cmu.libcal.com/event/11721905) [Content](content/osf.md) \n",
      "| January 29, 2024 | 09:00 AM - 12:00 PM | Data Carpentry: Introduction to Python | [Register Here](https://cmu.libcal.com/event/11732479) [Content](https://datacarpentry.org/python-ecology-lesson/) \n",
      "| January 30, 2024 | 09:00 AM - 12:00 PM | Data Carpentry: Introduction to Python | [Register Here](https://cmu.libcal.com/event/11732480) [Content](https://datacarpentry.org/python-ecology-lesson/) \n",
      "| January 30, 2024 | 01:00 PM - 02:30 PM | Introduction to R Part 1: Getting started with R and RStudio | [Register Here](https://cmu.libcal.com/event/11677891) [Content](IntroR_Materials/introR_pt1/00_introR_part1.md) \n",
      "| January 31, 2024 | 09:00 AM - 12:00 PM | Data Carpentry: Introduction to Python | [Register Here](https://cmu.libcal.com/event/11732481) [Content](https://datacarpentry.org/python-ecology-lesson/) \n",
      "| January 31, 2024 | 01:00 PM - 03:00 PM | Introduction to Python for Data Science: Introduction to Basic Programming with Data | [Register Here](https://cmu.libcal.com/event/11690015) [Content](Python_Series_Materials/part_1/part_1.md) \n",
      "| February 05, 2024 | 01:00 PM - 03:00 PM | Building your Programming Tool Box: Command Line Crash Course for Beginners | [Register Here](https://cmu.libcal.com/event/11722733) [Content](cli/cli_main.md) \n",
      "| February 06, 2024 | 01:00 PM - 02:30 PM | Introduction to R Part 2: Working with data in R | [Register Here](https://cmu.libcal.com/event/11677895) [Content](IntroR_Materials/introR_pt2/00_introR_part2.md) \n",
      "| February 07, 2024 | 01:00 PM - 03:00 PM | Introduction to Python for Data Science: Plotting and Analyzing Tabular Datasets | [Register Here](https://cmu.libcal.com/event/11720589) [Content](Python_Series_Materials/part_3/part_3.md) \n",
      "| February 12, 2024 | 01:00 PM - 03:00 PM | Building Your Programming Toolbox: Version Control with Git | [Register Here](https://cmu.libcal.com/event/11720611) [Content](Git_Materials/index.md) \n",
      "| February 13, 2024 | 10:00 AM - 11:00 AM | Introduction to Electronic Lab Notebooks | [Register Here](https://cmu.libcal.com/event/11622353) \n",
      "| February 14, 2024 | 09:00 AM - 10:30 AM | Introduction to R Part 1: Getting started with R and RStudio | [Register Here](https://cmu.libcal.com/event/11676663) [Content](IntroR_Materials/introR_pt1/00_introR_part1.md) \n",
      "| February 14, 2024 | 01:00 PM - 03:00 PM | Introduction to Python for Data Science: Analyzing Data with Logic and Iteration | [Register Here](https://cmu.libcal.com/event/11720619) [Content](Python_Series_Materials/part_3/part_3.md) \n",
      "| February 15, 2024 | 12:00 PM - 01:30 PM | Cleaning Untidy Data with OpenRefine | [Register Here](https://cmu.libcal.com/event/11676509) [Content](content/openrefine.md) \n",
      "| February 19, 2024 | 01:00 PM - 03:00 PM | Building Your Programming Toolbox: Collaborating with GitHub | [Register Here](https://cmu.libcal.com/event/11720634) [Content](GH_Materials/index.md) \n",
      "| February 21, 2024 | 09:00 AM - 10:30 AM | Introduction to R Part 2: Working with data in R | [Register Here](https://cmu.libcal.com/event/11676685) [Content](IntroR_Materials/introR_pt2/00_introR_part2.md) \n",
      "| February 26, 2024 | 01:00 PM - 03:00 PM | Building Your Programming Toolbox: Creating Websites and Portfolios with GitPages | [Register Here](https://cmu.libcal.com/event/11720699) [Content](content/git_github.md) \n",
      "| February 27, 2024 | 01:00 PM - 03:00 PM | Easing the transition from MATLAB to Python with AI | [Register Here](https://cmu.libcal.com/event/11732026) \n",
      "| February 28, 2024 | 10:00 AM - 12:00 PM | Encapsulating Reproducible Computational Research with Code Ocean | [Register Here](https://cmu.libcal.com/event/11720891) [Content](content/code_ocean.md) \n",
      "| March 11, 2024 | 01:00 PM - 03:00 PM | Command Line Crash Course for Beginners | [Register Here](https://cmu.libcal.com/event/11722048) [Content](cli/cli_main.md) \n",
      "| March 13, 2024 | 11:00 AM - 12:30 PM | Data Exploration with Python and SQL in Redivis, Part 1 | [Register Here](https://cmu.libcal.com/event/11740185) \n",
      "| March 20, 2024 | 11:00 AM - 12:30 PM | Data Exploration with Python and SQL in Redivis, Part 2 | [Register Here](https://cmu.libcal.com/event/11740329) \n",
      "| March 20, 2024 | 12:00 PM - 01:00 PM | Submitting Your Thesis or Dissertation to CMU Libraries | [Register Here](https://cmu.libcal.com/event/11622574) \n",
      "| March 25, 2024 | 01:00 PM - 02:00 PM | Open Science Framework (OSF) for Beginners | [Register Here](https://cmu.libcal.com/event/11722088) [Content](content/osf.md) \n",
      "| April 01, 2024 | 01:00 PM - 02:00 PM | Regex 101: Fundamentals for Beginners | [Register Here](https://cmu.libcal.com/event/11722604) \n",
      "| April 09, 2024 | 09:00 AM - 11:00 AM | Introduction to Python for Data Science: Introduction to Basic Programming with Data | [Register Here](https://cmu.libcal.com/event/11720957) [Content](Python_Series_Materials/part_1/part_1.md) \n",
      "| April 10, 2024 | 11:00 AM - 01:00 PM | Making the Most with Jupyter Lab and Notebooks | [Register Here](https://cmu.libcal.com/event/11722137) [Content](Python_Series_Materials/making_the_most_jupyter.md) \n",
      "| April 16, 2024 | 09:00 AM - 11:00 AM | Introduction to Python for Data Science: Plotting and Analyzing Tabular Datasets | [Register Here](https://cmu.libcal.com/event/11720984) [Content](Python_Series_Materials/part_2/part_2.md) \n",
      "| April 17, 2024 | 01:00 PM - 03:00 PM | Easing the transition from MATLAB to Python with AI | [Register Here](https://cmu.libcal.com/event/11732235) \n",
      "| April 19, 2024 | 11:00 AM - 01:00 PM | Python for Harvesting Data on the Web (Intermediate-Advanced) | [Register Here](https://cmu.libcal.com/event/11722162) [Content](Python_Series_Materials/python_harvesting/py_harvest_main.md) \n",
      "| April 23, 2024 | 09:00 AM - 11:00 AM | Introduction to Python for Data Science: Analyzing Data with Logic and Iteration | [Register Here](https://cmu.libcal.com/event/11721033) [Content](Python_Series_Materials/part_3/part_3.md) \n",
      "\n"
     ]
    }
   ],
   "source": [
    "print(table_body)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "321a7f49-e02c-45e6-84e6-6ae756918b99",
   "metadata": {},
   "outputs": [],
   "source": [
    "index_md = f\"\"\"---\n",
    "layout: default\n",
    "title: Home\n",
    "nav_order: 1\n",
    "---\n",
    "# Open Data Science Workshops\n",
    "Hosted by the Open Science program within the\n",
    "[Carnegie Mellon University (CMU) Libraries](https://www.library.cmu.edu/)\n",
    "\n",
    "This website highlights workshops from CMU libraries that help\n",
    "build computational skills for Open Research and Data Science.\n",
    "\n",
    "## Workshop Calendar\n",
    "{table_body}\n",
    "## Data Office Hours\n",
    "\n",
    "Schedule a [Data Consultation](https://library.cmu.edu/service/data-office-hours) with our library associates for support with data and research!\n",
    "\n",
    "![Data Office Hours Flyer](content/img/data-office-hours.png)\n",
    "\n",
    "## Coordinators\n",
    "\n",
    "Melanie Gainey (she/her/hers)  \n",
    "Open Science Program Director/Librarian  \n",
    "Office: Library 431, Mellon library  \n",
    "[mgainey@andrew.cmu.edu](mailto:mgainey@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointment/42420)\n",
    "\n",
    "Chasz Griego (he/him/his)  \n",
    "Science and Engineering Librarian  \n",
    "Office: 4410, Sorrells Library  \n",
    "[cgriego@andrew.cmu.edu](mailto:cgriego@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointments/cgriego)\n",
    "\n",
    "Lencia Beltran (she/her/hers)  \n",
    "Open Science Project Coordinator  \n",
    "Office: 4416, Sorrells Library  \n",
    "[lbeltran@andrew.cmu.edu](mailto:lbeltran@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointments/lencia)\n",
    "\n",
    "Emma Slayton (she/her/hers)  \n",
    "Data Curation, Visualization, and GIS Specialist  \n",
    "Office: 4408, Sorrells Library  \n",
    "[eslayton@andrew.cmu.edu](mailto:eslayton@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointment/41060)\n",
    "\n",
    "Sarah Young (she/her/hers)  \n",
    "Principal Librarian  \n",
    "Office: 109G, Hunt Library  \n",
    "[sarahy@andrew.cmu.edu](mailto:sarahy@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointments/sarahy)\n",
    "\n",
    "Emily Bongiovanni (she/her/hers)  \n",
    "Psychology Librarian Liaison  \n",
    "Office: 109D, Hunt Library  \n",
    "[ebongiov@andrew.cmu.edu](mailto:ebongiov@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointments/emily)  \n",
    "\n",
    "Taiwo Lasisi (she/her/hers)  \n",
    "CLIR Postdoctoral Fellow in Community Data Literacy  \n",
    "Office: 4418, Sorrells Library  \n",
    "[tlasisi@andrew.cmu.edu](mailto:tlasisi@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointments/TaiwoLasisi)  \n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "64433f0b-6eca-4d13-a023-a65631352a4c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "---\n",
      "layout: default\n",
      "title: Home\n",
      "nav_order: 1\n",
      "---\n",
      "# Open Data Science Workshops\n",
      "Hosted by the Open Science program within the\n",
      "[Carnegie Mellon University (CMU) Libraries](https://www.library.cmu.edu/)\n",
      "\n",
      "This website highlights workshops from CMU libraries that help\n",
      "build computational skills for Open Research and Data Science.\n",
      "\n",
      "## Workshop Calendar\n",
      "\n",
      "| January 24, 2024 | 12:00 PM - 01:00 PM | Submitting Your Thesis or Dissertation to CMU Libraries | [Register Here](https://cmu.libcal.com/event/11622573) \n",
      "| January 26, 2024 | 01:00 PM - 02:00 PM | Open Science Framework (OSF) for Beginners | [Register Here](https://cmu.libcal.com/event/11721905) [Content](content/osf.md) \n",
      "| January 29, 2024 | 09:00 AM - 12:00 PM | Data Carpentry: Introduction to Python | [Register Here](https://cmu.libcal.com/event/11732479) [Content](https://datacarpentry.org/python-ecology-lesson/) \n",
      "| January 30, 2024 | 09:00 AM - 12:00 PM | Data Carpentry: Introduction to Python | [Register Here](https://cmu.libcal.com/event/11732480) [Content](https://datacarpentry.org/python-ecology-lesson/) \n",
      "| January 30, 2024 | 01:00 PM - 02:30 PM | Introduction to R Part 1: Getting started with R and RStudio | [Register Here](https://cmu.libcal.com/event/11677891) [Content](IntroR_Materials/introR_pt1/00_introR_part1.md) \n",
      "| January 31, 2024 | 09:00 AM - 12:00 PM | Data Carpentry: Introduction to Python | [Register Here](https://cmu.libcal.com/event/11732481) [Content](https://datacarpentry.org/python-ecology-lesson/) \n",
      "| January 31, 2024 | 01:00 PM - 03:00 PM | Introduction to Python for Data Science: Introduction to Basic Programming with Data | [Register Here](https://cmu.libcal.com/event/11690015) [Content](Python_Series_Materials/part_1/part_1.md) \n",
      "| February 05, 2024 | 01:00 PM - 03:00 PM | Building your Programming Tool Box: Command Line Crash Course for Beginners | [Register Here](https://cmu.libcal.com/event/11722733) [Content](cli/cli_main.md) \n",
      "| February 06, 2024 | 01:00 PM - 02:30 PM | Introduction to R Part 2: Working with data in R | [Register Here](https://cmu.libcal.com/event/11677895) [Content](IntroR_Materials/introR_pt2/00_introR_part2.md) \n",
      "| February 07, 2024 | 01:00 PM - 03:00 PM | Introduction to Python for Data Science: Plotting and Analyzing Tabular Datasets | [Register Here](https://cmu.libcal.com/event/11720589) [Content](Python_Series_Materials/part_3/part_3.md) \n",
      "| February 12, 2024 | 01:00 PM - 03:00 PM | Building Your Programming Toolbox: Version Control with Git | [Register Here](https://cmu.libcal.com/event/11720611) [Content](Git_Materials/index.md) \n",
      "| February 13, 2024 | 10:00 AM - 11:00 AM | Introduction to Electronic Lab Notebooks | [Register Here](https://cmu.libcal.com/event/11622353) \n",
      "| February 14, 2024 | 09:00 AM - 10:30 AM | Introduction to R Part 1: Getting started with R and RStudio | [Register Here](https://cmu.libcal.com/event/11676663) [Content](IntroR_Materials/introR_pt1/00_introR_part1.md) \n",
      "| February 14, 2024 | 01:00 PM - 03:00 PM | Introduction to Python for Data Science: Analyzing Data with Logic and Iteration | [Register Here](https://cmu.libcal.com/event/11720619) [Content](Python_Series_Materials/part_3/part_3.md) \n",
      "| February 15, 2024 | 12:00 PM - 01:30 PM | Cleaning Untidy Data with OpenRefine | [Register Here](https://cmu.libcal.com/event/11676509) [Content](content/openrefine.md) \n",
      "| February 19, 2024 | 01:00 PM - 03:00 PM | Building Your Programming Toolbox: Collaborating with GitHub | [Register Here](https://cmu.libcal.com/event/11720634) [Content](GH_Materials/index.md) \n",
      "| February 21, 2024 | 09:00 AM - 10:30 AM | Introduction to R Part 2: Working with data in R | [Register Here](https://cmu.libcal.com/event/11676685) [Content](IntroR_Materials/introR_pt2/00_introR_part2.md) \n",
      "| February 26, 2024 | 01:00 PM - 03:00 PM | Building Your Programming Toolbox: Creating Websites and Portfolios with GitPages | [Register Here](https://cmu.libcal.com/event/11720699) [Content](content/git_github.md) \n",
      "| February 27, 2024 | 01:00 PM - 03:00 PM | Easing the transition from MATLAB to Python with AI | [Register Here](https://cmu.libcal.com/event/11732026) \n",
      "| February 28, 2024 | 10:00 AM - 12:00 PM | Encapsulating Reproducible Computational Research with Code Ocean | [Register Here](https://cmu.libcal.com/event/11720891) [Content](content/code_ocean.md) \n",
      "| March 11, 2024 | 01:00 PM - 03:00 PM | Command Line Crash Course for Beginners | [Register Here](https://cmu.libcal.com/event/11722048) [Content](cli/cli_main.md) \n",
      "| March 13, 2024 | 11:00 AM - 12:30 PM | Data Exploration with Python and SQL in Redivis, Part 1 | [Register Here](https://cmu.libcal.com/event/11740185) \n",
      "| March 20, 2024 | 11:00 AM - 12:30 PM | Data Exploration with Python and SQL in Redivis, Part 2 | [Register Here](https://cmu.libcal.com/event/11740329) \n",
      "| March 20, 2024 | 12:00 PM - 01:00 PM | Submitting Your Thesis or Dissertation to CMU Libraries | [Register Here](https://cmu.libcal.com/event/11622574) \n",
      "| March 25, 2024 | 01:00 PM - 02:00 PM | Open Science Framework (OSF) for Beginners | [Register Here](https://cmu.libcal.com/event/11722088) [Content](content/osf.md) \n",
      "| April 01, 2024 | 01:00 PM - 02:00 PM | Regex 101: Fundamentals for Beginners | [Register Here](https://cmu.libcal.com/event/11722604) \n",
      "| April 09, 2024 | 09:00 AM - 11:00 AM | Introduction to Python for Data Science: Introduction to Basic Programming with Data | [Register Here](https://cmu.libcal.com/event/11720957) [Content](Python_Series_Materials/part_1/part_1.md) \n",
      "| April 10, 2024 | 11:00 AM - 01:00 PM | Making the Most with Jupyter Lab and Notebooks | [Register Here](https://cmu.libcal.com/event/11722137) [Content](Python_Series_Materials/making_the_most_jupyter.md) \n",
      "| April 16, 2024 | 09:00 AM - 11:00 AM | Introduction to Python for Data Science: Plotting and Analyzing Tabular Datasets | [Register Here](https://cmu.libcal.com/event/11720984) [Content](Python_Series_Materials/part_2/part_2.md) \n",
      "| April 17, 2024 | 01:00 PM - 03:00 PM | Easing the transition from MATLAB to Python with AI | [Register Here](https://cmu.libcal.com/event/11732235) \n",
      "| April 19, 2024 | 11:00 AM - 01:00 PM | Python for Harvesting Data on the Web (Intermediate-Advanced) | [Register Here](https://cmu.libcal.com/event/11722162) [Content](Python_Series_Materials/python_harvesting/py_harvest_main.md) \n",
      "| April 23, 2024 | 09:00 AM - 11:00 AM | Introduction to Python for Data Science: Analyzing Data with Logic and Iteration | [Register Here](https://cmu.libcal.com/event/11721033) [Content](Python_Series_Materials/part_3/part_3.md) \n",
      "\n",
      "## Data Office Hours\n",
      "\n",
      "Schedule a [Data Consultation](https://library.cmu.edu/service/data-office-hours) with our library associates for support with data and research!\n",
      "\n",
      "![Data Office Hours Flyer](content/img/data-office-hours.png)\n",
      "\n",
      "## Coordinators\n",
      "\n",
      "Melanie Gainey (she/her/hers)  \n",
      "Open Science Program Director/Librarian  \n",
      "Office: Library 431, Mellon library  \n",
      "[mgainey@andrew.cmu.edu](mailto:mgainey@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointment/42420)\n",
      "\n",
      "Chasz Griego (he/him/his)  \n",
      "Science and Engineering Librarian  \n",
      "Office: 4410, Sorrells Library  \n",
      "[cgriego@andrew.cmu.edu](mailto:cgriego@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointments/cgriego)\n",
      "\n",
      "Lencia Beltran (she/her/hers)  \n",
      "Open Science Project Coordinator  \n",
      "Office: 4416, Sorrells Library  \n",
      "[lbeltran@andrew.cmu.edu](mailto:lbeltran@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointments/lencia)\n",
      "\n",
      "Emma Slayton (she/her/hers)  \n",
      "Data Curation, Visualization, and GIS Specialist  \n",
      "Office: 4408, Sorrells Library  \n",
      "[eslayton@andrew.cmu.edu](mailto:eslayton@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointment/41060)\n",
      "\n",
      "Sarah Young (she/her/hers)  \n",
      "Principal Librarian  \n",
      "Office: 109G, Hunt Library  \n",
      "[sarahy@andrew.cmu.edu](mailto:sarahy@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointments/sarahy)\n",
      "\n",
      "Emily Bongiovanni (she/her/hers)  \n",
      "Psychology Librarian Liaison  \n",
      "Office: 109D, Hunt Library  \n",
      "[ebongiov@andrew.cmu.edu](mailto:ebongiov@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointments/emily)  \n",
      "\n",
      "Taiwo Lasisi (she/her/hers)  \n",
      "CLIR Postdoctoral Fellow in Community Data Literacy  \n",
      "Office: 4418, Sorrells Library  \n",
      "[tlasisi@andrew.cmu.edu](mailto:tlasisi@andrew.cmu.edu) | [Schedule a Consultation](https://cmu.libcal.com/appointments/TaiwoLasisi)  \n",
      "\n"
     ]
    }
   ],
   "source": [
    "print(index_md)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "45591295-b19b-48df-8f5f-376bb5122490",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(\"./index.md\", \"w\") as file:\n",
    "    file.write(index_md)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "5c1323de-e2a3-4e88-9a31-9f965e12b154",
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(\"./README.md\", \"w\") as file:\n",
    "    file.write(index_md)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "686bd6d7-c43e-4dc2-a956-131be98d7fa0",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}