15_ntb_books.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyO8MB/niabWySwlM8+0BfG2",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/luasampaio/CienciaDados/blob/main/15_ntb_books.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "NEHSNnhdnEF9"
      },
      "outputs": [],
      "source": [
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# prompt: montar gooogle drive\n",
        "\n",
        "import pandas as pd\n",
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "uxcLQ0zDnOQr",
        "outputId": "05d44b45-6343-49d4-b003-2388186e3ee2"
      },
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/drive\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv('/content/drive/MyDrive/.Dataset/books.csv', sep=';', encoding='UTF-8', nrows=5, on_bad_lines='warn')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "SzMI92NhnhK1",
        "outputId": "2415eaa9-bc26-4a82-ea05-e703aea1a68d"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-4-7524ec721f16>:1: ParserWarning: Skipping line 3: expected 1 fields, saw 3\n",
            "\n",
            "  df = pd.read_csv('/content/drive/MyDrive/.Dataset/books.csv', sep=';', encoding='UTF-8', nrows=5, on_bad_lines='warn')\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv('/content/drive/MyDrive/.Dataset/books.csv', sep=',', encoding='UTF-8', nrows=5)\n"
      ],
      "metadata": {
        "id": "ZD-mIjNxnncX"
      },
      "execution_count": 5,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 583
        },
        "id": "kSbI_ZDGnpCo",
        "outputId": "f01b30e5-5284-45af-94ef-171df30188a2"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                        bookId  \\\n",
              "0                     2767052-the-hunger-games   \n",
              "1  2.Harry_Potter_and_the_Order_of_the_Phoenix   \n",
              "2                   2657.To_Kill_a_Mockingbird   \n",
              "3                     1885.Pride_and_Prejudice   \n",
              "4                               41865.Twilight   \n",
              "\n",
              "                                       title                 series  \\\n",
              "0                           The Hunger Games    The Hunger Games #1   \n",
              "1  Harry Potter and the Order of the Phoenix        Harry Potter #5   \n",
              "2                      To Kill a Mockingbird  To Kill a Mockingbird   \n",
              "3                        Pride and Prejudice                    NaN   \n",
              "4                                   Twilight   The Twilight Saga #1   \n",
              "\n",
              "                                      author  rating  \\\n",
              "0                            Suzanne Collins    4.33   \n",
              "1  J.K. Rowling, Mary GrandPré (Illustrator)    4.50   \n",
              "2                                 Harper Lee    4.28   \n",
              "3  Jane Austen, Anna Quindlen (Introduction)    4.26   \n",
              "4                            Stephenie Meyer    3.60   \n",
              "\n",
              "                                         description language           isbn  \\\n",
              "0  WINNING MEANS FAME AND FORTUNE.LOSING MEANS CE...  English  9780439023481   \n",
              "1  There is a door at the end of a silent corrido...  English  9780439358071   \n",
              "2  The unforgettable novel of a childhood in a sl...  English  9999999999999   \n",
              "3  Alternate cover edition of ISBN 9780679783268S...  English  9999999999999   \n",
              "4  About three things I was absolutely positive.\\...  English  9780316015844   \n",
              "\n",
              "                                              genres  \\\n",
              "0  ['Young Adult', 'Fiction', 'Dystopia', 'Fantas...   \n",
              "1  ['Fantasy', 'Young Adult', 'Fiction', 'Magic',...   \n",
              "2  ['Classics', 'Fiction', 'Historical Fiction', ...   \n",
              "3  ['Classics', 'Fiction', 'Romance', 'Historical...   \n",
              "4  ['Young Adult', 'Fantasy', 'Romance', 'Vampire...   \n",
              "\n",
              "                                          characters  ... firstPublishDate  \\\n",
              "0  ['Katniss Everdeen', 'Peeta Mellark', 'Cato (H...  ...              NaN   \n",
              "1  ['Sirius Black', 'Draco Malfoy', 'Ron Weasley'...  ...         06/21/03   \n",
              "2  ['Scout Finch', 'Atticus Finch', 'Jem Finch', ...  ...         07/11/60   \n",
              "3  ['Mr. Bennet', 'Mrs. Bennet', 'Jane Bennet', '...  ...         01/28/13   \n",
              "4  ['Edward Cullen', 'Jacob Black', 'Laurent', 'R...  ...         10/05/05   \n",
              "\n",
              "                                              awards  numRatings  \\\n",
              "0  ['Locus Award Nominee for Best Young Adult Boo...     6376780   \n",
              "1  ['Bram Stoker Award for Works for Young Reader...     2507623   \n",
              "2  ['Pulitzer Prize for Fiction (1961)', 'Audie A...     4501075   \n",
              "3                                                 []     2998241   \n",
              "4  ['Georgia Peach Book Award (2007)', 'Buxtehude...     4964519   \n",
              "\n",
              "                                      ratingsByStars likedPercent  \\\n",
              "0  ['3444695', '1921313', '745221', '171994', '93...           96   \n",
              "1  ['1593642', '637516', '222366', '39573', '14526']           98   \n",
              "2  ['2363896', '1333153', '573280', '149952', '80...           95   \n",
              "3  ['1617567', '816659', '373311', '113934', '767...           94   \n",
              "4  ['1751460', '1113682', '1008686', '542017', '5...           78   \n",
              "\n",
              "                                             setting  \\\n",
              "0  ['District 12, Panem', 'Capitol, Panem', 'Pane...   \n",
              "1  ['Hogwarts School of Witchcraft and Wizardry (...   \n",
              "2               ['Maycomb, Alabama (United States)']   \n",
              "3  ['United Kingdom', 'Derbyshire, England (Unite...   \n",
              "4  ['Forks, Washington (United States)', 'Phoenix...   \n",
              "\n",
              "                                            coverImg  bbeScore bbeVotes  price  \n",
              "0  https://i.gr-assets.com/images/S/compressed.ph...   2993816    30516   5.09  \n",
              "1  https://i.gr-assets.com/images/S/compressed.ph...   2632233    26923   7.38  \n",
              "2  https://i.gr-assets.com/images/S/compressed.ph...   2269402    23328    NaN  \n",
              "3  https://i.gr-assets.com/images/S/compressed.ph...   1983116    20452    NaN  \n",
              "4  https://i.gr-assets.com/images/S/compressed.ph...   1459448    14874   2.10  \n",
              "\n",
              "[5 rows x 25 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-fc683206-4faa-4fc8-9b97-e38a4aa35b19\" 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>bookId</th>\n",
              "      <th>title</th>\n",
              "      <th>series</th>\n",
              "      <th>author</th>\n",
              "      <th>rating</th>\n",
              "      <th>description</th>\n",
              "      <th>language</th>\n",
              "      <th>isbn</th>\n",
              "      <th>genres</th>\n",
              "      <th>characters</th>\n",
              "      <th>...</th>\n",
              "      <th>firstPublishDate</th>\n",
              "      <th>awards</th>\n",
              "      <th>numRatings</th>\n",
              "      <th>ratingsByStars</th>\n",
              "      <th>likedPercent</th>\n",
              "      <th>setting</th>\n",
              "      <th>coverImg</th>\n",
              "      <th>bbeScore</th>\n",
              "      <th>bbeVotes</th>\n",
              "      <th>price</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2767052-the-hunger-games</td>\n",
              "      <td>The Hunger Games</td>\n",
              "      <td>The Hunger Games #1</td>\n",
              "      <td>Suzanne Collins</td>\n",
              "      <td>4.33</td>\n",
              "      <td>WINNING MEANS FAME AND FORTUNE.LOSING MEANS CE...</td>\n",
              "      <td>English</td>\n",
              "      <td>9780439023481</td>\n",
              "      <td>['Young Adult', 'Fiction', 'Dystopia', 'Fantas...</td>\n",
              "      <td>['Katniss Everdeen', 'Peeta Mellark', 'Cato (H...</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>['Locus Award Nominee for Best Young Adult Boo...</td>\n",
              "      <td>6376780</td>\n",
              "      <td>['3444695', '1921313', '745221', '171994', '93...</td>\n",
              "      <td>96</td>\n",
              "      <td>['District 12, Panem', 'Capitol, Panem', 'Pane...</td>\n",
              "      <td>https://i.gr-assets.com/images/S/compressed.ph...</td>\n",
              "      <td>2993816</td>\n",
              "      <td>30516</td>\n",
              "      <td>5.09</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2.Harry_Potter_and_the_Order_of_the_Phoenix</td>\n",
              "      <td>Harry Potter and the Order of the Phoenix</td>\n",
              "      <td>Harry Potter #5</td>\n",
              "      <td>J.K. Rowling, Mary GrandPré (Illustrator)</td>\n",
              "      <td>4.50</td>\n",
              "      <td>There is a door at the end of a silent corrido...</td>\n",
              "      <td>English</td>\n",
              "      <td>9780439358071</td>\n",
              "      <td>['Fantasy', 'Young Adult', 'Fiction', 'Magic',...</td>\n",
              "      <td>['Sirius Black', 'Draco Malfoy', 'Ron Weasley'...</td>\n",
              "      <td>...</td>\n",
              "      <td>06/21/03</td>\n",
              "      <td>['Bram Stoker Award for Works for Young Reader...</td>\n",
              "      <td>2507623</td>\n",
              "      <td>['1593642', '637516', '222366', '39573', '14526']</td>\n",
              "      <td>98</td>\n",
              "      <td>['Hogwarts School of Witchcraft and Wizardry (...</td>\n",
              "      <td>https://i.gr-assets.com/images/S/compressed.ph...</td>\n",
              "      <td>2632233</td>\n",
              "      <td>26923</td>\n",
              "      <td>7.38</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2657.To_Kill_a_Mockingbird</td>\n",
              "      <td>To Kill a Mockingbird</td>\n",
              "      <td>To Kill a Mockingbird</td>\n",
              "      <td>Harper Lee</td>\n",
              "      <td>4.28</td>\n",
              "      <td>The unforgettable novel of a childhood in a sl...</td>\n",
              "      <td>English</td>\n",
              "      <td>9999999999999</td>\n",
              "      <td>['Classics', 'Fiction', 'Historical Fiction', ...</td>\n",
              "      <td>['Scout Finch', 'Atticus Finch', 'Jem Finch', ...</td>\n",
              "      <td>...</td>\n",
              "      <td>07/11/60</td>\n",
              "      <td>['Pulitzer Prize for Fiction (1961)', 'Audie A...</td>\n",
              "      <td>4501075</td>\n",
              "      <td>['2363896', '1333153', '573280', '149952', '80...</td>\n",
              "      <td>95</td>\n",
              "      <td>['Maycomb, Alabama (United States)']</td>\n",
              "      <td>https://i.gr-assets.com/images/S/compressed.ph...</td>\n",
              "      <td>2269402</td>\n",
              "      <td>23328</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1885.Pride_and_Prejudice</td>\n",
              "      <td>Pride and Prejudice</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Jane Austen, Anna Quindlen (Introduction)</td>\n",
              "      <td>4.26</td>\n",
              "      <td>Alternate cover edition of ISBN 9780679783268S...</td>\n",
              "      <td>English</td>\n",
              "      <td>9999999999999</td>\n",
              "      <td>['Classics', 'Fiction', 'Romance', 'Historical...</td>\n",
              "      <td>['Mr. Bennet', 'Mrs. Bennet', 'Jane Bennet', '...</td>\n",
              "      <td>...</td>\n",
              "      <td>01/28/13</td>\n",
              "      <td>[]</td>\n",
              "      <td>2998241</td>\n",
              "      <td>['1617567', '816659', '373311', '113934', '767...</td>\n",
              "      <td>94</td>\n",
              "      <td>['United Kingdom', 'Derbyshire, England (Unite...</td>\n",
              "      <td>https://i.gr-assets.com/images/S/compressed.ph...</td>\n",
              "      <td>1983116</td>\n",
              "      <td>20452</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>41865.Twilight</td>\n",
              "      <td>Twilight</td>\n",
              "      <td>The Twilight Saga #1</td>\n",
              "      <td>Stephenie Meyer</td>\n",
              "      <td>3.60</td>\n",
              "      <td>About three things I was absolutely positive.\\...</td>\n",
              "      <td>English</td>\n",
              "      <td>9780316015844</td>\n",
              "      <td>['Young Adult', 'Fantasy', 'Romance', 'Vampire...</td>\n",
              "      <td>['Edward Cullen', 'Jacob Black', 'Laurent', 'R...</td>\n",
              "      <td>...</td>\n",
              "      <td>10/05/05</td>\n",
              "      <td>['Georgia Peach Book Award (2007)', 'Buxtehude...</td>\n",
              "      <td>4964519</td>\n",
              "      <td>['1751460', '1113682', '1008686', '542017', '5...</td>\n",
              "      <td>78</td>\n",
              "      <td>['Forks, Washington (United States)', 'Phoenix...</td>\n",
              "      <td>https://i.gr-assets.com/images/S/compressed.ph...</td>\n",
              "      <td>1459448</td>\n",
              "      <td>14874</td>\n",
              "      <td>2.10</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 25 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fc683206-4faa-4fc8-9b97-e38a4aa35b19')\"\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 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\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",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\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-fc683206-4faa-4fc8-9b97-e38a4aa35b19 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-fc683206-4faa-4fc8-9b97-e38a4aa35b19');\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",
              "\n",
              "\n",
              "<div id=\"df-09d740a3-d3ca-4a8e-bfba-3ad5873141d7\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-09d740a3-d3ca-4a8e-bfba-3ad5873141d7')\"\n",
              "            title=\"Suggest charts\"\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",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-09d740a3-d3ca-4a8e-bfba-3ad5873141d7 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df"
            }
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "4U9c7lq1nwOI",
        "outputId": "63a6f65b-ce11-4ce3-b54f-af96fcfa781e"
      },
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['bookId', 'title', 'series', 'author', 'rating', 'description',\n",
              "       'language', 'isbn', 'genres', 'characters', 'bookFormat', 'edition',\n",
              "       'pages', 'publisher', 'publishDate', 'firstPublishDate', 'awards',\n",
              "       'numRatings', 'ratingsByStars', 'likedPercent', 'setting', 'coverImg',\n",
              "       'bbeScore', 'bbeVotes', 'price'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Renomear as colunas"
      ],
      "metadata": {
        "id": "BVUcOThmnowa"
      }
    },
    {
      "source": [
        "df = df.rename(columns={'title': 'titulo'})"
      ],
      "cell_type": "code",
      "metadata": {
        "id": "aHDBGsQpoAbw"
      },
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df.columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "e6z3LSn_oCQE",
        "outputId": "7f76dc5a-e965-42ca-9a3f-da8c91bcccad"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['bookId', 'titulo', 'series', 'author', 'rating', 'description',\n",
              "       'language', 'isbn', 'genres', 'characters', 'bookFormat', 'edition',\n",
              "       'pages', 'publisher', 'publishDate', 'firstPublishDate', 'awards',\n",
              "       'numRatings', 'ratingsByStars', 'likedPercent', 'setting', 'coverImg',\n",
              "       'bbeScore', 'bbeVotes', 'price'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Detectar automaticamente o separador:\n",
        " - Use o módulo csv.Sniffer para identificar o separador correto"
      ],
      "metadata": {
        "id": "xM1VtFFZofMp"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "import csv\n",
        "with open('/content/drive/MyDrive/.Dataset/books.csv', 'r', encoding='UTF-8') as file:\n",
        "    dialect = csv.Sniffer().sniff(file.read(1024))\n",
        "    file.seek(0)\n",
        "    df2 = pd.read_csv(file, sep=dialect.delimiter)\n"
      ],
      "metadata": {
        "id": "U4gs10ROoWS0"
      },
      "execution_count": 12,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df2.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 583
        },
        "id": "G4GsiWJroZCW",
        "outputId": "76752213-62ff-49ed-d737-9881489503db"
      },
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                        bookId  \\\n",
              "0                     2767052-the-hunger-games   \n",
              "1  2.Harry_Potter_and_the_Order_of_the_Phoenix   \n",
              "2                   2657.To_Kill_a_Mockingbird   \n",
              "3                     1885.Pride_and_Prejudice   \n",
              "4                               41865.Twilight   \n",
              "\n",
              "                                       title                 series  \\\n",
              "0                           The Hunger Games    The Hunger Games #1   \n",
              "1  Harry Potter and the Order of the Phoenix        Harry Potter #5   \n",
              "2                      To Kill a Mockingbird  To Kill a Mockingbird   \n",
              "3                        Pride and Prejudice                    NaN   \n",
              "4                                   Twilight   The Twilight Saga #1   \n",
              "\n",
              "                                      author  rating  \\\n",
              "0                            Suzanne Collins    4.33   \n",
              "1  J.K. Rowling, Mary GrandPré (Illustrator)    4.50   \n",
              "2                                 Harper Lee    4.28   \n",
              "3  Jane Austen, Anna Quindlen (Introduction)    4.26   \n",
              "4                            Stephenie Meyer    3.60   \n",
              "\n",
              "                                         description language           isbn  \\\n",
              "0  WINNING MEANS FAME AND FORTUNE.LOSING MEANS CE...  English  9780439023481   \n",
              "1  There is a door at the end of a silent corrido...  English  9780439358071   \n",
              "2  The unforgettable novel of a childhood in a sl...  English  9999999999999   \n",
              "3  Alternate cover edition of ISBN 9780679783268S...  English  9999999999999   \n",
              "4  About three things I was absolutely positive.\\...  English  9780316015844   \n",
              "\n",
              "                                              genres  \\\n",
              "0  ['Young Adult', 'Fiction', 'Dystopia', 'Fantas...   \n",
              "1  ['Fantasy', 'Young Adult', 'Fiction', 'Magic',...   \n",
              "2  ['Classics', 'Fiction', 'Historical Fiction', ...   \n",
              "3  ['Classics', 'Fiction', 'Romance', 'Historical...   \n",
              "4  ['Young Adult', 'Fantasy', 'Romance', 'Vampire...   \n",
              "\n",
              "                                          characters  ... firstPublishDate  \\\n",
              "0  ['Katniss Everdeen', 'Peeta Mellark', 'Cato (H...  ...              NaN   \n",
              "1  ['Sirius Black', 'Draco Malfoy', 'Ron Weasley'...  ...         06/21/03   \n",
              "2  ['Scout Finch', 'Atticus Finch', 'Jem Finch', ...  ...         07/11/60   \n",
              "3  ['Mr. Bennet', 'Mrs. Bennet', 'Jane Bennet', '...  ...         01/28/13   \n",
              "4  ['Edward Cullen', 'Jacob Black', 'Laurent', 'R...  ...         10/05/05   \n",
              "\n",
              "                                              awards numRatings  \\\n",
              "0  ['Locus Award Nominee for Best Young Adult Boo...    6376780   \n",
              "1  ['Bram Stoker Award for Works for Young Reader...    2507623   \n",
              "2  ['Pulitzer Prize for Fiction (1961)', 'Audie A...    4501075   \n",
              "3                                                 []    2998241   \n",
              "4  ['Georgia Peach Book Award (2007)', 'Buxtehude...    4964519   \n",
              "\n",
              "                                      ratingsByStars likedPercent  \\\n",
              "0  ['3444695', '1921313', '745221', '171994', '93...         96.0   \n",
              "1  ['1593642', '637516', '222366', '39573', '14526']         98.0   \n",
              "2  ['2363896', '1333153', '573280', '149952', '80...         95.0   \n",
              "3  ['1617567', '816659', '373311', '113934', '767...         94.0   \n",
              "4  ['1751460', '1113682', '1008686', '542017', '5...         78.0   \n",
              "\n",
              "                                             setting  \\\n",
              "0  ['District 12, Panem', 'Capitol, Panem', 'Pane...   \n",
              "1  ['Hogwarts School of Witchcraft and Wizardry (...   \n",
              "2               ['Maycomb, Alabama (United States)']   \n",
              "3  ['United Kingdom', 'Derbyshire, England (Unite...   \n",
              "4  ['Forks, Washington (United States)', 'Phoenix...   \n",
              "\n",
              "                                            coverImg  bbeScore bbeVotes  price  \n",
              "0  https://i.gr-assets.com/images/S/compressed.ph...   2993816    30516   5.09  \n",
              "1  https://i.gr-assets.com/images/S/compressed.ph...   2632233    26923   7.38  \n",
              "2  https://i.gr-assets.com/images/S/compressed.ph...   2269402    23328    NaN  \n",
              "3  https://i.gr-assets.com/images/S/compressed.ph...   1983116    20452    NaN  \n",
              "4  https://i.gr-assets.com/images/S/compressed.ph...   1459448    14874    2.1  \n",
              "\n",
              "[5 rows x 25 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-fbb56a14-2da0-4710-b663-093a4823aff5\" 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>bookId</th>\n",
              "      <th>title</th>\n",
              "      <th>series</th>\n",
              "      <th>author</th>\n",
              "      <th>rating</th>\n",
              "      <th>description</th>\n",
              "      <th>language</th>\n",
              "      <th>isbn</th>\n",
              "      <th>genres</th>\n",
              "      <th>characters</th>\n",
              "      <th>...</th>\n",
              "      <th>firstPublishDate</th>\n",
              "      <th>awards</th>\n",
              "      <th>numRatings</th>\n",
              "      <th>ratingsByStars</th>\n",
              "      <th>likedPercent</th>\n",
              "      <th>setting</th>\n",
              "      <th>coverImg</th>\n",
              "      <th>bbeScore</th>\n",
              "      <th>bbeVotes</th>\n",
              "      <th>price</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2767052-the-hunger-games</td>\n",
              "      <td>The Hunger Games</td>\n",
              "      <td>The Hunger Games #1</td>\n",
              "      <td>Suzanne Collins</td>\n",
              "      <td>4.33</td>\n",
              "      <td>WINNING MEANS FAME AND FORTUNE.LOSING MEANS CE...</td>\n",
              "      <td>English</td>\n",
              "      <td>9780439023481</td>\n",
              "      <td>['Young Adult', 'Fiction', 'Dystopia', 'Fantas...</td>\n",
              "      <td>['Katniss Everdeen', 'Peeta Mellark', 'Cato (H...</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>['Locus Award Nominee for Best Young Adult Boo...</td>\n",
              "      <td>6376780</td>\n",
              "      <td>['3444695', '1921313', '745221', '171994', '93...</td>\n",
              "      <td>96.0</td>\n",
              "      <td>['District 12, Panem', 'Capitol, Panem', 'Pane...</td>\n",
              "      <td>https://i.gr-assets.com/images/S/compressed.ph...</td>\n",
              "      <td>2993816</td>\n",
              "      <td>30516</td>\n",
              "      <td>5.09</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2.Harry_Potter_and_the_Order_of_the_Phoenix</td>\n",
              "      <td>Harry Potter and the Order of the Phoenix</td>\n",
              "      <td>Harry Potter #5</td>\n",
              "      <td>J.K. Rowling, Mary GrandPré (Illustrator)</td>\n",
              "      <td>4.50</td>\n",
              "      <td>There is a door at the end of a silent corrido...</td>\n",
              "      <td>English</td>\n",
              "      <td>9780439358071</td>\n",
              "      <td>['Fantasy', 'Young Adult', 'Fiction', 'Magic',...</td>\n",
              "      <td>['Sirius Black', 'Draco Malfoy', 'Ron Weasley'...</td>\n",
              "      <td>...</td>\n",
              "      <td>06/21/03</td>\n",
              "      <td>['Bram Stoker Award for Works for Young Reader...</td>\n",
              "      <td>2507623</td>\n",
              "      <td>['1593642', '637516', '222366', '39573', '14526']</td>\n",
              "      <td>98.0</td>\n",
              "      <td>['Hogwarts School of Witchcraft and Wizardry (...</td>\n",
              "      <td>https://i.gr-assets.com/images/S/compressed.ph...</td>\n",
              "      <td>2632233</td>\n",
              "      <td>26923</td>\n",
              "      <td>7.38</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2657.To_Kill_a_Mockingbird</td>\n",
              "      <td>To Kill a Mockingbird</td>\n",
              "      <td>To Kill a Mockingbird</td>\n",
              "      <td>Harper Lee</td>\n",
              "      <td>4.28</td>\n",
              "      <td>The unforgettable novel of a childhood in a sl...</td>\n",
              "      <td>English</td>\n",
              "      <td>9999999999999</td>\n",
              "      <td>['Classics', 'Fiction', 'Historical Fiction', ...</td>\n",
              "      <td>['Scout Finch', 'Atticus Finch', 'Jem Finch', ...</td>\n",
              "      <td>...</td>\n",
              "      <td>07/11/60</td>\n",
              "      <td>['Pulitzer Prize for Fiction (1961)', 'Audie A...</td>\n",
              "      <td>4501075</td>\n",
              "      <td>['2363896', '1333153', '573280', '149952', '80...</td>\n",
              "      <td>95.0</td>\n",
              "      <td>['Maycomb, Alabama (United States)']</td>\n",
              "      <td>https://i.gr-assets.com/images/S/compressed.ph...</td>\n",
              "      <td>2269402</td>\n",
              "      <td>23328</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1885.Pride_and_Prejudice</td>\n",
              "      <td>Pride and Prejudice</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Jane Austen, Anna Quindlen (Introduction)</td>\n",
              "      <td>4.26</td>\n",
              "      <td>Alternate cover edition of ISBN 9780679783268S...</td>\n",
              "      <td>English</td>\n",
              "      <td>9999999999999</td>\n",
              "      <td>['Classics', 'Fiction', 'Romance', 'Historical...</td>\n",
              "      <td>['Mr. Bennet', 'Mrs. Bennet', 'Jane Bennet', '...</td>\n",
              "      <td>...</td>\n",
              "      <td>01/28/13</td>\n",
              "      <td>[]</td>\n",
              "      <td>2998241</td>\n",
              "      <td>['1617567', '816659', '373311', '113934', '767...</td>\n",
              "      <td>94.0</td>\n",
              "      <td>['United Kingdom', 'Derbyshire, England (Unite...</td>\n",
              "      <td>https://i.gr-assets.com/images/S/compressed.ph...</td>\n",
              "      <td>1983116</td>\n",
              "      <td>20452</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>41865.Twilight</td>\n",
              "      <td>Twilight</td>\n",
              "      <td>The Twilight Saga #1</td>\n",
              "      <td>Stephenie Meyer</td>\n",
              "      <td>3.60</td>\n",
              "      <td>About three things I was absolutely positive.\\...</td>\n",
              "      <td>English</td>\n",
              "      <td>9780316015844</td>\n",
              "      <td>['Young Adult', 'Fantasy', 'Romance', 'Vampire...</td>\n",
              "      <td>['Edward Cullen', 'Jacob Black', 'Laurent', 'R...</td>\n",
              "      <td>...</td>\n",
              "      <td>10/05/05</td>\n",
              "      <td>['Georgia Peach Book Award (2007)', 'Buxtehude...</td>\n",
              "      <td>4964519</td>\n",
              "      <td>['1751460', '1113682', '1008686', '542017', '5...</td>\n",
              "      <td>78.0</td>\n",
              "      <td>['Forks, Washington (United States)', 'Phoenix...</td>\n",
              "      <td>https://i.gr-assets.com/images/S/compressed.ph...</td>\n",
              "      <td>1459448</td>\n",
              "      <td>14874</td>\n",
              "      <td>2.1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 25 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fbb56a14-2da0-4710-b663-093a4823aff5')\"\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 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\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",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\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-fbb56a14-2da0-4710-b663-093a4823aff5 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-fbb56a14-2da0-4710-b663-093a4823aff5');\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",
              "\n",
              "\n",
              "<div id=\"df-25aa2ebe-74a1-43e9-bcf2-2b73692919b4\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-25aa2ebe-74a1-43e9-bcf2-2b73692919b4')\"\n",
              "            title=\"Suggest charts\"\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",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-25aa2ebe-74a1-43e9-bcf2-2b73692919b4 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df2"
            }
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "renomeia coluna"
      ],
      "metadata": {
        "id": "lAdh5CUWpldT"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df2.rename(columns={'title': 'titulo', 'author': 'autor', 'description': 'descricao', 'setting': 'config'},  inplace=True)"
      ],
      "metadata": {
        "id": "2e1LjokGo7PE"
      },
      "execution_count": 16,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df2.columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "NJzByUXfpLja",
        "outputId": "cfa06c73-a523-49b2-c768-60aee7e4b225"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['bookId', 'titulo', 'series', 'autor', 'rating', 'descricao',\n",
              "       'language', 'isbn', 'genres', 'characters', 'bookFormat', 'edition',\n",
              "       'pages', 'publisher', 'publishDate', 'firstPublishDate', 'awards',\n",
              "       'numRatings', 'ratingsByStars', 'likedPercent', 'config', 'coverImg',\n",
              "       'bbeScore', 'bbeVotes', 'price'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df2.count()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 868
        },
        "id": "Z67tJDgepqOG",
        "outputId": "de75f8e0-fe3b-4002-cc61-63a084c76986"
      },
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "bookId              52478\n",
              "titulo              52478\n",
              "series              23470\n",
              "autor               52478\n",
              "rating              52478\n",
              "descricao           51140\n",
              "language            48672\n",
              "isbn                52478\n",
              "genres              52478\n",
              "characters          52478\n",
              "bookFormat          51005\n",
              "edition              4955\n",
              "pages               50131\n",
              "publisher           48782\n",
              "publishDate         51598\n",
              "firstPublishDate    31152\n",
              "awards              52478\n",
              "numRatings          52478\n",
              "ratingsByStars      52478\n",
              "likedPercent        51856\n",
              "config              52478\n",
              "coverImg            51873\n",
              "bbeScore            52478\n",
              "bbeVotes            52478\n",
              "price               38113\n",
              "dtype: int64"
            ],
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>0</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>bookId</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>titulo</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>series</th>\n",
              "      <td>23470</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>autor</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>rating</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>descricao</th>\n",
              "      <td>51140</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>language</th>\n",
              "      <td>48672</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>isbn</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>genres</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>characters</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>bookFormat</th>\n",
              "      <td>51005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>edition</th>\n",
              "      <td>4955</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>pages</th>\n",
              "      <td>50131</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>publisher</th>\n",
              "      <td>48782</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>publishDate</th>\n",
              "      <td>51598</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>firstPublishDate</th>\n",
              "      <td>31152</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>awards</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>numRatings</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>ratingsByStars</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>likedPercent</th>\n",
              "      <td>51856</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>config</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>coverImg</th>\n",
              "      <td>51873</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>bbeScore</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>bbeVotes</th>\n",
              "      <td>52478</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>price</th>\n",
              "      <td>38113</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div><br><label><b>dtype:</b> int64</label>"
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(df2.head())\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "JRPf_Nw5rYfz",
        "outputId": "bfbc7354-80b0-44c5-ff03-ca14547a4320"
      },
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "       bookId  titulo  series  autor  rating  descricao  language  isbn  \\\n",
            "price                                                                     \n",
            "0.84      146     146      80    146     146        143       139   146   \n",
            "0.85      188     188     103    188     188        188       184   188   \n",
            "0.86       19      19      13     19      19         19        17    19   \n",
            "0.87       31      31      14     31      31         30        31    31   \n",
            "0.88       54      54      15     54      54         54        49    54   \n",
            "\n",
            "       genres  characters  ...  publishDate  firstPublishDate  awards  \\\n",
            "price                      ...                                          \n",
            "0.84      146         146  ...          143                95     146   \n",
            "0.85      188         188  ...          187               128     188   \n",
            "0.86       19          19  ...           17                14      19   \n",
            "0.87       31          31  ...           31                20      31   \n",
            "0.88       54          54  ...           54                41      54   \n",
            "\n",
            "       numRatings  ratingsByStars  likedPercent  config  coverImg  bbeScore  \\\n",
            "price                                                                         \n",
            "0.84          146             146           144     146       146       146   \n",
            "0.85          188             188           188     188       188       188   \n",
            "0.86           19              19            19      19        19        19   \n",
            "0.87           31              31            31      31        31        31   \n",
            "0.88           54              54            54      54        53        54   \n",
            "\n",
            "       bbeVotes  \n",
            "price            \n",
            "0.84        146  \n",
            "0.85        188  \n",
            "0.86         19  \n",
            "0.87         31  \n",
            "0.88         54  \n",
            "\n",
            "[5 rows x 24 columns]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "valor = df2.groupby('price').sum()\n",
        "print(f'Valor é:\\n{valor}')\n",
        "\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "8DMvgTsQrczj",
        "outputId": "fad7d40d-1d90-4254-f601-5d7df87b43f7"
      },
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Valor é:\n",
            "       bookId  titulo  series  autor  rating  descricao  language  isbn  \\\n",
            "price                                                                     \n",
            "0.84      146     146      80    146     146        143       139   146   \n",
            "0.85      188     188     103    188     188        188       184   188   \n",
            "0.86       19      19      13     19      19         19        17    19   \n",
            "0.87       31      31      14     31      31         30        31    31   \n",
            "0.88       54      54      15     54      54         54        49    54   \n",
            "...       ...     ...     ...    ...     ...        ...       ...   ...   \n",
            "98.97       1       1       0      1       1          1         1     1   \n",
            "99.20       1       1       1      1       1          1         1     1   \n",
            "99.26       1       1       0      1       1          1         1     1   \n",
            "99.51       1       1       0      1       1          1         1     1   \n",
            "99.96       1       1       0      1       1          1         1     1   \n",
            "\n",
            "       genres  characters  ...  publishDate  firstPublishDate  awards  \\\n",
            "price                      ...                                          \n",
            "0.84      146         146  ...          143                95     146   \n",
            "0.85      188         188  ...          187               128     188   \n",
            "0.86       19          19  ...           17                14      19   \n",
            "0.87       31          31  ...           31                20      31   \n",
            "0.88       54          54  ...           54                41      54   \n",
            "...       ...         ...  ...          ...               ...     ...   \n",
            "98.97       1           1  ...            1                 1       1   \n",
            "99.20       1           1  ...            1                 0       1   \n",
            "99.26       1           1  ...            1                 1       1   \n",
            "99.51       1           1  ...            1                 1       1   \n",
            "99.96       1           1  ...            1                 0       1   \n",
            "\n",
            "       numRatings  ratingsByStars  likedPercent  config  coverImg  bbeScore  \\\n",
            "price                                                                         \n",
            "0.84          146             146           144     146       146       146   \n",
            "0.85          188             188           188     188       188       188   \n",
            "0.86           19              19            19      19        19        19   \n",
            "0.87           31              31            31      31        31        31   \n",
            "0.88           54              54            54      54        53        54   \n",
            "...           ...             ...           ...     ...       ...       ...   \n",
            "98.97           1               1             1       1         1         1   \n",
            "99.20           1               1             1       1         1         1   \n",
            "99.26           1               1             1       1         1         1   \n",
            "99.51           1               1             1       1         1         1   \n",
            "99.96           1               1             1       1         1         1   \n",
            "\n",
            "       bbeVotes  \n",
            "price            \n",
            "0.84        146  \n",
            "0.85        188  \n",
            "0.86         19  \n",
            "0.87         31  \n",
            "0.88         54  \n",
            "...         ...  \n",
            "98.97         1  \n",
            "99.20         1  \n",
            "99.26         1  \n",
            "99.51         1  \n",
            "99.96         1  \n",
            "\n",
            "[3776 rows x 24 columns]\n"
          ]
        }
      ]
    },
    {
      "source": [
        "print(df2.dtypes)"
      ],
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tppB2Rxurtl_",
        "outputId": "89a6b3be-cc97-4b1a-c5f5-13d6e0fe513b"
      },
      "execution_count": 34,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "bookId              int64\n",
            "titulo              int64\n",
            "series              int64\n",
            "autor               int64\n",
            "rating              int64\n",
            "descricao           int64\n",
            "language            int64\n",
            "isbn                int64\n",
            "genres              int64\n",
            "characters          int64\n",
            "bookFormat          int64\n",
            "edition             int64\n",
            "pages               int64\n",
            "publisher           int64\n",
            "publishDate         int64\n",
            "firstPublishDate    int64\n",
            "awards              int64\n",
            "numRatings          int64\n",
            "ratingsByStars      int64\n",
            "likedPercent        int64\n",
            "config              int64\n",
            "coverImg            int64\n",
            "bbeScore            int64\n",
            "bbeVotes            int64\n",
            "dtype: object\n"
          ]
        }
      ]
    },
    {
      "source": [
        "valor = df2.groupby('price').sum()\n",
        "print(F'Valor é : {valor}')"
      ],
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "8R-1dBO0rCgf",
        "outputId": "336d8fa7-d64f-4af1-bb37-58aea5655f2e"
      },
      "execution_count": 35,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Valor é :        bookId  titulo  series  autor  rating  descricao  language  isbn  \\\n",
            "price                                                                     \n",
            "0.84      146     146      80    146     146        143       139   146   \n",
            "0.85      188     188     103    188     188        188       184   188   \n",
            "0.86       19      19      13     19      19         19        17    19   \n",
            "0.87       31      31      14     31      31         30        31    31   \n",
            "0.88       54      54      15     54      54         54        49    54   \n",
            "...       ...     ...     ...    ...     ...        ...       ...   ...   \n",
            "98.97       1       1       0      1       1          1         1     1   \n",
            "99.20       1       1       1      1       1          1         1     1   \n",
            "99.26       1       1       0      1       1          1         1     1   \n",
            "99.51       1       1       0      1       1          1         1     1   \n",
            "99.96       1       1       0      1       1          1         1     1   \n",
            "\n",
            "       genres  characters  ...  publishDate  firstPublishDate  awards  \\\n",
            "price                      ...                                          \n",
            "0.84      146         146  ...          143                95     146   \n",
            "0.85      188         188  ...          187               128     188   \n",
            "0.86       19          19  ...           17                14      19   \n",
            "0.87       31          31  ...           31                20      31   \n",
            "0.88       54          54  ...           54                41      54   \n",
            "...       ...         ...  ...          ...               ...     ...   \n",
            "98.97       1           1  ...            1                 1       1   \n",
            "99.20       1           1  ...            1                 0       1   \n",
            "99.26       1           1  ...            1                 1       1   \n",
            "99.51       1           1  ...            1                 1       1   \n",
            "99.96       1           1  ...            1                 0       1   \n",
            "\n",
            "       numRatings  ratingsByStars  likedPercent  config  coverImg  bbeScore  \\\n",
            "price                                                                         \n",
            "0.84          146             146           144     146       146       146   \n",
            "0.85          188             188           188     188       188       188   \n",
            "0.86           19              19            19      19        19        19   \n",
            "0.87           31              31            31      31        31        31   \n",
            "0.88           54              54            54      54        53        54   \n",
            "...           ...             ...           ...     ...       ...       ...   \n",
            "98.97           1               1             1       1         1         1   \n",
            "99.20           1               1             1       1         1         1   \n",
            "99.26           1               1             1       1         1         1   \n",
            "99.51           1               1             1       1         1         1   \n",
            "99.96           1               1             1       1         1         1   \n",
            "\n",
            "       bbeVotes  \n",
            "price            \n",
            "0.84        146  \n",
            "0.85        188  \n",
            "0.86         19  \n",
            "0.87         31  \n",
            "0.88         54  \n",
            "...         ...  \n",
            "98.97         1  \n",
            "99.20         1  \n",
            "99.26         1  \n",
            "99.51         1  \n",
            "99.96         1  \n",
            "\n",
            "[3776 rows x 24 columns]\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(valor.columns)\n",
        "\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Wlfq5h3MsILf",
        "outputId": "9f18d3d2-0dcf-4db3-d594-049c250cdc09"
      },
      "execution_count": 40,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Index(['bookId', 'titulo', 'series', 'autor', 'rating', 'descricao',\n",
            "       'language', 'isbn', 'genres', 'characters', 'bookFormat', 'edition',\n",
            "       'pages', 'publisher', 'publishDate', 'firstPublishDate', 'awards',\n",
            "       'numRatings', 'ratingsByStars', 'likedPercent', 'config', 'coverImg',\n",
            "       'bbeScore', 'bbeVotes'],\n",
            "      dtype='object')\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "92qB6nXITGPg"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}