{
"cells": [
{
"cell_type": "markdown",
"source": [
"# Assessment 1 - Part A\n",
"\n",
"Answer the questions below to demonstrate your understand of foundational techniques.\n",
"\n",
"You can run the *test* cells (after each answer cell) to check for simple errors.\n"
],
"metadata": {
"nbgrader": {
"grade": false,
"grade_id": "cell-52d1c05618afd0f1",
"locked": true,
"schema_version": 3,
"solution": false,
"task": false
}
}
},
{
"cell_type": "markdown",
"source": [
"## 1. Read a CSV file\n",
"\n",
"After importing the required dataframes library as `pd`, read the contents of file `mountain_heights.csv` into a dataframe called `mountain_heights`. Use the mountain code for the index of the dataframe. Using a dataframe property, output the dataframe's rows and columns in the format `(rows,cols)`. \n",
"\n",
"**This solution requires 3 lines of code.**"
],
"metadata": {
"nbgrader": {
"grade": false,
"grade_id": "q1",
"locked": true,
"schema_version": 3,
"solution": false,
"task": false
}
}
},
{
"cell_type": "code",
"execution_count": 50,
"source": [
"### BEGIN SOLUTION\n",
"\n",
"# Import pandas\n",
"import pandas as pd\n",
"\n",
"# Read the contents of the desired file\n",
"\n",
"mountain_heights = pd.read_csv('/home/jovyan/iab303/21s2/assignments/IAB303_Assignment1_PartA/mountain_heights.csv', index_col = 'Code')\n",
"\n",
"# Output the dataframe's rows and columns in the format rows,cols\n",
"\n",
"print(mountain_heights.shape)\n",
"\n",
"\n",
"### END SOLUTION"
],
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
   "(10, 4)\n"
]
}
],
"metadata": {
"nbgrader": {
"grade": false,
"grade_id": "q1-answer",
"locked": false,
"schema_version": 3,
"solution": true,
"task": false
}
}
},
{
"cell_type": "code",
"execution_count": 51,
"source": [
"### RUN BASIC TESTS\n",
"\"Check that the dataframe has been loaded and rows and columns output\"\n",
"assert(type(mountain_heights)==type(pd.DataFrame()))\n",
"assert(_==(10,4))"
],
"outputs": [
{
"output_type": "error",
"ename": "AssertionError",
"evalue": "",
"traceback": [
   "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
   "\u001b[0;31mAssertionError\u001b[0m                         Traceback (most recent call last)",
   "\u001b[0;32m/tmp/ipykernel_52/1197572249.py\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m    2\u001b[0m \u001b[0;34m\"Check that the dataframe has been loaded and rows and columns output\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    3\u001b[0m \u001b[0;32massert\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mtype\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmountain_heights\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0mtype\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mDataFrame\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 4\u001b[0;31m \u001b[0;32massert\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0m_\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m10\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;36m4\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
   "\u001b[0;31mAssertionError\u001b[0m: "
]
}
],
"metadata": {
"nbgrader": {
"grade": true,
"grade_id": "q1-tests",
"locked": true,
"points": 1,
"schema_version": 3,
"solution": false,
"task": false
}
}
},
{
"cell_type": "markdown",
"source": [
"## 2. Fix missing data\n",
"\n",
"Using a single line of code, assign the string `Antarctica` to the appropriate cell of the dataframe by using the index and column labels."
],
"metadata": {
"nbgrader": {
"grade": false,
"grade_id": "q2",
"locked": true,
"schema_version": 3,
"solution": false,
"task": false
}

A computer program in Java, Javascript or C are made up of many dif...