Homework4.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Before you turn this problem in, make sure everything runs as expected. First, **restart the kernel** (in the menubar, select Kernel$\\rightarrow$Restart) and then **run all cells** (in the menubar, select Cell$\\rightarrow$Run All).\n",
    "\n",
    "Make sure you fill in any place that says `YOUR CODE HERE` or \"YOUR ANSWER HERE\", as well as your name and collaborators below:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "NAME = \"Sreya Dhar\"\n",
    "COLLABORATORS = \"\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "deletable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "c32b10e487c11043ff5da12624f9b3fa",
     "grade": false,
     "grade_id": "cell-08c74419fb3f0714",
     "locked": false,
     "schema_version": 3,
     "solution": true,
     "task": false
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[3, 4, 6, 8, 9, 12, 15, 16, 18]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Exercise 1\n",
    "\n",
    "\n",
    "def list_comp1(lst):\n",
    "    # Complete this function to use list comprehension to return all values from `lst`\n",
    "    # that are a multiple of 3 or 4. Just complete the list comprehension below.\n",
    "    # input: `lst` of numbers\n",
    "    # output: a list of numbers\n",
    "    \n",
    "    # complete the following line!\n",
    "#     return [for ele in lst] #complete this line!\n",
    "    \n",
    "    # YOUR CODE HERE\n",
    "    d = [x for x in lst if x % 3 == 0 or x % 4 == 0]\n",
    "    return d\n",
    "\n",
    "list_comp1(range(1, 20))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "deletable": false,
    "editable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "546bb95c101426ec8a51502f04ee7c1e",
     "grade": true,
     "grade_id": "cell-e746cd92918acbf8",
     "locked": true,
     "points": 4,
     "schema_version": 3,
     "solution": false,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "\n",
    "assert list_comp1(range(1, 20)) == [3, 4, 6, 8, 9, 12, 15, 16, 18]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "deletable": false,
    "editable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "e8cf498c76b99a19da22dd02574bb6bf",
     "grade": true,
     "grade_id": "cell-0870e46368550525",
     "locked": true,
     "points": 4,
     "schema_version": 3,
     "solution": false,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "assert list_comp1(range(101, 140)) == [\n",
    "    102, 104, 105, 108, 111, 112, 114, 116, 117, 120, 123, 124, 126, 128, 129, 132, 135, 136, 138]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "deletable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "23e1767f9e78f8953caefea40cd5e88d",
     "grade": false,
     "grade_id": "cell-0316a6dcb5476768",
     "locked": false,
     "schema_version": 3,
     "solution": true,
     "task": false
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[0, 5, 6, 15, 12, 25, 18, 35, 24, 45, 30, 55, 36, 65, 42, 75, 48, 85, 54, 95]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Exercise 2\n",
    "\n",
    "\n",
    "def list_comp2(lst):\n",
    "    # Complete this function to use list comprehension to multiple all numbers\n",
    "    # in the list by 3 if it is even or 5 if its odd\n",
    "    # input: `lst` of numbers\n",
    "    # output: a list of numbers\n",
    "\n",
    "    # complete the following line!\n",
    "#     return [for ele in lst] #complete this line!\n",
    "   \n",
    "    \n",
    "    # YOUR CODE HERE\n",
    "#    \n",
    "    obj_1 = [x*3 if x%2 == 0 else x*5 for x in lst ]\n",
    "    #print(obj_1)\n",
    "    res = [] \n",
    "    for i in obj_1: \n",
    "        if i not in res: \n",
    "            res.append(i) \n",
    "        \n",
    "    return  res\n",
    "\n",
    "list_comp2(range(20))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "deletable": false,
    "editable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "5055b9b88b1a1328160bfaad0548965d",
     "grade": true,
     "grade_id": "cell-ed0cf2a2412e8b86",
     "locked": true,
     "points": 4,
     "schema_version": 3,
     "solution": false,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "assert list_comp2(range(20)) == [\n",
    "    0, 5, 6, 15, 12, 25, 18, 35, 24, 45, 30, 55, 36, 65, 42, 75, 48, 85, 54, 95]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "deletable": false,
    "editable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "9a6020270d6a77698d47cc1bc6164cd3",
     "grade": true,
     "grade_id": "cell-ba9c140c2ddaf762",
     "locked": true,
     "points": 4,
     "schema_version": 3,
     "solution": false,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "assert list_comp2(range(200, 220)) == [600, 1005, 606, 1015, 612, 1025, 618,\n",
    "                                       1035, 624, 1045, 630, 1055, 636, 1065, 642, 1075, 648, 1085, 654, 1095]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "deletable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "86a5cb0549b5a6727f7c5df3c3f2c97e",
     "grade": false,
     "grade_id": "cell-91d6b402c85e893d",
     "locked": false,
     "schema_version": 3,
     "solution": true,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "# Exercise 3\n",
    "import statistics\n",
    "import linecache\n",
    "#\n",
    "\n",
    "\n",
    "def lambda_1(filename):\n",
    "    # Complete this function to read grades from `filename` and find the minimum\n",
    "    # student test averages. File has student_name, test1_score, test2_score,\n",
    "    # test3_score, test4_score, test5_score. This function must use a lambda\n",
    "    # function and use the min() function to find the student with the minimum\n",
    "    # test average. The input to the min function should be\n",
    "    # a list of lines. Ex. ['student1,33,34,35,36,45', 'student2,33,34,35,36,75']\n",
    "    # input filename\n",
    "    # output: (lambda_func, line_with_min_student) -- example (lambda_func, 'student1,33,34,35,36,45')\n",
    "    file =open(filename)\n",
    "    lines=[]\n",
    "    \n",
    "    for line in file:\n",
    "        \n",
    "        if line.strip('\\n'):\n",
    "            line = line.strip('\\n')\n",
    "            if not line:\n",
    "                continue\n",
    "            lines.append(line)\n",
    "            \n",
    "    lambda_func = lambda line: sum(list(map(int, line.split(',')[1:])))\n",
    "      \n",
    "    return  (lambda_func, min(lines, key=lambda_func))\n",
    "    \n",
    "\n",
    "lambda_1('ex3_data.txt')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "deletable": false,
    "editable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "68cb8c6879d35f1f53ee9200eed4257d",
     "grade": true,
     "grade_id": "cell-e684bb8e7de533f1",
     "locked": true,
     "points": 8,
     "schema_version": 3,
     "solution": false,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "l_func, min_student = lambda_1('ex3_data.txt')\n",
    "assert min_student == 'student11,72,69,69,65,91'\n",
    "\n",
    "lines = (\n",
    "    'student45,83,74,99,76,95',\n",
    "    'student46,96,83,79,89,71',\n",
    "    'student47,70,85,94,73,74',\n",
    "    'student48,99,72,92,65,87',\n",
    "    'student49,78,93,99,77,85',\n",
    "    'student50,96,91,76,72,66',\n",
    "    'student51,94,86,77,91,96',\n",
    ")\n",
    "\n",
    "assert min(lines, key=l_func) == 'student47,70,85,94,73,74'\n",
    "import types\n",
    "assert type(l_func) is types.LambdaType"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "deletable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "7e167eabee69a8165f4f67def326975b",
     "grade": false,
     "grade_id": "cell-7688e2600060e34b",
     "locked": false,
     "schema_version": 3,
     "solution": true,
     "task": false
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(<function __main__.lambda_2.<locals>.<lambda>(line)>,\n",
       " ['student1: B',\n",
       "  'student2: B',\n",
       "  'student3: B',\n",
       "  'student4: B',\n",
       "  'student5: B',\n",
       "  'student6: B',\n",
       "  'student7: C',\n",
       "  'student8: C',\n",
       "  'student9: B',\n",
       "  'student10: C',\n",
       "  'student11: C',\n",
       "  'student12: C',\n",
       "  'student13: B',\n",
       "  'student14: B',\n",
       "  'student15: C',\n",
       "  'student16: B',\n",
       "  'student17: B',\n",
       "  'student18: B',\n",
       "  'student19: C',\n",
       "  'student20: B',\n",
       "  'student21: B',\n",
       "  'student22: C',\n",
       "  'student23: B',\n",
       "  'student24: B',\n",
       "  'student25: A',\n",
       "  'student26: B',\n",
       "  'student27: C',\n",
       "  'student28: B',\n",
       "  'student29: B',\n",
       "  'student30: B',\n",
       "  'student31: B',\n",
       "  'student32: C',\n",
       "  'student33: B',\n",
       "  'student34: B',\n",
       "  'student35: B',\n",
       "  'student36: C',\n",
       "  'student37: B',\n",
       "  'student38: B',\n",
       "  'student39: C',\n",
       "  'student40: C',\n",
       "  'student41: B',\n",
       "  'student42: A',\n",
       "  'student43: B',\n",
       "  'student44: C',\n",
       "  'student45: B',\n",
       "  'student46: B',\n",
       "  'student47: C',\n",
       "  'student48: B',\n",
       "  'student49: B',\n",
       "  'student50: B',\n",
       "  'student51: B',\n",
       "  'student52: C',\n",
       "  'student53: B',\n",
       "  'student54: C',\n",
       "  'student55: A',\n",
       "  'student56: A',\n",
       "  'student57: B',\n",
       "  'student58: C',\n",
       "  'student59: B',\n",
       "  'student60: B',\n",
       "  'student61: B',\n",
       "  'student62: B',\n",
       "  'student63: B',\n",
       "  'student64: B',\n",
       "  'student65: C',\n",
       "  'student66: C',\n",
       "  'student67: C',\n",
       "  'student68: B',\n",
       "  'student69: B',\n",
       "  'student70: B',\n",
       "  'student71: B',\n",
       "  'student72: C',\n",
       "  'student73: B',\n",
       "  'student74: B',\n",
       "  'student75: B',\n",
       "  'student76: B',\n",
       "  'student77: B',\n",
       "  'student78: C',\n",
       "  'student79: B',\n",
       "  'student80: B',\n",
       "  'student81: B',\n",
       "  'student82: C',\n",
       "  'student83: B',\n",
       "  'student84: C',\n",
       "  'student85: C',\n",
       "  'student86: B',\n",
       "  'student87: A',\n",
       "  'student88: B',\n",
       "  'student89: C',\n",
       "  'student90: B',\n",
       "  'student91: B',\n",
       "  'student92: C',\n",
       "  'student93: C',\n",
       "  'student94: C',\n",
       "  'student95: A',\n",
       "  'student96: B',\n",
       "  'student97: A',\n",
       "  'student98: B',\n",
       "  'student99: C',\n",
       "  'student100: B'])"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Ex 4\n",
    "import statistics\n",
    "def lambda_2(filename):\n",
    "    # Complete this function to read grades from `filename` and map the test average to letter\n",
    "    # grades using map and lambda. File has student_name, test1_score, test2_score,\n",
    "    # test3_score, test4_score, test5_score. This function must use a lambda\n",
    "    # function and map() function.\n",
    "    # The input to the map function should be\n",
    "    # a list of lines. Ex. ['student1,73,74,75,76,75', ...]. Output is a list of strings in the format\n",
    "    # studentname: Letter Grade -- 'student1: C'\n",
    "    # input filename\n",
    "    # output: (lambda_func, list_of_studentname_and_lettergrade) -- example (lambda_func, ['student1: C', ...])\n",
    "\n",
    "    # Use this average to grade mapping. Round the average mapping.\n",
    "    # D = 65<=average<70\n",
    "    # C = 70<=average<80\n",
    "    # B = 80<=average<90\n",
    "    # A = 90<=average  \n",
    "    \n",
    "    # YOUR CODE HERE\n",
    "    \n",
    " \n",
    "    grade_mapping = {}  # fill this!\n",
    "\n",
    "    # YOUR CODE HERE\n",
    "    lambda_func = lambda line: '{}: {}'.format(line.split(',')[0], grade_mapping[round(sum([int(ele) for ele in line.split(',')[1:]])/len(line.split(',')[1:]))])    \n",
    "    \n",
    "    lines=[]  \n",
    "    \n",
    "    for grade in range(65, 101):\n",
    "        if 65 <= grade < 70:\n",
    "            grade_mapping[grade] = 'D'\n",
    "        elif 70 <= grade < 80:\n",
    "            grade_mapping[grade] = 'C'\n",
    "        elif 80 <= grade < 90:\n",
    "            grade_mapping[grade] = 'B'\n",
    "        else:\n",
    "            grade_mapping[grade] = 'A'\n",
    "        \n",
    "    with open(filename,'r') as file:\n",
    "        for line in file:\n",
    "            if not line.strip():\n",
    "                continue\n",
    "            line = line.strip()\n",
    "            lines.append(line)\n",
    "    \n",
    "    return lambda_func,list(map(lambda_func, lines))\n",
    "    \n",
    "lambda_2('ex3_data.txt')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "deletable": false,
    "editable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "cad4e8f4c39cc8a7f192cbf7cef66d6f",
     "grade": true,
     "grade_id": "cell-dbc80a45ca9fe86b",
     "locked": true,
     "points": 8,
     "schema_version": 3,
     "solution": false,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "l_func, student_grades = lambda_2('ex3_data.txt')\n",
    "\n",
    "\n",
    "result = ['student1: B',\n",
    " 'student2: B',\n",
    " 'student3: B',\n",
    " 'student4: B',\n",
    " 'student5: B',\n",
    " 'student6: B',\n",
    " 'student7: C',\n",
    " 'student8: C',\n",
    " 'student9: B',\n",
    " 'student10: C',\n",
    " 'student11: C',\n",
    " 'student12: C',\n",
    " 'student13: B',\n",
    " 'student14: B',\n",
    " 'student15: C',\n",
    " 'student16: B',\n",
    " 'student17: B',\n",
    " 'student18: B',\n",
    " 'student19: C',\n",
    " 'student20: B',\n",
    " 'student21: B',\n",
    " 'student22: C',\n",
    " 'student23: B',\n",
    " 'student24: B',\n",
    " 'student25: A',\n",
    " 'student26: B',\n",
    " 'student27: C',\n",
    " 'student28: B',\n",
    " 'student29: B',\n",
    " 'student30: B',\n",
    " 'student31: B',\n",
    " 'student32: C',\n",
    " 'student33: B',\n",
    " 'student34: B',\n",
    " 'student35: B',\n",
    " 'student36: C',\n",
    " 'student37: B',\n",
    " 'student38: B',\n",
    " 'student39: C',\n",
    " 'student40: C',\n",
    " 'student41: B',\n",
    " 'student42: A',\n",
    " 'student43: B',\n",
    " 'student44: C',\n",
    " 'student45: B',\n",
    " 'student46: B',\n",
    " 'student47: C',\n",
    " 'student48: B',\n",
    " 'student49: B',\n",
    " 'student50: B',\n",
    " 'student51: B',\n",
    " 'student52: C',\n",
    " 'student53: B',\n",
    " 'student54: C',\n",
    " 'student55: A',\n",
    " 'student56: A',\n",
    " 'student57: B',\n",
    " 'student58: C',\n",
    " 'student59: B',\n",
    " 'student60: B',\n",
    " 'student61: B',\n",
    " 'student62: B',\n",
    " 'student63: B',\n",
    " 'student64: B',\n",
    " 'student65: C',\n",
    " 'student66: C',\n",
    " 'student67: C',\n",
    " 'student68: B',\n",
    " 'student69: B',\n",
    " 'student70: B',\n",
    " 'student71: B',\n",
    " 'student72: C',\n",
    " 'student73: B',\n",
    " 'student74: B',\n",
    " 'student75: B',\n",
    " 'student76: B',\n",
    " 'student77: B',\n",
    " 'student78: C',\n",
    " 'student79: B',\n",
    " 'student80: B',\n",
    " 'student81: B',\n",
    " 'student82: C',\n",
    " 'student83: B',\n",
    " 'student84: C',\n",
    " 'student85: C',\n",
    " 'student86: B',\n",
    " 'student87: A',\n",
    " 'student88: B',\n",
    " 'student89: C',\n",
    " 'student90: B',\n",
    " 'student91: B',\n",
    " 'student92: C',\n",
    " 'student93: C',\n",
    " 'student94: C',\n",
    " 'student95: A',\n",
    " 'student96: B',\n",
    " 'student97: A',\n",
    " 'student98: B',\n",
    " 'student99: C',\n",
    " 'student100: B']\n",
    "\n",
    "assert list(student_grades) == result\n",
    "\n",
    "import types\n",
    "assert type(l_func) is types.LambdaType\n",
    "\n",
    "lines = (\n",
    "    'student45,83,74,99,76,95',\n",
    "    'student46,96,83,79,89,71',\n",
    "    'student47,70,85,94,73,74',\n",
    "    'student48,99,72,92,65,87',\n",
    "    'student49,78,93,99,77,85',\n",
    "    'student50,96,91,76,72,66',\n",
    "    'student51,94,86,77,91,96',\n",
    ")\n",
    "\n",
    "assert list(map(l_func, lines)) == ['student45: B', 'student46: B', 'student47: C', 'student48: B', 'student49: B', 'student50: B', 'student51: B']\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "deletable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "2faa88a69f7d2cd0094c38a07cba9f9f",
     "grade": false,
     "grade_id": "cell-831427ca3f2605f7",
     "locked": false,
     "schema_version": 3,
     "solution": true,
     "task": false
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(<function __main__.ex5.<locals>.<lambda>(row)>,\n",
       " [{'name': 'student2',\n",
       "   'test1': '100',\n",
       "   'test2': '90',\n",
       "   'test3': '65',\n",
       "   'test4': '68',\n",
       "   'test5': '94'},\n",
       "  {'name': 'student83',\n",
       "   'test1': '88',\n",
       "   'test2': '76',\n",
       "   'test3': '65',\n",
       "   'test4': '97',\n",
       "   'test5': '82'},\n",
       "  {'name': 'student31',\n",
       "   'test1': '90',\n",
       "   'test2': '87',\n",
       "   'test3': '66',\n",
       "   'test4': '95',\n",
       "   'test5': '72'},\n",
       "  {'name': 'student43',\n",
       "   'test1': '86',\n",
       "   'test2': '69',\n",
       "   'test3': '66',\n",
       "   'test4': '70',\n",
       "   'test5': '74'},\n",
       "  {'name': 'student47',\n",
       "   'test1': '93',\n",
       "   'test2': '78',\n",
       "   'test3': '67',\n",
       "   'test4': '74',\n",
       "   'test5': '74'},\n",
       "  {'name': 'student52',\n",
       "   'test1': '83',\n",
       "   'test2': '78',\n",
       "   'test3': '67',\n",
       "   'test4': '71',\n",
       "   'test5': '65'},\n",
       "  {'name': 'student37',\n",
       "   'test1': '91',\n",
       "   'test2': '78',\n",
       "   'test3': '68',\n",
       "   'test4': '67',\n",
       "   'test5': '92'},\n",
       "  {'name': 'student58',\n",
       "   'test1': '89',\n",
       "   'test2': '88',\n",
       "   'test3': '68',\n",
       "   'test4': '79',\n",
       "   'test5': '79'},\n",
       "  {'name': 'student63',\n",
       "   'test1': '85',\n",
       "   'test2': '66',\n",
       "   'test3': '69',\n",
       "   'test4': '74',\n",
       "   'test5': '69'},\n",
       "  {'name': 'student12',\n",
       "   'test1': '88',\n",
       "   'test2': '83',\n",
       "   'test3': '71',\n",
       "   'test4': '89',\n",
       "   'test5': '73'},\n",
       "  {'name': 'student85',\n",
       "   'test1': '76',\n",
       "   'test2': '100',\n",
       "   'test3': '71',\n",
       "   'test4': '69',\n",
       "   'test5': '65'},\n",
       "  {'name': 'student98',\n",
       "   'test1': '81',\n",
       "   'test2': '85',\n",
       "   'test3': '71',\n",
       "   'test4': '89',\n",
       "   'test5': '76'},\n",
       "  {'name': 'student17',\n",
       "   'test1': '86',\n",
       "   'test2': '98',\n",
       "   'test3': '73',\n",
       "   'test4': '100',\n",
       "   'test5': '92'},\n",
       "  {'name': 'student62',\n",
       "   'test1': '86',\n",
       "   'test2': '100',\n",
       "   'test3': '73',\n",
       "   'test4': '99',\n",
       "   'test5': '76'},\n",
       "  {'name': 'student69',\n",
       "   'test1': '93',\n",
       "   'test2': '95',\n",
       "   'test3': '73',\n",
       "   'test4': '86',\n",
       "   'test5': '90'},\n",
       "  {'name': 'student81',\n",
       "   'test1': '95',\n",
       "   'test2': '83',\n",
       "   'test3': '74',\n",
       "   'test4': '75',\n",
       "   'test5': '81'},\n",
       "  {'name': 'student93',\n",
       "   'test1': '95',\n",
       "   'test2': '97',\n",
       "   'test3': '74',\n",
       "   'test4': '74',\n",
       "   'test5': '81'},\n",
       "  {'name': 'student26',\n",
       "   'test1': '80',\n",
       "   'test2': '78',\n",
       "   'test3': '75',\n",
       "   'test4': '69',\n",
       "   'test5': '87'},\n",
       "  {'name': 'student34',\n",
       "   'test1': '93',\n",
       "   'test2': '88',\n",
       "   'test3': '77',\n",
       "   'test4': '67',\n",
       "   'test5': '93'},\n",
       "  {'name': 'student14',\n",
       "   'test1': '85',\n",
       "   'test2': '97',\n",
       "   'test3': '78',\n",
       "   'test4': '67',\n",
       "   'test5': '99'},\n",
       "  {'name': 'student79',\n",
       "   'test1': '91',\n",
       "   'test2': '94',\n",
       "   'test3': '78',\n",
       "   'test4': '83',\n",
       "   'test5': '92'},\n",
       "  {'name': 'student25',\n",
       "   'test1': '77',\n",
       "   'test2': '86',\n",
       "   'test3': '79',\n",
       "   'test4': '70',\n",
       "   'test5': '92'},\n",
       "  {'name': 'student55',\n",
       "   'test1': '91',\n",
       "   'test2': '76',\n",
       "   'test3': '79',\n",
       "   'test4': '65',\n",
       "   'test5': '66'},\n",
       "  {'name': 'student70',\n",
       "   'test1': '100',\n",
       "   'test2': '71',\n",
       "   'test3': '79',\n",
       "   'test4': '99',\n",
       "   'test5': '78'},\n",
       "  {'name': 'student80',\n",
       "   'test1': '98',\n",
       "   'test2': '85',\n",
       "   'test3': '79',\n",
       "   'test4': '91',\n",
       "   'test5': '92'},\n",
       "  {'name': 'student13',\n",
       "   'test1': '95',\n",
       "   'test2': '72',\n",
       "   'test3': '80',\n",
       "   'test4': '73',\n",
       "   'test5': '84'},\n",
       "  {'name': 'student35',\n",
       "   'test1': '75',\n",
       "   'test2': '89',\n",
       "   'test3': '80',\n",
       "   'test4': '93',\n",
       "   'test5': '74'},\n",
       "  {'name': 'student20',\n",
       "   'test1': '68',\n",
       "   'test2': '68',\n",
       "   'test3': '81',\n",
       "   'test4': '74',\n",
       "   'test5': '76'},\n",
       "  {'name': 'student50',\n",
       "   'test1': '94',\n",
       "   'test2': '68',\n",
       "   'test3': '81',\n",
       "   'test4': '69',\n",
       "   'test5': '89'},\n",
       "  {'name': 'student66',\n",
       "   'test1': '91',\n",
       "   'test2': '92',\n",
       "   'test3': '81',\n",
       "   'test4': '79',\n",
       "   'test5': '69'},\n",
       "  {'name': 'student1',\n",
       "   'test1': '73',\n",
       "   'test2': '91',\n",
       "   'test3': '82',\n",
       "   'test4': '90',\n",
       "   'test5': '93'},\n",
       "  {'name': 'student100',\n",
       "   'test1': '79',\n",
       "   'test2': '79',\n",
       "   'test3': '82',\n",
       "   'test4': '71',\n",
       "   'test5': '87'},\n",
       "  {'name': 'student5',\n",
       "   'test1': '86',\n",
       "   'test2': '93',\n",
       "   'test3': '83',\n",
       "   'test4': '94',\n",
       "   'test5': '94'},\n",
       "  {'name': 'student16',\n",
       "   'test1': '81',\n",
       "   'test2': '95',\n",
       "   'test3': '83',\n",
       "   'test4': '87',\n",
       "   'test5': '95'},\n",
       "  {'name': 'student19',\n",
       "   'test1': '70',\n",
       "   'test2': '70',\n",
       "   'test3': '83',\n",
       "   'test4': '99',\n",
       "   'test5': '97'},\n",
       "  {'name': 'student61',\n",
       "   'test1': '65',\n",
       "   'test2': '76',\n",
       "   'test3': '83',\n",
       "   'test4': '75',\n",
       "   'test5': '68'},\n",
       "  {'name': 'student91',\n",
       "   'test1': '79',\n",
       "   'test2': '100',\n",
       "   'test3': '83',\n",
       "   'test4': '66',\n",
       "   'test5': '69'},\n",
       "  {'name': 'student96',\n",
       "   'test1': '99',\n",
       "   'test2': '93',\n",
       "   'test3': '83',\n",
       "   'test4': '75',\n",
       "   'test5': '85'},\n",
       "  {'name': 'student21',\n",
       "   'test1': '74',\n",
       "   'test2': '73',\n",
       "   'test3': '84',\n",
       "   'test4': '84',\n",
       "   'test5': '69'},\n",
       "  {'name': 'student46',\n",
       "   'test1': '92',\n",
       "   'test2': '83',\n",
       "   'test3': '84',\n",
       "   'test4': '69',\n",
       "   'test5': '90'},\n",
       "  {'name': 'student22',\n",
       "   'test1': '65',\n",
       "   'test2': '87',\n",
       "   'test3': '85',\n",
       "   'test4': '78',\n",
       "   'test5': '98'},\n",
       "  {'name': 'student23',\n",
       "   'test1': '88',\n",
       "   'test2': '95',\n",
       "   'test3': '85',\n",
       "   'test4': '67',\n",
       "   'test5': '93'},\n",
       "  {'name': 'student72',\n",
       "   'test1': '85',\n",
       "   'test2': '66',\n",
       "   'test3': '85',\n",
       "   'test4': '78',\n",
       "   'test5': '75'},\n",
       "  {'name': 'student82',\n",
       "   'test1': '77',\n",
       "   'test2': '100',\n",
       "   'test3': '85',\n",
       "   'test4': '65',\n",
       "   'test5': '80'},\n",
       "  {'name': 'student88',\n",
       "   'test1': '77',\n",
       "   'test2': '87',\n",
       "   'test3': '85',\n",
       "   'test4': '90',\n",
       "   'test5': '78'},\n",
       "  {'name': 'student18',\n",
       "   'test1': '65',\n",
       "   'test2': '78',\n",
       "   'test3': '86',\n",
       "   'test4': '69',\n",
       "   'test5': '98'},\n",
       "  {'name': 'student24',\n",
       "   'test1': '80',\n",
       "   'test2': '91',\n",
       "   'test3': '86',\n",
       "   'test4': '99',\n",
       "   'test5': '96'},\n",
       "  {'name': 'student28',\n",
       "   'test1': '90',\n",
       "   'test2': '100',\n",
       "   'test3': '86',\n",
       "   'test4': '89',\n",
       "   'test5': '75'},\n",
       "  {'name': 'student53',\n",
       "   'test1': '83',\n",
       "   'test2': '100',\n",
       "   'test3': '86',\n",
       "   'test4': '83',\n",
       "   'test5': '90'},\n",
       "  {'name': 'student74',\n",
       "   'test1': '97',\n",
       "   'test2': '99',\n",
       "   'test3': '86',\n",
       "   'test4': '93',\n",
       "   'test5': '99'},\n",
       "  {'name': 'student75',\n",
       "   'test1': '79',\n",
       "   'test2': '79',\n",
       "   'test3': '86',\n",
       "   'test4': '78',\n",
       "   'test5': '68'},\n",
       "  {'name': 'student78',\n",
       "   'test1': '88',\n",
       "   'test2': '98',\n",
       "   'test3': '86',\n",
       "   'test4': '100',\n",
       "   'test5': '71'},\n",
       "  {'name': 'student90',\n",
       "   'test1': '95',\n",
       "   'test2': '66',\n",
       "   'test3': '86',\n",
       "   'test4': '85',\n",
       "   'test5': '65'},\n",
       "  {'name': 'student10',\n",
       "   'test1': '98',\n",
       "   'test2': '68',\n",
       "   'test3': '87',\n",
       "   'test4': '85',\n",
       "   'test5': '96'},\n",
       "  {'name': 'student27',\n",
       "   'test1': '94',\n",
       "   'test2': '99',\n",
       "   'test3': '87',\n",
       "   'test4': '91',\n",
       "   'test5': '86'},\n",
       "  {'name': 'student42',\n",
       "   'test1': '72',\n",
       "   'test2': '86',\n",
       "   'test3': '87',\n",
       "   'test4': '98',\n",
       "   'test5': '73'},\n",
       "  {'name': 'student49',\n",
       "   'test1': '81',\n",
       "   'test2': '98',\n",
       "   'test3': '87',\n",
       "   'test4': '81',\n",
       "   'test5': '79'},\n",
       "  {'name': 'student84',\n",
       "   'test1': '70',\n",
       "   'test2': '66',\n",
       "   'test3': '87',\n",
       "   'test4': '100',\n",
       "   'test5': '97'},\n",
       "  {'name': 'student33',\n",
       "   'test1': '95',\n",
       "   'test2': '67',\n",
       "   'test3': '88',\n",
       "   'test4': '81',\n",
       "   'test5': '97'},\n",
       "  {'name': 'student38',\n",
       "   'test1': '68',\n",
       "   'test2': '98',\n",
       "   'test3': '88',\n",
       "   'test4': '84',\n",
       "   'test5': '72'},\n",
       "  {'name': 'student45',\n",
       "   'test1': '91',\n",
       "   'test2': '81',\n",
       "   'test3': '88',\n",
       "   'test4': '95',\n",
       "   'test5': '69'},\n",
       "  {'name': 'student64',\n",
       "   'test1': '89',\n",
       "   'test2': '78',\n",
       "   'test3': '88',\n",
       "   'test4': '86',\n",
       "   'test5': '95'},\n",
       "  {'name': 'student86',\n",
       "   'test1': '81',\n",
       "   'test2': '71',\n",
       "   'test3': '88',\n",
       "   'test4': '98',\n",
       "   'test5': '81'},\n",
       "  {'name': 'student76',\n",
       "   'test1': '80',\n",
       "   'test2': '72',\n",
       "   'test3': '89',\n",
       "   'test4': '88',\n",
       "   'test5': '89'},\n",
       "  {'name': 'student77',\n",
       "   'test1': '84',\n",
       "   'test2': '99',\n",
       "   'test3': '89',\n",
       "   'test4': '69',\n",
       "   'test5': '66'},\n",
       "  {'name': 'student92',\n",
       "   'test1': '88',\n",
       "   'test2': '91',\n",
       "   'test3': '89',\n",
       "   'test4': '97',\n",
       "   'test5': '99'},\n",
       "  {'name': 'student3',\n",
       "   'test1': '94',\n",
       "   'test2': '67',\n",
       "   'test3': '90',\n",
       "   'test4': '95',\n",
       "   'test5': '84'},\n",
       "  {'name': 'student40',\n",
       "   'test1': '94',\n",
       "   'test2': '97',\n",
       "   'test3': '90',\n",
       "   'test4': '95',\n",
       "   'test5': '84'},\n",
       "  {'name': 'student11',\n",
       "   'test1': '92',\n",
       "   'test2': '81',\n",
       "   'test3': '91',\n",
       "   'test4': '96',\n",
       "   'test5': '78'},\n",
       "  {'name': 'student57',\n",
       "   'test1': '87',\n",
       "   'test2': '84',\n",
       "   'test3': '91',\n",
       "   'test4': '83',\n",
       "   'test5': '80'},\n",
       "  {'name': 'student87',\n",
       "   'test1': '88',\n",
       "   'test2': '100',\n",
       "   'test3': '91',\n",
       "   'test4': '75',\n",
       "   'test5': '66'},\n",
       "  {'name': 'student44',\n",
       "   'test1': '67',\n",
       "   'test2': '100',\n",
       "   'test3': '92',\n",
       "   'test4': '87',\n",
       "   'test5': '80'},\n",
       "  {'name': 'student68',\n",
       "   'test1': '78',\n",
       "   'test2': '99',\n",
       "   'test3': '92',\n",
       "   'test4': '74',\n",
       "   'test5': '89'},\n",
       "  {'name': 'student89',\n",
       "   'test1': '82',\n",
       "   'test2': '78',\n",
       "   'test3': '92',\n",
       "   'test4': '90',\n",
       "   'test5': '99'},\n",
       "  {'name': 'student97',\n",
       "   'test1': '87',\n",
       "   'test2': '82',\n",
       "   'test3': '92',\n",
       "   'test4': '88',\n",
       "   'test5': '92'},\n",
       "  {'name': 'student8',\n",
       "   'test1': '88',\n",
       "   'test2': '71',\n",
       "   'test3': '93',\n",
       "   'test4': '71',\n",
       "   'test5': '86'},\n",
       "  {'name': 'student59',\n",
       "   'test1': '78',\n",
       "   'test2': '76',\n",
       "   'test3': '94',\n",
       "   'test4': '65',\n",
       "   'test5': '80'},\n",
       "  {'name': 'student60',\n",
       "   'test1': '67',\n",
       "   'test2': '76',\n",
       "   'test3': '94',\n",
       "   'test4': '67',\n",
       "   'test5': '74'},\n",
       "  {'name': 'student15',\n",
       "   'test1': '84',\n",
       "   'test2': '71',\n",
       "   'test3': '95',\n",
       "   'test4': '77',\n",
       "   'test5': '77'},\n",
       "  {'name': 'student29',\n",
       "   'test1': '89',\n",
       "   'test2': '93',\n",
       "   'test3': '95',\n",
       "   'test4': '78',\n",
       "   'test5': '82'},\n",
       "  {'name': 'student67',\n",
       "   'test1': '74',\n",
       "   'test2': '80',\n",
       "   'test3': '95',\n",
       "   'test4': '85',\n",
       "   'test5': '94'},\n",
       "  {'name': 'student94',\n",
       "   'test1': '80',\n",
       "   'test2': '71',\n",
       "   'test3': '95',\n",
       "   'test4': '76',\n",
       "   'test5': '68'},\n",
       "  {'name': 'student32',\n",
       "   'test1': '91',\n",
       "   'test2': '76',\n",
       "   'test3': '96',\n",
       "   'test4': '73',\n",
       "   'test5': '91'},\n",
       "  {'name': 'student51',\n",
       "   'test1': '94',\n",
       "   'test2': '93',\n",
       "   'test3': '96',\n",
       "   'test4': '96',\n",
       "   'test5': '76'},\n",
       "  {'name': 'student73',\n",
       "   'test1': '92',\n",
       "   'test2': '89',\n",
       "   'test3': '96',\n",
       "   'test4': '83',\n",
       "   'test5': '79'},\n",
       "  {'name': 'student99',\n",
       "   'test1': '69',\n",
       "   'test2': '74',\n",
       "   'test3': '96',\n",
       "   'test4': '97',\n",
       "   'test5': '71'},\n",
       "  {'name': 'student39',\n",
       "   'test1': '75',\n",
       "   'test2': '90',\n",
       "   'test3': '97',\n",
       "   'test4': '86',\n",
       "   'test5': '72'},\n",
       "  {'name': 'student56',\n",
       "   'test1': '98',\n",
       "   'test2': '80',\n",
       "   'test3': '97',\n",
       "   'test4': '68',\n",
       "   'test5': '91'},\n",
       "  {'name': 'student4',\n",
       "   'test1': '68',\n",
       "   'test2': '85',\n",
       "   'test3': '98',\n",
       "   'test4': '69',\n",
       "   'test5': '77'},\n",
       "  {'name': 'student30',\n",
       "   'test1': '66',\n",
       "   'test2': '92',\n",
       "   'test3': '98',\n",
       "   'test4': '92',\n",
       "   'test5': '100'},\n",
       "  {'name': 'student41',\n",
       "   'test1': '71',\n",
       "   'test2': '77',\n",
       "   'test3': '98',\n",
       "   'test4': '95',\n",
       "   'test5': '70'},\n",
       "  {'name': 'student54',\n",
       "   'test1': '92',\n",
       "   'test2': '72',\n",
       "   'test3': '98',\n",
       "   'test4': '70',\n",
       "   'test5': '98'},\n",
       "  {'name': 'student71',\n",
       "   'test1': '95',\n",
       "   'test2': '98',\n",
       "   'test3': '98',\n",
       "   'test4': '98',\n",
       "   'test5': '75'},\n",
       "  {'name': 'student95',\n",
       "   'test1': '78',\n",
       "   'test2': '71',\n",
       "   'test3': '98',\n",
       "   'test4': '78',\n",
       "   'test5': '96'},\n",
       "  {'name': 'student6',\n",
       "   'test1': '72',\n",
       "   'test2': '97',\n",
       "   'test3': '99',\n",
       "   'test4': '69',\n",
       "   'test5': '83'},\n",
       "  {'name': 'student9',\n",
       "   'test1': '79',\n",
       "   'test2': '69',\n",
       "   'test3': '99',\n",
       "   'test4': '73',\n",
       "   'test5': '76'},\n",
       "  {'name': 'student7',\n",
       "   'test1': '66',\n",
       "   'test2': '99',\n",
       "   'test3': '100',\n",
       "   'test4': '96',\n",
       "   'test5': '81'},\n",
       "  {'name': 'student36',\n",
       "   'test1': '76',\n",
       "   'test2': '69',\n",
       "   'test3': '100',\n",
       "   'test4': '97',\n",
       "   'test5': '83'},\n",
       "  {'name': 'student48',\n",
       "   'test1': '98',\n",
       "   'test2': '69',\n",
       "   'test3': '100',\n",
       "   'test4': '84',\n",
       "   'test5': '80'},\n",
       "  {'name': 'student65',\n",
       "   'test1': '80',\n",
       "   'test2': '75',\n",
       "   'test3': '100',\n",
       "   'test4': '83',\n",
       "   'test5': '77'}])"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def ex5(filename):\n",
    "    # Complete this function to sort a list of dictionary by 'test3'\n",
    "    # return the lambda function and the sorted list of dictionaries\n",
    "\n",
    "    import json\n",
    "    with open(filename) as infile:\n",
    "        grades_list = json.load(infile)\n",
    "    \n",
    "    # YOUR CODE HERE\n",
    "    \n",
    "    lambda_func = lambda row: int(row.get('test3'))\n",
    "    \n",
    "    return lambda_func, sorted(grades_list, key=lambda_func)\n",
    "\n",
    "ex5('grades_dict.json')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "deletable": false,
    "editable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "d2d557ba052ec35916863c721f195904",
     "grade": true,
     "grade_id": "cell-446bd1939a594ade",
     "locked": true,
     "points": 8,
     "schema_version": 3,
     "solution": false,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "\n",
    "results = [{'name': 'student2', 'test1': '100', 'test2': '90', 'test3': '65', 'test4': '68', 'test5': '94'},\n",
    " {'name': 'student83', 'test1': '88', 'test2': '76', 'test3': '65', 'test4': '97', 'test5': '82'},\n",
    " {'name': 'student31', 'test1': '90', 'test2': '87', 'test3': '66', 'test4': '95', 'test5': '72'},\n",
    " {'name': 'student43', 'test1': '86', 'test2': '69', 'test3': '66', 'test4': '70', 'test5': '74'},\n",
    " {'name': 'student47', 'test1': '93', 'test2': '78', 'test3': '67', 'test4': '74', 'test5': '74'},\n",
    " {'name': 'student52', 'test1': '83', 'test2': '78', 'test3': '67', 'test4': '71', 'test5': '65'},\n",
    " {'name': 'student37', 'test1': '91', 'test2': '78', 'test3': '68', 'test4': '67', 'test5': '92'},\n",
    " {'name': 'student58', 'test1': '89', 'test2': '88', 'test3': '68', 'test4': '79', 'test5': '79'},\n",
    " {'name': 'student63', 'test1': '85', 'test2': '66', 'test3': '69', 'test4': '74', 'test5': '69'},\n",
    " {'name': 'student12', 'test1': '88', 'test2': '83', 'test3': '71', 'test4': '89', 'test5': '73'},\n",
    " {'name': 'student85', 'test1': '76', 'test2': '100', 'test3': '71', 'test4': '69', 'test5': '65'},\n",
    " {'name': 'student98', 'test1': '81', 'test2': '85', 'test3': '71', 'test4': '89', 'test5': '76'},\n",
    " {'name': 'student17', 'test1': '86', 'test2': '98', 'test3': '73', 'test4': '100', 'test5': '92'},\n",
    " {'name': 'student62', 'test1': '86', 'test2': '100', 'test3': '73', 'test4': '99', 'test5': '76'},\n",
    " {'name': 'student69', 'test1': '93', 'test2': '95', 'test3': '73', 'test4': '86', 'test5': '90'},\n",
    " {'name': 'student81', 'test1': '95', 'test2': '83', 'test3': '74', 'test4': '75', 'test5': '81'},\n",
    " {'name': 'student93', 'test1': '95', 'test2': '97', 'test3': '74', 'test4': '74', 'test5': '81'},\n",
    " {'name': 'student26', 'test1': '80', 'test2': '78', 'test3': '75', 'test4': '69', 'test5': '87'},\n",
    " {'name': 'student34', 'test1': '93', 'test2': '88', 'test3': '77', 'test4': '67', 'test5': '93'},\n",
    " {'name': 'student14', 'test1': '85', 'test2': '97', 'test3': '78', 'test4': '67', 'test5': '99'},\n",
    " {'name': 'student79', 'test1': '91', 'test2': '94', 'test3': '78', 'test4': '83', 'test5': '92'},\n",
    " {'name': 'student25', 'test1': '77', 'test2': '86', 'test3': '79', 'test4': '70', 'test5': '92'},\n",
    " {'name': 'student55', 'test1': '91', 'test2': '76', 'test3': '79', 'test4': '65', 'test5': '66'},\n",
    " {'name': 'student70', 'test1': '100', 'test2': '71', 'test3': '79', 'test4': '99', 'test5': '78'},\n",
    " {'name': 'student80', 'test1': '98', 'test2': '85', 'test3': '79', 'test4': '91', 'test5': '92'},\n",
    " {'name': 'student13', 'test1': '95', 'test2': '72', 'test3': '80', 'test4': '73', 'test5': '84'},\n",
    " {'name': 'student35', 'test1': '75', 'test2': '89', 'test3': '80', 'test4': '93', 'test5': '74'},\n",
    " {'name': 'student20', 'test1': '68', 'test2': '68', 'test3': '81', 'test4': '74', 'test5': '76'},\n",
    " {'name': 'student50', 'test1': '94', 'test2': '68', 'test3': '81', 'test4': '69', 'test5': '89'},\n",
    " {'name': 'student66', 'test1': '91', 'test2': '92', 'test3': '81', 'test4': '79', 'test5': '69'},\n",
    " {'name': 'student1', 'test1': '73', 'test2': '91', 'test3': '82', 'test4': '90', 'test5': '93'},\n",
    " {'name': 'student100', 'test1': '79', 'test2': '79', 'test3': '82', 'test4': '71', 'test5': '87'},\n",
    " {'name': 'student5', 'test1': '86', 'test2': '93', 'test3': '83', 'test4': '94', 'test5': '94'},\n",
    " {'name': 'student16', 'test1': '81', 'test2': '95', 'test3': '83', 'test4': '87', 'test5': '95'},\n",
    " {'name': 'student19', 'test1': '70', 'test2': '70', 'test3': '83', 'test4': '99', 'test5': '97'},\n",
    " {'name': 'student61', 'test1': '65', 'test2': '76', 'test3': '83', 'test4': '75', 'test5': '68'},\n",
    " {'name': 'student91', 'test1': '79', 'test2': '100', 'test3': '83', 'test4': '66', 'test5': '69'},\n",
    " {'name': 'student96', 'test1': '99', 'test2': '93', 'test3': '83', 'test4': '75', 'test5': '85'},\n",
    " {'name': 'student21', 'test1': '74', 'test2': '73', 'test3': '84', 'test4': '84', 'test5': '69'},\n",
    " {'name': 'student46', 'test1': '92', 'test2': '83', 'test3': '84', 'test4': '69', 'test5': '90'},\n",
    " {'name': 'student22', 'test1': '65', 'test2': '87', 'test3': '85', 'test4': '78', 'test5': '98'},\n",
    " {'name': 'student23', 'test1': '88', 'test2': '95', 'test3': '85', 'test4': '67', 'test5': '93'},\n",
    " {'name': 'student72', 'test1': '85', 'test2': '66', 'test3': '85', 'test4': '78', 'test5': '75'},\n",
    " {'name': 'student82', 'test1': '77', 'test2': '100', 'test3': '85', 'test4': '65', 'test5': '80'},\n",
    " {'name': 'student88', 'test1': '77', 'test2': '87', 'test3': '85', 'test4': '90', 'test5': '78'},\n",
    " {'name': 'student18', 'test1': '65', 'test2': '78', 'test3': '86', 'test4': '69', 'test5': '98'},\n",
    " {'name': 'student24', 'test1': '80', 'test2': '91', 'test3': '86', 'test4': '99', 'test5': '96'},\n",
    " {'name': 'student28', 'test1': '90', 'test2': '100', 'test3': '86', 'test4': '89', 'test5': '75'},\n",
    " {'name': 'student53', 'test1': '83', 'test2': '100', 'test3': '86', 'test4': '83', 'test5': '90'},\n",
    " {'name': 'student74', 'test1': '97', 'test2': '99', 'test3': '86', 'test4': '93', 'test5': '99'},\n",
    " {'name': 'student75', 'test1': '79', 'test2': '79', 'test3': '86', 'test4': '78', 'test5': '68'},\n",
    " {'name': 'student78', 'test1': '88', 'test2': '98', 'test3': '86', 'test4': '100', 'test5': '71'},\n",
    " {'name': 'student90', 'test1': '95', 'test2': '66', 'test3': '86', 'test4': '85', 'test5': '65'},\n",
    " {'name': 'student10', 'test1': '98', 'test2': '68', 'test3': '87', 'test4': '85', 'test5': '96'},\n",
    " {'name': 'student27', 'test1': '94', 'test2': '99', 'test3': '87', 'test4': '91', 'test5': '86'},\n",
    " {'name': 'student42', 'test1': '72', 'test2': '86', 'test3': '87', 'test4': '98', 'test5': '73'},\n",
    " {'name': 'student49', 'test1': '81', 'test2': '98', 'test3': '87', 'test4': '81', 'test5': '79'},\n",
    " {'name': 'student84', 'test1': '70', 'test2': '66', 'test3': '87', 'test4': '100', 'test5': '97'},\n",
    " {'name': 'student33', 'test1': '95', 'test2': '67', 'test3': '88', 'test4': '81', 'test5': '97'},\n",
    " {'name': 'student38', 'test1': '68', 'test2': '98', 'test3': '88', 'test4': '84', 'test5': '72'},\n",
    " {'name': 'student45', 'test1': '91', 'test2': '81', 'test3': '88', 'test4': '95', 'test5': '69'},\n",
    " {'name': 'student64', 'test1': '89', 'test2': '78', 'test3': '88', 'test4': '86', 'test5': '95'},\n",
    " {'name': 'student86', 'test1': '81', 'test2': '71', 'test3': '88', 'test4': '98', 'test5': '81'},\n",
    " {'name': 'student76', 'test1': '80', 'test2': '72', 'test3': '89', 'test4': '88', 'test5': '89'},\n",
    " {'name': 'student77', 'test1': '84', 'test2': '99', 'test3': '89', 'test4': '69', 'test5': '66'},\n",
    " {'name': 'student92', 'test1': '88', 'test2': '91', 'test3': '89', 'test4': '97', 'test5': '99'},\n",
    " {'name': 'student3', 'test1': '94', 'test2': '67', 'test3': '90', 'test4': '95', 'test5': '84'},\n",
    " {'name': 'student40', 'test1': '94', 'test2': '97', 'test3': '90', 'test4': '95', 'test5': '84'},\n",
    " {'name': 'student11', 'test1': '92', 'test2': '81', 'test3': '91', 'test4': '96', 'test5': '78'},\n",
    " {'name': 'student57', 'test1': '87', 'test2': '84', 'test3': '91', 'test4': '83', 'test5': '80'},\n",
    " {'name': 'student87', 'test1': '88', 'test2': '100', 'test3': '91', 'test4': '75', 'test5': '66'},\n",
    " {'name': 'student44', 'test1': '67', 'test2': '100', 'test3': '92', 'test4': '87', 'test5': '80'},\n",
    " {'name': 'student68', 'test1': '78', 'test2': '99', 'test3': '92', 'test4': '74', 'test5': '89'},\n",
    " {'name': 'student89', 'test1': '82', 'test2': '78', 'test3': '92', 'test4': '90', 'test5': '99'},\n",
    " {'name': 'student97', 'test1': '87', 'test2': '82', 'test3': '92', 'test4': '88', 'test5': '92'},\n",
    " {'name': 'student8', 'test1': '88', 'test2': '71', 'test3': '93', 'test4': '71', 'test5': '86'},\n",
    " {'name': 'student59', 'test1': '78', 'test2': '76', 'test3': '94', 'test4': '65', 'test5': '80'},\n",
    " {'name': 'student60', 'test1': '67', 'test2': '76', 'test3': '94', 'test4': '67', 'test5': '74'},\n",
    " {'name': 'student15', 'test1': '84', 'test2': '71', 'test3': '95', 'test4': '77', 'test5': '77'},\n",
    " {'name': 'student29', 'test1': '89', 'test2': '93', 'test3': '95', 'test4': '78', 'test5': '82'},\n",
    " {'name': 'student67', 'test1': '74', 'test2': '80', 'test3': '95', 'test4': '85', 'test5': '94'},\n",
    " {'name': 'student94', 'test1': '80', 'test2': '71', 'test3': '95', 'test4': '76', 'test5': '68'},\n",
    " {'name': 'student32', 'test1': '91', 'test2': '76', 'test3': '96', 'test4': '73', 'test5': '91'},\n",
    " {'name': 'student51', 'test1': '94', 'test2': '93', 'test3': '96', 'test4': '96', 'test5': '76'},\n",
    " {'name': 'student73', 'test1': '92', 'test2': '89', 'test3': '96', 'test4': '83', 'test5': '79'},\n",
    " {'name': 'student99', 'test1': '69', 'test2': '74', 'test3': '96', 'test4': '97', 'test5': '71'},\n",
    " {'name': 'student39', 'test1': '75', 'test2': '90', 'test3': '97', 'test4': '86', 'test5': '72'},\n",
    " {'name': 'student56', 'test1': '98', 'test2': '80', 'test3': '97', 'test4': '68', 'test5': '91'},\n",
    " {'name': 'student4', 'test1': '68', 'test2': '85', 'test3': '98', 'test4': '69', 'test5': '77'},\n",
    " {'name': 'student30', 'test1': '66', 'test2': '92', 'test3': '98', 'test4': '92', 'test5': '100'},\n",
    " {'name': 'student41', 'test1': '71', 'test2': '77', 'test3': '98', 'test4': '95', 'test5': '70'},\n",
    " {'name': 'student54', 'test1': '92', 'test2': '72', 'test3': '98', 'test4': '70', 'test5': '98'},\n",
    " {'name': 'student71', 'test1': '95', 'test2': '98', 'test3': '98', 'test4': '98', 'test5': '75'},\n",
    " {'name': 'student95', 'test1': '78', 'test2': '71', 'test3': '98', 'test4': '78', 'test5': '96'},\n",
    " {'name': 'student6', 'test1': '72', 'test2': '97', 'test3': '99', 'test4': '69', 'test5': '83'},\n",
    " {'name': 'student9', 'test1': '79', 'test2': '69', 'test3': '99', 'test4': '73', 'test5': '76'},\n",
    " {'name': 'student7', 'test1': '66', 'test2': '99', 'test3': '100', 'test4': '96', 'test5': '81'},\n",
    " {'name': 'student36', 'test1': '76', 'test2': '69', 'test3': '100', 'test4': '97', 'test5': '83'},\n",
    " {'name': 'student48', 'test1': '98', 'test2': '69', 'test3': '100', 'test4': '84', 'test5': '80'}, \n",
    " {'name': 'student65', 'test1': '80', 'test2': '75', 'test3': '100', 'test4': '83', 'test5': '77'}]\n",
    "\n",
    "l_func, output = ex5('grades_dict.json')\n",
    "\n",
    "assert output == results\n",
    "\n",
    "\n",
    "\n",
    "import types\n",
    "assert type(l_func) is types.LambdaType\n",
    "\n",
    "lines = [    {\n",
    "        \"name\": \"student19\",\n",
    "        \"test1\": \"70\",\n",
    "        \"test2\": \"70\",\n",
    "        \"test3\": \"83\",\n",
    "        \"test4\": \"99\",\n",
    "        \"test5\": \"97\"\n",
    "    },\n",
    "    {\n",
    "        \"name\": \"student20\",\n",
    "        \"test1\": \"68\",\n",
    "        \"test2\": \"68\",\n",
    "        \"test3\": \"81\",\n",
    "        \"test4\": \"74\",\n",
    "        \"test5\": \"76\"\n",
    "    },\n",
    "    {\n",
    "        \"name\": \"student21\",\n",
    "        \"test1\": \"74\",\n",
    "        \"test2\": \"73\",\n",
    "        \"test3\": \"84\",\n",
    "        \"test4\": \"84\",\n",
    "        \"test5\": \"69\"\n",
    "    },\n",
    "    {\n",
    "        \"name\": \"student22\",\n",
    "        \"test1\": \"65\",\n",
    "        \"test2\": \"87\",\n",
    "        \"test3\": \"85\",\n",
    "        \"test4\": \"78\",\n",
    "        \"test5\": \"98\"\n",
    "    },\n",
    "    {\n",
    "        \"name\": \"student23\",\n",
    "        \"test1\": \"88\",\n",
    "        \"test2\": \"95\",\n",
    "        \"test3\": \"85\",\n",
    "        \"test4\": \"67\",\n",
    "        \"test5\": \"93\"\n",
    "    },\n",
    "    {\n",
    "        \"name\": \"student24\",\n",
    "        \"test1\": \"80\",\n",
    "        \"test2\": \"91\",\n",
    "        \"test3\": \"86\",\n",
    "        \"test4\": \"99\",\n",
    "        \"test5\": \"96\"\n",
    "    },\n",
    "    {\n",
    "        \"name\": \"student25\",\n",
    "        \"test1\": \"77\",\n",
    "        \"test2\": \"86\",\n",
    "        \"test3\": \"79\",\n",
    "        \"test4\": \"70\",\n",
    "        \"test5\": \"92\"\n",
    "    },\n",
    "    {\n",
    "        \"name\": \"student26\",\n",
    "        \"test1\": \"80\",\n",
    "        \"test2\": \"78\",\n",
    "        \"test3\": \"75\",\n",
    "        \"test4\": \"69\",\n",
    "        \"test5\": \"87\"\n",
    "    },]\n",
    "\n",
    "\n",
    "result2 = [{'name': 'student26', 'test1': '80', 'test2': '78', 'test3': '75', 'test4': '69', 'test5': '87'},\n",
    " {'name': 'student25', 'test1': '77', 'test2': '86', 'test3': '79', 'test4': '70', 'test5': '92'},\n",
    " {'name': 'student20', 'test1': '68', 'test2': '68', 'test3': '81', 'test4': '74', 'test5': '76'},\n",
    " {'name': 'student19', 'test1': '70', 'test2': '70', 'test3': '83', 'test4': '99', 'test5': '97'},\n",
    " {'name': 'student21', 'test1': '74', 'test2': '73', 'test3': '84', 'test4': '84', 'test5': '69'},\n",
    " {'name': 'student22', 'test1': '65', 'test2': '87', 'test3': '85', 'test4': '78', 'test5': '98'},\n",
    " {'name': 'student23', 'test1': '88', 'test2': '95', 'test3': '85', 'test4': '67', 'test5': '93'},\n",
    " {'name': 'student24', 'test1': '80', 'test2': '91', 'test3': '86', 'test4': '99', 'test5': '96'}]\n",
    " \n",
    "assert sorted(lines, key=l_func) == result2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "deletable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "6a8c2b716f4aba8d45a06ace034ca2f0",
     "grade": false,
     "grade_id": "cell-dee8832087e8f013",
     "locked": false,
     "schema_version": 3,
     "solution": true,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "# Ex6: Reverse Lookup\n",
    "\n",
    "def reverse_lookup(input_dict, test_value):\n",
    "    # Complete this function to find all the keys in a dictionary that map to the input value. \n",
    "    # input1: input_dict (dict)\n",
    "    # input2: test_value\n",
    "    # output: list of keys\n",
    "\n",
    "    # YOUR CODE HERE\n",
    "    #def get_key(val): \n",
    "    \n",
    "    listOfKeys = [key  for (key, value) in input_dict.items() if value == test_value]\n",
    "\n",
    "    return listOfKeys\n",
    "  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "deletable": false,
    "editable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "7a42cdb8c6f7b9a3e115f13ba5e9834e",
     "grade": true,
     "grade_id": "cell-7766334fd67504c1",
     "locked": true,
     "points": 4,
     "schema_version": 3,
     "solution": false,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "input_dict = {\n",
    "    'January': 31,\n",
    "    'February': 28,\n",
    "    'March': 31,\n",
    "    'April': 30,\n",
    "    'May': 31,\n",
    "    'June': 30,\n",
    "    'July': 31,\n",
    "    'August': 31,\n",
    "    'September': 30,\n",
    "    'October': 31,\n",
    "    'November': 30,\n",
    "    'December': 31,\n",
    "}\n",
    "\n",
    "\n",
    "\n",
    "assert reverse_lookup(input_dict, 31) == ['January', 'March', 'May', 'July', 'August', 'October', 'December']\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "deletable": false,
    "editable": false,
    "nbgrader": {
     "cell_type": "code",
     "checksum": "f4a36eccd546437d4944967eb424d63e",
     "grade": true,
     "grade_id": "cell-3377bab1557a5cb6",
     "locked": true,
     "points": 4,
     "schema_version": 3,
     "solution": false,
     "task": false
    }
   },
   "outputs": [],
   "source": [
    "## Hidden tests\n"
   ]
  },
  {
   "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.6.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}