challenge_14_python_pandas.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/abiflynn/python_pandas/blob/main/challenge_14_python_pandas.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#Challenge 14: Data Cleaning"
      ],
      "metadata": {
        "id": "yy8V4z8GWPSC"
      },
      "id": "yy8V4z8GWPSC"
    },
    {
      "cell_type": "code",
      "execution_count": 29,
      "id": "3eea1a31-68f6-4ec5-a176-72730422cf50",
      "metadata": {
        "id": "3eea1a31-68f6-4ec5-a176-72730422cf50"
      },
      "outputs": [],
      "source": [
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 30,
      "id": "4ceb6f9b-84a0-457b-b251-58d8d8bdbf2c",
      "metadata": {
        "id": "4ceb6f9b-84a0-457b-b251-58d8d8bdbf2c"
      },
      "outputs": [],
      "source": [
        "# death_metal.csv\n",
        "url = 'https://drive.google.com/file/d/11HsCgxJL_PtJ8xxdT5VZbw6e0y0-VKag/view?usp=sharing' \n",
        "path = 'https://drive.google.com/uc?export=download&id='+url.split('/')[-2]\n",
        "bands = pd.read_csv(path)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 31,
      "id": "99620969-6364-47f2-a030-6c1b346caf60",
      "metadata": {
        "id": "99620969-6364-47f2-a030-6c1b346caf60",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "outputId": "181e06b4-6f7c-4e0e-919f-a76f08c5197b"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                     name        country status  formed_in  \\\n",
              "0  **Act of Destruction?>  united states     ac     2005.0   \n",
              "1        **Nirvana 2002?>         sweden     su     1988.0   \n",
              "2              **Olemus?>        austria     ac     1993.0   \n",
              "3         **Misanthrope?>         mexico     oh     2010.0   \n",
              "4           **Detonator?>         russia     su     1991.0   \n",
              "\n",
              "                          genre  \\\n",
              "0    Melodic Death/Thrash Metal   \n",
              "1                   Death Metal   \n",
              "2      Death/Black/Gothic Metal   \n",
              "3                   Death Metal   \n",
              "4  Technical Death/Thrash Metal   \n",
              "\n",
              "                                               theme        active  \n",
              "0              Death| Love| Life| Evil| Darker Tones  2005-present  \n",
              "1            Metaphysical Philosophy| Parapsychology     1988-1992  \n",
              "2                               Sadness| Life| Death  1993-present  \n",
              "3                 Death| Destruction| War| Decadence  2010-present  \n",
              "4  Loneliness philosophy| state of mind of the pe...     1991-2002  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c59f97f1-bc8f-474b-afe0-8b8de9619004\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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></th>\n",
              "      <th>name</th>\n",
              "      <th>country</th>\n",
              "      <th>status</th>\n",
              "      <th>formed_in</th>\n",
              "      <th>genre</th>\n",
              "      <th>theme</th>\n",
              "      <th>active</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>**Act of Destruction?&gt;</td>\n",
              "      <td>united states</td>\n",
              "      <td>ac</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>Melodic Death/Thrash Metal</td>\n",
              "      <td>Death| Love| Life| Evil| Darker Tones</td>\n",
              "      <td>2005-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>**Nirvana 2002?&gt;</td>\n",
              "      <td>sweden</td>\n",
              "      <td>su</td>\n",
              "      <td>1988.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Metaphysical Philosophy| Parapsychology</td>\n",
              "      <td>1988-1992</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>**Olemus?&gt;</td>\n",
              "      <td>austria</td>\n",
              "      <td>ac</td>\n",
              "      <td>1993.0</td>\n",
              "      <td>Death/Black/Gothic Metal</td>\n",
              "      <td>Sadness| Life| Death</td>\n",
              "      <td>1993-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>**Misanthrope?&gt;</td>\n",
              "      <td>mexico</td>\n",
              "      <td>oh</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Death| Destruction| War| Decadence</td>\n",
              "      <td>2010-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>**Detonator?&gt;</td>\n",
              "      <td>russia</td>\n",
              "      <td>su</td>\n",
              "      <td>1991.0</td>\n",
              "      <td>Technical Death/Thrash Metal</td>\n",
              "      <td>Loneliness philosophy| state of mind of the pe...</td>\n",
              "      <td>1991-2002</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c59f97f1-bc8f-474b-afe0-8b8de9619004')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-c59f97f1-bc8f-474b-afe0-8b8de9619004 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-c59f97f1-bc8f-474b-afe0-8b8de9619004');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ],
      "source": [
        "bands.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 32,
      "id": "bfe46ee5-2556-4078-bdcf-fe7bbdf3e5d8",
      "metadata": {
        "id": "bfe46ee5-2556-4078-bdcf-fe7bbdf3e5d8",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "05959dbe-7313-448b-a86a-61288044c5e9"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 26 entries, 0 to 25\n",
            "Data columns (total 7 columns):\n",
            " #   Column     Non-Null Count  Dtype  \n",
            "---  ------     --------------  -----  \n",
            " 0   name       26 non-null     object \n",
            " 1   country    26 non-null     object \n",
            " 2   status     26 non-null     object \n",
            " 3   formed_in  26 non-null     float64\n",
            " 4   genre      26 non-null     object \n",
            " 5   theme      26 non-null     object \n",
            " 6   active     26 non-null     object \n",
            "dtypes: float64(1), object(6)\n",
            "memory usage: 1.5+ KB\n"
          ]
        }
      ],
      "source": [
        "bands.info()"
      ]
    },
    {
      "cell_type": "markdown",
      "id": "0b26d1ae-cbae-4752-b002-6f24f08eebe4",
      "metadata": {
        "tags": [],
        "id": "0b26d1ae-cbae-4752-b002-6f24f08eebe4"
      },
      "source": [
        "### **Exercise 1:** \n",
        "Cleaning the 'name' column"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 33,
      "id": "5593d130-26ba-42da-9c1d-40ebf1e4a2a1",
      "metadata": {
        "id": "5593d130-26ba-42da-9c1d-40ebf1e4a2a1",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "e43649cb-3be0-456c-8ba7-799058d13906"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0    **Act of Destruction?>\n",
              "1          **Nirvana 2002?>\n",
              "2                **Olemus?>\n",
              "3           **Misanthrope?>\n",
              "4             **Detonator?>\n",
              "Name: name, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ],
      "source": [
        "bands['name'].head(5)"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bands[\"name\"] = bands[\"name\"].str.replace(\"\\W\", '', regex=True)\n",
        "bands"
      ],
      "metadata": {
        "id": "UQ_5bMDQTgEw",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 864
        },
        "outputId": "2ae6bc0d-d320-4c82-b45f-c8b2fa2aef1d"
      },
      "id": "UQ_5bMDQTgEw",
      "execution_count": 34,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                name         country status  formed_in  \\\n",
              "0   ActofDestruction   united states     ac     2005.0   \n",
              "1        Nirvana2002          sweden     su     1988.0   \n",
              "2             Olemus         austria     ac     1993.0   \n",
              "3        Misanthrope          mexico     oh     2010.0   \n",
              "4          Detonator          russia     su     1991.0   \n",
              "5         BloodAgent         germany     ac     2013.0   \n",
              "6         Traumagain           italy     ac     2001.0   \n",
              "7         Anaktorian         finland     su     2001.0   \n",
              "8             Revolt           italy     cn     2001.0   \n",
              "9         Coldworker          sweden     su     2006.0   \n",
              "10      TotalCarnage     switzerland     su     2010.0   \n",
              "11      TheAwakening         germany     su     1998.0   \n",
              "12       FeuGregeois          france     cn     2005.0   \n",
              "13           Nemesis        colombia     su     1986.0   \n",
              "14           Grind64  czech republic     ac     1997.0   \n",
              "15       Gloomlurker  united kingdom     su     2012.0   \n",
              "16              Dark         germany     su     1991.0   \n",
              "17            Midian    korea| south     ac     2009.0   \n",
              "18         Desecrate        malaysia     ac     2014.0   \n",
              "19            Mortum          sweden     su     1997.0   \n",
              "20      AColdReality   united states     su     1999.0   \n",
              "21      CasttheStone   united states     un     2002.0   \n",
              "22       Persecution       australia     su     1989.0   \n",
              "23       Stigmatizer         germany     su     2004.0   \n",
              "24          Ravenage  united kingdom     ac     2007.0   \n",
              "25          Riverden   united states     oh     2004.0   \n",
              "\n",
              "                                                genre  \\\n",
              "0                          Melodic Death/Thrash Metal   \n",
              "1                                         Death Metal   \n",
              "2                            Death/Black/Gothic Metal   \n",
              "3                                         Death Metal   \n",
              "4                        Technical Death/Thrash Metal   \n",
              "5                                  Death/Thrash Metal   \n",
              "6                                  Brutal Death Metal   \n",
              "7                                 Melodic Death Metal   \n",
              "8                                  Death/Thrash Metal   \n",
              "9                                         Death Metal   \n",
              "10                                  Death Metal/Crust   \n",
              "11                                        Death Metal   \n",
              "12                                  Black/Death Metal   \n",
              "13                                 Death/Thrash Metal   \n",
              "14                       Brutal Death Metal/Grindcore   \n",
              "15                           Melodic Death/Doom Metal   \n",
              "16  Death/Thrash Metal (early)| Dark/Gothic Metal ...   \n",
              "17                                Melodic Death Metal   \n",
              "18                     Death/Thrash/Progressive Metal   \n",
              "19                          Melodic Death/Black Metal   \n",
              "20                                 Thrash/Death Metal   \n",
              "21                                        Death Metal   \n",
              "22                                        Death Metal   \n",
              "23                                        Death Metal   \n",
              "24                           Folk/Melodic Death Metal   \n",
              "25                                 Thrash/Death Metal   \n",
              "\n",
              "                                                theme        active  \n",
              "0               Death| Love| Life| Evil| Darker Tones  2005-present  \n",
              "1             Metaphysical Philosophy| Parapsychology     1988-1992  \n",
              "2                                Sadness| Life| Death  1993-present  \n",
              "3                  Death| Destruction| War| Decadence  2010-present  \n",
              "4   Loneliness philosophy| state of mind of the pe...     1991-2002  \n",
              "5                              War| Death| Apocalypse  2013-present  \n",
              "6                                     Nihilism| Death  2001-present  \n",
              "7                               Death| emotions| pain     2001-2007  \n",
              "8                                       Society| Hate     2001-2006  \n",
              "9                                               Death     2006-2013  \n",
              "10              Post-Apocalypse| Nuclear Warfare| WW3     2010-2011  \n",
              "11   Human existence| Apocalyptic visions| Nightmares     1998-2008  \n",
              "12                                    Medieval themes        2005-?  \n",
              "13                                     Destiny| Death        1986-?  \n",
              "14                                  Working accidents  1997-present  \n",
              "15                     Death| Curses| Strength| Power     2012-2013  \n",
              "16                 Darkness| Depression| Nature| Love        1991-?  \n",
              "17                        Despair| Salvation| Duality  2009-present  \n",
              "18                                 Anti Nuclear Power  2014-present  \n",
              "19                               Love| Death| Fantasy     1997-1998  \n",
              "20                 Corruption| Society| Relationships     1999-2008  \n",
              "21                                  Death| Corruption        2002-?  \n",
              "22                                  Political| Social        1989-?  \n",
              "23                               Life| Death| Society     2004-2007  \n",
              "24                                 Battles| Mythology  2007-present  \n",
              "25                 Life| Experiences| Nature| History     2004-2012  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7c51e4ae-82b4-44ee-afb0-0b2e67e5be70\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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></th>\n",
              "      <th>name</th>\n",
              "      <th>country</th>\n",
              "      <th>status</th>\n",
              "      <th>formed_in</th>\n",
              "      <th>genre</th>\n",
              "      <th>theme</th>\n",
              "      <th>active</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>ActofDestruction</td>\n",
              "      <td>united states</td>\n",
              "      <td>ac</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>Melodic Death/Thrash Metal</td>\n",
              "      <td>Death| Love| Life| Evil| Darker Tones</td>\n",
              "      <td>2005-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Nirvana2002</td>\n",
              "      <td>sweden</td>\n",
              "      <td>su</td>\n",
              "      <td>1988.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Metaphysical Philosophy| Parapsychology</td>\n",
              "      <td>1988-1992</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Olemus</td>\n",
              "      <td>austria</td>\n",
              "      <td>ac</td>\n",
              "      <td>1993.0</td>\n",
              "      <td>Death/Black/Gothic Metal</td>\n",
              "      <td>Sadness| Life| Death</td>\n",
              "      <td>1993-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Misanthrope</td>\n",
              "      <td>mexico</td>\n",
              "      <td>oh</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Death| Destruction| War| Decadence</td>\n",
              "      <td>2010-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Detonator</td>\n",
              "      <td>russia</td>\n",
              "      <td>su</td>\n",
              "      <td>1991.0</td>\n",
              "      <td>Technical Death/Thrash Metal</td>\n",
              "      <td>Loneliness philosophy| state of mind of the pe...</td>\n",
              "      <td>1991-2002</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>BloodAgent</td>\n",
              "      <td>germany</td>\n",
              "      <td>ac</td>\n",
              "      <td>2013.0</td>\n",
              "      <td>Death/Thrash Metal</td>\n",
              "      <td>War| Death| Apocalypse</td>\n",
              "      <td>2013-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Traumagain</td>\n",
              "      <td>italy</td>\n",
              "      <td>ac</td>\n",
              "      <td>2001.0</td>\n",
              "      <td>Brutal Death Metal</td>\n",
              "      <td>Nihilism| Death</td>\n",
              "      <td>2001-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Anaktorian</td>\n",
              "      <td>finland</td>\n",
              "      <td>su</td>\n",
              "      <td>2001.0</td>\n",
              "      <td>Melodic Death Metal</td>\n",
              "      <td>Death| emotions| pain</td>\n",
              "      <td>2001-2007</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Revolt</td>\n",
              "      <td>italy</td>\n",
              "      <td>cn</td>\n",
              "      <td>2001.0</td>\n",
              "      <td>Death/Thrash Metal</td>\n",
              "      <td>Society| Hate</td>\n",
              "      <td>2001-2006</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Coldworker</td>\n",
              "      <td>sweden</td>\n",
              "      <td>su</td>\n",
              "      <td>2006.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Death</td>\n",
              "      <td>2006-2013</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>TotalCarnage</td>\n",
              "      <td>switzerland</td>\n",
              "      <td>su</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>Death Metal/Crust</td>\n",
              "      <td>Post-Apocalypse| Nuclear Warfare| WW3</td>\n",
              "      <td>2010-2011</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>TheAwakening</td>\n",
              "      <td>germany</td>\n",
              "      <td>su</td>\n",
              "      <td>1998.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Human existence| Apocalyptic visions| Nightmares</td>\n",
              "      <td>1998-2008</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>FeuGregeois</td>\n",
              "      <td>france</td>\n",
              "      <td>cn</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>Black/Death Metal</td>\n",
              "      <td>Medieval themes</td>\n",
              "      <td>2005-?</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Nemesis</td>\n",
              "      <td>colombia</td>\n",
              "      <td>su</td>\n",
              "      <td>1986.0</td>\n",
              "      <td>Death/Thrash Metal</td>\n",
              "      <td>Destiny| Death</td>\n",
              "      <td>1986-?</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Grind64</td>\n",
              "      <td>czech republic</td>\n",
              "      <td>ac</td>\n",
              "      <td>1997.0</td>\n",
              "      <td>Brutal Death Metal/Grindcore</td>\n",
              "      <td>Working accidents</td>\n",
              "      <td>1997-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Gloomlurker</td>\n",
              "      <td>united kingdom</td>\n",
              "      <td>su</td>\n",
              "      <td>2012.0</td>\n",
              "      <td>Melodic Death/Doom Metal</td>\n",
              "      <td>Death| Curses| Strength| Power</td>\n",
              "      <td>2012-2013</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Dark</td>\n",
              "      <td>germany</td>\n",
              "      <td>su</td>\n",
              "      <td>1991.0</td>\n",
              "      <td>Death/Thrash Metal (early)| Dark/Gothic Metal ...</td>\n",
              "      <td>Darkness| Depression| Nature| Love</td>\n",
              "      <td>1991-?</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Midian</td>\n",
              "      <td>korea| south</td>\n",
              "      <td>ac</td>\n",
              "      <td>2009.0</td>\n",
              "      <td>Melodic Death Metal</td>\n",
              "      <td>Despair| Salvation| Duality</td>\n",
              "      <td>2009-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Desecrate</td>\n",
              "      <td>malaysia</td>\n",
              "      <td>ac</td>\n",
              "      <td>2014.0</td>\n",
              "      <td>Death/Thrash/Progressive Metal</td>\n",
              "      <td>Anti Nuclear Power</td>\n",
              "      <td>2014-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Mortum</td>\n",
              "      <td>sweden</td>\n",
              "      <td>su</td>\n",
              "      <td>1997.0</td>\n",
              "      <td>Melodic Death/Black Metal</td>\n",
              "      <td>Love| Death| Fantasy</td>\n",
              "      <td>1997-1998</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>AColdReality</td>\n",
              "      <td>united states</td>\n",
              "      <td>su</td>\n",
              "      <td>1999.0</td>\n",
              "      <td>Thrash/Death Metal</td>\n",
              "      <td>Corruption| Society| Relationships</td>\n",
              "      <td>1999-2008</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>CasttheStone</td>\n",
              "      <td>united states</td>\n",
              "      <td>un</td>\n",
              "      <td>2002.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Death| Corruption</td>\n",
              "      <td>2002-?</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Persecution</td>\n",
              "      <td>australia</td>\n",
              "      <td>su</td>\n",
              "      <td>1989.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Political| Social</td>\n",
              "      <td>1989-?</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Stigmatizer</td>\n",
              "      <td>germany</td>\n",
              "      <td>su</td>\n",
              "      <td>2004.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Life| Death| Society</td>\n",
              "      <td>2004-2007</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Ravenage</td>\n",
              "      <td>united kingdom</td>\n",
              "      <td>ac</td>\n",
              "      <td>2007.0</td>\n",
              "      <td>Folk/Melodic Death Metal</td>\n",
              "      <td>Battles| Mythology</td>\n",
              "      <td>2007-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Riverden</td>\n",
              "      <td>united states</td>\n",
              "      <td>oh</td>\n",
              "      <td>2004.0</td>\n",
              "      <td>Thrash/Death Metal</td>\n",
              "      <td>Life| Experiences| Nature| History</td>\n",
              "      <td>2004-2012</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7c51e4ae-82b4-44ee-afb0-0b2e67e5be70')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-7c51e4ae-82b4-44ee-afb0-0b2e67e5be70 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-7c51e4ae-82b4-44ee-afb0-0b2e67e5be70');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 34
        }
      ]
    },
    {
      "cell_type": "markdown",
      "id": "efd6119a-809f-4d56-8967-c1201aa20462",
      "metadata": {
        "tags": [],
        "id": "efd6119a-809f-4d56-8967-c1201aa20462"
      },
      "source": [
        "### **Exercise 2:** \n",
        "Cleaning the country column\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 35,
      "id": "a9a355c5-f3ef-434e-901b-c0d578d56ab4",
      "metadata": {
        "id": "a9a355c5-f3ef-434e-901b-c0d578d56ab4",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "4013af11-7358-4093-afeb-58fc71ca14dc"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0    united states\n",
              "1           sweden\n",
              "2          austria\n",
              "3           mexico\n",
              "4           russia\n",
              "Name: country, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 35
        }
      ],
      "source": [
        "bands['country'].head(5)"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bands.loc[:,\"country\"] = bands.country.str.upper()\n",
        "bands.head(5)\n"
      ],
      "metadata": {
        "id": "wV2HC0gqTkD_",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "outputId": "97c56efe-bfc6-46fc-9390-c930ad58d8f6"
      },
      "id": "wV2HC0gqTkD_",
      "execution_count": 36,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "               name        country status  formed_in  \\\n",
              "0  ActofDestruction  UNITED STATES     ac     2005.0   \n",
              "1       Nirvana2002         SWEDEN     su     1988.0   \n",
              "2            Olemus        AUSTRIA     ac     1993.0   \n",
              "3       Misanthrope         MEXICO     oh     2010.0   \n",
              "4         Detonator         RUSSIA     su     1991.0   \n",
              "\n",
              "                          genre  \\\n",
              "0    Melodic Death/Thrash Metal   \n",
              "1                   Death Metal   \n",
              "2      Death/Black/Gothic Metal   \n",
              "3                   Death Metal   \n",
              "4  Technical Death/Thrash Metal   \n",
              "\n",
              "                                               theme        active  \n",
              "0              Death| Love| Life| Evil| Darker Tones  2005-present  \n",
              "1            Metaphysical Philosophy| Parapsychology     1988-1992  \n",
              "2                               Sadness| Life| Death  1993-present  \n",
              "3                 Death| Destruction| War| Decadence  2010-present  \n",
              "4  Loneliness philosophy| state of mind of the pe...     1991-2002  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-cd4bb4b4-a116-407c-9a13-e98dcef36125\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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></th>\n",
              "      <th>name</th>\n",
              "      <th>country</th>\n",
              "      <th>status</th>\n",
              "      <th>formed_in</th>\n",
              "      <th>genre</th>\n",
              "      <th>theme</th>\n",
              "      <th>active</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>ActofDestruction</td>\n",
              "      <td>UNITED STATES</td>\n",
              "      <td>ac</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>Melodic Death/Thrash Metal</td>\n",
              "      <td>Death| Love| Life| Evil| Darker Tones</td>\n",
              "      <td>2005-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Nirvana2002</td>\n",
              "      <td>SWEDEN</td>\n",
              "      <td>su</td>\n",
              "      <td>1988.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Metaphysical Philosophy| Parapsychology</td>\n",
              "      <td>1988-1992</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Olemus</td>\n",
              "      <td>AUSTRIA</td>\n",
              "      <td>ac</td>\n",
              "      <td>1993.0</td>\n",
              "      <td>Death/Black/Gothic Metal</td>\n",
              "      <td>Sadness| Life| Death</td>\n",
              "      <td>1993-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Misanthrope</td>\n",
              "      <td>MEXICO</td>\n",
              "      <td>oh</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Death| Destruction| War| Decadence</td>\n",
              "      <td>2010-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Detonator</td>\n",
              "      <td>RUSSIA</td>\n",
              "      <td>su</td>\n",
              "      <td>1991.0</td>\n",
              "      <td>Technical Death/Thrash Metal</td>\n",
              "      <td>Loneliness philosophy| state of mind of the pe...</td>\n",
              "      <td>1991-2002</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cd4bb4b4-a116-407c-9a13-e98dcef36125')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-cd4bb4b4-a116-407c-9a13-e98dcef36125 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-cd4bb4b4-a116-407c-9a13-e98dcef36125');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 36
        }
      ]
    },
    {
      "cell_type": "markdown",
      "id": "14781008-16ee-4d92-8806-c79b7f0828ed",
      "metadata": {
        "tags": [],
        "id": "14781008-16ee-4d92-8806-c79b7f0828ed"
      },
      "source": [
        "### **Exercise 3:**\n",
        "Cleaning the status column\n",
        "\n",
        "The status column has some abbreviations instead of the real status.  \n",
        "Change them in accordance with this:  \n",
        "* ac = Active  \n",
        "* su = Split-up  \n",
        "* cn = Changed name  \n",
        "* oh = On hold  \n",
        "* un = Unknown\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 37,
      "id": "0f1fd5bf-7a73-485d-a663-d7c738a90cb4",
      "metadata": {
        "id": "0f1fd5bf-7a73-485d-a663-d7c738a90cb4",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "1879638a-1008-4d53-fe61-5232cfbc725d"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0    ac\n",
              "1    su\n",
              "2    ac\n",
              "3    oh\n",
              "4    su\n",
              "Name: status, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 37
        }
      ],
      "source": [
        "bands['status'].head(5)"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bands[\"status\"] = bands[\"status\"].replace({'ac': \"Active\", 'su': \"Split-Up\", 'cn': \"Changed Name\", 'oh':  \"On Hold\", 'un': \"Unknown\"})\n",
        "bands.head()"
      ],
      "metadata": {
        "id": "-o7CzbRJT5r0",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "outputId": "361d8882-469a-45e0-80a9-112ccc1a8003"
      },
      "id": "-o7CzbRJT5r0",
      "execution_count": 38,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "               name        country    status  formed_in  \\\n",
              "0  ActofDestruction  UNITED STATES    Active     2005.0   \n",
              "1       Nirvana2002         SWEDEN  Split-Up     1988.0   \n",
              "2            Olemus        AUSTRIA    Active     1993.0   \n",
              "3       Misanthrope         MEXICO   On Hold     2010.0   \n",
              "4         Detonator         RUSSIA  Split-Up     1991.0   \n",
              "\n",
              "                          genre  \\\n",
              "0    Melodic Death/Thrash Metal   \n",
              "1                   Death Metal   \n",
              "2      Death/Black/Gothic Metal   \n",
              "3                   Death Metal   \n",
              "4  Technical Death/Thrash Metal   \n",
              "\n",
              "                                               theme        active  \n",
              "0              Death| Love| Life| Evil| Darker Tones  2005-present  \n",
              "1            Metaphysical Philosophy| Parapsychology     1988-1992  \n",
              "2                               Sadness| Life| Death  1993-present  \n",
              "3                 Death| Destruction| War| Decadence  2010-present  \n",
              "4  Loneliness philosophy| state of mind of the pe...     1991-2002  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ca690c26-ce1b-4eba-97fd-e695c7d6ae7a\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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></th>\n",
              "      <th>name</th>\n",
              "      <th>country</th>\n",
              "      <th>status</th>\n",
              "      <th>formed_in</th>\n",
              "      <th>genre</th>\n",
              "      <th>theme</th>\n",
              "      <th>active</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>ActofDestruction</td>\n",
              "      <td>UNITED STATES</td>\n",
              "      <td>Active</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>Melodic Death/Thrash Metal</td>\n",
              "      <td>Death| Love| Life| Evil| Darker Tones</td>\n",
              "      <td>2005-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Nirvana2002</td>\n",
              "      <td>SWEDEN</td>\n",
              "      <td>Split-Up</td>\n",
              "      <td>1988.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Metaphysical Philosophy| Parapsychology</td>\n",
              "      <td>1988-1992</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Olemus</td>\n",
              "      <td>AUSTRIA</td>\n",
              "      <td>Active</td>\n",
              "      <td>1993.0</td>\n",
              "      <td>Death/Black/Gothic Metal</td>\n",
              "      <td>Sadness| Life| Death</td>\n",
              "      <td>1993-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Misanthrope</td>\n",
              "      <td>MEXICO</td>\n",
              "      <td>On Hold</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>Death Metal</td>\n",
              "      <td>Death| Destruction| War| Decadence</td>\n",
              "      <td>2010-present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Detonator</td>\n",
              "      <td>RUSSIA</td>\n",
              "      <td>Split-Up</td>\n",
              "      <td>1991.0</td>\n",
              "      <td>Technical Death/Thrash Metal</td>\n",
              "      <td>Loneliness philosophy| state of mind of the pe...</td>\n",
              "      <td>1991-2002</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ca690c26-ce1b-4eba-97fd-e695c7d6ae7a')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-ca690c26-ce1b-4eba-97fd-e695c7d6ae7a button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-ca690c26-ce1b-4eba-97fd-e695c7d6ae7a');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 38
        }
      ]
    },
    {
      "cell_type": "markdown",
      "id": "c1989a51-eb98-4c78-9018-50a0f214991a",
      "metadata": {
        "tags": [],
        "id": "c1989a51-eb98-4c78-9018-50a0f214991a"
      },
      "source": [
        "### **Exercise 4:**\n",
        "Cleaning the genre column\n",
        "\n",
        "The column genre has genres in a single string separated by character /  \n",
        "1. First, transform the string to list of strings  \n",
        "(e.g. 'Avant-garde Black/Death Metal'    to     \\[Avant-garde Black, Death Metal\\]  \n",
        "1. Then, create a new column 'number_of_genres' where you will store the number of genres in each list.  \n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 39,
      "id": "462ff471-0557-41c0-aa68-1d88149c790c",
      "metadata": {
        "id": "462ff471-0557-41c0-aa68-1d88149c790c",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "a24e3595-e752-4025-c187-cbb4e364f05e"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0      Melodic Death/Thrash Metal\n",
              "1                     Death Metal\n",
              "2        Death/Black/Gothic Metal\n",
              "3                     Death Metal\n",
              "4    Technical Death/Thrash Metal\n",
              "Name: genre, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 39
        }
      ],
      "source": [
        "bands['genre'].head(5)"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bands['genre'] = bands['genre'].str.split('/')\n",
        "bands[\"genre\"] = list(bands[\"genre\"])\n",
        "bands[\"number_of_genres\"] = bands[\"genre\"].str.len()\n",
        "bands.head()\n"
      ],
      "metadata": {
        "id": "5xXYLo2pT9g3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "outputId": "6817a53e-6d3c-4ce1-b45b-56b572f15a40"
      },
      "id": "5xXYLo2pT9g3",
      "execution_count": 40,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "               name        country    status  formed_in  \\\n",
              "0  ActofDestruction  UNITED STATES    Active     2005.0   \n",
              "1       Nirvana2002         SWEDEN  Split-Up     1988.0   \n",
              "2            Olemus        AUSTRIA    Active     1993.0   \n",
              "3       Misanthrope         MEXICO   On Hold     2010.0   \n",
              "4         Detonator         RUSSIA  Split-Up     1991.0   \n",
              "\n",
              "                             genre  \\\n",
              "0    [Melodic Death, Thrash Metal]   \n",
              "1                    [Death Metal]   \n",
              "2     [Death, Black, Gothic Metal]   \n",
              "3                    [Death Metal]   \n",
              "4  [Technical Death, Thrash Metal]   \n",
              "\n",
              "                                               theme        active  \\\n",
              "0              Death| Love| Life| Evil| Darker Tones  2005-present   \n",
              "1            Metaphysical Philosophy| Parapsychology     1988-1992   \n",
              "2                               Sadness| Life| Death  1993-present   \n",
              "3                 Death| Destruction| War| Decadence  2010-present   \n",
              "4  Loneliness philosophy| state of mind of the pe...     1991-2002   \n",
              "\n",
              "   number_of_genres  \n",
              "0                 2  \n",
              "1                 1  \n",
              "2                 3  \n",
              "3                 1  \n",
              "4                 2  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ffac43da-b58a-4b47-ab71-aa6cd49777a7\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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></th>\n",
              "      <th>name</th>\n",
              "      <th>country</th>\n",
              "      <th>status</th>\n",
              "      <th>formed_in</th>\n",
              "      <th>genre</th>\n",
              "      <th>theme</th>\n",
              "      <th>active</th>\n",
              "      <th>number_of_genres</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>ActofDestruction</td>\n",
              "      <td>UNITED STATES</td>\n",
              "      <td>Active</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>[Melodic Death, Thrash Metal]</td>\n",
              "      <td>Death| Love| Life| Evil| Darker Tones</td>\n",
              "      <td>2005-present</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Nirvana2002</td>\n",
              "      <td>SWEDEN</td>\n",
              "      <td>Split-Up</td>\n",
              "      <td>1988.0</td>\n",
              "      <td>[Death Metal]</td>\n",
              "      <td>Metaphysical Philosophy| Parapsychology</td>\n",
              "      <td>1988-1992</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Olemus</td>\n",
              "      <td>AUSTRIA</td>\n",
              "      <td>Active</td>\n",
              "      <td>1993.0</td>\n",
              "      <td>[Death, Black, Gothic Metal]</td>\n",
              "      <td>Sadness| Life| Death</td>\n",
              "      <td>1993-present</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Misanthrope</td>\n",
              "      <td>MEXICO</td>\n",
              "      <td>On Hold</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>[Death Metal]</td>\n",
              "      <td>Death| Destruction| War| Decadence</td>\n",
              "      <td>2010-present</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Detonator</td>\n",
              "      <td>RUSSIA</td>\n",
              "      <td>Split-Up</td>\n",
              "      <td>1991.0</td>\n",
              "      <td>[Technical Death, Thrash Metal]</td>\n",
              "      <td>Loneliness philosophy| state of mind of the pe...</td>\n",
              "      <td>1991-2002</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ffac43da-b58a-4b47-ab71-aa6cd49777a7')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-ffac43da-b58a-4b47-ab71-aa6cd49777a7 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-ffac43da-b58a-4b47-ab71-aa6cd49777a7');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 40
        }
      ]
    },
    {
      "cell_type": "markdown",
      "id": "f1614fa1-21c8-4de9-9b4a-6786496935c7",
      "metadata": {
        "tags": [],
        "id": "f1614fa1-21c8-4de9-9b4a-6786496935c7"
      },
      "source": [
        "### **Exercise 5:** \n",
        "Cleaning the active column\n",
        "\n",
        "The column `active` contains information about the years when a band was active or '?' if the status or year is unknown.  \n",
        "\n",
        "Create two new columns \n",
        "- `active_from`: when the band formed\n",
        "- `active_to`: when the band broke up\n",
        "\n",
        "and fill them with the information contained in the column `active`.  \n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 41,
      "id": "8b5127a8-0512-4fcd-a52a-5cb7a814e327",
      "metadata": {
        "id": "8b5127a8-0512-4fcd-a52a-5cb7a814e327",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "68af99a1-ad07-4469-816e-385a5e4d0eb4"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0    2005-present\n",
              "1       1988-1992\n",
              "2    1993-present\n",
              "3    2010-present\n",
              "4       1991-2002\n",
              "Name: active, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 41
        }
      ],
      "source": [
        "bands['active'].head(5)"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bands[[\"active_from\", \"active_to\"]] = bands[\"active\"].str.split(\"-\", n=2, expand=True)\n",
        "bands.head()\n",
        "\n"
      ],
      "metadata": {
        "id": "GlD74kyFVRJF",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "outputId": "a9f67ce7-17bd-43f7-9155-d05be8ebfe94"
      },
      "id": "GlD74kyFVRJF",
      "execution_count": 42,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "               name        country    status  formed_in  \\\n",
              "0  ActofDestruction  UNITED STATES    Active     2005.0   \n",
              "1       Nirvana2002         SWEDEN  Split-Up     1988.0   \n",
              "2            Olemus        AUSTRIA    Active     1993.0   \n",
              "3       Misanthrope         MEXICO   On Hold     2010.0   \n",
              "4         Detonator         RUSSIA  Split-Up     1991.0   \n",
              "\n",
              "                             genre  \\\n",
              "0    [Melodic Death, Thrash Metal]   \n",
              "1                    [Death Metal]   \n",
              "2     [Death, Black, Gothic Metal]   \n",
              "3                    [Death Metal]   \n",
              "4  [Technical Death, Thrash Metal]   \n",
              "\n",
              "                                               theme        active  \\\n",
              "0              Death| Love| Life| Evil| Darker Tones  2005-present   \n",
              "1            Metaphysical Philosophy| Parapsychology     1988-1992   \n",
              "2                               Sadness| Life| Death  1993-present   \n",
              "3                 Death| Destruction| War| Decadence  2010-present   \n",
              "4  Loneliness philosophy| state of mind of the pe...     1991-2002   \n",
              "\n",
              "   number_of_genres active_from active_to  \n",
              "0                 2        2005   present  \n",
              "1                 1        1988      1992  \n",
              "2                 3        1993   present  \n",
              "3                 1        2010   present  \n",
              "4                 2        1991      2002  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5a7fc84b-aee2-4f2e-9320-c20b2fc39e05\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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></th>\n",
              "      <th>name</th>\n",
              "      <th>country</th>\n",
              "      <th>status</th>\n",
              "      <th>formed_in</th>\n",
              "      <th>genre</th>\n",
              "      <th>theme</th>\n",
              "      <th>active</th>\n",
              "      <th>number_of_genres</th>\n",
              "      <th>active_from</th>\n",
              "      <th>active_to</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>ActofDestruction</td>\n",
              "      <td>UNITED STATES</td>\n",
              "      <td>Active</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>[Melodic Death, Thrash Metal]</td>\n",
              "      <td>Death| Love| Life| Evil| Darker Tones</td>\n",
              "      <td>2005-present</td>\n",
              "      <td>2</td>\n",
              "      <td>2005</td>\n",
              "      <td>present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Nirvana2002</td>\n",
              "      <td>SWEDEN</td>\n",
              "      <td>Split-Up</td>\n",
              "      <td>1988.0</td>\n",
              "      <td>[Death Metal]</td>\n",
              "      <td>Metaphysical Philosophy| Parapsychology</td>\n",
              "      <td>1988-1992</td>\n",
              "      <td>1</td>\n",
              "      <td>1988</td>\n",
              "      <td>1992</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Olemus</td>\n",
              "      <td>AUSTRIA</td>\n",
              "      <td>Active</td>\n",
              "      <td>1993.0</td>\n",
              "      <td>[Death, Black, Gothic Metal]</td>\n",
              "      <td>Sadness| Life| Death</td>\n",
              "      <td>1993-present</td>\n",
              "      <td>3</td>\n",
              "      <td>1993</td>\n",
              "      <td>present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Misanthrope</td>\n",
              "      <td>MEXICO</td>\n",
              "      <td>On Hold</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>[Death Metal]</td>\n",
              "      <td>Death| Destruction| War| Decadence</td>\n",
              "      <td>2010-present</td>\n",
              "      <td>1</td>\n",
              "      <td>2010</td>\n",
              "      <td>present</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Detonator</td>\n",
              "      <td>RUSSIA</td>\n",
              "      <td>Split-Up</td>\n",
              "      <td>1991.0</td>\n",
              "      <td>[Technical Death, Thrash Metal]</td>\n",
              "      <td>Loneliness philosophy| state of mind of the pe...</td>\n",
              "      <td>1991-2002</td>\n",
              "      <td>2</td>\n",
              "      <td>1991</td>\n",
              "      <td>2002</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5a7fc84b-aee2-4f2e-9320-c20b2fc39e05')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-5a7fc84b-aee2-4f2e-9320-c20b2fc39e05 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-5a7fc84b-aee2-4f2e-9320-c20b2fc39e05');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 42
        }
      ]
    },
    {
      "cell_type": "markdown",
      "id": "0dda4368-b84b-4e0a-9cf7-7b6b0e8d22c1",
      "metadata": {
        "tags": [],
        "id": "0dda4368-b84b-4e0a-9cf7-7b6b0e8d22c1"
      },
      "source": [
        "### **Exercise 6** \n",
        "Counting the themes\n",
        "\n",
        "Count how many times do the words Love, Life, Death repeat in a themes column.  "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 43,
      "id": "04397ff2-74a5-4593-9593-04538acdbada",
      "metadata": {
        "id": "04397ff2-74a5-4593-9593-04538acdbada",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "5f095910-d4c0-4e96-8485-1b7aa3e60354"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0                Death| Love| Life| Evil| Darker Tones\n",
              "1              Metaphysical Philosophy| Parapsychology\n",
              "2                                 Sadness| Life| Death\n",
              "3                   Death| Destruction| War| Decadence\n",
              "4    Loneliness philosophy| state of mind of the pe...\n",
              "Name: theme, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 43
        }
      ],
      "source": [
        "bands['theme'].head(5)"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bands[\"theme_love\"] = bands[\"theme\"].str.count(\"Love\")\n",
        "bands[\"theme_life\"] = bands[\"theme\"].str.count(\"Life\")\n",
        "bands[\"theme_death\"] = bands[\"theme\"].str.count(\"Death\")\n",
        "bands[\"total_themes\"] = bands[\"theme_love\"] + bands[\"theme_life\"] + bands[\"theme_death\"]\n",
        "bands_final = bands.drop(columns=[\"theme_love\", \"theme_life\", \"theme_death\"])\n",
        "bands_final.head()"
      ],
      "metadata": {
        "id": "46VIC7bZVVaZ",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "outputId": "0d49316d-74de-458a-c1ea-b95f3f87481c"
      },
      "id": "46VIC7bZVVaZ",
      "execution_count": 46,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "               name        country    status  formed_in  \\\n",
              "0  ActofDestruction  UNITED STATES    Active     2005.0   \n",
              "1       Nirvana2002         SWEDEN  Split-Up     1988.0   \n",
              "2            Olemus        AUSTRIA    Active     1993.0   \n",
              "3       Misanthrope         MEXICO   On Hold     2010.0   \n",
              "4         Detonator         RUSSIA  Split-Up     1991.0   \n",
              "\n",
              "                             genre  \\\n",
              "0    [Melodic Death, Thrash Metal]   \n",
              "1                    [Death Metal]   \n",
              "2     [Death, Black, Gothic Metal]   \n",
              "3                    [Death Metal]   \n",
              "4  [Technical Death, Thrash Metal]   \n",
              "\n",
              "                                               theme        active  \\\n",
              "0              Death| Love| Life| Evil| Darker Tones  2005-present   \n",
              "1            Metaphysical Philosophy| Parapsychology     1988-1992   \n",
              "2                               Sadness| Life| Death  1993-present   \n",
              "3                 Death| Destruction| War| Decadence  2010-present   \n",
              "4  Loneliness philosophy| state of mind of the pe...     1991-2002   \n",
              "\n",
              "   number_of_genres active_from active_to  total_themes  \n",
              "0                 2        2005   present             3  \n",
              "1                 1        1988      1992             0  \n",
              "2                 3        1993   present             2  \n",
              "3                 1        2010   present             1  \n",
              "4                 2        1991      2002             0  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2e0c8eb6-1ff7-4e48-a216-eacd7dc29205\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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></th>\n",
              "      <th>name</th>\n",
              "      <th>country</th>\n",
              "      <th>status</th>\n",
              "      <th>formed_in</th>\n",
              "      <th>genre</th>\n",
              "      <th>theme</th>\n",
              "      <th>active</th>\n",
              "      <th>number_of_genres</th>\n",
              "      <th>active_from</th>\n",
              "      <th>active_to</th>\n",
              "      <th>total_themes</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>ActofDestruction</td>\n",
              "      <td>UNITED STATES</td>\n",
              "      <td>Active</td>\n",
              "      <td>2005.0</td>\n",
              "      <td>[Melodic Death, Thrash Metal]</td>\n",
              "      <td>Death| Love| Life| Evil| Darker Tones</td>\n",
              "      <td>2005-present</td>\n",
              "      <td>2</td>\n",
              "      <td>2005</td>\n",
              "      <td>present</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Nirvana2002</td>\n",
              "      <td>SWEDEN</td>\n",
              "      <td>Split-Up</td>\n",
              "      <td>1988.0</td>\n",
              "      <td>[Death Metal]</td>\n",
              "      <td>Metaphysical Philosophy| Parapsychology</td>\n",
              "      <td>1988-1992</td>\n",
              "      <td>1</td>\n",
              "      <td>1988</td>\n",
              "      <td>1992</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Olemus</td>\n",
              "      <td>AUSTRIA</td>\n",
              "      <td>Active</td>\n",
              "      <td>1993.0</td>\n",
              "      <td>[Death, Black, Gothic Metal]</td>\n",
              "      <td>Sadness| Life| Death</td>\n",
              "      <td>1993-present</td>\n",
              "      <td>3</td>\n",
              "      <td>1993</td>\n",
              "      <td>present</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Misanthrope</td>\n",
              "      <td>MEXICO</td>\n",
              "      <td>On Hold</td>\n",
              "      <td>2010.0</td>\n",
              "      <td>[Death Metal]</td>\n",
              "      <td>Death| Destruction| War| Decadence</td>\n",
              "      <td>2010-present</td>\n",
              "      <td>1</td>\n",
              "      <td>2010</td>\n",
              "      <td>present</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Detonator</td>\n",
              "      <td>RUSSIA</td>\n",
              "      <td>Split-Up</td>\n",
              "      <td>1991.0</td>\n",
              "      <td>[Technical Death, Thrash Metal]</td>\n",
              "      <td>Loneliness philosophy| state of mind of the pe...</td>\n",
              "      <td>1991-2002</td>\n",
              "      <td>2</td>\n",
              "      <td>1991</td>\n",
              "      <td>2002</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2e0c8eb6-1ff7-4e48-a216-eacd7dc29205')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-2e0c8eb6-1ff7-4e48-a216-eacd7dc29205 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-2e0c8eb6-1ff7-4e48-a216-eacd7dc29205');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 46
        }
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3 (ipykernel)",
      "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.9.7"
    },
    "colab": {
      "provenance": [],
      "include_colab_link": true
    }
  },
  "nbformat": 4,
  "nbformat_minor": 5
}