TJ-06 Visualization & Reporting in TaskJuggler.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Visualization and Reporting\n",
    "\n",
    "So far we have concentrated on the process of incrementally building your project plan through the\n",
    "specification of resources, tasks, accounts, and project constraints. All of this work, while necessary, \n",
    "is not sufficient to effectively communicate the project plan to your team, management, sponsors, or\n",
    "other stakeholders. Only through effective visualization of your project plan, and having the capacity \n",
    "to integrate the products of your planning process into other systems, such as calendaring, spreadsheet,\n",
    "or word processing applications, can you maximize the benefits of your plan. \n",
    "\n",
    "In this final section of the workshop we will use the [project plan](http://localhost:8888/notebooks/Repos/cc-taskjuggler/Sample-Files/foundation-05.tjp) from the previous section as a starting point, and add some additional reports to highlight some of the possibilities for generating a variety of outputs based on a generated project plan. \n",
    "\n",
    "[foundation-06.tjp file](Sample-Files/foundation-06.tjp)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "TaskJuggler v3.6.0 - A Project Management Software\n",
      "\n",
      "Copyright (c) 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016\n",
      "              by Chris Schlaeger <cs@taskjuggler.org>\n",
      "\n",
      "This program is free software; you can redistribute it and/or modify it under\n",
      "the terms of version 2 of the GNU General Public License as published by the\n",
      "Free Software Foundation.\n",
      "\n",
      "Reading file foundation-06.tjp                               ...\r",
      "Reading file foundation-06.tjp                               ...\r",
      "Reading file foundation-06.tjp                               [      Done      ]\n",
      "Preparing scenario Initial Plan                              ...\r",
      "Preparing scenario Initial Plan                              [==     16%      ]\r",
      "Preparing scenario Initial Plan                              [=====  32%      ]\r",
      "Preparing scenario Initial Plan                              [=======48%      ]\r",
      "Preparing scenario Initial Plan                              [=======64%      ]\r",
      "Preparing scenario Initial Plan                              [=======80%==    ]\r",
      "Preparing scenario Initial Plan                              [=======81%==    ]\r",
      "Preparing scenario Initial Plan                              [=======82%===   ]\r",
      "Preparing scenario Initial Plan                              [=======83%===   ]\r",
      "Preparing scenario Initial Plan                              [=======84%===   ]\r",
      "Preparing scenario Initial Plan                              [=======85%===   ]\r",
      "Preparing scenario Initial Plan                              [=======87%===   ]\r",
      "Preparing scenario Initial Plan                              [=======88%====  ]\r",
      "Preparing scenario Initial Plan                              [=======90%====  ]\r",
      "Preparing scenario Initial Plan                              [=======95%===== ]\r",
      "Preparing scenario Initial Plan                              [=======99%===== ]\r",
      "Preparing scenario Initial Plan                              [======100%======]\r",
      "Preparing scenario Initial Plan                              [      Done      ]\n",
      "Scheduling scenario Initial Plan                             ...\r",
      "Scheduling scenario Initial Plan                             [      Done      ]\n",
      "Checking scenario Initial Plan                               ...\r",
      "Checking scenario Initial Plan                               [=      6%       ]\r",
      "Checking scenario Initial Plan                               [==     13%      ]\r",
      "Checking scenario Initial Plan                               [===    20%      ]\r",
      "Checking scenario Initial Plan                               [====   26%      ]\r",
      "Checking scenario Initial Plan                               [=====  33%      ]\r",
      "Checking scenario Initial Plan                               [====== 40%      ]\r",
      "Checking scenario Initial Plan                               [=======46%      ]\r",
      "Checking scenario Initial Plan                               [=======53%      ]\r",
      "Checking scenario Initial Plan                               [=======60%      ]\r",
      "Checking scenario Initial Plan                               [=======66%      ]\r",
      "Checking scenario Initial Plan                               [=======73%=     ]\r",
      "Checking scenario Initial Plan                               [=======80%==    ]\r",
      "Checking scenario Initial Plan                               [=======86%===   ]\r",
      "Checking scenario Initial Plan                               [=======93%====  ]\r",
      "Checking scenario Initial Plan                               [======100%======]\r",
      "Checking scenario Initial Plan                               [      Done      ]\n",
      "Preparing scenario Actual Plan Execution                     ...\r",
      "Preparing scenario Actual Plan Execution                     [==     16%      ]\r",
      "Preparing scenario Actual Plan Execution                     [=====  32%      ]\r",
      "Preparing scenario Actual Plan Execution                     [=======48%      ]\r",
      "Preparing scenario Actual Plan Execution                     [=======64%      ]\r",
      "Preparing scenario Actual Plan Execution                     [=======80%==    ]\r",
      "Preparing scenario Actual Plan Execution                     [=======81%==    ]\r",
      "Preparing scenario Actual Plan Execution                     [=======82%===   ]\r",
      "Preparing scenario Actual Plan Execution                     [=======83%===   ]\r",
      "Preparing scenario Actual Plan Execution                     [=======84%===   ]\r",
      "Preparing scenario Actual Plan Execution                     [=======85%===   ]\r",
      "Preparing scenario Actual Plan Execution                     [=======87%===   ]\r",
      "Preparing scenario Actual Plan Execution                     [=======88%====  ]\r",
      "Preparing scenario Actual Plan Execution                     [=======90%====  ]\r",
      "Preparing scenario Actual Plan Execution                     [=======95%===== ]\r",
      "Preparing scenario Actual Plan Execution                     [=======99%===== ]\r",
      "Preparing scenario Actual Plan Execution                     [======100%======]\r",
      "Preparing scenario Actual Plan Execution                     [      Done      ]\n",
      "Scheduling scenario Actual Plan Execution                    ...\r",
      "Scheduling scenario Actual Plan Execution                    [      Done      ]\n",
      "Checking scenario Actual Plan Execution                      ...\r",
      "Checking scenario Actual Plan Execution                      [=      6%       ]\r",
      "Checking scenario Actual Plan Execution                      [==     13%      ]\r",
      "Checking scenario Actual Plan Execution                      [===    20%      ]\r",
      "Checking scenario Actual Plan Execution                      [====   26%      ]\r",
      "Checking scenario Actual Plan Execution                      [=====  33%      ]\r",
      "Checking scenario Actual Plan Execution                      [====== 40%      ]\r",
      "Checking scenario Actual Plan Execution                      [=======46%      ]\r",
      "Checking scenario Actual Plan Execution                      [=======53%      ]\r",
      "Checking scenario Actual Plan Execution                      [=======60%      ]\r",
      "Checking scenario Actual Plan Execution                      [=======66%      ]\r",
      "Checking scenario Actual Plan Execution                      [=======73%=     ]\r",
      "Checking scenario Actual Plan Execution                      [=======80%==    ]\r",
      "Checking scenario Actual Plan Execution                      [=======86%===   ]\r",
      "Checking scenario Actual Plan Execution                      [=======93%====  ]\r",
      "Checking scenario Actual Plan Execution                      [======100%======]\r",
      "Checking scenario Actual Plan Execution                      [      Done      ]\n",
      "Preparing scenario Plan B                                    ...\r",
      "Preparing scenario Plan B                                    [=      10%      ]\r",
      "Preparing scenario Plan B                                    [===    20%      ]\r",
      "Preparing scenario Plan B                                    [====   30%      ]\r",
      "Preparing scenario Plan B                                    [====== 40%      ]\r",
      "Preparing scenario Plan B                                    [=======50%      ]\r",
      "Preparing scenario Plan B                                    [=======60%      ]\r",
      "Preparing scenario Plan B                                    [=======70%=     ]\r",
      "Preparing scenario Plan B                                    [=======80%==    ]\r",
      "Preparing scenario Plan B                                    [=======81%==    ]\r",
      "Preparing scenario Plan B                                    [=======82%===   ]\r",
      "Preparing scenario Plan B                                    [=======83%===   ]\r",
      "Preparing scenario Plan B                                    [=======84%===   ]\r",
      "Preparing scenario Plan B                                    [=======85%===   ]\r",
      "Preparing scenario Plan B                                    [=======87%===   ]\r",
      "Preparing scenario Plan B                                    [=======88%====  ]\r",
      "Preparing scenario Plan B                                    [=======90%====  ]\r",
      "Preparing scenario Plan B                                    [=======95%===== ]\r",
      "Preparing scenario Plan B                                    [=======99%===== ]\r",
      "Preparing scenario Plan B                                    [======100%======]\r",
      "Preparing scenario Plan B                                    [      Done      ]\n",
      "Scheduling scenario Plan B                                   ...\r",
      "Scheduling scenario Plan B                                   [      Done      ]\n",
      "Checking scenario Plan B                                     ...\r",
      "Checking scenario Plan B                                     [=      6%       ]\r",
      "Checking scenario Plan B                                     [==     13%      ]\r",
      "Checking scenario Plan B                                     [===    20%      ]\r",
      "Checking scenario Plan B                                     [====   26%      ]\r",
      "Checking scenario Plan B                                     [=====  33%      ]\r",
      "Checking scenario Plan B                                     [====== 40%      ]\r",
      "Checking scenario Plan B                                     [=======46%      ]\r",
      "Checking scenario Plan B                                     [=======53%      ]\r",
      "Checking scenario Plan B                                     [=======60%      ]\r",
      "Checking scenario Plan B                                     [=======66%      ]\r",
      "Checking scenario Plan B                                     [=======73%=     ]\r",
      "Checking scenario Plan B                                     [=======80%==    ]\r",
      "Checking scenario Plan B                                     [=======86%===   ]\r",
      "Checking scenario Plan B                                     [=======93%====  ]\r",
      "Checking scenario Plan B                                     [======100%======]\r",
      "Checking scenario Plan B                                     [      Done      ]\n",
      "Report reports/foundation-06_taskreport_01                   ...\r",
      "Report reports/foundation-06_taskreport_01                   [|]\r",
      "Report reports/foundation-06_taskreport_01                   [/]\r",
      "Report reports/foundation-06_taskreport_01                   [-]\r",
      "Report reports/foundation-06_taskreport_01                   [\\]\r",
      "Report reports/foundation-06_taskreport_01                   [|]\r",
      "Report reports/foundation-06_taskreport_01                   [/]\r",
      "Report reports/foundation-06_taskreport_01                   [-]\r",
      "Report reports/foundation-06_taskreport_01                   [      Done      ]\n",
      "Report reports/foundation-06_taskreport_02                   ...\r",
      "Report reports/foundation-06_taskreport_02                   [\\]\r",
      "Report reports/foundation-06_taskreport_02                   [|]\r",
      "Report reports/foundation-06_taskreport_02                   [      Done      ]\n",
      "Report reports/foundation-06_taskreport_03                   ...\r",
      "Report reports/foundation-06_taskreport_03                   [/]\r",
      "Report reports/foundation-06_taskreport_03                   [-]\r",
      "Report reports/foundation-06_taskreport_03                   [      Done      ]\n",
      "Report reports/foundation-06_resourcereport_01               ...\r",
      "Report reports/foundation-06_resourcereport_01               [\\]\r",
      "Report reports/foundation-06_resourcereport_01               [|]\r",
      "Report reports/foundation-06_resourcereport_01               [/]\r",
      "Report reports/foundation-06_resourcereport_01               [-]\r",
      "Report reports/foundation-06_resourcereport_01               [\\]\r",
      "Report reports/foundation-06_resourcereport_01               [|]\r",
      "Report reports/foundation-06_resourcereport_01               [      Done      ]\n",
      "Report reports/foundation-06_resourcereport_02               ...\r",
      "Report reports/foundation-06_resourcereport_02               [/]\r",
      "Report reports/foundation-06_resourcereport_02               [      Done      ]\n",
      "Report reports/foundation-06_resourcereport_03               ...\r",
      "Report reports/foundation-06_resourcereport_03               [-]\r",
      "Report reports/foundation-06_resourcereport_03               [      Done      ]\n",
      "Report reports/foundation-06_resourcereport_04               ...\r",
      "Report reports/foundation-06_resourcereport_04               [\\]\r",
      "Report reports/foundation-06_resourcereport_04               [      Done      ]\n",
      "Report reports/foundation-06_ProfitAndLoss_01                ...\r",
      "Report reports/foundation-06_ProfitAndLoss_01                [|]\r",
      "Report reports/foundation-06_ProfitAndLoss_01                [      Done      ]\n",
      "Report reports/foundation-06_ProfitAndLoss_02                ...\r",
      "Report reports/foundation-06_ProfitAndLoss_02                [/]\r",
      "Report reports/foundation-06_ProfitAndLoss_02                [      Done      ]\n",
      "Report reports/foundation-06_ical_01                         ...\r",
      "Report reports/foundation-06_ical_01                         [      Done      ]\n"
     ]
    }
   ],
   "source": [
    "%%bash\n",
    "cd Sample-Files\n",
    "tj3 foundation-06.tjp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "## Task-based reporting\n",
    "\n",
    "Throughout the workshop we have been incrementally developing a task-based report in order to illustrate\n",
    "the results of our step-by-step development process of our project plan, with the final task report specification\n",
    "of:\n",
    "\n",
    "    taskreport \"reports/foundation-06_taskreport_01\" {\n",
    "        formats html, csv\n",
    "        columns bsi, name, scenario, start, end, effort, cost, revenue, chart\n",
    "        hideresource 0\n",
    "        scenarios planned, actual, planb\n",
    "        headline \"Project Breakdown\"\n",
    "    }\n",
    "\n",
    "This report uses the [`taskreport`](http://taskjuggler.org/tj3/manual/taskreport.html) command. The report name provided in the quotes\n",
    "provides the prefix (including any path relative to the master `.tjp` file that is being used) that will be used for the one or more formats of \n",
    "report that will be generated. \n",
    "\n",
    "The reports generated by this `taskreport` command are:\n",
    "\n",
    "[Sample-Files/reports/foundation-06_taskreport_01.html](Sample-Files/reports/foundation-06_taskreport_01.html)\n",
    "\n",
    "[Sample-Files/reports/foundation-06_taskreport_01.csv](Sample-Files/reports/foundation-06_taskreport_01.csv)\n",
    "\n",
    "* The [`formats`](http://taskjuggler.org/tj3/manual/formats.html) attribute (*required*)\n",
    "generate two reports: an HTML and CSV (**colon** separated values - though actually semi-colons) formatted file. The generated HTML file also\n",
    "references a number of other external style (CSS), image, and javascript files that are also automatically generated\n",
    "during the report generation process.  \n",
    "* The [`columns`](http://taskjuggler.org/tj3/manual/columns.html) attribute (*optional*) allows\n",
    "for the specification of a list of multiple [`columnid`](http://taskjuggler.org/tj3/manual/columnid.html) values that\n",
    "will determine the information provided in the report, and the order of its presentation. The default columns that will be used if not specified are: *bsi*, *name*, *start*, *end*, and *effort*. \n",
    "* The [`hideresource`](http://taskjuggler.org/tj3/manual/hideresource.html) attribute (*optional*) allows for the display or hiding of all or selected resources that are associated with the project tasks. The default taskreport behavior is to suppress the inclusion of resources in the report. `hideresource 0` will show all resources associated with a task while `hideresource 1` will hide all resources. Alternatively a logical expression can be built that will select the specific resources that will be hidden. \n",
    "* The [`scenarios`](http://taskjuggler.org/tj3/manual/scenarios.html) attribute (*optional*) allows for the specification of the scenarios that should be included in the report. If no `scenarios` attribute is provided, the default (top-level) scenario will be used for the report. \n",
    "* The [`headilne`](http://taskjuggler.org/tj3/manual/headline.html) attribute (*optional*) allows for the specification of a custom headline for the generated HTML report. TaskJuggler supports the use of a custom [rich text](http://taskjuggler.org/tj3/manual/Rich_Text_Attributes.html) syntax for delivering formatted content. \n",
    "\n",
    "A minimum (using all default values) taskreport for our project is specified as:\n",
    "\n",
    "    taskreport \"reports/foundation-06_taskreport_02\" {\n",
    "        formats html\n",
    "    }\n",
    "\n",
    "[Sample-Files/reports/foundation-06_taskreport_02.html](Sample-Files/reports/foundation-06_taskreport_02.html)\n",
    "\n",
    "You can customize the displayed [`columns`](http://taskjuggler.org/tj3/manual/columns.html) using additional optional atributes for one or more columns in the list. For example, the following task report changes the [`scale`](http://taskjuggler.org/tj3/manual/scale.column.html) of the `chart` column from the default *week* to *month* (calendar), and the [`title`](http://taskjuggler.org/tj3/manual/title.column.html) of the `effort` column from the default value \"Effort\" to \"Effort (days)\".\n",
    "\n",
    "    taskreport \"reports/foundation-06_taskreport_03\" {\n",
    "        formats html\n",
    "        columns bsi, name, start, end, effort {title \"Effort (days)\"}, chart {scale month}\n",
    "    }\n",
    "\n",
    "[Sample-Files/reports/foundation-06_taskreport_03.html](Sample-Files/reports/foundation-06_taskreport_03.html)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Resource-based Reports\n",
    "\n",
    "Resource-based reports provide an alternative perspective on your project - with a focus on the resources participating in the project, their load throughout the project, and (if desired) the specific tasks to which they are contributing. These reports are generated using the [`resourcereport`](http://taskjuggler.org/tj3/manual/resourcereport.html) command, for which there a similar set of options are there are for `taskreport` reports. For example:\n",
    "\n",
    "    resourcereport \"reports/foundation-06_resourcereport_01\" {\n",
    "        formats html, csv\n",
    "        columns bsi, name, scenario, start, end, effort, chart\n",
    "        hidetask 0\n",
    "        scenarios planned, actual, planb\n",
    "        headline \"Project Breakdown - Resources\"\n",
    "    }\n",
    "\n",
    "generates the following reports:\n",
    "\n",
    "[Sample-Files/reports/foundation-06_resourcereport_01.html](Sample-Files/reports/foundation-06_resourcereport_01.html)\n",
    "\n",
    "[Sample-Files/reports/foundation-06_resourcereport_01.csv](Sample-Files/reports/foundation-06_resourcereport_01.csv)\n",
    "\n",
    "The only significant differences between the definition of this resource report and the previous task report are\n",
    "* the elimination of the `cost` and `revenue` columns as we would need to set up a modified account structure (which can be done) to have these values properly show up in this report. \n",
    "* the replacement of the `hideresource` attribute with the `hidetask` attribute in order to enable the display of tasks associated with each resource. In reality, both of these attributes can be used in a single `taskreport` or `resourcereport` definition, one to filter the resources that are included in the report, the second to filter the tasks that are displayed. \n",
    "* the `headline` was slightly modified to more accurately reflect the content of the report. \n",
    "\n",
    "As with task reports, resource reports have a set of default values that will be used if optional attributes are not specified, yielding a simple list of resources. For example, this minimum valid resource report definition can be used:\n",
    "\n",
    "    resourcereport \"reports/foundation-06_resourcereport_02\" {\n",
    "        formats html\n",
    "    }\n",
    "\n",
    "to produce the following HTML report:\n",
    "\n",
    "[Sample-Files/reports/foundation-06_resourcereport_02.html](Sample-Files/reports/foundation-06_resourcereport_02.html)\n",
    "\n",
    "A middle level of detail between these two reports can provide a nice summary of the load through time for all the members of the team through the following resource report specifications:\n",
    "\n",
    "For the initial plan only:\n",
    "\n",
    "    resourcereport \"reports/foundation-06_resourcereport_03\" {\n",
    "        formats html, csv\n",
    "        columns bsi, name, scenario, effort {title \"Effort (days)\"}, chart {scale month}\n",
    "    }\n",
    "\n",
    "[Sample-Files/reports/foundation-06_resourcereport_03.html](Sample-Files/reports/foundation-06_resourcereport_03.html)\n",
    "\n",
    "For all of the scenarios:\n",
    "\n",
    "    resourcereport \"reports/foundation-06_resourcereport_04\" {\n",
    "        formats html, csv\n",
    "        columns bsi, name, scenario, effort {title \"Effort (days)\"}, chart {scale month}\n",
    "        scenarios planned, actual, planb\n",
    "    }\n",
    "\n",
    "[Sample-Files/reports/foundation-06_resourcereport_04.html](Sample-Files/reports/foundation-06_resourcereport_04.html)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Some Other Report Options\n",
    "\n",
    "Due to time constraints a couple of other report types will be highlighted here, but not explained in detail. Full documentation for these reports may be found in the TaskJuggler documentation pages linked below. \n",
    "\n",
    "### Accounting-based reports\n",
    "\n",
    "TaskJuggler has an experimental capability to provide reports specifically focused on the account and accounting information embedded in the definition of the project. These are generated using the [`accountreport`](http://taskjuggler.org/tj3/manual/accountreport.html) command and its associated attributes. A couple of examples of the definition of an `accountreport` are provided here:\n",
    "\n",
    "A basic profit and loss report based on the `balance` command included in the accounts section of the master project for the initial project plan:\n",
    "\n",
    "    accountreport \"reports/foundation_06_ProfitAndLoss_01\" {\n",
    "      formats html, csv\n",
    "      columns no, name, scenario, monthly\n",
    "    }\n",
    "\n",
    "[Sample-Files/reports/foundation-06_ProfitAndLoss_01.html](Sample-Files/reports/foundation-06_ProfitAndLoss_01.html)\n",
    "\n",
    "A variation on the base report that includes information for all three defined scenarios:\n",
    "\n",
    "    accountreport \"reports/foundation_06_ProfitAndLoss_02\" {\n",
    "      formats html, csv\n",
    "      columns no, name, scenario, monthly\n",
    "      scenarios planned, actual, planb\n",
    "    }\n",
    "\n",
    "[Sample-Files/reports/foundation-06_ProfitAndLoss_02.html](Sample-Files/reports/foundation-06_ProfitAndLoss_02.html)\n",
    "\n",
    "### iCal file reports\n",
    "\n",
    "TaskJuggler has the capability to export task information in the form of an [iCal](https://en.wikipedia.org/wiki/ICalendar) file that may then be iported into a wide variety of dekstop and online calendaring applications. Furthermore, if the calendar file is published at a location that may be accessed through a valid web address, some calendar applications can be configured to *subscribe* to the calendar file, allowing for the delivery of updated project calendar information as the project plan evolves. A sample [`icalreport`](http://taskjuggler.org/tj3/manual/icalreport.html) example is provided here: \n",
    "\n",
    "    icalreport \"reports/foundation-06_ical_01\" {\n",
    "        hideresource ~(isleaf() & isleaf_())\n",
    "    }\n",
    "\n",
    "[Sample-Files/reports/foundation-06_ical_01.ics](Sample-Files/reports/foundation-06_ical_01.ics)\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Practice ...\n",
    "\n",
    "Finalize your plan with additional reports based on the examples provided above. When done you can generate \n",
    "new HTML and CSV reports that illustrate/contain the results of the project scheduling processs\n",
    "in TaskJuggler.  \n",
    "\n",
    "### Activity:\n",
    "\n",
    "1. Add one or more reports to your project plan.\n",
    "\n",
    "2. Run the TaskJuggler scheduler to test your skeleton to make sure that it does not generate any errors. If it does, see if you can fix them and re-run the scheduler. \n",
    "\n",
    "<video controls src=\"images/Timer10Minutestory.mov\" />"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "-------------------\n",
    "[(0)](TJ-00%20What%20is%20TaskJuggler.ipynb) -- \n",
    "[(1)](TJ-01%20Project%20Skeleton.ipynb) -- \n",
    "[(2)](TJ-02%20A%20Fleshed%20Out%20TaskJuggler%20Outline.ipynb) -- \n",
    "[(3)](TJ-03%20Progressive%20Elaboration%20of%20Tasks%20in%20TaskJuggler.ipynb) -- \n",
    "[(4)](TJ-04%20Assigning%20Resources%20%26%20Cost%20Estimation%20in%20TaskJuggler.ipynb) --\n",
    "[(5)](TJ-05%20Project%20Tracking%20in%20TaskJuggler.ipynb) -- \n",
    "(6)"
   ]
  },
  {
   "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}