Skip to content

Instantly share code, notes, and snippets.

@razzius

razzius/Untitled.ipynb

Created July 10, 2018 03:19
Show Gist options
  • Save razzius/d8e8184d869a0e781cd82c7c3a551e04 to your computer and use it in GitHub Desktop.
Save razzius/d8e8184d869a0e781cd82c7c3a551e04 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
Untitled.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"df = pd.read_csv('instructors/class_size.csv')"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [],
"source": [
"df = df.reset_index()\n",
"df.columns = ['date', 'teachers', 'students', 'class', 'day']"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [],
"source": [
"def try_to_float(x):\n",
" try:\n",
" return float(x)\n",
" except:\n",
" return 0\n"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"167.0"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df[' num_teachers'].apply(try_to_float).sum()"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>date</th>\n",
" <th>teachers</th>\n",
" <th>students</th>\n",
" <th>class</th>\n",
" <th>day</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>05.18.15</td>\n",
" <td>2</td>\n",
" <td>20</td>\n",
" <td>class1.1</td>\n",
" <td>mon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>05.21.15</td>\n",
" <td>2</td>\n",
" <td>17</td>\n",
" <td>class1.2</td>\n",
" <td>thu</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>05.25.15</td>\n",
" <td>2</td>\n",
" <td>16</td>\n",
" <td>class2.1</td>\n",
" <td>mon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>05.28.15</td>\n",
" <td>2</td>\n",
" <td>16</td>\n",
" <td>class2.2</td>\n",
" <td>thu</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>06.01.15</td>\n",
" <td>2</td>\n",
" <td>14</td>\n",
" <td>class3.1</td>\n",
" <td>mon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>06.04.15</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>class3.2</td>\n",
" <td>thu</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>06.08.15</td>\n",
" <td>2</td>\n",
" <td>11</td>\n",
" <td>class4.1</td>\n",
" <td>mon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>06.11.15</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>class4.2</td>\n",
" <td>thu</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>06.15.15</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>class5.1</td>\n",
" <td>mon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>06.18.15</td>\n",
" <td>1</td>\n",
" <td></td>\n",
" <td>class5.2</td>\n",
" <td>thu</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>06.22.15</td>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>class6.1</td>\n",
" <td>mon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>06.25.15</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>class6.2</td>\n",
" <td>thu</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>06.29.15</td>\n",
" <td>1</td>\n",
" <td>10</td>\n",
" <td>class7.1</td>\n",
" <td>mon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>07.02.15</td>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>class7.2</td>\n",
" <td>thu</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>07.06.15</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>class8.1</td>\n",
" <td>mon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>07.09.15</td>\n",
" <td>2</td>\n",
" <td>8</td>\n",
" <td>class8.2</td>\n",
" <td>thu</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>07.13.15</td>\n",
" <td>2</td>\n",
" <td>11</td>\n",
" <td>class9.1</td>\n",
" <td>mon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>07.16.15</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>class9.2</td>\n",
" <td>thu</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" date teachers students class day\n",
"0 05.18.15 2 20 class1.1 mon\n",
"1 05.21.15 2 17 class1.2 thu\n",
"2 05.25.15 2 16 class2.1 mon\n",
"3 05.28.15 2 16 class2.2 thu\n",
"4 06.01.15 2 14 class3.1 mon\n",
"5 06.04.15 2 7 class3.2 thu\n",
"6 06.08.15 2 11 class4.1 mon\n",
"7 06.11.15 2 7 class4.2 thu\n",
"8 06.15.15 2 7 class5.1 mon\n",
"9 06.18.15 1 class5.2 thu\n",
"10 06.22.15 1 6 class6.1 mon\n",
"11 06.25.15 1 4 class6.2 thu\n",
"12 06.29.15 1 10 class7.1 mon\n",
"13 07.02.15 1 6 class7.2 thu\n",
"14 07.06.15 2 7 class8.1 mon\n",
"15 07.09.15 2 8 class8.2 thu\n",
"16 07.13.15 2 11 class9.1 mon\n",
"17 07.16.15 class9.2 thu"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.0"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment