lecture_1_exercise_solution.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "editable": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "source": [
    "# Lecture 1 in-class exercise solution\n",
    "\n",
    "## Step 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true,
    "editable": true,
    "execution": {
     "iopub.execute_input": "2025-01-18T15:52:09.700204Z",
     "iopub.status.busy": "2025-01-18T15:52:09.699940Z",
     "iopub.status.idle": "2025-01-18T15:52:10.364711Z",
     "shell.execute_reply": "2025-01-18T15:52:10.364314Z"
    },
    "jupyter": {
     "outputs_hidden": true
    },
    "scrolled": true,
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2025-01-18 10:52:10 URL:https://data.cityofnewyork.us/resource/m6nq-qud6.csv [136065] -> \"2021_yellow_taxi_trips.csv\" [1]\r\n"
     ]
    }
   ],
   "source": [
    "!wget -O 2021_yellow_taxi_trips.csv --no-verbose https://data.cityofnewyork.us/resource/m6nq-qud6.csv"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Step 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2025-01-18T15:52:10.366545Z",
     "iopub.status.busy": "2025-01-18T15:52:10.366422Z",
     "iopub.status.idle": "2025-01-18T15:52:10.372718Z",
     "shell.execute_reply": "2025-01-18T15:52:10.372383Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2.10\n",
      "0.20\n",
      "14.70\n",
      "10.60\n",
      "4.94\n",
      "1.60\n",
      "4.10\n",
      "5.70\n",
      "9.10\n",
      "2.70\n",
      "6.11\n",
      "1.21\n",
      "7.40\n",
      "1.70\n",
      "0.81\n",
      "1.01\n",
      "0.73\n",
      "1.17\n",
      "0.78\n",
      "1.66\n",
      "0.93\n",
      "1.16\n",
      "2.20\n",
      "3.60\n",
      "19.10\n",
      "5.40\n",
      "3.15\n",
      "4.65\n",
      "4.07\n",
      "14.30\n",
      "3.96\n",
      "0.76\n",
      "0.64\n",
      "3.00\n",
      "10.74\n",
      "2.62\n",
      "13.67\n",
      "6.10\n",
      "0.00\n",
      "0.00\n",
      "2.00\n",
      "1.00\n",
      "1.98\n",
      "1.27\n",
      "1.66\n",
      "0.89\n",
      "4.85\n",
      "1.16\n",
      "1.40\n",
      "2.01\n",
      "3.45\n",
      "3.79\n",
      "17.20\n",
      "3.10\n",
      "2.85\n",
      "1.68\n",
      "0.77\n",
      "0.52\n",
      "0.40\n",
      "1.05\n",
      "5.85\n",
      "0.27\n",
      "3.70\n",
      "3.70\n",
      "16.54\n",
      "2.19\n",
      "4.09\n",
      "3.26\n",
      "1.11\n",
      "2.87\n",
      "4.00\n",
      "1.30\n",
      "2.30\n",
      "0.80\n",
      "7.00\n",
      "0.51\n",
      "1.17\n",
      "3.00\n",
      "2.00\n",
      "1.10\n",
      "0.60\n",
      "2.50\n",
      "3.58\n",
      "1.24\n",
      "4.78\n",
      "1.69\n",
      "1.33\n",
      "8.06\n",
      "2.60\n",
      "1.40\n",
      "2.44\n",
      "1.58\n",
      "3.98\n",
      "1.06\n",
      "1.91\n",
      "4.13\n",
      "4.12\n",
      "2.22\n",
      "7.11\n",
      "1.61\n",
      "1.89\n",
      "1.62\n",
      "3.70\n",
      "6.56\n",
      "0.58\n",
      "1.37\n",
      "2.65\n",
      "1.20\n",
      "0.80\n",
      "0.20\n",
      "1.24\n",
      "1.91\n",
      "0.50\n",
      "0.70\n",
      "1.29\n",
      "4.26\n",
      "0.70\n",
      "4.60\n",
      "1.34\n",
      "6.71\n",
      "1.60\n",
      "1.10\n",
      "9.19\n",
      "8.02\n",
      "4.50\n",
      "9.40\n",
      "1.38\n",
      "0.50\n",
      "0.80\n",
      "5.83\n",
      "1.35\n",
      "4.11\n",
      "0.32\n",
      "2.31\n",
      "1.00\n",
      "0.90\n",
      "0.20\n",
      "0.40\n",
      "11.10\n",
      "8.40\n",
      "2.80\n",
      "1.30\n",
      "2.19\n",
      "2.30\n",
      "0.20\n",
      "2.90\n",
      "0.80\n",
      "3.50\n",
      "6.17\n",
      "0.79\n",
      "5.10\n",
      "5.08\n",
      "6.43\n",
      "14.30\n",
      "1.20\n",
      "0.70\n",
      "3.30\n",
      "15.19\n",
      "3.40\n",
      "2.76\n",
      "0.00\n",
      "0.60\n",
      "1.98\n",
      "2.71\n",
      "1.07\n",
      "0.81\n",
      "2.27\n",
      "1.50\n",
      "0.77\n",
      "1.73\n",
      "1.44\n",
      "1.08\n",
      "4.69\n",
      "9.60\n",
      "1.49\n",
      "1.62\n",
      "1.60\n",
      "1.60\n",
      "2.54\n",
      "3.78\n",
      "1.25\n",
      "2.52\n",
      "1.18\n",
      "3.85\n",
      "5.20\n",
      "0.00\n",
      "5.04\n",
      "2.41\n",
      "2.09\n",
      "1.57\n",
      "2.60\n",
      "1.02\n",
      "1.80\n",
      "6.45\n",
      "7.12\n",
      "4.10\n",
      "2.96\n",
      "7.35\n",
      "2.50\n",
      "2.70\n",
      "1.20\n",
      "2.40\n",
      "0.40\n",
      "1.20\n",
      "6.80\n",
      "1.42\n",
      "0.81\n",
      "1.06\n",
      "1.34\n",
      "1.50\n",
      "1.48\n",
      "3.13\n",
      "2.50\n",
      "0.66\n",
      "0.69\n",
      "3.05\n",
      "0.77\n",
      "4.36\n",
      "2.95\n",
      "4.29\n",
      "4.18\n",
      "3.47\n",
      "0.96\n",
      "0.56\n",
      "15.40\n",
      "1.50\n",
      "4.20\n",
      "8.89\n",
      "6.53\n",
      "1.91\n",
      "17.68\n",
      "5.10\n",
      "0.25\n",
      "2.70\n",
      "1.20\n",
      "1.00\n",
      "1.20\n",
      "6.30\n",
      "1.00\n",
      "1.71\n",
      "0.46\n",
      "2.88\n",
      "4.11\n",
      "1.95\n",
      "1.68\n",
      "5.90\n",
      "1.53\n",
      "1.59\n",
      "5.60\n",
      "0.80\n",
      "5.74\n",
      "3.67\n",
      "1.25\n",
      "7.99\n",
      "0.94\n",
      "0.00\n",
      "1.11\n",
      "0.90\n",
      "1.00\n",
      "1.44\n",
      "1.78\n",
      "1.62\n",
      "0.37\n",
      "0.74\n",
      "1.40\n",
      "6.50\n",
      "7.08\n",
      "5.97\n",
      "0.76\n",
      "3.72\n",
      "0.94\n",
      "1.44\n",
      "0.53\n",
      "1.45\n",
      "1.79\n",
      "2.40\n",
      "20.26\n",
      "3.90\n",
      "2.03\n",
      "7.00\n",
      "1.38\n",
      "1.86\n",
      "3.04\n",
      "1.82\n",
      "0.41\n",
      "6.91\n",
      "1.58\n",
      "1.65\n",
      "1.51\n",
      "1.28\n",
      "10.40\n",
      "6.40\n",
      "17.05\n",
      "2.80\n",
      "3.36\n",
      "5.44\n",
      "0.98\n",
      "1.08\n",
      "33.18\n",
      "2.41\n",
      "2.37\n",
      "3.60\n",
      "2.79\n",
      "0.59\n",
      "1.53\n",
      "0.54\n",
      "3.85\n",
      "7.25\n",
      "2.41\n",
      "1.50\n",
      "2.62\n",
      "0.59\n",
      "1.20\n",
      "0.90\n",
      "14.00\n",
      "0.40\n",
      "1.10\n",
      "2.88\n",
      "1.46\n",
      "2.08\n",
      "9.40\n",
      "1.40\n",
      "1.10\n",
      "15.73\n",
      "1.64\n",
      "3.74\n",
      "0.94\n",
      "3.00\n",
      "7.04\n",
      "1.30\n",
      "1.10\n",
      "6.90\n",
      "1.90\n",
      "2.90\n",
      "0.60\n",
      "1.91\n",
      "2.43\n",
      "7.42\n",
      "6.88\n",
      "3.30\n",
      "1.00\n",
      "0.20\n",
      "0.50\n",
      "1.60\n",
      "1.89\n",
      "1.96\n",
      "0.00\n",
      "8.50\n",
      "0.77\n",
      "1.12\n",
      "4.44\n",
      "6.10\n",
      "3.22\n",
      "2.64\n",
      "19.90\n",
      "0.50\n",
      "2.49\n",
      "1.97\n",
      "8.67\n",
      "1.85\n",
      "1.17\n",
      "0.90\n",
      "6.71\n",
      "7.27\n",
      "0.79\n",
      "2.79\n",
      "1.03\n",
      "1.24\n",
      "0.92\n",
      "3.55\n",
      "5.47\n",
      "9.50\n",
      "6.20\n",
      "1.61\n",
      "7.54\n",
      "2.40\n",
      "0.92\n",
      "1.39\n",
      "2.59\n",
      "2.15\n",
      "1.60\n",
      "1.20\n",
      "2.77\n",
      "1.65\n",
      "1.40\n",
      "1.50\n",
      "1.10\n",
      "1.30\n",
      "0.50\n",
      "2.70\n",
      "1.70\n",
      "11.10\n",
      "9.50\n",
      "1.50\n",
      "2.00\n",
      "0.50\n",
      "3.52\n",
      "3.34\n",
      "2.18\n",
      "1.29\n",
      "10.86\n",
      "1.80\n",
      "0.00\n",
      "2.71\n",
      "4.85\n",
      "0.78\n",
      "0.20\n",
      "3.80\n",
      "2.20\n",
      "2.20\n",
      "0.80\n",
      "5.60\n",
      "1.68\n",
      "12.08\n",
      "3.80\n",
      "0.70\n",
      "2.46\n",
      "5.16\n",
      "1.85\n",
      "5.18\n",
      "5.32\n",
      "0.00\n",
      "1.02\n",
      "4.50\n",
      "3.01\n",
      "3.17\n",
      "3.46\n",
      "1.72\n",
      "2.30\n",
      "1.60\n",
      "3.20\n",
      "1.43\n",
      "6.10\n",
      "7.01\n",
      "0.90\n",
      "2.64\n",
      "0.51\n",
      "0.59\n",
      "1.04\n",
      "0.81\n",
      "0.25\n",
      "2.80\n",
      "1.93\n",
      "2.18\n",
      "1.40\n",
      "3.80\n",
      "0.50\n",
      "1.48\n",
      "3.49\n",
      "0.50\n",
      "2.00\n",
      "5.70\n",
      "0.94\n",
      "2.40\n",
      "2.40\n",
      "0.74\n",
      "0.59\n",
      "1.70\n",
      "3.45\n",
      "12.40\n",
      "5.40\n",
      "1.00\n",
      "12.10\n",
      "2.15\n",
      "2.06\n",
      "0.44\n",
      "1.57\n",
      "3.12\n",
      "1.06\n",
      "5.37\n",
      "5.20\n",
      "0.90\n",
      "1.40\n",
      "14.91\n",
      "2.16\n",
      "1.09\n",
      "5.04\n",
      "0.80\n",
      "2.90\n",
      "1.10\n",
      "3.47\n",
      "3.93\n",
      "0.88\n",
      "3.85\n",
      "2.58\n",
      "1.07\n",
      "1.18\n",
      "2.47\n",
      "4.17\n",
      "1.80\n",
      "0.72\n",
      "2.60\n",
      "4.83\n",
      "0.48\n",
      "2.90\n",
      "6.29\n",
      "0.58\n",
      "1.06\n",
      "8.22\n",
      "0.95\n",
      "0.02\n",
      "0.68\n",
      "12.01\n",
      "5.70\n",
      "10.22\n",
      "0.96\n",
      "0.69\n",
      "2.62\n",
      "1.71\n",
      "0.60\n",
      "5.86\n",
      "0.99\n",
      "8.35\n",
      "7.89\n",
      "1.63\n",
      "0.60\n",
      "1.90\n",
      "2.50\n",
      "5.50\n",
      "3.71\n",
      "2.39\n",
      "1.29\n",
      "12.95\n",
      "12.95\n",
      "7.94\n",
      "2.70\n",
      "3.41\n",
      "0.70\n",
      "1.00\n",
      "2.60\n",
      "17.96\n",
      "0.80\n",
      "0.54\n",
      "2.00\n",
      "0.70\n",
      "1.30\n",
      "4.40\n",
      "1.27\n",
      "3.30\n",
      "1.83\n",
      "1.27\n",
      "9.70\n",
      "2.56\n",
      "5.27\n",
      "0.92\n",
      "2.04\n",
      "3.80\n",
      "0.92\n",
      "2.29\n",
      "0.36\n",
      "1.78\n",
      "0.77\n",
      "0.40\n",
      "1.20\n",
      "1.90\n",
      "1.96\n",
      "0.80\n",
      "2.50\n",
      "3.80\n",
      "8.78\n",
      "1.33\n",
      "1.05\n",
      "5.45\n",
      "7.60\n",
      "3.91\n",
      "1.40\n",
      "1.93\n",
      "3.22\n",
      "1.63\n",
      "17.33\n",
      "0.64\n",
      "1.06\n",
      "1.81\n",
      "1.67\n",
      "2.76\n",
      "0.65\n",
      "3.30\n",
      "2.00\n",
      "1.44\n",
      "1.43\n",
      "3.97\n",
      "2.99\n",
      "5.95\n",
      "1.25\n",
      "0.59\n",
      "0.85\n",
      "3.40\n",
      "2.87\n",
      "1.36\n",
      "5.01\n",
      "6.20\n",
      "19.51\n",
      "2.63\n",
      "2.26\n",
      "1.66\n",
      "2.04\n",
      "0.78\n",
      "3.62\n",
      "1.19\n",
      "1.19\n",
      "0.35\n",
      "1.81\n",
      "2.20\n",
      "1.60\n",
      "8.00\n",
      "0.90\n",
      "2.61\n",
      "1.90\n",
      "3.50\n",
      "1.76\n",
      "4.82\n",
      "3.71\n",
      "1.03\n",
      "2.27\n",
      "4.17\n",
      "0.91\n",
      "3.63\n",
      "4.10\n",
      "0.99\n",
      "0.94\n",
      "6.00\n",
      "2.96\n",
      "0.80\n",
      "5.00\n",
      "6.91\n",
      "3.67\n",
      "5.08\n",
      "1.27\n",
      "0.00\n",
      "0.00\n",
      "3.19\n",
      "1.44\n",
      "0.70\n",
      "0.69\n",
      "2.65\n",
      "1.57\n",
      "2.56\n",
      "2.61\n",
      "3.76\n",
      "8.80\n",
      "2.00\n",
      "2.00\n",
      "1.40\n",
      "6.20\n",
      "2.12\n",
      "3.60\n",
      "0.60\n",
      "2.13\n",
      "0.50\n",
      "2.07\n",
      "1.20\n",
      "2.08\n",
      "4.35\n",
      "5.07\n",
      "2.18\n",
      "0.52\n",
      "3.09\n",
      "27.07\n",
      "0.73\n",
      "1.69\n",
      "3.39\n",
      "7.60\n",
      "4.50\n",
      "1.62\n",
      "1.68\n",
      "3.57\n",
      "0.66\n",
      "0.70\n",
      "0.60\n",
      "2.90\n",
      "2.70\n",
      "0.55\n",
      "5.31\n",
      "5.31\n",
      "9.29\n",
      "3.88\n",
      "1.53\n",
      "4.62\n",
      "3.47\n",
      "2.60\n",
      "2.10\n",
      "4.30\n",
      "3.40\n",
      "2.30\n",
      "0.70\n",
      "1.40\n",
      "1.51\n",
      "2.07\n",
      "1.01\n",
      "3.79\n",
      "0.65\n",
      "0.38\n",
      "0.55\n",
      "1.20\n",
      "2.85\n",
      "2.54\n",
      "2.21\n",
      "0.88\n",
      "3.24\n",
      "4.97\n",
      "4.81\n",
      "3.86\n",
      "1.90\n",
      "7.50\n",
      "12.88\n",
      "16.66\n",
      "0.00\n",
      "16.00\n",
      "5.71\n",
      "15.26\n",
      "2.70\n",
      "3.00\n",
      "0.49\n",
      "7.86\n",
      "0.66\n",
      "2.00\n",
      "0.52\n",
      "1.01\n",
      "3.08\n",
      "0.39\n",
      "3.60\n",
      "7.43\n",
      "5.39\n",
      "3.50\n",
      "2.37\n",
      "0.76\n",
      "0.90\n",
      "2.50\n",
      "1.40\n",
      "0.73\n",
      "3.11\n",
      "6.70\n",
      "1.22\n",
      "0.00\n",
      "2.20\n",
      "0.49\n",
      "18.40\n",
      "6.38\n",
      "1.25\n",
      "2.90\n",
      "0.70\n",
      "19.59\n",
      "2.27\n",
      "1.05\n",
      "3.66\n",
      "1.15\n",
      "4.30\n",
      "1.20\n",
      "3.20\n",
      "3.80\n",
      "1.14\n",
      "7.30\n",
      "5.36\n",
      "1.60\n",
      "3.80\n",
      "4.98\n",
      "0.77\n",
      "1.96\n",
      "0.20\n",
      "0.51\n",
      "6.88\n",
      "1.76\n",
      "0.00\n",
      "0.00\n",
      "0.36\n",
      "7.24\n",
      "3.70\n",
      "0.00\n",
      "4.68\n",
      "1.10\n",
      "32.58\n",
      "2.10\n",
      "0.28\n",
      "0.28\n",
      "3.80\n",
      "3.30\n",
      "0.30\n",
      "3.30\n",
      "1.40\n",
      "0.76\n",
      "1.60\n",
      "0.00\n",
      "1.87\n",
      "0.53\n",
      "2.36\n",
      "1.73\n",
      "4.82\n",
      "0.46\n",
      "1.99\n",
      "3.36\n",
      "4.32\n",
      "1.53\n",
      "1.64\n",
      "0.79\n",
      "1.13\n",
      "0.00\n",
      "0.83\n",
      "4.71\n",
      "0.54\n",
      "3.67\n",
      "1.51\n",
      "0.96\n",
      "0.96\n",
      "0.60\n",
      "2.63\n",
      "2.06\n",
      "1.59\n",
      "2.30\n",
      "0.10\n",
      "1.64\n",
      "1.01\n",
      "2.65\n",
      "0.74\n",
      "1.13\n",
      "1.13\n",
      "2.84\n",
      "2.84\n",
      "1.52\n",
      "1.84\n",
      "1.08\n",
      "1.18\n",
      "1.69\n",
      "2.35\n",
      "6.09\n",
      "3.08\n",
      "0.05\n",
      "1.97\n",
      "1.30\n",
      "0.10\n",
      "1.40\n",
      "1.60\n",
      "2.31\n",
      "5.67\n",
      "4.64\n",
      "1.69\n",
      "2.47\n",
      "0.68\n",
      "1.85\n",
      "2.72\n",
      "3.10\n",
      "2.73\n",
      "0.68\n",
      "2.60\n",
      "4.70\n",
      "2.99\n",
      "11.15\n",
      "1.35\n",
      "0.76\n",
      "3.07\n",
      "3.17\n",
      "1.84\n",
      "1.60\n",
      "5.40\n",
      "0.90\n",
      "1.69\n",
      "2.49\n",
      "0.93\n",
      "3.52\n",
      "7.05\n",
      "2.39\n",
      "10.52\n",
      "1.99\n",
      "4.13\n",
      "8.16\n",
      "1.06\n",
      "4.80\n",
      "1.30\n",
      "5.50\n",
      "3.80\n",
      "0.03\n",
      "1.91\n",
      "1.98\n",
      "1.78\n",
      "1.15\n",
      "2.03\n",
      "10.82\n",
      "5.20\n",
      "2.00\n",
      "0.80\n",
      "11.64\n",
      "1.77\n",
      "1.70\n",
      "7.20\n",
      "5.60\n",
      "3.17\n",
      "1.80\n",
      "6.81\n",
      "3.86\n",
      "1.19\n",
      "1.79\n",
      "0.50\n",
      "9.08\n",
      "0.62\n",
      "21.17\n",
      "2.70\n",
      "1.65\n",
      "1.30\n",
      "12.40\n",
      "0.56\n",
      "3.67\n",
      "10.50\n",
      "2.34\n",
      "6.45\n",
      "11.78\n",
      "1.60\n",
      "0.41\n",
      "0.41\n",
      "1.67\n",
      "3.60\n",
      "0.70\n",
      "1.13\n",
      "0.89\n",
      "1.92\n",
      "2.15\n",
      "1.65\n",
      "2.25\n",
      "7.83\n",
      "9.61\n",
      "9.84\n",
      "2.30\n",
      "4.24\n",
      "2.60\n",
      "1.64\n",
      "2.24\n",
      "0.12\n",
      "7.28\n",
      "5.10\n",
      "4.30\n",
      "2.10\n",
      "2.59\n",
      "0.93\n",
      "0.61\n",
      "0.30\n",
      "6.10\n",
      "5.71\n",
      "3.58\n",
      "3.76\n",
      "1.90\n",
      "2.10\n",
      "1.60\n",
      "1.68\n",
      "6.33\n",
      "23.26\n",
      "4.72\n",
      "7.02\n",
      "3.05\n",
      "1.55\n",
      "3.40\n",
      "2.00\n",
      "6.50\n",
      "1.20\n",
      "3.96\n",
      "2.00\n",
      "1.90\n",
      "8.90\n",
      "4.51\n",
      "0.99\n",
      "2.79\n",
      "13.03\n",
      "2.35\n",
      "0.94\n",
      "2.50\n",
      "1.45\n",
      "2.36\n",
      "8.90\n",
      "3.06\n",
      "0.98\n",
      "2.19\n",
      "2.87\n",
      "0.47\n",
      "0.13\n",
      "1.13\n",
      "1.41\n",
      "1.38\n",
      "0.48\n",
      "3.60\n",
      "6.34\n",
      "6.34\n",
      "0.00\n",
      "9.34\n",
      "7.09\n",
      "8.75\n",
      "0.01\n",
      "0.80\n",
      "3.50\n",
      "4.39\n",
      "2.72\n",
      "2.21\n",
      "3.12\n",
      "4.45\n",
      "1.53\n",
      "3.85\n",
      "0.00\n",
      "0.50\n",
      "2.20\n",
      "3.10\n",
      "2.77\n",
      "2.01\n",
      "3.35\n",
      "3.35\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "\n",
    "with open(\"2021_yellow_taxi_trips.csv\") as csvfile:\n",
    "    reader = csv.DictReader(csvfile)\n",
    "    for row in reader:\n",
    "        print(row[\"trip_distance\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Step 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "editable": true,
    "execution": {
     "iopub.execute_input": "2025-01-18T15:52:10.374180Z",
     "iopub.status.busy": "2025-01-18T15:52:10.374093Z",
     "iopub.status.idle": "2025-01-18T15:52:10.378456Z",
     "shell.execute_reply": "2025-01-18T15:52:10.378208Z"
    },
    "slideshow": {
     "slide_type": ""
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3.279060000000005\n"
     ]
    }
   ],
   "source": [
    "num_trips = 0\n",
    "miles = 0\n",
    "\n",
    "with open(\"2021_yellow_taxi_trips.csv\") as csvfile:\n",
    "    reader = csv.DictReader(csvfile)\n",
    "    for row in reader:\n",
    "        # convert from a string to a numeric type\n",
    "        dist = float(row[\"trip_distance\"])\n",
    "\n",
    "        # increment the counters\n",
    "        num_trips += 1\n",
    "        miles += dist\n",
    "\n",
    "print(miles / num_trips)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Step 3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2025-01-18T15:52:10.379677Z",
     "iopub.status.busy": "2025-01-18T15:52:10.379598Z",
     "iopub.status.idle": "2025-01-18T15:52:10.383905Z",
     "shell.execute_reply": "2025-01-18T15:52:10.383657Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "59.0%\n"
     ]
    }
   ],
   "source": [
    "num_trips = 0\n",
    "num_paid_by_card = 0\n",
    "\n",
    "with open(\"2021_yellow_taxi_trips.csv\") as csvfile:\n",
    "    reader = csv.DictReader(csvfile)\n",
    "    for row in reader:\n",
    "        # increment the counters\n",
    "        num_trips += 1\n",
    "        if row[\"payment_type\"] == \"1\":\n",
    "            num_paid_by_card += 1\n",
    "\n",
    "pct = num_paid_by_card / num_trips\n",
    "print(f\"{pct * 100}%\")"
   ]
  }
 ],
 "metadata": {
  "file_extension": ".py",
  "kernelspec": {
   "display_name": "Python [conda env:python-public-policy] *",
   "language": "python",
   "name": "conda-env-python-public-policy-py"
  },
  "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.11.11"
  },
  "mimetype": "text/x-python",
  "name": "python",
  "npconvert_exporter": "python",
  "pygments_lexer": "ipython3",
  "version": 3
 },
 "nbformat": 4,
 "nbformat_minor": 4
}