Introduction-to-Pandas--solution.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "exercise": "task",
    "tags": [
     "task"
    ]
   },
   "source": [
    "# Data Analysis and Plotting in Python with Pandas\n",
    "\n",
    "_Andreas Herten, J\u00fclich Supercomputing Centre, Forschungszentrum J\u00fclich, 2 June 2021_"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "exercise": "onlysolution",
    "slideshow": {
     "slide_type": "skip"
    }
   },
   "source": [
    "**Version: Solutions**"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "exercise": "task",
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "source": [
    "## Task Outline\n",
    "\n",
    "* [Task 1](#task1)\n",
    "* [Task 2](#task2)\n",
    "* [Task 3](#task3)\n",
    "* [Task 4](#task4)\n",
    "* [Task 5](#task5)\n",
    "* [Task 6](#task6)\n",
    "* [Task 7](#task7)\n",
    "* [Task 7B](#task7b)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "exercise": "task",
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "exercise": "task",
    "slideshow": {
     "slide_type": "slide"
    }
   },
   "source": [
    "## Task 1\n",
    "<a name=\"task1\"></a>\n",
    "<span class=\"task\" style=\"padding: 2px 8px; color: white; background-color: #b9d25f; float: right; text-weight: bolder;\">TASK</em></span>\n",
    "\n",
    "* Create data frame with\n",
    "    - 6 names of dinosaurs, \n",
    "    - their favourite prime number, \n",
    "    - and their favorite color.\n",
    "* Play around with the frame\n",
    "* Tell me when you're done with status icon in BigBlueButton: \ud83d\udc4d"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "exercise": "nopresentation",
    "slideshow": {
     "slide_type": "skip"
    }
   },
   "source": [
    "Jupyter Notebook 101:\n",
    "\n",
    "* Execute cell: `shift+enter`\n",
    "* New cell in front of current cell: `a`\n",
    "* New cell after current cell: `b`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "exercise": "task",
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [],
   "source": [
    "happy_dinos = {\n",
    "    \"Dinosaur Name\": [],\n",
    "    \"Favourite Prime\": [],\n",
    "    \"Favourite Color\": []\n",
    "}\n",
    "#df_dinos = "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "exercise": "solution",
    "slideshow": {
     "slide_type": "fragment"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>Dinosaur Name</th>\n",
       "      <th>Aegyptosaurus</th>\n",
       "      <th>Tyrannosaurus</th>\n",
       "      <th>Panoplosaurus</th>\n",
       "      <th>Isisaurus</th>\n",
       "      <th>Triceratops</th>\n",
       "      <th>Velociraptor</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Favourite Prime</th>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>15</td>\n",
       "      <td>16</td>\n",
       "      <td>23</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Favourite Color</th>\n",
       "      <td>blue</td>\n",
       "      <td>white</td>\n",
       "      <td>blue</td>\n",
       "      <td>purple</td>\n",
       "      <td>violet</td>\n",
       "      <td>gray</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Dinosaur Name   Aegyptosaurus Tyrannosaurus Panoplosaurus Isisaurus  \\\n",
       "Favourite Prime             4             8            15        16   \n",
       "Favourite Color          blue         white          blue    purple   \n",
       "\n",
       "Dinosaur Name   Triceratops Velociraptor  \n",
       "Favourite Prime          23           42  \n",
       "Favourite Color      violet         gray  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "happy_dinos = {\n",
    "    \"Dinosaur Name\": [\"Aegyptosaurus\", \"Tyrannosaurus\", \"Panoplosaurus\", \"Isisaurus\", \"Triceratops\", \"Velociraptor\"],\n",
    "    \"Favourite Prime\": [\"4\", \"8\", \"15\", \"16\", \"23\", \"42\"],\n",