CRIM_MEI_URL_list.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import xml.etree.ElementTree as ET"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "tree = ET.parse('Senfl_Ave_forCRIM.mei_msg.mei')\n",
    "root = tree.getroot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'{http://www.music-encoding.org/ns/mei}mei'"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "root.tag"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>Root_URL</th>\n",
       "      <th>Name</th>\n",
       "      <th>Suffix</th>\n",
       "      <th>Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0001</td>\n",
       "      <td>.mei</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0002</td>\n",
       "      <td>.mei</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0003</td>\n",
       "      <td>.mei</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0004</td>\n",
       "      <td>.mei</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0005</td>\n",
       "      <td>.mei</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Root_URL             Name Suffix  \\\n",
       "0  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Model_0001   .mei   \n",
       "1  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Model_0002   .mei   \n",
       "2  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Model_0003   .mei   \n",
       "3  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Model_0004   .mei   \n",
       "4  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Model_0005   .mei   \n",
       "\n",
       "  Status  \n",
       "0      Y  \n",
       "1      Y  \n",
       "2      Y  \n",
       "3      Y  \n",
       "4      Y  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "names = pd.read_csv('https://docs.google.com/spreadsheets/d/e/2PACX-1vQjXKwqPfDFdyZ9h_p0WlovWOItweyK8S6eF5QjrIxCqT-IVngrSpy3mjLZTg1gFHHKFw7c3zfwv-cw/pub?output=csv')\n",
    "#names[names['Status'].str.match('Y')]\n",
    "names.head()\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "names[\"Complete_URL\"] = names[\"Root_URL\"] + names[\"Name\"] + names[\"Suffix\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0      https://raw.githubusercontent.com/CRIM-Project...\n",
      "1      https://raw.githubusercontent.com/CRIM-Project...\n",
      "2      https://raw.githubusercontent.com/CRIM-Project...\n",
      "3      https://raw.githubusercontent.com/CRIM-Project...\n",
      "4      https://raw.githubusercontent.com/CRIM-Project...\n",
      "                             ...                        \n",
      "193    https://raw.githubusercontent.com/CRIM-Project...\n",
      "194    https://raw.githubusercontent.com/CRIM-Project...\n",
      "195    https://raw.githubusercontent.com/CRIM-Project...\n",
      "196    https://raw.githubusercontent.com/CRIM-Project...\n",
      "197    https://raw.githubusercontent.com/CRIM-Project...\n",
      "Name: Complete_URL, Length: 198, dtype: object\n",
      "0      https://raw.githubusercontent.com/CRIM-Project...\n",
      "1      https://raw.githubusercontent.com/CRIM-Project...\n",
      "2      https://raw.githubusercontent.com/CRIM-Project...\n",
      "3      https://raw.githubusercontent.com/CRIM-Project...\n",
      "4      https://raw.githubusercontent.com/CRIM-Project...\n",
      "                             ...                        \n",
      "193    https://raw.githubusercontent.com/CRIM-Project...\n",
      "194    https://raw.githubusercontent.com/CRIM-Project...\n",
      "195    https://raw.githubusercontent.com/CRIM-Project...\n",
      "196    https://raw.githubusercontent.com/CRIM-Project...\n",
      "197    https://raw.githubusercontent.com/CRIM-Project...\n",
      "Name: Complete_URL, Length: 198, dtype: object\n",
      "0      https://raw.githubusercontent.com/CRIM-Project...\n",
      "1      https://raw.githubusercontent.com/CRIM-Project...\n",
      "2      https://raw.githubusercontent.com/CRIM-Project...\n",
      "3      https://raw.githubusercontent.com/CRIM-Project...\n",
      "4      https://raw.githubusercontent.com/CRIM-Project...\n",
      "                             ...                        \n",
      "193    https://raw.githubusercontent.com/CRIM-Project...\n",
      "194    https://raw.githubusercontent.com/CRIM-Project...\n",
      "195    https://raw.githubusercontent.com/CRIM-Project...\n",
      "196    https://raw.githubusercontent.com/CRIM-Project...\n",
      "197    https://raw.githubusercontent.com/CRIM-Project...\n",
      "Name: Complete_URL, Length: 198, dtype: object\n",
      "0      https://raw.githubusercontent.com/CRIM-Project...\n",
      "1      https://raw.githubusercontent.com/CRIM-Project...\n",
      "2      https://raw.githubusercontent.com/CRIM-Project...\n",
      "3      https://raw.githubusercontent.com/CRIM-Project...\n",
      "4      https://raw.githubusercontent.com/CRIM-Project...\n",
      "                             ...                        \n",
      "193    https://raw.githubusercontent.com/CRIM-Project...\n",
      "194    https://raw.githubusercontent.com/CRIM-Project...\n",
      "195    https://raw.githubusercontent.com/CRIM-Project...\n",
      "196    https://raw.githubusercontent.com/CRIM-Project...\n",
      "197    https://raw.githubusercontent.com/CRIM-Project...\n",
      "Name: Complete_URL, Length: 198, dtype: object\n",
      "0      https://raw.githubusercontent.com/CRIM-Project...\n",
      "1      https://raw.githubusercontent.com/CRIM-Project...\n",
      "2      https://raw.githubusercontent.com/CRIM-Project...\n",
      "3      https://raw.githubusercontent.com/CRIM-Project...\n",
      "4      https://raw.githubusercontent.com/CRIM-Project...\n",
      "                             ...                        \n",
      "193    https://raw.githubusercontent.com/CRIM-Project...\n",
      "194    https://raw.githubusercontent.com/CRIM-Project...\n",
      "195    https://raw.githubusercontent.com/CRIM-Project...\n",
      "196    https://raw.githubusercontent.com/CRIM-Project...\n",
      "197    https://raw.githubusercontent.com/CRIM-Project...\n",
      "Name: Complete_URL, Length: 198, dtype: object\n"
     ]
    }
   ],
   "source": [
    "for piece in names:\n",
    "    print(names[\"Complete_URL\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "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>Root_URL</th>\n",
       "      <th>Name</th>\n",
       "      <th>Complete URL</th>\n",
       "      <th>Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0001.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0002.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0003.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0004.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0005.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0006.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0007.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0008.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0009.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0010.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0011.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0012.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0013.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0014.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0015.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0016.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0017.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0018.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0019.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0020.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Model_0024.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Mass_0001_1.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Mass_0001_2.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Mass_0001_3.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Mass_0001_4.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Mass_0001_5.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Mass_0002_1.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Mass_0002_2.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Mass_0002_3.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Mass_0002_4.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>CRIM_Mass_0002_5.mei</td>\n",
       "      <td>https://raw.githubusercontent.com/CRIM-Project...</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Root_URL                  Name  \\\n",
       "0   https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0001.mei   \n",
       "1   https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0002.mei   \n",
       "2   https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0003.mei   \n",
       "3   https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0004.mei   \n",
       "4   https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0005.mei   \n",
       "5   https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0006.mei   \n",
       "6   https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0007.mei   \n",
       "7   https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0008.mei   \n",
       "8   https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0009.mei   \n",
       "9   https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0010.mei   \n",
       "10  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0011.mei   \n",
       "11  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0012.mei   \n",
       "12  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0013.mei   \n",
       "13  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0014.mei   \n",
       "14  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0015.mei   \n",
       "15  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0016.mei   \n",
       "16  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0017.mei   \n",
       "17  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0018.mei   \n",
       "18  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0019.mei   \n",
       "19  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0020.mei   \n",
       "23  https://raw.githubusercontent.com/CRIM-Project...   CRIM_Model_0024.mei   \n",
       "24  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Mass_0001_1.mei   \n",
       "25  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Mass_0001_2.mei   \n",
       "26  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Mass_0001_3.mei   \n",
       "27  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Mass_0001_4.mei   \n",
       "28  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Mass_0001_5.mei   \n",
       "29  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Mass_0002_1.mei   \n",
       "30  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Mass_0002_2.mei   \n",
       "31  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Mass_0002_3.mei   \n",
       "32  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Mass_0002_4.mei   \n",
       "33  https://raw.githubusercontent.com/CRIM-Project...  CRIM_Mass_0002_5.mei   \n",
       "\n",
       "                                         Complete URL Status  \n",
       "0   https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "1   https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "2   https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "3   https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "4   https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "5   https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "6   https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "7   https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "8   https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "9   https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "10  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "11  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "12  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "13  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "14  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "15  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "16  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "17  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "18  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "19  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "23  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "24  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "25  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "26  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "27  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "28  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "29  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "30  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "31  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "32  https://raw.githubusercontent.com/CRIM-Project...      Y  \n",
       "33  https://raw.githubusercontent.com/CRIM-Project...      Y  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filtered=names['Status']=='Y'\n",
    "final = names[filtered]\n",
    "final.head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# final.to_csv('names.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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": 2
}