code/analyze/transaction data visualization/Transaction_Data_Analysis_CryptoPunks_Gender_Skin_tone.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    },
    "gpuClass": "standard"
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 5,
      "metadata": {
        "id": "HQI_37swx6Tu"
      },
      "outputs": [],
      "source": [
        "import plotly.express as px\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv('cryptopunks_gender_skintone_info_new.csv')"
      ],
      "metadata": {
        "id": "nf4CKz3-9vUd"
      },
      "execution_count": 6,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df = df.drop(columns=['Unnamed: 0'])"
      ],
      "metadata": {
        "id": "_tmBLl1h-S5r"
      },
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 548
        },
        "id": "GOSZuAqJ90DR",
        "outputId": "7f29fc05-5bca-4dfc-e5a9-f773307e33da"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      date  from    to  eth_price  punk_id   type  gender skin_tone  \\\n",
              "0   4/6/19   336  4411      31.00        1  Human    Male      Dark   \n",
              "1  7/13/17   166  4540       0.90       14  Human  Female      Dark   \n",
              "2  7/17/17  4540  5394       1.85       14  Human  Female      Dark   \n",
              "3  12/7/18  5394   204       2.50       14  Human  Female      Dark   \n",
              "4   2/1/21   166  5853      20.00       53  Human  Female     Light   \n",
              "\n",
              "   attr_count                                attributes skin_tone_color  \\\n",
              "0           2                       ['Smile', 'Mohawk']         #A4031F   \n",
              "1           3  ['Pipe', 'Pilot Helmet', 'Hot Lipstick']         #A4031F   \n",
              "2           3  ['Pipe', 'Pilot Helmet', 'Hot Lipstick']         #A4031F   \n",
              "3           3  ['Pipe', 'Pilot Helmet', 'Hot Lipstick']         #A4031F   \n",
              "4           2           ['Big Shades', 'Straight Hair']         #F2A359   \n",
              "\n",
              "                                             img_url  \n",
              "0  https://www.larvalabs.com/cryptopunks/cryptopu...  \n",
              "1  https://www.larvalabs.com/cryptopunks/cryptopu...  \n",
              "2  https://www.larvalabs.com/cryptopunks/cryptopu...  \n",
              "3  https://www.larvalabs.com/cryptopunks/cryptopu...  \n",
              "4  https://www.larvalabs.com/cryptopunks/cryptopu...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-d2662aaf-2135-4842-b190-77b5bd1f800a\">\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>date</th>\n",
              "      <th>from</th>\n",
              "      <th>to</th>\n",
              "      <th>eth_price</th>\n",
              "      <th>punk_id</th>\n",
              "      <th>type</th>\n",
              "      <th>gender</th>\n",
              "      <th>skin_tone</th>\n",
              "      <th>attr_count</th>\n",
              "      <th>attributes</th>\n",
              "      <th>skin_tone_color</th>\n",
              "      <th>img_url</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>4/6/19</td>\n",
              "      <td>336</td>\n",
              "      <td>4411</td>\n",
              "      <td>31.00</td>\n",
              "      <td>1</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Dark</td>\n",
              "      <td>2</td>\n",
              "      <td>['Smile', 'Mohawk']</td>\n",
              "      <td>#A4031F</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>7/13/17</td>\n",
              "      <td>166</td>\n",
              "      <td>4540</td>\n",
              "      <td>0.90</td>\n",
              "      <td>14</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Dark</td>\n",
              "      <td>3</td>\n",
              "      <td>['Pipe', 'Pilot Helmet', 'Hot Lipstick']</td>\n",
              "      <td>#A4031F</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>7/17/17</td>\n",
              "      <td>4540</td>\n",
              "      <td>5394</td>\n",
              "      <td>1.85</td>\n",
              "      <td>14</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Dark</td>\n",
              "      <td>3</td>\n",
              "      <td>['Pipe', 'Pilot Helmet', 'Hot Lipstick']</td>\n",
              "      <td>#A4031F</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>12/7/18</td>\n",
              "      <td>5394</td>\n",
              "      <td>204</td>\n",
              "      <td>2.50</td>\n",
              "      <td>14</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Dark</td>\n",
              "      <td>3</td>\n",
              "      <td>['Pipe', 'Pilot Helmet', 'Hot Lipstick']</td>\n",
              "      <td>#A4031F</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2/1/21</td>\n",
              "      <td>166</td>\n",
              "      <td>5853</td>\n",
              "      <td>20.00</td>\n",
              "      <td>53</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Light</td>\n",
              "      <td>2</td>\n",
              "      <td>['Big Shades', 'Straight Hair']</td>\n",
              "      <td>#F2A359</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-d2662aaf-2135-4842-b190-77b5bd1f800a')\"\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-d2662aaf-2135-4842-b190-77b5bd1f800a 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-d2662aaf-2135-4842-b190-77b5bd1f800a');\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": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df['date'] = pd.to_datetime(df['date'], utc=True)\n",
        "\n",
        "df['date'] = df['date'].apply(lambda x: x.replace(tzinfo=None))\n",
        "\n",
        "df['dte'] = pd.to_datetime(df['date'])\n",
        "\n",
        "# set time column as index\n",
        "df = df.set_index('date')\n",
        "\n",
        "# sort dataframe by index (i.e., by time) in ascending order\n",
        "df = df.sort_index()"
      ],
      "metadata": {
        "id": "4V3Yl8Wl_Ibh"
      },
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df = df.reset_index()"
      ],
      "metadata": {
        "id": "leyKXcX0_T_T"
      },
      "execution_count": 10,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "ubFDw_tN_V-i",
        "outputId": "556217ec-d3b0-42a7-f115-449badad0603"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            date  from    to  eth_price  punk_id   type  gender skin_tone  \\\n",
              "0     2017-06-23  1406   888       0.20     4641  Human  Female     Light   \n",
              "1     2017-06-23  1406  1218       0.04     5719  Human  Female    Medium   \n",
              "2     2017-06-23  1406  1218       0.06     6208  Human    Male    Medium   \n",
              "3     2017-06-23   166  4722       0.10     5056  Human    Male    Albino   \n",
              "4     2017-06-23  1406  2518       0.20     5545  Human  Female    Albino   \n",
              "...          ...   ...   ...        ...      ...    ...     ...       ...   \n",
              "17821 2022-07-26  3002  1044      94.90     5600  Human    Male    Albino   \n",
              "17822 2022-07-26  5318  4950      69.00     4430  Human  Female    Albino   \n",
              "17823 2022-07-26   980  1939      94.00     9099  Human    Male     Light   \n",
              "17824 2022-07-27  3096  1028      69.69     6221  Human  Female      Dark   \n",
              "17825 2022-07-27   402  1955     104.95     2567  Human    Male     Light   \n",
              "\n",
              "       attr_count                                         attributes  \\\n",
              "0               3  ['Purple Eye Shadow', 'Wild Blonde', 'Cigarette']   \n",
              "1               3      ['Welding Goggles', 'Dark Hair', 'Cigarette']   \n",
              "2               2                        ['Shadow Beard', 'Earring']   \n",
              "3               4     ['Beanie', 'Luxurious Beard', 'Earring', 'VR']   \n",
              "4               5  ['Vape', 'Hot Lipstick', 'Wild Hair', 'Earring...   \n",
              "...           ...                                                ...   \n",
              "17821           3      ['Frumpy Hair', 'Gold Chain', 'Small Shades']   \n",
              "17822           2                ['Clown Eyes Green', 'Frumpy Hair']   \n",
              "17823           4  ['Cigarette', 'Mustache', 'Earring', 'Crazy Ha...   \n",
              "17824           4  ['Green Eye Shadow', 'Half Shaved', 'Earring',...   \n",
              "17825           3                ['Cigarette', 'Fedora', 'Mustache']   \n",
              "\n",
              "      skin_tone_color                                            img_url  \\\n",
              "0             #F2A359  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "1             #DB9065  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "2             #DB9065  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "3             #F2DC5D  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "4             #F2DC5D  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "...               ...                                                ...   \n",
              "17821         #F2DC5D  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "17822         #F2DC5D  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "17823         #F2A359  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "17824         #A4031F  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "17825         #F2A359  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "\n",
              "             dte  \n",
              "0     2017-06-23  \n",
              "1     2017-06-23  \n",
              "2     2017-06-23  \n",
              "3     2017-06-23  \n",
              "4     2017-06-23  \n",
              "...          ...  \n",
              "17821 2022-07-26  \n",
              "17822 2022-07-26  \n",
              "17823 2022-07-26  \n",
              "17824 2022-07-27  \n",
              "17825 2022-07-27  \n",
              "\n",
              "[17826 rows x 13 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a3c1a4c5-5d2b-4262-8399-72d072c1f975\">\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>date</th>\n",
              "      <th>from</th>\n",
              "      <th>to</th>\n",
              "      <th>eth_price</th>\n",
              "      <th>punk_id</th>\n",
              "      <th>type</th>\n",
              "      <th>gender</th>\n",
              "      <th>skin_tone</th>\n",
              "      <th>attr_count</th>\n",
              "      <th>attributes</th>\n",
              "      <th>skin_tone_color</th>\n",
              "      <th>img_url</th>\n",
              "      <th>dte</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>888</td>\n",
              "      <td>0.20</td>\n",
              "      <td>4641</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Light</td>\n",
              "      <td>3</td>\n",
              "      <td>['Purple Eye Shadow', 'Wild Blonde', 'Cigarette']</td>\n",
              "      <td>#F2A359</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>1218</td>\n",
              "      <td>0.04</td>\n",
              "      <td>5719</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Medium</td>\n",
              "      <td>3</td>\n",
              "      <td>['Welding Goggles', 'Dark Hair', 'Cigarette']</td>\n",
              "      <td>#DB9065</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>1218</td>\n",
              "      <td>0.06</td>\n",
              "      <td>6208</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Medium</td>\n",
              "      <td>2</td>\n",
              "      <td>['Shadow Beard', 'Earring']</td>\n",
              "      <td>#DB9065</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>166</td>\n",
              "      <td>4722</td>\n",
              "      <td>0.10</td>\n",
              "      <td>5056</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Albino</td>\n",
              "      <td>4</td>\n",
              "      <td>['Beanie', 'Luxurious Beard', 'Earring', 'VR']</td>\n",
              "      <td>#F2DC5D</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>2518</td>\n",
              "      <td>0.20</td>\n",
              "      <td>5545</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Albino</td>\n",
              "      <td>5</td>\n",
              "      <td>['Vape', 'Hot Lipstick', 'Wild Hair', 'Earring...</td>\n",
              "      <td>#F2DC5D</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17821</th>\n",
              "      <td>2022-07-26</td>\n",
              "      <td>3002</td>\n",
              "      <td>1044</td>\n",
              "      <td>94.90</td>\n",
              "      <td>5600</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Albino</td>\n",
              "      <td>3</td>\n",
              "      <td>['Frumpy Hair', 'Gold Chain', 'Small Shades']</td>\n",
              "      <td>#F2DC5D</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2022-07-26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17822</th>\n",
              "      <td>2022-07-26</td>\n",
              "      <td>5318</td>\n",
              "      <td>4950</td>\n",
              "      <td>69.00</td>\n",
              "      <td>4430</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Albino</td>\n",
              "      <td>2</td>\n",
              "      <td>['Clown Eyes Green', 'Frumpy Hair']</td>\n",
              "      <td>#F2DC5D</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2022-07-26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17823</th>\n",
              "      <td>2022-07-26</td>\n",
              "      <td>980</td>\n",
              "      <td>1939</td>\n",
              "      <td>94.00</td>\n",
              "      <td>9099</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Light</td>\n",
              "      <td>4</td>\n",
              "      <td>['Cigarette', 'Mustache', 'Earring', 'Crazy Ha...</td>\n",
              "      <td>#F2A359</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2022-07-26</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17824</th>\n",
              "      <td>2022-07-27</td>\n",
              "      <td>3096</td>\n",
              "      <td>1028</td>\n",
              "      <td>69.69</td>\n",
              "      <td>6221</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Dark</td>\n",
              "      <td>4</td>\n",
              "      <td>['Green Eye Shadow', 'Half Shaved', 'Earring',...</td>\n",
              "      <td>#A4031F</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2022-07-27</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17825</th>\n",
              "      <td>2022-07-27</td>\n",
              "      <td>402</td>\n",
              "      <td>1955</td>\n",
              "      <td>104.95</td>\n",
              "      <td>2567</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Light</td>\n",
              "      <td>3</td>\n",
              "      <td>['Cigarette', 'Fedora', 'Mustache']</td>\n",
              "      <td>#F2A359</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2022-07-27</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>17826 rows × 13 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a3c1a4c5-5d2b-4262-8399-72d072c1f975')\"\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-a3c1a4c5-5d2b-4262-8399-72d072c1f975 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-a3c1a4c5-5d2b-4262-8399-72d072c1f975');\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": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# drop rows with duplicate names\n",
        "df = df.drop_duplicates(subset=['img_url'])\n",
        "\n",
        "# display the updated dataframe\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "w2mUJO3m-Xvt",
        "outputId": "c9dd8cd9-a6d7-46ba-b9c4-840574053162"
      },
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            date  from    to  eth_price  punk_id   type  gender skin_tone  \\\n",
              "0     2017-06-23  1406   888       0.20     4641  Human  Female     Light   \n",
              "1     2017-06-23  1406  1218       0.04     5719  Human  Female    Medium   \n",
              "2     2017-06-23  1406  1218       0.06     6208  Human    Male    Medium   \n",
              "3     2017-06-23   166  4722       0.10     5056  Human    Male    Albino   \n",
              "4     2017-06-23  1406  2518       0.20     5545  Human  Female    Albino   \n",
              "...          ...   ...   ...        ...      ...    ...     ...       ...   \n",
              "17778 2022-07-17  2292  2070      88.88     4656  Human  Female    Medium   \n",
              "17780 2022-07-17  5496  3096      85.00     4739  Human    Male      Dark   \n",
              "17788 2022-07-18   107  1044      84.00     4569  Human    Male     Light   \n",
              "17810 2022-07-21   244   801      86.68     4755  Human    Male      Dark   \n",
              "17814 2022-07-23    10  1618     110.00     9544  Human  Female     Light   \n",
              "\n",
              "       attr_count                                         attributes  \\\n",
              "0               3  ['Purple Eye Shadow', 'Wild Blonde', 'Cigarette']   \n",
              "1               3      ['Welding Goggles', 'Dark Hair', 'Cigarette']   \n",
              "2               2                        ['Shadow Beard', 'Earring']   \n",
              "3               4     ['Beanie', 'Luxurious Beard', 'Earring', 'VR']   \n",
              "4               5  ['Vape', 'Hot Lipstick', 'Wild Hair', 'Earring...   \n",
              "...           ...                                                ...   \n",
              "17778           2                 ['Blonde Short', 'Classic Shades']   \n",
              "17780           2                       ['Chinstrap', 'Mohawk Dark']   \n",
              "17788           3      ['Clown Eyes Blue', 'Shadow Beard', 'Mohawk']   \n",
              "17810           3          ['Messy Hair', 'Earring', 'Normal Beard']   \n",
              "17814           3  ['Pipe', 'Straight Hair Blonde', 'Purple Lipst...   \n",
              "\n",
              "      skin_tone_color                                            img_url  \\\n",
              "0             #F2A359  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "1             #DB9065  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "2             #DB9065  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "3             #F2DC5D  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "4             #F2DC5D  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "...               ...                                                ...   \n",
              "17778         #DB9065  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "17780         #A4031F  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "17788         #F2A359  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "17810         #A4031F  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "17814         #F2A359  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "\n",
              "             dte  \n",
              "0     2017-06-23  \n",
              "1     2017-06-23  \n",
              "2     2017-06-23  \n",
              "3     2017-06-23  \n",
              "4     2017-06-23  \n",
              "...          ...  \n",
              "17778 2022-07-17  \n",
              "17780 2022-07-17  \n",
              "17788 2022-07-18  \n",
              "17810 2022-07-21  \n",
              "17814 2022-07-23  \n",
              "\n",
              "[6275 rows x 13 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3dd0e8d1-98a0-4720-a6a0-45fb20a4ed50\">\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>date</th>\n",
              "      <th>from</th>\n",
              "      <th>to</th>\n",
              "      <th>eth_price</th>\n",
              "      <th>punk_id</th>\n",
              "      <th>type</th>\n",
              "      <th>gender</th>\n",
              "      <th>skin_tone</th>\n",
              "      <th>attr_count</th>\n",
              "      <th>attributes</th>\n",
              "      <th>skin_tone_color</th>\n",
              "      <th>img_url</th>\n",
              "      <th>dte</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>888</td>\n",
              "      <td>0.20</td>\n",
              "      <td>4641</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Light</td>\n",
              "      <td>3</td>\n",
              "      <td>['Purple Eye Shadow', 'Wild Blonde', 'Cigarette']</td>\n",
              "      <td>#F2A359</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>1218</td>\n",
              "      <td>0.04</td>\n",
              "      <td>5719</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Medium</td>\n",
              "      <td>3</td>\n",
              "      <td>['Welding Goggles', 'Dark Hair', 'Cigarette']</td>\n",
              "      <td>#DB9065</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>1218</td>\n",
              "      <td>0.06</td>\n",
              "      <td>6208</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Medium</td>\n",
              "      <td>2</td>\n",
              "      <td>['Shadow Beard', 'Earring']</td>\n",
              "      <td>#DB9065</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>166</td>\n",
              "      <td>4722</td>\n",
              "      <td>0.10</td>\n",
              "      <td>5056</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Albino</td>\n",
              "      <td>4</td>\n",
              "      <td>['Beanie', 'Luxurious Beard', 'Earring', 'VR']</td>\n",
              "      <td>#F2DC5D</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>2518</td>\n",
              "      <td>0.20</td>\n",
              "      <td>5545</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Albino</td>\n",
              "      <td>5</td>\n",
              "      <td>['Vape', 'Hot Lipstick', 'Wild Hair', 'Earring...</td>\n",
              "      <td>#F2DC5D</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17778</th>\n",
              "      <td>2022-07-17</td>\n",
              "      <td>2292</td>\n",
              "      <td>2070</td>\n",
              "      <td>88.88</td>\n",
              "      <td>4656</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Medium</td>\n",
              "      <td>2</td>\n",
              "      <td>['Blonde Short', 'Classic Shades']</td>\n",
              "      <td>#DB9065</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2022-07-17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17780</th>\n",
              "      <td>2022-07-17</td>\n",
              "      <td>5496</td>\n",
              "      <td>3096</td>\n",
              "      <td>85.00</td>\n",
              "      <td>4739</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Dark</td>\n",
              "      <td>2</td>\n",
              "      <td>['Chinstrap', 'Mohawk Dark']</td>\n",
              "      <td>#A4031F</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2022-07-17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17788</th>\n",
              "      <td>2022-07-18</td>\n",
              "      <td>107</td>\n",
              "      <td>1044</td>\n",
              "      <td>84.00</td>\n",
              "      <td>4569</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Light</td>\n",
              "      <td>3</td>\n",
              "      <td>['Clown Eyes Blue', 'Shadow Beard', 'Mohawk']</td>\n",
              "      <td>#F2A359</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2022-07-18</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17810</th>\n",
              "      <td>2022-07-21</td>\n",
              "      <td>244</td>\n",
              "      <td>801</td>\n",
              "      <td>86.68</td>\n",
              "      <td>4755</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Dark</td>\n",
              "      <td>3</td>\n",
              "      <td>['Messy Hair', 'Earring', 'Normal Beard']</td>\n",
              "      <td>#A4031F</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2022-07-21</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17814</th>\n",
              "      <td>2022-07-23</td>\n",
              "      <td>10</td>\n",
              "      <td>1618</td>\n",
              "      <td>110.00</td>\n",
              "      <td>9544</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Light</td>\n",
              "      <td>3</td>\n",
              "      <td>['Pipe', 'Straight Hair Blonde', 'Purple Lipst...</td>\n",
              "      <td>#F2A359</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2022-07-23</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>6275 rows × 13 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3dd0e8d1-98a0-4720-a6a0-45fb20a4ed50')\"\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-3dd0e8d1-98a0-4720-a6a0-45fb20a4ed50 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-3dd0e8d1-98a0-4720-a6a0-45fb20a4ed50');\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": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# replace \"Non-human\" values in the \"skin_tone\" column with their corresponding value in the \"type\" column\n",
        "df.loc[df['skin_tone'] == 'Non-human', 'skin_tone'] = df['type']\n",
        "\n",
        "# print the modified dataframe\n",
        "df.head()\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 548
        },
        "id": "Yy-wqbWaHbHF",
        "outputId": "6fd622d8-287d-4eb1-b7fd-0556774dd8ec"
      },
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        date  from    to  eth_price  punk_id   type  gender skin_tone  \\\n",
              "0 2017-06-23  1406   888       0.20     4641  Human  Female     Light   \n",
              "1 2017-06-23  1406  1218       0.04     5719  Human  Female    Medium   \n",
              "2 2017-06-23  1406  1218       0.06     6208  Human    Male    Medium   \n",
              "3 2017-06-23   166  4722       0.10     5056  Human    Male    Albino   \n",
              "4 2017-06-23  1406  2518       0.20     5545  Human  Female    Albino   \n",
              "\n",
              "   attr_count                                         attributes  \\\n",
              "0           3  ['Purple Eye Shadow', 'Wild Blonde', 'Cigarette']   \n",
              "1           3      ['Welding Goggles', 'Dark Hair', 'Cigarette']   \n",
              "2           2                        ['Shadow Beard', 'Earring']   \n",
              "3           4     ['Beanie', 'Luxurious Beard', 'Earring', 'VR']   \n",
              "4           5  ['Vape', 'Hot Lipstick', 'Wild Hair', 'Earring...   \n",
              "\n",
              "  skin_tone_color                                            img_url  \\\n",
              "0         #F2A359  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "1         #DB9065  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "2         #DB9065  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "3         #F2DC5D  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "4         #F2DC5D  https://www.larvalabs.com/cryptopunks/cryptopu...   \n",
              "\n",
              "         dte  \n",
              "0 2017-06-23  \n",
              "1 2017-06-23  \n",
              "2 2017-06-23  \n",
              "3 2017-06-23  \n",
              "4 2017-06-23  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-35b98f53-e0dc-4647-9447-fca52e8ad24d\">\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>date</th>\n",
              "      <th>from</th>\n",
              "      <th>to</th>\n",
              "      <th>eth_price</th>\n",
              "      <th>punk_id</th>\n",
              "      <th>type</th>\n",
              "      <th>gender</th>\n",
              "      <th>skin_tone</th>\n",
              "      <th>attr_count</th>\n",
              "      <th>attributes</th>\n",
              "      <th>skin_tone_color</th>\n",
              "      <th>img_url</th>\n",
              "      <th>dte</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>888</td>\n",
              "      <td>0.20</td>\n",
              "      <td>4641</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Light</td>\n",
              "      <td>3</td>\n",
              "      <td>['Purple Eye Shadow', 'Wild Blonde', 'Cigarette']</td>\n",
              "      <td>#F2A359</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>1218</td>\n",
              "      <td>0.04</td>\n",
              "      <td>5719</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Medium</td>\n",
              "      <td>3</td>\n",
              "      <td>['Welding Goggles', 'Dark Hair', 'Cigarette']</td>\n",
              "      <td>#DB9065</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>1218</td>\n",
              "      <td>0.06</td>\n",
              "      <td>6208</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Medium</td>\n",
              "      <td>2</td>\n",
              "      <td>['Shadow Beard', 'Earring']</td>\n",
              "      <td>#DB9065</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>166</td>\n",
              "      <td>4722</td>\n",
              "      <td>0.10</td>\n",
              "      <td>5056</td>\n",
              "      <td>Human</td>\n",
              "      <td>Male</td>\n",
              "      <td>Albino</td>\n",
              "      <td>4</td>\n",
              "      <td>['Beanie', 'Luxurious Beard', 'Earring', 'VR']</td>\n",
              "      <td>#F2DC5D</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2017-06-23</td>\n",
              "      <td>1406</td>\n",
              "      <td>2518</td>\n",
              "      <td>0.20</td>\n",
              "      <td>5545</td>\n",
              "      <td>Human</td>\n",
              "      <td>Female</td>\n",
              "      <td>Albino</td>\n",
              "      <td>5</td>\n",
              "      <td>['Vape', 'Hot Lipstick', 'Wild Hair', 'Earring...</td>\n",
              "      <td>#F2DC5D</td>\n",
              "      <td>https://www.larvalabs.com/cryptopunks/cryptopu...</td>\n",
              "      <td>2017-06-23</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-35b98f53-e0dc-4647-9447-fca52e8ad24d')\"\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-35b98f53-e0dc-4647-9447-fca52e8ad24d 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-35b98f53-e0dc-4647-9447-fca52e8ad24d');\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": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_gs = df[['gender','skin_tone']]\n",
        "df_gs.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "B2wlystNDqyU",
        "outputId": "a0639665-3e08-4469-8aac-655e3b23b58b"
      },
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   gender skin_tone\n",
              "0  Female     Light\n",
              "1  Female    Medium\n",
              "2    Male    Medium\n",
              "3    Male    Albino\n",
              "4  Female    Albino"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-562e9dd5-691a-4d69-a1fd-84d3415a94af\">\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>gender</th>\n",
              "      <th>skin_tone</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Female</td>\n",
              "      <td>Light</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Female</td>\n",
              "      <td>Medium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Male</td>\n",
              "      <td>Medium</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Male</td>\n",
              "      <td>Albino</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Female</td>\n",
              "      <td>Albino</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-562e9dd5-691a-4d69-a1fd-84d3415a94af')\"\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-562e9dd5-691a-4d69-a1fd-84d3415a94af 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-562e9dd5-691a-4d69-a1fd-84d3415a94af');\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": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "pivot_df = df_gs.pivot_table(index='gender', columns='skin_tone', aggfunc=len)"
      ],
      "metadata": {
        "id": "pJn10-8bDbVf"
      },
      "execution_count": 15,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# add a row and column for total numbers\n",
        "pivot_df.loc['Total'] = pivot_df.sum()\n",
        "pivot_df['Total'] = pivot_df.sum(axis=1)\n",
        "\n",
        "# add a row and column for proportion of each gender and skin tone\n",
        "total_num = pivot_df.loc['Total', 'Total']\n"
      ],
      "metadata": {
        "id": "Mw300o0BAmbD"
      },
      "execution_count": 16,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "pivot_df = pivot_df.fillna(0)"
      ],
      "metadata": {
        "id": "iAS8awqDGnDO"
      },
      "execution_count": 17,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# calculate the total number of observations\n",
        "total = 6275\n",
        "\n",
        "# calculate the proportion of each cell\n",
        "pivot_df_prop = pivot_df / total * 100"
      ],
      "metadata": {
        "id": "MwrQSR5r_-m5"
      },
      "execution_count": 18,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "pivot_df "
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 175
        },
        "id": "XD_mbiFiCMaA",
        "outputId": "ee6bb2b8-5df7-4518-e21f-89f9d33e2441"
      },
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "skin_tone  Albino  Alien   Ape    Dark   Light  Medium  Zombie   Total\n",
              "gender                                                                \n",
              "Female      207.0    0.0   0.0   650.0   644.0   701.0     0.0  2202.0\n",
              "Male        371.0    2.0  14.0  1166.0  1249.0  1236.0    35.0  4073.0\n",
              "Total       578.0    2.0  14.0  1816.0  1893.0  1937.0    35.0  6275.0"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0b81af53-d995-4ead-8c09-ba1129b7f726\">\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>skin_tone</th>\n",
              "      <th>Albino</th>\n",
              "      <th>Alien</th>\n",
              "      <th>Ape</th>\n",
              "      <th>Dark</th>\n",
              "      <th>Light</th>\n",
              "      <th>Medium</th>\n",
              "      <th>Zombie</th>\n",
              "      <th>Total</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>gender</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Female</th>\n",
              "      <td>207.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>650.0</td>\n",
              "      <td>644.0</td>\n",
              "      <td>701.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2202.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Male</th>\n",
              "      <td>371.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>1166.0</td>\n",
              "      <td>1249.0</td>\n",
              "      <td>1236.0</td>\n",
              "      <td>35.0</td>\n",
              "      <td>4073.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Total</th>\n",
              "      <td>578.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>1816.0</td>\n",
              "      <td>1893.0</td>\n",
              "      <td>1937.0</td>\n",
              "      <td>35.0</td>\n",
              "      <td>6275.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0b81af53-d995-4ead-8c09-ba1129b7f726')\"\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-0b81af53-d995-4ead-8c09-ba1129b7f726 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-0b81af53-d995-4ead-8c09-ba1129b7f726');\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": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# create the heatmap graph\n",
        "fig = px.imshow(pivot_df_prop.values,\n",
        "                labels=dict(x=\"Skin Tone\", y=\"Gender\"),\n",
        "                x=list(pivot_df_prop.columns),\n",
        "                y=list(pivot_df_prop.index),\n",
        "                color_continuous_scale='blues')\n",
        "\n",
        "# add the corresponding values to each cell of the heatmap\n",
        "for i in range(len(pivot_df_prop.index)):\n",
        "    for j in range(len(pivot_df_prop.columns)):\n",
        "        value = pivot_df_prop.values[i][j]\n",
        "        count = pivot_df.values[i][j]\n",
        "        font_size = 14\n",
        "        font_color = 'black'\n",
        "        if count > 2000:\n",
        "            font_color = 'white'\n",
        "        fig.add_annotation(x=j, y=i, text=f\"{format(int(count), ',')}<br>({value:.1f}%)\",\n",
        "                           font=dict(size=font_size, color=font_color),\n",
        "                           showarrow=False)\n",
        "\n",
        "# add a title to the graph\n",
        "fig.update_layout(title='CryptoPunks Gender and Skin Tone Distribution Heatmap')\n",
        "\n",
        "# show the graph\n",
        "fig.show()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 542
        },
        "id": "EmKCMq7xADES",
        "outputId": "ee4ec232-2f07-4541-dbf1-61121089404a"
      },
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax && window.MathJax.Hub && window.MathJax.Hub.Config) {window.MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script src=\"https://cdn.plot.ly/plotly-2.18.2.min.js\"></script>                <div id=\"54607e07-db4f-48a2-9c70-c9f8f24550ae\" class=\"plotly-graph-div\" style=\"height:525px; width:100%;\"></div>            <script type=\"text/javascript\">                                    window.PLOTLYENV=window.PLOTLYENV || {};                                    if (document.getElementById(\"54607e07-db4f-48a2-9c70-c9f8f24550ae\")) {                    Plotly.newPlot(                        \"54607e07-db4f-48a2-9c70-c9f8f24550ae\",                        [{\"coloraxis\":\"coloraxis\",\"name\":\"0\",\"x\":[\"Albino\",\"Alien\",\"Ape\",\"Dark\",\"Light\",\"Medium\",\"Zombie\",\"Total\"],\"y\":[\"Female\",\"Male\",\"Total\"],\"z\":[[3.298804780876494,0.0,0.0,10.358565737051793,10.262948207171315,11.171314741035857,0.0,35.091633466135455],[5.912350597609562,0.03187250996015936,0.22310756972111553,18.58167330677291,19.904382470119522,19.697211155378486,0.5577689243027889,64.90836653386454],[9.211155378486056,0.03187250996015936,0.22310756972111553,28.9402390438247,30.16733067729084,30.868525896414344,0.5577689243027889,100.0]],\"type\":\"heatmap\",\"xaxis\":\"x\",\"yaxis\":\"y\",\"hovertemplate\":\"Skin Tone: %{x}<br>Gender: %{y}<br>color: %{z}<extra></extra>\"}],                        {\"template\":{\"data\":{\"histogram2dcontour\":[{\"type\":\"histogram2dcontour\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"choropleth\":[{\"type\":\"choropleth\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"histogram2d\":[{\"type\":\"histogram2d\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"heatmap\":[{\"type\":\"heatmap\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"heatmapgl\":[{\"type\":\"heatmapgl\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"contourcarpet\":[{\"type\":\"contourcarpet\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"contour\":[{\"type\":\"contour\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"surface\":[{\"type\":\"surface\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"mesh3d\":[{\"type\":\"mesh3d\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"scatter\":[{\"fillpattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2},\"type\":\"scatter\"}],\"parcoords\":[{\"type\":\"parcoords\",\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterpolargl\":[{\"type\":\"scatterpolargl\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"bar\":[{\"error_x\":{\"color\":\"#2a3f5f\"},\"error_y\":{\"color\":\"#2a3f5f\"},\"marker\":{\"line\":{\"color\":\"#E5ECF6\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"bar\"}],\"scattergeo\":[{\"type\":\"scattergeo\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterpolar\":[{\"type\":\"scatterpolar\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"histogram\":[{\"marker\":{\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"histogram\"}],\"scattergl\":[{\"type\":\"scattergl\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatter3d\":[{\"type\":\"scatter3d\",\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scattermapbox\":[{\"type\":\"scattermapbox\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterternary\":[{\"type\":\"scatterternary\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scattercarpet\":[{\"type\":\"scattercarpet\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"carpet\":[{\"aaxis\":{\"endlinecolor\":\"#2a3f5f\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"minorgridcolor\":\"white\",\"startlinecolor\":\"#2a3f5f\"},\"baxis\":{\"endlinecolor\":\"#2a3f5f\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"minorgridcolor\":\"white\",\"startlinecolor\":\"#2a3f5f\"},\"type\":\"carpet\"}],\"table\":[{\"cells\":{\"fill\":{\"color\":\"#EBF0F8\"},\"line\":{\"color\":\"white\"}},\"header\":{\"fill\":{\"color\":\"#C8D4E3\"},\"line\":{\"color\":\"white\"}},\"type\":\"table\"}],\"barpolar\":[{\"marker\":{\"line\":{\"color\":\"#E5ECF6\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"barpolar\"}],\"pie\":[{\"automargin\":true,\"type\":\"pie\"}]},\"layout\":{\"autotypenumbers\":\"strict\",\"colorway\":[\"#636efa\",\"#EF553B\",\"#00cc96\",\"#ab63fa\",\"#FFA15A\",\"#19d3f3\",\"#FF6692\",\"#B6E880\",\"#FF97FF\",\"#FECB52\"],\"font\":{\"color\":\"#2a3f5f\"},\"hovermode\":\"closest\",\"hoverlabel\":{\"align\":\"left\"},\"paper_bgcolor\":\"white\",\"plot_bgcolor\":\"#E5ECF6\",\"polar\":{\"bgcolor\":\"#E5ECF6\",\"angularaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"radialaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"}},\"ternary\":{\"bgcolor\":\"#E5ECF6\",\"aaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"baxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"caxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"}},\"coloraxis\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"colorscale\":{\"sequential\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"sequentialminus\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"diverging\":[[0,\"#8e0152\"],[0.1,\"#c51b7d\"],[0.2,\"#de77ae\"],[0.3,\"#f1b6da\"],[0.4,\"#fde0ef\"],[0.5,\"#f7f7f7\"],[0.6,\"#e6f5d0\"],[0.7,\"#b8e186\"],[0.8,\"#7fbc41\"],[0.9,\"#4d9221\"],[1,\"#276419\"]]},\"xaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"white\",\"automargin\":true,\"zerolinewidth\":2},\"yaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"white\",\"automargin\":true,\"zerolinewidth\":2},\"scene\":{\"xaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2},\"yaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2},\"zaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2}},\"shapedefaults\":{\"line\":{\"color\":\"#2a3f5f\"}},\"annotationdefaults\":{\"arrowcolor\":\"#2a3f5f\",\"arrowhead\":0,\"arrowwidth\":1},\"geo\":{\"bgcolor\":\"white\",\"landcolor\":\"#E5ECF6\",\"subunitcolor\":\"white\",\"showland\":true,\"showlakes\":true,\"lakecolor\":\"white\"},\"title\":{\"x\":0.05},\"mapbox\":{\"style\":\"light\"}}},\"xaxis\":{\"anchor\":\"y\",\"domain\":[0.0,1.0],\"scaleanchor\":\"y\",\"constrain\":\"domain\",\"title\":{\"text\":\"Skin Tone\"}},\"yaxis\":{\"anchor\":\"x\",\"domain\":[0.0,1.0],\"autorange\":\"reversed\",\"constrain\":\"domain\",\"title\":{\"text\":\"Gender\"}},\"coloraxis\":{\"colorscale\":[[0.0,\"rgb(247,251,255)\"],[0.125,\"rgb(222,235,247)\"],[0.25,\"rgb(198,219,239)\"],[0.375,\"rgb(158,202,225)\"],[0.5,\"rgb(107,174,214)\"],[0.625,\"rgb(66,146,198)\"],[0.75,\"rgb(33,113,181)\"],[0.875,\"rgb(8,81,156)\"],[1.0,\"rgb(8,48,107)\"]]},\"margin\":{\"t\":60},\"annotations\":[{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"207<br>(3.3%)\",\"x\":0,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"0<br>(0.0%)\",\"x\":1,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"0<br>(0.0%)\",\"x\":2,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"650<br>(10.4%)\",\"x\":3,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"644<br>(10.3%)\",\"x\":4,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"701<br>(11.2%)\",\"x\":5,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"0<br>(0.0%)\",\"x\":6,\"y\":0},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"2,202<br>(35.1%)\",\"x\":7,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"371<br>(5.9%)\",\"x\":0,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"2<br>(0.0%)\",\"x\":1,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"14<br>(0.2%)\",\"x\":2,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"1,166<br>(18.6%)\",\"x\":3,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"1,249<br>(19.9%)\",\"x\":4,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"1,236<br>(19.7%)\",\"x\":5,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"35<br>(0.6%)\",\"x\":6,\"y\":1},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"4,073<br>(64.9%)\",\"x\":7,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"578<br>(9.2%)\",\"x\":0,\"y\":2},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"2<br>(0.0%)\",\"x\":1,\"y\":2},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"14<br>(0.2%)\",\"x\":2,\"y\":2},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"1,816<br>(28.9%)\",\"x\":3,\"y\":2},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"1,893<br>(30.2%)\",\"x\":4,\"y\":2},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"1,937<br>(30.9%)\",\"x\":5,\"y\":2},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"35<br>(0.6%)\",\"x\":6,\"y\":2},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"6,275<br>(100.0%)\",\"x\":7,\"y\":2}],\"title\":{\"text\":\"CryptoPunks Gender and Skin Tone Distribution Heatmap\"}},                        {\"responsive\": true}                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('54607e07-db4f-48a2-9c70-c9f8f24550ae');\n",
              "var x = new MutationObserver(function (mutations, observer) {{\n",
              "        var display = window.getComputedStyle(gd).display;\n",
              "        if (!display || display === 'none') {{\n",
              "            console.log([gd, 'removed!']);\n",
              "            Plotly.purge(gd);\n",
              "            observer.disconnect();\n",
              "        }}\n",
              "}});\n",
              "\n",
              "// Listen for the removal of the full notebook cells\n",
              "var notebookContainer = gd.closest('#notebook-container');\n",
              "if (notebookContainer) {{\n",
              "    x.observe(notebookContainer, {childList: true});\n",
              "}}\n",
              "\n",
              "// Listen for the clearing of the current output cell\n",
              "var outputEl = gd.closest('.output');\n",
              "if (outputEl) {{\n",
              "    x.observe(outputEl, {childList: true});\n",
              "}}\n",
              "\n",
              "                        })                };                            </script>        </div>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# create the heatmap graph\n",
        "fig = px.imshow(pivot_df.values,\n",
        "                labels=dict(x=\"Skin Tone\", y=\"Gender\"),\n",
        "                x=list(pivot_df.columns),\n",
        "                y=list(pivot_df.index),\n",
        "                color_continuous_scale='blues')\n",
        "\n",
        "# add the corresponding values to each cell of the heatmap\n",
        "for i in range(len(pivot_df.index)):\n",
        "    for j in range(len(pivot_df.columns)):\n",
        "        value = pivot_df.values[i][j]\n",
        "        font_size = 14\n",
        "        font_color = 'black'\n",
        "        if value > 1000:\n",
        "            font_color = 'white'\n",
        "        fig.add_annotation(x=j, y=i, text=format(int(value), ','), \n",
        "                           showarrow=False, \n",
        "                           font=dict(size=font_size, color=font_color))\n",
        "\n",
        "# add a title to the graph\n",
        "fig.update_layout(title='CryptoPunks Gender and Skin Tone Distribution Heatmap')\n",
        "\n",
        "# show the graph\n",
        "fig.show()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 542
        },
        "id": "UNwQwSmGJwaH",
        "outputId": "c00bf99d-b491-4529-ce43-831adef99cf2"
      },
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax && window.MathJax.Hub && window.MathJax.Hub.Config) {window.MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script src=\"https://cdn.plot.ly/plotly-2.18.2.min.js\"></script>                <div id=\"2e7ec65c-4453-47e7-aaf8-c27430c2c4f4\" class=\"plotly-graph-div\" style=\"height:525px; width:100%;\"></div>            <script type=\"text/javascript\">                                    window.PLOTLYENV=window.PLOTLYENV || {};                                    if (document.getElementById(\"2e7ec65c-4453-47e7-aaf8-c27430c2c4f4\")) {                    Plotly.newPlot(                        \"2e7ec65c-4453-47e7-aaf8-c27430c2c4f4\",                        [{\"coloraxis\":\"coloraxis\",\"name\":\"0\",\"x\":[\"Albino\",\"Alien\",\"Ape\",\"Dark\",\"Light\",\"Medium\",\"Zombie\",\"Total\"],\"y\":[\"Female\",\"Male\",\"Total\"],\"z\":[[207.0,0.0,0.0,650.0,644.0,701.0,0.0,2202.0],[371.0,2.0,14.0,1166.0,1249.0,1236.0,35.0,4073.0],[578.0,2.0,14.0,1816.0,1893.0,1937.0,35.0,6275.0]],\"type\":\"heatmap\",\"xaxis\":\"x\",\"yaxis\":\"y\",\"hovertemplate\":\"Skin Tone: %{x}<br>Gender: %{y}<br>color: %{z}<extra></extra>\"}],                        {\"template\":{\"data\":{\"histogram2dcontour\":[{\"type\":\"histogram2dcontour\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"choropleth\":[{\"type\":\"choropleth\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"histogram2d\":[{\"type\":\"histogram2d\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"heatmap\":[{\"type\":\"heatmap\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"heatmapgl\":[{\"type\":\"heatmapgl\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"contourcarpet\":[{\"type\":\"contourcarpet\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"contour\":[{\"type\":\"contour\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"surface\":[{\"type\":\"surface\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"mesh3d\":[{\"type\":\"mesh3d\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"scatter\":[{\"fillpattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2},\"type\":\"scatter\"}],\"parcoords\":[{\"type\":\"parcoords\",\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterpolargl\":[{\"type\":\"scatterpolargl\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"bar\":[{\"error_x\":{\"color\":\"#2a3f5f\"},\"error_y\":{\"color\":\"#2a3f5f\"},\"marker\":{\"line\":{\"color\":\"#E5ECF6\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"bar\"}],\"scattergeo\":[{\"type\":\"scattergeo\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterpolar\":[{\"type\":\"scatterpolar\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"histogram\":[{\"marker\":{\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"histogram\"}],\"scattergl\":[{\"type\":\"scattergl\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatter3d\":[{\"type\":\"scatter3d\",\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scattermapbox\":[{\"type\":\"scattermapbox\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterternary\":[{\"type\":\"scatterternary\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scattercarpet\":[{\"type\":\"scattercarpet\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"carpet\":[{\"aaxis\":{\"endlinecolor\":\"#2a3f5f\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"minorgridcolor\":\"white\",\"startlinecolor\":\"#2a3f5f\"},\"baxis\":{\"endlinecolor\":\"#2a3f5f\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"minorgridcolor\":\"white\",\"startlinecolor\":\"#2a3f5f\"},\"type\":\"carpet\"}],\"table\":[{\"cells\":{\"fill\":{\"color\":\"#EBF0F8\"},\"line\":{\"color\":\"white\"}},\"header\":{\"fill\":{\"color\":\"#C8D4E3\"},\"line\":{\"color\":\"white\"}},\"type\":\"table\"}],\"barpolar\":[{\"marker\":{\"line\":{\"color\":\"#E5ECF6\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"barpolar\"}],\"pie\":[{\"automargin\":true,\"type\":\"pie\"}]},\"layout\":{\"autotypenumbers\":\"strict\",\"colorway\":[\"#636efa\",\"#EF553B\",\"#00cc96\",\"#ab63fa\",\"#FFA15A\",\"#19d3f3\",\"#FF6692\",\"#B6E880\",\"#FF97FF\",\"#FECB52\"],\"font\":{\"color\":\"#2a3f5f\"},\"hovermode\":\"closest\",\"hoverlabel\":{\"align\":\"left\"},\"paper_bgcolor\":\"white\",\"plot_bgcolor\":\"#E5ECF6\",\"polar\":{\"bgcolor\":\"#E5ECF6\",\"angularaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"radialaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"}},\"ternary\":{\"bgcolor\":\"#E5ECF6\",\"aaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"baxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"},\"caxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\"}},\"coloraxis\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"colorscale\":{\"sequential\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"sequentialminus\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"diverging\":[[0,\"#8e0152\"],[0.1,\"#c51b7d\"],[0.2,\"#de77ae\"],[0.3,\"#f1b6da\"],[0.4,\"#fde0ef\"],[0.5,\"#f7f7f7\"],[0.6,\"#e6f5d0\"],[0.7,\"#b8e186\"],[0.8,\"#7fbc41\"],[0.9,\"#4d9221\"],[1,\"#276419\"]]},\"xaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"white\",\"automargin\":true,\"zerolinewidth\":2},\"yaxis\":{\"gridcolor\":\"white\",\"linecolor\":\"white\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"white\",\"automargin\":true,\"zerolinewidth\":2},\"scene\":{\"xaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2},\"yaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2},\"zaxis\":{\"backgroundcolor\":\"#E5ECF6\",\"gridcolor\":\"white\",\"linecolor\":\"white\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"white\",\"gridwidth\":2}},\"shapedefaults\":{\"line\":{\"color\":\"#2a3f5f\"}},\"annotationdefaults\":{\"arrowcolor\":\"#2a3f5f\",\"arrowhead\":0,\"arrowwidth\":1},\"geo\":{\"bgcolor\":\"white\",\"landcolor\":\"#E5ECF6\",\"subunitcolor\":\"white\",\"showland\":true,\"showlakes\":true,\"lakecolor\":\"white\"},\"title\":{\"x\":0.05},\"mapbox\":{\"style\":\"light\"}}},\"xaxis\":{\"anchor\":\"y\",\"domain\":[0.0,1.0],\"scaleanchor\":\"y\",\"constrain\":\"domain\",\"title\":{\"text\":\"Skin Tone\"}},\"yaxis\":{\"anchor\":\"x\",\"domain\":[0.0,1.0],\"autorange\":\"reversed\",\"constrain\":\"domain\",\"title\":{\"text\":\"Gender\"}},\"coloraxis\":{\"colorscale\":[[0.0,\"rgb(247,251,255)\"],[0.125,\"rgb(222,235,247)\"],[0.25,\"rgb(198,219,239)\"],[0.375,\"rgb(158,202,225)\"],[0.5,\"rgb(107,174,214)\"],[0.625,\"rgb(66,146,198)\"],[0.75,\"rgb(33,113,181)\"],[0.875,\"rgb(8,81,156)\"],[1.0,\"rgb(8,48,107)\"]]},\"margin\":{\"t\":60},\"annotations\":[{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"207\",\"x\":0,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"0\",\"x\":1,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"0\",\"x\":2,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"650\",\"x\":3,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"644\",\"x\":4,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"701\",\"x\":5,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"0\",\"x\":6,\"y\":0},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"2,202\",\"x\":7,\"y\":0},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"371\",\"x\":0,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"2\",\"x\":1,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"14\",\"x\":2,\"y\":1},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"1,166\",\"x\":3,\"y\":1},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"1,249\",\"x\":4,\"y\":1},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"1,236\",\"x\":5,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"35\",\"x\":6,\"y\":1},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"4,073\",\"x\":7,\"y\":1},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"578\",\"x\":0,\"y\":2},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"2\",\"x\":1,\"y\":2},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"14\",\"x\":2,\"y\":2},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"1,816\",\"x\":3,\"y\":2},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"1,893\",\"x\":4,\"y\":2},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"1,937\",\"x\":5,\"y\":2},{\"font\":{\"color\":\"black\",\"size\":14},\"showarrow\":false,\"text\":\"35\",\"x\":6,\"y\":2},{\"font\":{\"color\":\"white\",\"size\":14},\"showarrow\":false,\"text\":\"6,275\",\"x\":7,\"y\":2}],\"title\":{\"text\":\"CryptoPunks Gender and Skin Tone Distribution Heatmap\"}},                        {\"responsive\": true}                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('2e7ec65c-4453-47e7-aaf8-c27430c2c4f4');\n",
              "var x = new MutationObserver(function (mutations, observer) {{\n",
              "        var display = window.getComputedStyle(gd).display;\n",
              "        if (!display || display === 'none') {{\n",
              "            console.log([gd, 'removed!']);\n",
              "            Plotly.purge(gd);\n",
              "            observer.disconnect();\n",
              "        }}\n",
              "}});\n",
              "\n",
              "// Listen for the removal of the full notebook cells\n",
              "var notebookContainer = gd.closest('#notebook-container');\n",
              "if (notebookContainer) {{\n",
              "    x.observe(notebookContainer, {childList: true});\n",
              "}}\n",
              "\n",
              "// Listen for the clearing of the current output cell\n",
              "var outputEl = gd.closest('.output');\n",
              "if (outputEl) {{\n",
              "    x.observe(outputEl, {childList: true});\n",
              "}}\n",
              "\n",
              "                        })                };                            </script>        </div>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {}
        }
      ]
    }
  ]
}