Skip to content

Instantly share code, notes, and snippets.

@mulrdkm

mulrdkm/muliansyah_rasdakim.ipynb

Last active March 25, 2023 11:24
Show Gist options
  • Save mulrdkm/e500ea3b92761e475be213e386a678cc to your computer and use it in GitHub Desktop.
Save mulrdkm/e500ea3b92761e475be213e386a678cc to your computer and use it in GitHub Desktop.
Download ZIP
Muliansyah_Rasdakim.ipynb
Display the source blob
Display the rendered blob
Raw
muliansyah_rasdakim.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/mulrdkm/e500ea3b92761e475be213e386a678cc/muliansyah_rasdakim.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "markdown",
"id": "ae0654e1",
"metadata": {
"id": "ae0654e1"
},
"source": [
"### Homework Rakamin Trial Class - Mini Case"
]
},
{
"cell_type": "markdown",
"id": "578645f2",
"metadata": {
"id": "578645f2"
},
"source": [
"# Mengukur Performa Penjualan Ritel Online"
]
},
{
"cell_type": "markdown",
"id": "ebf52fe7",
"metadata": {
"id": "ebf52fe7"
},
"source": [
"## Load Data"
]
},
{
"cell_type": "code",
"source": [
"from google.colab import drive\n",
"drive.mount('/content/drive/')"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "g0C5Y79WshO-",
"outputId": "b0122d07-58a9-42e9-e2f2-0564eb71c89b"
},
"id": "g0C5Y79WshO-",
"execution_count": null,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"Mounted at /content/drive/\n"
]
}
]
},
{
"cell_type": "code",
"source": [
"import pandas as pd\n",
"import matplotlib.pyplot as plt\n",
"import seaborn as sns"
],
"metadata": {
"id": "YBMF9LW9rkx7"
},
"id": "YBMF9LW9rkx7",
"execution_count": null,
"outputs": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "6c4b0183",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 423
},
"id": "6c4b0183",
"outputId": "8580e6a1-7c40-4202-cd53-286b5b3165bf"
},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Invoice StockCode Description Quantity \\\n",
"0 489434 85048 15CM CHRISTMAS GLASS BALL 20 LIGHTS 12 \n",
"1 489434 79323P PINK CHERRY LIGHTS 12 \n",
"2 489434 79323W WHITE CHERRY LIGHTS 12 \n",
"3 489434 22041 RECORD FRAME 7\" SINGLE SIZE 48 \n",
"4 489434 21232 STRAWBERRY CERAMIC TRINKET BOX 24 \n",
"... ... ... ... ... \n",
"1067366 581587 22899 CHILDREN'S APRON DOLLY GIRL 6 \n",
"1067367 581587 23254 CHILDRENS CUTLERY DOLLY GIRL 4 \n",
"1067368 581587 23255 CHILDRENS CUTLERY CIRCUS PARADE 4 \n",
"1067369 581587 22138 BAKING SET 9 PIECE RETROSPOT 3 \n",
"1067370 581587 POST POSTAGE 1 \n",
"\n",
" InvoiceDate Price Customer ID Country \n",
"0 2009-12-01 07:45:00 6.95 13085.0 United Kingdom \n",
"1 2009-12-01 07:45:00 6.75 13085.0 United Kingdom \n",
"2 2009-12-01 07:45:00 6.75 13085.0 United Kingdom \n",
"3 2009-12-01 07:45:00 2.10 13085.0 United Kingdom \n",
"4 2009-12-01 07:45:00 1.25 13085.0 United Kingdom \n",
"... ... ... ... ... \n",
"1067366 2011-12-09 12:50:00 2.10 12680.0 France \n",
"1067367 2011-12-09 12:50:00 4.15 12680.0 France \n",
"1067368 2011-12-09 12:50:00 4.15 12680.0 France \n",
"1067369 2011-12-09 12:50:00 4.95 12680.0 France \n",
"1067370 2011-12-09 12:50:00 18.00 12680.0 France \n",
"\n",
"[1067371 rows x 8 columns]"
],
"text/html": [
"\n",
" <div id=\"df-ad6c840f-8f59-4d6f-a5c3-738de8019012\">\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>Invoice</th>\n",
" <th>StockCode</th>\n",
" <th>Description</th>\n",
" <th>Quantity</th>\n",
" <th>InvoiceDate</th>\n",
" <th>Price</th>\n",
" <th>Customer ID</th>\n",
" <th>Country</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>489434</td>\n",
" <td>85048</td>\n",
" <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.95</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>489434</td>\n",
" <td>79323P</td>\n",
" <td>PINK CHERRY LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.75</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>489434</td>\n",
" <td>79323W</td>\n",
" <td>WHITE CHERRY LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.75</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>489434</td>\n",
" <td>22041</td>\n",
" <td>RECORD FRAME 7\" SINGLE SIZE</td>\n",
" <td>48</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>2.10</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>489434</td>\n",
" <td>21232</td>\n",
" <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n",
" <td>24</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>1.25</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</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",
" </tr>\n",
" <tr>\n",
" <th>1067366</th>\n",
" <td>581587</td>\n",
" <td>22899</td>\n",
" <td>CHILDREN'S APRON DOLLY GIRL</td>\n",
" <td>6</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>2.10</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1067367</th>\n",
" <td>581587</td>\n",
" <td>23254</td>\n",
" <td>CHILDRENS CUTLERY DOLLY GIRL</td>\n",
" <td>4</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.15</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1067368</th>\n",
" <td>581587</td>\n",
" <td>23255</td>\n",
" <td>CHILDRENS CUTLERY CIRCUS PARADE</td>\n",
" <td>4</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.15</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1067369</th>\n",
" <td>581587</td>\n",
" <td>22138</td>\n",
" <td>BAKING SET 9 PIECE RETROSPOT</td>\n",
" <td>3</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.95</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1067370</th>\n",
" <td>581587</td>\n",
" <td>POST</td>\n",
" <td>POSTAGE</td>\n",
" <td>1</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>18.00</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1067371 rows × 8 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ad6c840f-8f59-4d6f-a5c3-738de8019012')\"\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-ad6c840f-8f59-4d6f-a5c3-738de8019012 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-ad6c840f-8f59-4d6f-a5c3-738de8019012');\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": 3
}
],
"source": [
"data = pd.read_csv('/content/drive/MyDrive/Dataset/online_retail_II.csv')\n",
"data"
]
},
{
"cell_type": "markdown",
"source": [
"Pembahasan tentang ai, teknologi dan lainnya dapat di temukan diblog [teknologi](https://https://www.eighttails.xyz/) saya."
],
"metadata": {
"id": "HGq4i8qh2N7N"
},
"id": "HGq4i8qh2N7N"
},
{
"cell_type": "markdown",
"id": "794e2063",
"metadata": {
"id": "794e2063"
},
"source": [
"## Section 1"
]
},
{
"cell_type": "markdown",
"id": "0ead195f",
"metadata": {
"id": "0ead195f"
},
"source": [
"### Create New Feature: Year"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "5a1281e7",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 423
},
"id": "5a1281e7",
"outputId": "367d6a64-f9ab-4956-b114-7f352c7e0621"
},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Invoice StockCode Description Quantity \\\n",
"0 489434 85048 15CM CHRISTMAS GLASS BALL 20 LIGHTS 12 \n",
"1 489434 79323P PINK CHERRY LIGHTS 12 \n",
"2 489434 79323W WHITE CHERRY LIGHTS 12 \n",
"3 489434 22041 RECORD FRAME 7\" SINGLE SIZE 48 \n",
"4 489434 21232 STRAWBERRY CERAMIC TRINKET BOX 24 \n",
"... ... ... ... ... \n",
"1067366 581587 22899 CHILDREN'S APRON DOLLY GIRL 6 \n",
"1067367 581587 23254 CHILDRENS CUTLERY DOLLY GIRL 4 \n",
"1067368 581587 23255 CHILDRENS CUTLERY CIRCUS PARADE 4 \n",
"1067369 581587 22138 BAKING SET 9 PIECE RETROSPOT 3 \n",
"1067370 581587 POST POSTAGE 1 \n",
"\n",
" InvoiceDate Price Customer ID Country Year \n",
"0 2009-12-01 07:45:00 6.95 13085.0 United Kingdom 2009 \n",
"1 2009-12-01 07:45:00 6.75 13085.0 United Kingdom 2009 \n",
"2 2009-12-01 07:45:00 6.75 13085.0 United Kingdom 2009 \n",
"3 2009-12-01 07:45:00 2.10 13085.0 United Kingdom 2009 \n",
"4 2009-12-01 07:45:00 1.25 13085.0 United Kingdom 2009 \n",
"... ... ... ... ... ... \n",
"1067366 2011-12-09 12:50:00 2.10 12680.0 France 2011 \n",
"1067367 2011-12-09 12:50:00 4.15 12680.0 France 2011 \n",
"1067368 2011-12-09 12:50:00 4.15 12680.0 France 2011 \n",
"1067369 2011-12-09 12:50:00 4.95 12680.0 France 2011 \n",
"1067370 2011-12-09 12:50:00 18.00 12680.0 France 2011 \n",
"\n",
"[1067371 rows x 9 columns]"
],
"text/html": [
"\n",
" <div id=\"df-80a6aba5-d449-48f9-b695-5d22c5dcef49\">\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>Invoice</th>\n",
" <th>StockCode</th>\n",
" <th>Description</th>\n",
" <th>Quantity</th>\n",
" <th>InvoiceDate</th>\n",
" <th>Price</th>\n",
" <th>Customer ID</th>\n",
" <th>Country</th>\n",
" <th>Year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>489434</td>\n",
" <td>85048</td>\n",
" <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.95</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>489434</td>\n",
" <td>79323P</td>\n",
" <td>PINK CHERRY LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.75</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>489434</td>\n",
" <td>79323W</td>\n",
" <td>WHITE CHERRY LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.75</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>489434</td>\n",
" <td>22041</td>\n",
" <td>RECORD FRAME 7\" SINGLE SIZE</td>\n",
" <td>48</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>2.10</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>489434</td>\n",
" <td>21232</td>\n",
" <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n",
" <td>24</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>1.25</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</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",
" </tr>\n",
" <tr>\n",
" <th>1067366</th>\n",
" <td>581587</td>\n",
" <td>22899</td>\n",
" <td>CHILDREN'S APRON DOLLY GIRL</td>\n",
" <td>6</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>2.10</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1067367</th>\n",
" <td>581587</td>\n",
" <td>23254</td>\n",
" <td>CHILDRENS CUTLERY DOLLY GIRL</td>\n",
" <td>4</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.15</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1067368</th>\n",
" <td>581587</td>\n",
" <td>23255</td>\n",
" <td>CHILDRENS CUTLERY CIRCUS PARADE</td>\n",
" <td>4</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.15</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1067369</th>\n",
" <td>581587</td>\n",
" <td>22138</td>\n",
" <td>BAKING SET 9 PIECE RETROSPOT</td>\n",
" <td>3</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.95</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1067370</th>\n",
" <td>581587</td>\n",
" <td>POST</td>\n",
" <td>POSTAGE</td>\n",
" <td>1</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>18.00</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1067371 rows × 9 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-80a6aba5-d449-48f9-b695-5d22c5dcef49')\"\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-80a6aba5-d449-48f9-b695-5d22c5dcef49 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-80a6aba5-d449-48f9-b695-5d22c5dcef49');\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": 4
}
],
"source": [
"#Mengubah tipe data InvoiceDate ke datetime\n",
"pd.to_datetime(data['InvoiceDate'])\n",
"\n",
"#Menambah coloum Year dengan Value dari Tahun InvoiceDate\n",
"data[\"Year\"]= pd.DatetimeIndex(data['InvoiceDate']).year\n",
"data"
]
},
{
"cell_type": "markdown",
"id": "9a9f5438",
"metadata": {
"id": "9a9f5438"
},
"source": [
"### Filtering Data"
]
},
{
"cell_type": "markdown",
"source": [
"Buat filtering data dengan ketentuan di bawah ini dan simpan dalam variabel baru,\n",
"misalnya sales\n",
"- Quantity minimal 1 (tidak boleh 0 dan minus)\n",
"- Kolom Invoice tidak mengandung huruf ‘C’ karena hal tersebut menandakan\n",
"pelanggan tidak menyelesaikan belanjanya atau melakukan pembatalan."
],
"metadata": {
"id": "emGVcyGEw3Ob"
},
"id": "emGVcyGEw3Ob"
},
{
"cell_type": "code",
"execution_count": null,
"id": "547a9e99",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 658
},
"id": "547a9e99",
"outputId": "1844348e-b734-4efe-82a9-eb4a80546cdd"
},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" index Invoice StockCode Description \\\n",
"0 0 489434 85048 15CM CHRISTMAS GLASS BALL 20 LIGHTS \n",
"1 1 489434 79323P PINK CHERRY LIGHTS \n",
"2 2 489434 79323W WHITE CHERRY LIGHTS \n",
"3 3 489434 22041 RECORD FRAME 7\" SINGLE SIZE \n",
"4 4 489434 21232 STRAWBERRY CERAMIC TRINKET BOX \n",
"... ... ... ... ... \n",
"1044415 1067366 581587 22899 CHILDREN'S APRON DOLLY GIRL \n",
"1044416 1067367 581587 23254 CHILDRENS CUTLERY DOLLY GIRL \n",
"1044417 1067368 581587 23255 CHILDRENS CUTLERY CIRCUS PARADE \n",
"1044418 1067369 581587 22138 BAKING SET 9 PIECE RETROSPOT \n",
"1044419 1067370 581587 POST POSTAGE \n",
"\n",
" Quantity InvoiceDate Price Customer ID Country \\\n",
"0 12 2009-12-01 07:45:00 6.95 13085.0 United Kingdom \n",
"1 12 2009-12-01 07:45:00 6.75 13085.0 United Kingdom \n",
"2 12 2009-12-01 07:45:00 6.75 13085.0 United Kingdom \n",
"3 48 2009-12-01 07:45:00 2.10 13085.0 United Kingdom \n",
"4 24 2009-12-01 07:45:00 1.25 13085.0 United Kingdom \n",
"... ... ... ... ... ... \n",
"1044415 6 2011-12-09 12:50:00 2.10 12680.0 France \n",
"1044416 4 2011-12-09 12:50:00 4.15 12680.0 France \n",
"1044417 4 2011-12-09 12:50:00 4.15 12680.0 France \n",
"1044418 3 2011-12-09 12:50:00 4.95 12680.0 France \n",
"1044419 1 2011-12-09 12:50:00 18.00 12680.0 France \n",
"\n",
" Year \n",
"0 2009 \n",
"1 2009 \n",
"2 2009 \n",
"3 2009 \n",
"4 2009 \n",
"... ... \n",
"1044415 2011 \n",
"1044416 2011 \n",
"1044417 2011 \n",
"1044418 2011 \n",
"1044419 2011 \n",
"\n",
"[1044420 rows x 10 columns]"
],
"text/html": [
"\n",
" <div id=\"df-360e4233-0f8c-4af3-916d-4d4b7ac295ac\">\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>index</th>\n",
" <th>Invoice</th>\n",
" <th>StockCode</th>\n",
" <th>Description</th>\n",
" <th>Quantity</th>\n",
" <th>InvoiceDate</th>\n",
" <th>Price</th>\n",
" <th>Customer ID</th>\n",
" <th>Country</th>\n",
" <th>Year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0</td>\n",
" <td>489434</td>\n",
" <td>85048</td>\n",
" <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.95</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1</td>\n",
" <td>489434</td>\n",
" <td>79323P</td>\n",
" <td>PINK CHERRY LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.75</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2</td>\n",
" <td>489434</td>\n",
" <td>79323W</td>\n",
" <td>WHITE CHERRY LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.75</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>3</td>\n",
" <td>489434</td>\n",
" <td>22041</td>\n",
" <td>RECORD FRAME 7\" SINGLE SIZE</td>\n",
" <td>48</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>2.10</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>4</td>\n",
" <td>489434</td>\n",
" <td>21232</td>\n",
" <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n",
" <td>24</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>1.25</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</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",
" </tr>\n",
" <tr>\n",
" <th>1044415</th>\n",
" <td>1067366</td>\n",
" <td>581587</td>\n",
" <td>22899</td>\n",
" <td>CHILDREN'S APRON DOLLY GIRL</td>\n",
" <td>6</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>2.10</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1044416</th>\n",
" <td>1067367</td>\n",
" <td>581587</td>\n",
" <td>23254</td>\n",
" <td>CHILDRENS CUTLERY DOLLY GIRL</td>\n",
" <td>4</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.15</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1044417</th>\n",
" <td>1067368</td>\n",
" <td>581587</td>\n",
" <td>23255</td>\n",
" <td>CHILDRENS CUTLERY CIRCUS PARADE</td>\n",
" <td>4</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.15</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1044418</th>\n",
" <td>1067369</td>\n",
" <td>581587</td>\n",
" <td>22138</td>\n",
" <td>BAKING SET 9 PIECE RETROSPOT</td>\n",
" <td>3</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.95</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1044419</th>\n",
" <td>1067370</td>\n",
" <td>581587</td>\n",
" <td>POST</td>\n",
" <td>POSTAGE</td>\n",
" <td>1</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>18.00</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1044420 rows × 10 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-360e4233-0f8c-4af3-916d-4d4b7ac295ac')\"\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-360e4233-0f8c-4af3-916d-4d4b7ac295ac 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-360e4233-0f8c-4af3-916d-4d4b7ac295ac');\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": 6
}
],
"source": [
"#Filtering Quantity minimal 1 dan Kolom Invoice tidak mengandung huruf ‘C’\n",
"\n",
"Data_Quantity_Minimal_NoC_Invoice = data[(data['Quantity'] >= 1) & (~data['Invoice'].str.contains(\"C\"))].reset_index()\n",
"Data_Quantity_Minimal_NoC_Invoice"
]
},
{
"cell_type": "markdown",
"id": "0bef109f",
"metadata": {
"id": "0bef109f"
},
"source": [
"### Create New Feature: Revenue"
]
},
{
"cell_type": "markdown",
"source": [
"Buat kolom baru bernama Revenue dengan nilai Quantity dikali dengan Price"
],
"metadata": {
"id": "-P4r4o893GC1"
},
"id": "-P4r4o893GC1"
},
{
"cell_type": "code",
"execution_count": null,
"id": "9a670915",
"metadata": {
"id": "9a670915"
},
"outputs": [],
"source": [
"Data_Quantity_Minimal_NoC_Invoice[\"Revenue\"] = Data_Quantity_Minimal_NoC_Invoice[\"Quantity\"] * Data_Quantity_Minimal_NoC_Invoice[\"Price\"]"
]
},
{
"cell_type": "code",
"source": [
"Data_Quantity_Minimal_NoC_Invoice"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 658
},
"id": "1EOtpXby4gVU",
"outputId": "87851504-0e8c-469a-ae54-7c66b533e791"
},
"id": "1EOtpXby4gVU",
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" index Invoice StockCode Description \\\n",
"0 0 489434 85048 15CM CHRISTMAS GLASS BALL 20 LIGHTS \n",
"1 1 489434 79323P PINK CHERRY LIGHTS \n",
"2 2 489434 79323W WHITE CHERRY LIGHTS \n",
"3 3 489434 22041 RECORD FRAME 7\" SINGLE SIZE \n",
"4 4 489434 21232 STRAWBERRY CERAMIC TRINKET BOX \n",
"... ... ... ... ... \n",
"1044415 1067366 581587 22899 CHILDREN'S APRON DOLLY GIRL \n",
"1044416 1067367 581587 23254 CHILDRENS CUTLERY DOLLY GIRL \n",
"1044417 1067368 581587 23255 CHILDRENS CUTLERY CIRCUS PARADE \n",
"1044418 1067369 581587 22138 BAKING SET 9 PIECE RETROSPOT \n",
"1044419 1067370 581587 POST POSTAGE \n",
"\n",
" Quantity InvoiceDate Price Customer ID Country \\\n",
"0 12 2009-12-01 07:45:00 6.95 13085.0 United Kingdom \n",
"1 12 2009-12-01 07:45:00 6.75 13085.0 United Kingdom \n",
"2 12 2009-12-01 07:45:00 6.75 13085.0 United Kingdom \n",
"3 48 2009-12-01 07:45:00 2.10 13085.0 United Kingdom \n",
"4 24 2009-12-01 07:45:00 1.25 13085.0 United Kingdom \n",
"... ... ... ... ... ... \n",
"1044415 6 2011-12-09 12:50:00 2.10 12680.0 France \n",
"1044416 4 2011-12-09 12:50:00 4.15 12680.0 France \n",
"1044417 4 2011-12-09 12:50:00 4.15 12680.0 France \n",
"1044418 3 2011-12-09 12:50:00 4.95 12680.0 France \n",
"1044419 1 2011-12-09 12:50:00 18.00 12680.0 France \n",
"\n",
" Year Revenue \n",
"0 2009 83.40 \n",
"1 2009 81.00 \n",
"2 2009 81.00 \n",
"3 2009 100.80 \n",
"4 2009 30.00 \n",
"... ... ... \n",
"1044415 2011 12.60 \n",
"1044416 2011 16.60 \n",
"1044417 2011 16.60 \n",
"1044418 2011 14.85 \n",
"1044419 2011 18.00 \n",
"\n",
"[1044420 rows x 11 columns]"
],
"text/html": [
"\n",
" <div id=\"df-ec98b30b-31b1-4da2-9451-f32b0d011ad2\">\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>index</th>\n",
" <th>Invoice</th>\n",
" <th>StockCode</th>\n",
" <th>Description</th>\n",
" <th>Quantity</th>\n",
" <th>InvoiceDate</th>\n",
" <th>Price</th>\n",
" <th>Customer ID</th>\n",
" <th>Country</th>\n",
" <th>Year</th>\n",
" <th>Revenue</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0</td>\n",
" <td>489434</td>\n",
" <td>85048</td>\n",
" <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.95</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" <td>83.40</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1</td>\n",
" <td>489434</td>\n",
" <td>79323P</td>\n",
" <td>PINK CHERRY LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.75</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" <td>81.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2</td>\n",
" <td>489434</td>\n",
" <td>79323W</td>\n",
" <td>WHITE CHERRY LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.75</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" <td>81.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>3</td>\n",
" <td>489434</td>\n",
" <td>22041</td>\n",
" <td>RECORD FRAME 7\" SINGLE SIZE</td>\n",
" <td>48</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>2.10</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" <td>100.80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>4</td>\n",
" <td>489434</td>\n",
" <td>21232</td>\n",
" <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n",
" <td>24</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>1.25</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" <td>30.00</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",
" </tr>\n",
" <tr>\n",
" <th>1044415</th>\n",
" <td>1067366</td>\n",
" <td>581587</td>\n",
" <td>22899</td>\n",
" <td>CHILDREN'S APRON DOLLY GIRL</td>\n",
" <td>6</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>2.10</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" <td>12.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1044416</th>\n",
" <td>1067367</td>\n",
" <td>581587</td>\n",
" <td>23254</td>\n",
" <td>CHILDRENS CUTLERY DOLLY GIRL</td>\n",
" <td>4</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.15</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" <td>16.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1044417</th>\n",
" <td>1067368</td>\n",
" <td>581587</td>\n",
" <td>23255</td>\n",
" <td>CHILDRENS CUTLERY CIRCUS PARADE</td>\n",
" <td>4</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.15</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" <td>16.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1044418</th>\n",
" <td>1067369</td>\n",
" <td>581587</td>\n",
" <td>22138</td>\n",
" <td>BAKING SET 9 PIECE RETROSPOT</td>\n",
" <td>3</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.95</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" <td>14.85</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1044419</th>\n",
" <td>1067370</td>\n",
" <td>581587</td>\n",
" <td>POST</td>\n",
" <td>POSTAGE</td>\n",
" <td>1</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>18.00</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" <td>18.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1044420 rows × 11 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ec98b30b-31b1-4da2-9451-f32b0d011ad2')\"\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-ec98b30b-31b1-4da2-9451-f32b0d011ad2 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-ec98b30b-31b1-4da2-9451-f32b0d011ad2');\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": "markdown",
"id": "c955f053",
"metadata": {
"id": "c955f053"
},
"source": [
"### Average of Revenue per Year"
]
},
{
"cell_type": "markdown",
"source": [
"Hitung rata-rata Revenue per tahun. Lalu buatlah visualisasinya.\n"
],
"metadata": {
"id": "tfAlOHjR56y0"
},
"id": "tfAlOHjR56y0"
},
{
"cell_type": "code",
"execution_count": null,
"id": "4a2e5ed4",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 143
},
"id": "4a2e5ed4",
"outputId": "846c15d9-30c5-43e4-f03a-2da17ffb3c1c"
},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Year index Quantity Price Customer ID Revenue\n",
"0 2009 22610.203363 10.104957 4.256300 15479.710055 18.713273\n",
"1 2010 307198.158621 11.607816 4.015408 15370.439337 19.908987\n",
"2 2011 818004.041538 10.822372 3.777422 15277.787842 20.058767"
],
"text/html": [
"\n",
" <div id=\"df-55c06158-906c-4960-b6ba-68c8ccb52ca9\">\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>Year</th>\n",
" <th>index</th>\n",
" <th>Quantity</th>\n",
" <th>Price</th>\n",
" <th>Customer ID</th>\n",
" <th>Revenue</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2009</td>\n",
" <td>22610.203363</td>\n",
" <td>10.104957</td>\n",
" <td>4.256300</td>\n",
" <td>15479.710055</td>\n",
" <td>18.713273</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2010</td>\n",
" <td>307198.158621</td>\n",
" <td>11.607816</td>\n",
" <td>4.015408</td>\n",
" <td>15370.439337</td>\n",
" <td>19.908987</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2011</td>\n",
" <td>818004.041538</td>\n",
" <td>10.822372</td>\n",
" <td>3.777422</td>\n",
" <td>15277.787842</td>\n",
" <td>20.058767</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-55c06158-906c-4960-b6ba-68c8ccb52ca9')\"\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-55c06158-906c-4960-b6ba-68c8ccb52ca9 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-55c06158-906c-4960-b6ba-68c8ccb52ca9');\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": 9
}
],
"source": [
"#ata-rata Revenue per tahun\n",
"\n",
"rerata_revenue=Data_Quantity_Minimal_NoC_Invoice.groupby('Year').mean().reset_index()\n",
"rerata_revenue"
]
},
{
"cell_type": "code",
"source": [
"sns.barplot(x=\"Year\", y=\"Revenue\", data=rerata_revenue)\n"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 297
},
"id": "pkofj6hQ7FgD",
"outputId": "e528068d-cb82-40ba-c756-947e44e28155"
},
"id": "pkofj6hQ7FgD",
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x7f2824db5790>"
]
},
"metadata": {},
"execution_count": 10
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
],
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAEGCAYAAAB/+QKOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAUEklEQVR4nO3dfbAldX3n8fcngDFBCCC3RgTGcV0CNSE87Q2SkjUYhAzEBOOyCpXSiWt2YgqN1JpsYbIlllaq8mBMKpKVmsgU6BrERFF2RWGWtYIYFC4THiUIQVhmHJnBYXmM0YHv/nF75Hj93ZnDzD2n78x5v6pO3e5f/7rP91RP8aGffp2qQpKkuX6s7wIkSYuTASFJajIgJElNBoQkqcmAkCQ17d13AQvp4IMPrmXLlvVdhiTtNm655ZZHqmqqtWyPCohly5YxMzPTdxmStNtI8uB8yzzFJElqMiAkSU0GhCSpyYCQJDUZEJKkJgNCktQ0soBIcniSLyX5epK7kryraz8oydok93Z/D5xn/ZVdn3uTrBxVnZKktlEeQWwF3l1Vy4GTgPOSLAcuAK6rqiOA67r5H5LkIOBC4JXAicCF8wWJJGk0RhYQVbWxqtZ1008AdwOHAmcBl3XdLgNe31j9l4C1VbWlqh4F1gIrRlWrJOlHjeVJ6iTLgOOBrwFLqmpjt+jbwJLGKocCDw3Mr+/aWtteBawCWLp06cIULGlkXvXhV/Vdwh7vK+/8yoJsZ+QBkeRFwKeB86vq8SQ/WFZVlWSXXmlXVauB1QDT09O+Hm8C/N/3/2zfJUyEpe+9o+8S1LOR3sWUZB9mw+ETVfWZrvnhJId0yw8BNjVW3QAcPjB/WNcmSRqTUd7FFOAS4O6q+tDAoquAbXclrQQ+11j9GuD0JAd2F6dP79okSWMyyiOIVwFvBn4xya3d50zgj4DTktwLvLabJ8l0ko8CVNUW4APAzd3n/V2bJGlMRnYNoqpuADLP4lMb/WeA3xyYXwOsGU11kqQd8UlqSVKTASFJajIgJElNBoQkqcmAkCQ1GRCSpCYDQpLUZEBIkprGMprrYvTvfu9jfZewx7vlT9/SdwmSdoFHEJKkJgNCktRkQEiSmgwISVKTASFJajIgJElNBoQkqcmAkCQ1jexBuSRrgNcBm6rq6K7tCuDIrssBwP+rquMa6z4APAE8A2ytqulR1SlJahvlk9SXAhcBP3hkuaretG06yZ8Bj21n/ddU1SMjq06StF2jfCf19UmWtZYlCfBG4BdH9f2SpF3T1zWIfw88XFX3zrO8gGuT3JJk1fY2lGRVkpkkM5s3b17wQiVpUvUVEOcCl29n+clVdQJwBnBeklfP17GqVlfVdFVNT01NLXSdkjSxxh4QSfYG3gBcMV+fqtrQ/d0EXAmcOJ7qJEnb9HEE8Vrgn6pqfWthkn2T7LdtGjgduHOM9UmSGGFAJLkcuBE4Msn6JG/rFp3DnNNLSV6a5OpudglwQ5LbgJuAz1fVF0dVpySpbZR3MZ07T/tvNNq+BZzZTd8PHDuquiRJw/FJaklSkwEhSWoyICRJTQaEJKnJgJAkNRkQkqQmA0KS1GRASJKaDAhJUpMBIUlqMiAkSU0GhCSpyYCQJDUZEJKkJgNCktRkQEiSmgwISVLTKF85uibJpiR3DrS9L8mGJLd2nzPnWXdFknuS3JfkglHVKEma3yiPIC4FVjTa/7yqjus+V89dmGQv4K+AM4DlwLlJlo+wTklSw8gCoqquB7bsxKonAvdV1f1V9T3gk8BZC1qcJGmH+rgG8Y4kt3enoA5sLD8UeGhgfn3X1pRkVZKZJDObN29e6FolaWKNOyA+ArwCOA7YCPzZrm6wqlZX1XRVTU9NTe3q5iRJnbEGRFU9XFXPVNWzwF8zezpprg3A4QPzh3VtkqQxGmtAJDlkYPbXgDsb3W4Gjkjy8iQvAM4BrhpHfZKk5+w9qg0nuRw4BTg4yXrgQuCUJMcBBTwA/FbX96XAR6vqzKramuQdwDXAXsCaqrprVHVKktpGFhBVdW6j+ZJ5+n4LOHNg/mrgR26BlSSNj09SS5KaDAhJUpMBIUlqMiAkSU0GhCSpyYCQJDUZEJKkJgNCktRkQEiSmgwISVKTASFJajIgJElNBoQkqcmAkCQ1GRCSpCYDQpLUZEBIkppGFhBJ1iTZlOTOgbY/TfJPSW5PcmWSA+ZZ94EkdyS5NcnMqGqUJM1vlEcQlwIr5rStBY6uqmOAbwDv2c76r6mq46pqekT1SZK2Y2QBUVXXA1vmtF1bVVu72a8Ch43q+yVJu6bPaxD/CfjCPMsKuDbJLUlWbW8jSVYlmUkys3nz5gUvUpImVS8BkeQPgK3AJ+bpcnJVnQCcAZyX5NXzbauqVlfVdFVNT01NjaBaSZpMQwVEkiVJLknyhW5+eZK37cwXJvkN4HXAr1dVtfpU1Ybu7ybgSuDEnfkuSdLOG/YI4lLgGuCl3fw3gPOf75clWQH8V+BXq+rpefrsm2S/bdPA6cCdrb6SpNEZNiAOrqpPAc8CdBean9neCkkuB24EjkyyvjviuAjYD1jb3cJ6cdf3pUmu7lZdAtyQ5DbgJuDzVfXF5/vDJEm7Zu8h+z2V5MXMXjwmyUnAY9tboarObTRfMk/fbwFndtP3A8cOWZckaUSGDYj/AlwFvCLJV4Ap4OyRVSVJ6t1QAVFV65L8AnAkEOCeqvr+SCuTJPVqqIBI8pY5TSckoao+NoKaJEmLwLCnmH5uYPqFwKnAOsCAkKQ91LCnmN45ON8NsvfJkVQkSVoUdvZJ6qeAly9kIZKkxWXYaxD/k+4WV2ZDZTnwqVEVJUnq37DXID44ML0VeLCq1o+gHknSIjHsNYi/H3UhkqTFZdjB+t6Q5N4kjyV5PMkTSR4fdXGSpP4Me4rpT4Bfqaq7R1mMJGnxGPYupocNB0maLMMeQcwkuQL4LPCv2xqr6jMjqUqS1LthA2J/4Glm382wTQEGhCTtoYa9i+mtoy5EkrS4DHsX008nuS7Jnd38MUn+22hLkyT1adiL1H8NvAf4PkBV3Q6cs6OVkqxJsmlbsHRtByVZ2902uzbJgfOsu7Lrc2+SlUPWKUlaIMMGxE9W1U1z2rYOsd6lwIo5bRcA11XVEcB13fwPSXIQcCHwSuBE4ML5gkSSNBrDBsQjSV7Bc68cPRvYuKOVqup6YMuc5rOAy7rpy4DXN1b9JWBtVW2pqkeBtfxo0EiSRmjYu5jOA1YDRyXZAHwT+PWd/M4lVbUtXL4NLGn0ORR4aGB+fdcmSRqTYQPiwap6bZJ9gR+rqicW4surqpLUjnvOL8kqYBXA0qVLF6IsSRLDn2L6ZpLVwEnAk7v4nQ8nOQSg+7up0WcDcPjA/GFd24+oqtVVNV1V01NTU7tYmiRpm2ED4ijgfzN7qumbSS5KcvJOfudVwLa7klYCn2v0uQY4PcmB3cXp07s2SdKYDBUQVfV0VX2qqt4AHM/sk9U7HAI8yeXAjcCRSdYneRvwR8BpSe4FXtvNk2Q6yUe779sCfAC4ufu8v2uTJI3JsNcgSPILwJuYvZtoBnjjjtapqnPnWXRqo+8M8JsD82uANcPWJ0laWMO+cvQB4B+Zfc3o71XVU6MsSpLUv2GPII6pKl8QJEkTZNiL1C9xLCZJmiwjHYtJkrT7GvVYTJKk3dRIx2KSJO2++hiLSZK0Gxj2jXL3Az8Yi4nZ14+eAzw4wtokST3a7immJPsneU83tMZpzAbDSuA+hnhQTpK0+9rREcTHgUeZHS7jPwN/AAT4taq6dcS1SZJ6tKOA+DdV9bMA3ThJG4GlVfXdkVcmSerVju5i+v62iap6BlhvOEjSZNjREcSxSbYNsRHgJ7r5MPu+n/1HWp0kqTfbDYiq2mtchUiSFpdhH5STJE0YA0KS1GRASJKaxh4QSY5McuvA5/Ek58/pc0qSxwb6vHfcdUrSpBv6laMLparuAY4DSLIXsAG4stH1y1X1unHWJkl6Tt+nmE4F/rmqHNNJkhaZvgPiHODyeZb9fJLbknwhyc/Mt4Ekq5LMJJnZvHnzaKqUpAnUW0AkeQHwq8DfNhavA15WVccCHwY+O992qmp1VU1X1fTU1NRoipWkCdTnEcQZwLqqenjugqp6vKqe7KavBvZJcvC4C5SkSdZnQJzLPKeXkrwkSbrpE5mt8ztjrE2SJt7Y72IC6F48dBrwWwNtbweoqouBs4HfTrIV+BfgnKqqPmqVpEnVS0BU1VPAi+e0XTwwfRFw0bjrkiQ9p++7mCRJi5QBIUlqMiAkSU0GhCSpyYCQJDUZEJKkJgNCktRkQEiSmgwISVKTASFJajIgJElNBoQkqcmAkCQ1GRCSpCYDQpLUZEBIkpoMCElSU28BkeSBJHckuTXJTGN5kvxlkvuS3J7khD7qlKRJ1csrRwe8pqoemWfZGcAR3eeVwEe6v5KkMVjMp5jOAj5Ws74KHJDkkL6LkqRJ0WdAFHBtkluSrGosPxR4aGB+fdf2Q5KsSjKTZGbz5s0jKlWSJk+fAXFyVZ3A7Kmk85K8emc2UlWrq2q6qqanpqYWtkJJmmC9BURVbej+bgKuBE6c02UDcPjA/GFdmyRpDHoJiCT7Jtlv2zRwOnDnnG5XAW/p7mY6CXisqjaOuVRJmlh93cW0BLgyybYa/qaqvpjk7QBVdTFwNXAmcB/wNPDWnmqVpInUS0BU1f3AsY32iwemCzhvnHVJkp6zmG9zlST1yICQJDUZEJKkJgNCktRkQEiSmgwISVKTASFJajIgJElNBoQkqcmAkCQ1GRCSpCYDQpLUZEBIkpoMCElSkwEhSWoyICRJTQaEJKlp7AGR5PAkX0ry9SR3JXlXo88pSR5Lcmv3ee+465SkSdfHK0e3Au+uqnVJ9gNuSbK2qr4+p9+Xq+p1PdQnSaKHI4iq2lhV67rpJ4C7gUPHXYckaft6vQaRZBlwPPC1xuKfT3Jbki8k+ZntbGNVkpkkM5s3bx5RpZI0eXoLiCQvAj4NnF9Vj89ZvA54WVUdC3wY+Ox826mq1VU1XVXTU1NToytYkiZMLwGRZB9mw+ETVfWZucur6vGqerKbvhrYJ8nBYy5TkiZaH3cxBbgEuLuqPjRPn5d0/UhyIrN1fmd8VUqS+riL6VXAm4E7ktzatf0+sBSgqi4GzgZ+O8lW4F+Ac6qqeqhVkibW2AOiqm4AsoM+FwEXjaciSVKLT1JLkpoMCElSkwEhSWoyICRJTQaEJKnJgJAkNRkQkqQmA0KS1GRASJKaDAhJUpMBIUlqMiAkSU0GhCSpyYCQJDUZEJKkJgNCktRkQEiSmnoJiCQrktyT5L4kFzSW/3iSK7rlX0uybPxVStJkG3tAJNkL+CvgDGA5cG6S5XO6vQ14tKr+LfDnwB+Pt0pJUh9HECcC91XV/VX1PeCTwFlz+pwFXNZN/x1wapLtvsdakrSw9u7hOw8FHhqYXw+8cr4+VbU1yWPAi4FH5m4sySpgVTf7ZJJ7FrzixeFgGr9/McsHV/ZdwmKy2+0/LvT/yQbsVvsvv/O89t3L5lvQR0AsqKpaDazuu45RSzJTVdN916Gd4/7bvU3q/uvjFNMG4PCB+cO6tmafJHsDPwV8ZyzVSZKAfgLiZuCIJC9P8gLgHOCqOX2uAradnzgb+D9VVWOsUZIm3thPMXXXFN4BXAPsBaypqruSvB+YqaqrgEuAjye5D9jCbIhMuj3+NNoezv23e5vI/Rf/x1yS1OKT1JKkJgNCktRkQPQkyeFJvpTk60nuSvKurv2gJGuT3Nv9PbBrT5K/7IYfuT3JCQPb+uMkd3afN/X1mybJTuy/o5LcmORfk/zunG1td+gZLbwF3n9rkmxKcmcfv2WUDIj+bAXeXVXLgZOA87ohRy4ArquqI4DrunmYHZrkiO6zCvgIQJJfBk4AjmP2gcPfTbL/OH/IhHq++28L8DvABwc3MuTQM1p4C7L/OpcCK0ZecQ8MiJ5U1caqWtdNPwHczewT5IPDjFwGvL6bPgv4WM36KnBAkkOY/Y/K9VW1taqeAm5nD/3Hupg83/1XVZuq6mbg+3M2NczQM1pgC7j/qKrrmQ2QPY4BsQh0o9UeD3wNWFJVG7tF3waWdNOtIUoOBW4DViT5ySQHA6/hhx9E1IgNuf/mM99+1Zjs4v7bo+32Q23s7pK8CPg0cH5VPT44JmFVVZLt3odcVdcm+TngH4DNwI3AMyMsWQN2df+pX+6/7fMIokdJ9mH2H+cnquozXfPD3akjur+buvZ5hyipqj+squOq6jQgwDfGUf+ke577bz7DDD2jEVig/bdHMyB60g1ffglwd1V9aGDR4DAjK4HPDbS/pbub6STgsaramGSvJC/utnkMcAxw7Vh+xATbif03n2GGntECW8D9t0fzSeqeJDkZ+DJwB/Bs1/z7zJ4H/RSwFHgQeGNVben+QV/E7AXop4G3VtVMkhcC67r1HwfeXlW3ju+XTKad2H8vAWaA/bv+TwLLu9MaZwJ/wXNDz/zhWH/MBFrg/Xc5cAqzQ4I/DFxYVZeM8eeMjAEhSWryFJMkqcmAkCQ1GRCSpCYDQpLUZEBIkpoMCGkndc+k3JDkjIG2/5jki33WJS0Ub3OVdkGSo4G/ZXYsn72BfwRWVNU/78S29q6qrQtcorTTDAhpFyX5E+ApYN/u78uAo4F9gPdV1ee6AeE+3vUBeEdV/UOSU4APAI8CR1XVT4+3eml+BoS0i5Lsy+zT7N8D/hdwV1X9jyQHADcxe3RRwLNV9d0kRwCXV9V0FxCfB46uqm/28wukNkdzlXZRVT2V5Apmh194I/ArA28deyGzwzZ8C7goyXHMjrY7eKRwk+GgxciAkBbGs90nwH+oqnsGFyZ5H7Pj9BzL7M0h3x1Y/NSYapSeF+9ikhbWNcA7u8EVSXJ81/5TwMaqehZ4M7MD80mLmgEhLawPMHtx+vYkd3XzAP8dWJnkNuAoPGrQbsCL1JKkJo8gJElNBoQkqcmAkCQ1GRCSpCYDQpLUZEBIkpoMCElS0/8H4MRANiBpuIoAAAAASUVORK5CYII=\n"
},
"metadata": {
"needs_background": "light"
}
}
]
},
{
"cell_type": "markdown",
"id": "8823e17c",
"metadata": {
"id": "8823e17c"
},
"source": [
"### Interpretation"
]
},
{
"cell_type": "markdown",
"id": "3739a278",
"metadata": {
"id": "3739a278"
},
"source": [
"Rata-rata revenue penjualan ritel online setiap tahun mengalami kenaikan hal ini ditunjukan pada tahun 2009 rata-rata revenue 18.713273, kemudian pada tahun 2010 naik sebesar 1.195714 menjadi 19.908987 dan meningkat lagi pada tahun 2011 menjadi 20.058767. Pertumbuhan atau peningkatan rata-rata revenue penjualan ritel online tertinggi terjadi pada tahun 2010 sedangkan Peningkatan rata-rata revenue terendah terjadi pada tahun 2011."
]
},
{
"cell_type": "markdown",
"id": "4ff5f5d4",
"metadata": {
"id": "4ff5f5d4"
},
"source": [
"## Section 2"
]
},
{
"cell_type": "markdown",
"id": "8dadd5ef",
"metadata": {
"id": "8dadd5ef"
},
"source": [
"### Filtering Data "
]
},
{
"cell_type": "markdown",
"id": "2c053fd2",
"metadata": {
"id": "2c053fd2"
},
"source": [
"#### Customers who finished their purchases"
]
},
{
"cell_type": "markdown",
"source": [
"Lakukan filtering menggunakan data sales (data yang sudah di filter pada section 1)\n",
"dengan ketentuan CustomerID tidak boleh kosong atau null. Kemudian simpan dalam\n",
"variabel finished"
],
"metadata": {
"id": "lk46A1qmbrwY"
},
"id": "lk46A1qmbrwY"
},
{
"cell_type": "code",
"execution_count": null,
"id": "d992a159",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 658
},
"id": "d992a159",
"outputId": "0d476ee6-0881-4c3f-e50d-f666b8f13847"
},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" level_0 index Invoice StockCode \\\n",
"0 0 0 489434 85048 \n",
"1 1 1 489434 79323P \n",
"2 2 2 489434 79323W \n",
"3 3 3 489434 22041 \n",
"4 4 4 489434 21232 \n",
"... ... ... ... ... \n",
"805615 1044415 1067366 581587 22899 \n",
"805616 1044416 1067367 581587 23254 \n",
"805617 1044417 1067368 581587 23255 \n",
"805618 1044418 1067369 581587 22138 \n",
"805619 1044419 1067370 581587 POST \n",
"\n",
" Description Quantity InvoiceDate \\\n",
"0 15CM CHRISTMAS GLASS BALL 20 LIGHTS 12 2009-12-01 07:45:00 \n",
"1 PINK CHERRY LIGHTS 12 2009-12-01 07:45:00 \n",
"2 WHITE CHERRY LIGHTS 12 2009-12-01 07:45:00 \n",
"3 RECORD FRAME 7\" SINGLE SIZE 48 2009-12-01 07:45:00 \n",
"4 STRAWBERRY CERAMIC TRINKET BOX 24 2009-12-01 07:45:00 \n",
"... ... ... ... \n",
"805615 CHILDREN'S APRON DOLLY GIRL 6 2011-12-09 12:50:00 \n",
"805616 CHILDRENS CUTLERY DOLLY GIRL 4 2011-12-09 12:50:00 \n",
"805617 CHILDRENS CUTLERY CIRCUS PARADE 4 2011-12-09 12:50:00 \n",
"805618 BAKING SET 9 PIECE RETROSPOT 3 2011-12-09 12:50:00 \n",
"805619 POSTAGE 1 2011-12-09 12:50:00 \n",
"\n",
" Price Customer ID Country Year Revenue \n",
"0 6.95 13085.0 United Kingdom 2009 83.40 \n",
"1 6.75 13085.0 United Kingdom 2009 81.00 \n",
"2 6.75 13085.0 United Kingdom 2009 81.00 \n",
"3 2.10 13085.0 United Kingdom 2009 100.80 \n",
"4 1.25 13085.0 United Kingdom 2009 30.00 \n",
"... ... ... ... ... ... \n",
"805615 2.10 12680.0 France 2011 12.60 \n",
"805616 4.15 12680.0 France 2011 16.60 \n",
"805617 4.15 12680.0 France 2011 16.60 \n",
"805618 4.95 12680.0 France 2011 14.85 \n",
"805619 18.00 12680.0 France 2011 18.00 \n",
"\n",
"[805620 rows x 12 columns]"
],
"text/html": [
"\n",
" <div id=\"df-5b1d8572-e8f7-4af6-96e1-4122269ce8b2\">\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>level_0</th>\n",
" <th>index</th>\n",
" <th>Invoice</th>\n",
" <th>StockCode</th>\n",
" <th>Description</th>\n",
" <th>Quantity</th>\n",
" <th>InvoiceDate</th>\n",
" <th>Price</th>\n",
" <th>Customer ID</th>\n",
" <th>Country</th>\n",
" <th>Year</th>\n",
" <th>Revenue</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>489434</td>\n",
" <td>85048</td>\n",
" <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.95</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" <td>83.40</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>489434</td>\n",
" <td>79323P</td>\n",
" <td>PINK CHERRY LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.75</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" <td>81.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>489434</td>\n",
" <td>79323W</td>\n",
" <td>WHITE CHERRY LIGHTS</td>\n",
" <td>12</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>6.75</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" <td>81.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>489434</td>\n",
" <td>22041</td>\n",
" <td>RECORD FRAME 7\" SINGLE SIZE</td>\n",
" <td>48</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>2.10</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" <td>100.80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>4</td>\n",
" <td>4</td>\n",
" <td>489434</td>\n",
" <td>21232</td>\n",
" <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n",
" <td>24</td>\n",
" <td>2009-12-01 07:45:00</td>\n",
" <td>1.25</td>\n",
" <td>13085.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2009</td>\n",
" <td>30.00</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",
" </tr>\n",
" <tr>\n",
" <th>805615</th>\n",
" <td>1044415</td>\n",
" <td>1067366</td>\n",
" <td>581587</td>\n",
" <td>22899</td>\n",
" <td>CHILDREN'S APRON DOLLY GIRL</td>\n",
" <td>6</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>2.10</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" <td>12.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>805616</th>\n",
" <td>1044416</td>\n",
" <td>1067367</td>\n",
" <td>581587</td>\n",
" <td>23254</td>\n",
" <td>CHILDRENS CUTLERY DOLLY GIRL</td>\n",
" <td>4</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.15</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" <td>16.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>805617</th>\n",
" <td>1044417</td>\n",
" <td>1067368</td>\n",
" <td>581587</td>\n",
" <td>23255</td>\n",
" <td>CHILDRENS CUTLERY CIRCUS PARADE</td>\n",
" <td>4</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.15</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" <td>16.60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>805618</th>\n",
" <td>1044418</td>\n",
" <td>1067369</td>\n",
" <td>581587</td>\n",
" <td>22138</td>\n",
" <td>BAKING SET 9 PIECE RETROSPOT</td>\n",
" <td>3</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>4.95</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" <td>14.85</td>\n",
" </tr>\n",
" <tr>\n",
" <th>805619</th>\n",
" <td>1044419</td>\n",
" <td>1067370</td>\n",
" <td>581587</td>\n",
" <td>POST</td>\n",
" <td>POSTAGE</td>\n",
" <td>1</td>\n",
" <td>2011-12-09 12:50:00</td>\n",
" <td>18.00</td>\n",
" <td>12680.0</td>\n",
" <td>France</td>\n",
" <td>2011</td>\n",
" <td>18.00</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>805620 rows × 12 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5b1d8572-e8f7-4af6-96e1-4122269ce8b2')\"\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-5b1d8572-e8f7-4af6-96e1-4122269ce8b2 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-5b1d8572-e8f7-4af6-96e1-4122269ce8b2');\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
}
],
"source": [
"#CustomerID tidak boleh kosong atau null\n",
"\n",
"data_sales = Data_Quantity_Minimal_NoC_Invoice\n",
"finished = data_sales[data_sales[['Customer ID']].notnull().all(1)].reset_index()\n",
"finished"
]
},
{
"cell_type": "markdown",
"id": "136b9900",
"metadata": {
"id": "136b9900"
},
"source": [
"#### Customers who canceled their purchases"
]
},
{
"cell_type": "markdown",
"source": [
"Lakukan filtering data untuk mengelompokkan pelanggan yang membatalkan\n",
"belanjanya, dengan cara mendeteksi kolom Invoice mengandung huruf ‘C’. Kemudian\n",
"simpan dalam variabel baru bernama cancel.\n"
],
"metadata": {
"id": "hot0lxD-gODX"
},
"id": "hot0lxD-gODX"
},
{
"cell_type": "code",
"execution_count": null,
"id": "98af92ed",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 467
},
"id": "98af92ed",
"outputId": "7ecf2180-4607-4216-fcfa-f09d288cd252"
},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" index Invoice StockCode Description Quantity \\\n",
"0 178 C489449 22087 PAPER BUNTING WHITE LACE -12 \n",
"1 179 C489449 85206A CREAM FELT EASTER EGG BASKET -6 \n",
"2 180 C489449 21895 POTTING SHED SOW 'N' GROW SET -4 \n",
"3 181 C489449 21896 POTTING SHED TWINE -6 \n",
"4 182 C489449 22083 PAPER CHAIN KIT RETRO SPOT -12 \n",
"... ... ... ... ... ... \n",
"19489 1065910 C581490 23144 ZINC T-LIGHT HOLDER STARS SMALL -11 \n",
"19490 1067002 C581499 M Manual -1 \n",
"19491 1067176 C581568 21258 VICTORIAN SEWING BOX LARGE -5 \n",
"19492 1067177 C581569 84978 HANGING HEART JAR T-LIGHT HOLDER -1 \n",
"19493 1067178 C581569 20979 36 PENCILS TUBE RED RETROSPOT -5 \n",
"\n",
" InvoiceDate Price Customer ID Country Year \n",
"0 2009-12-01 10:33:00 2.95 16321.0 Australia 2009 \n",
"1 2009-12-01 10:33:00 1.65 16321.0 Australia 2009 \n",
"2 2009-12-01 10:33:00 4.25 16321.0 Australia 2009 \n",
"3 2009-12-01 10:33:00 2.10 16321.0 Australia 2009 \n",
"4 2009-12-01 10:33:00 2.95 16321.0 Australia 2009 \n",
"... ... ... ... ... ... \n",
"19489 2011-12-09 09:57:00 0.83 14397.0 United Kingdom 2011 \n",
"19490 2011-12-09 10:28:00 224.69 15498.0 United Kingdom 2011 \n",
"19491 2011-12-09 11:57:00 10.95 15311.0 United Kingdom 2011 \n",
"19492 2011-12-09 11:58:00 1.25 17315.0 United Kingdom 2011 \n",
"19493 2011-12-09 11:58:00 1.25 17315.0 United Kingdom 2011 \n",
"\n",
"[19494 rows x 10 columns]"
],
"text/html": [
"\n",
" <div id=\"df-f9cff3cf-eea5-4aef-ae53-2c7af13c9bb0\">\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>index</th>\n",
" <th>Invoice</th>\n",
" <th>StockCode</th>\n",
" <th>Description</th>\n",
" <th>Quantity</th>\n",
" <th>InvoiceDate</th>\n",
" <th>Price</th>\n",
" <th>Customer ID</th>\n",
" <th>Country</th>\n",
" <th>Year</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>178</td>\n",
" <td>C489449</td>\n",
" <td>22087</td>\n",
" <td>PAPER BUNTING WHITE LACE</td>\n",
" <td>-12</td>\n",
" <td>2009-12-01 10:33:00</td>\n",
" <td>2.95</td>\n",
" <td>16321.0</td>\n",
" <td>Australia</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>179</td>\n",
" <td>C489449</td>\n",
" <td>85206A</td>\n",
" <td>CREAM FELT EASTER EGG BASKET</td>\n",
" <td>-6</td>\n",
" <td>2009-12-01 10:33:00</td>\n",
" <td>1.65</td>\n",
" <td>16321.0</td>\n",
" <td>Australia</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>180</td>\n",
" <td>C489449</td>\n",
" <td>21895</td>\n",
" <td>POTTING SHED SOW 'N' GROW SET</td>\n",
" <td>-4</td>\n",
" <td>2009-12-01 10:33:00</td>\n",
" <td>4.25</td>\n",
" <td>16321.0</td>\n",
" <td>Australia</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>181</td>\n",
" <td>C489449</td>\n",
" <td>21896</td>\n",
" <td>POTTING SHED TWINE</td>\n",
" <td>-6</td>\n",
" <td>2009-12-01 10:33:00</td>\n",
" <td>2.10</td>\n",
" <td>16321.0</td>\n",
" <td>Australia</td>\n",
" <td>2009</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>182</td>\n",
" <td>C489449</td>\n",
" <td>22083</td>\n",
" <td>PAPER CHAIN KIT RETRO SPOT</td>\n",
" <td>-12</td>\n",
" <td>2009-12-01 10:33:00</td>\n",
" <td>2.95</td>\n",
" <td>16321.0</td>\n",
" <td>Australia</td>\n",
" <td>2009</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",
" </tr>\n",
" <tr>\n",
" <th>19489</th>\n",
" <td>1065910</td>\n",
" <td>C581490</td>\n",
" <td>23144</td>\n",
" <td>ZINC T-LIGHT HOLDER STARS SMALL</td>\n",
" <td>-11</td>\n",
" <td>2011-12-09 09:57:00</td>\n",
" <td>0.83</td>\n",
" <td>14397.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19490</th>\n",
" <td>1067002</td>\n",
" <td>C581499</td>\n",
" <td>M</td>\n",
" <td>Manual</td>\n",
" <td>-1</td>\n",
" <td>2011-12-09 10:28:00</td>\n",
" <td>224.69</td>\n",
" <td>15498.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19491</th>\n",
" <td>1067176</td>\n",
" <td>C581568</td>\n",
" <td>21258</td>\n",
" <td>VICTORIAN SEWING BOX LARGE</td>\n",
" <td>-5</td>\n",
" <td>2011-12-09 11:57:00</td>\n",
" <td>10.95</td>\n",
" <td>15311.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19492</th>\n",
" <td>1067177</td>\n",
" <td>C581569</td>\n",
" <td>84978</td>\n",
" <td>HANGING HEART JAR T-LIGHT HOLDER</td>\n",
" <td>-1</td>\n",
" <td>2011-12-09 11:58:00</td>\n",
" <td>1.25</td>\n",
" <td>17315.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19493</th>\n",
" <td>1067178</td>\n",
" <td>C581569</td>\n",
" <td>20979</td>\n",
" <td>36 PENCILS TUBE RED RETROSPOT</td>\n",
" <td>-5</td>\n",
" <td>2011-12-09 11:58:00</td>\n",
" <td>1.25</td>\n",
" <td>17315.0</td>\n",
" <td>United Kingdom</td>\n",
" <td>2011</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>19494 rows × 10 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f9cff3cf-eea5-4aef-ae53-2c7af13c9bb0')\"\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-f9cff3cf-eea5-4aef-ae53-2c7af13c9bb0 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-f9cff3cf-eea5-4aef-ae53-2c7af13c9bb0');\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
}
],
"source": [
"#deteksi kolom Invoice mengandung huruf ‘C’.\n",
"\n",
"cancel = data[(data['Invoice'].str.contains(\"C\"))].reset_index()\n",
"cancel"
]
},
{
"cell_type": "markdown",
"id": "d3fbb31a",
"metadata": {
"id": "d3fbb31a"
},
"source": [
"### Number of Finished and Canceled Transactions Each Year"
]
},
{
"cell_type": "markdown",
"source": [
"Hitung jumlah transaksi yang berhasil (dari variabel finished) dan jumlah transaksi yang\n",
"dibatalkan (dari variabel cancel) untuk setiap tahunnya. Lalu buatlah visualisasinya\n",
"(grafik).\n"
],
"metadata": {
"id": "YmKPHRp9g1Zu"
},
"id": "YmKPHRp9g1Zu"
},
{
"cell_type": "code",
"execution_count": null,
"id": "04158c66",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 205
},
"id": "04158c66",
"outputId": "b410e368-e9a6-47ab-f9b4-0588c23fd1ea"
},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Year level_0 index Finished Transaction StockCode Description \\\n",
"0 2009 30761 30761 30761 30761 30761 \n",
"1 2010 403094 403094 403094 403094 403094 \n",
"2 2011 371765 371765 371765 371765 371765 \n",
"\n",
" Quantity Finished TransactionDate Price Customer ID Country Revenue \n",
"0 30761 30761 30761 30761 30761 30761 \n",
"1 403094 403094 403094 403094 403094 403094 \n",
"2 371765 371765 371765 371765 371765 371765 "
],
"text/html": [
"\n",
" <div id=\"df-00dd1149-e481-41a9-941c-511e811feb0b\">\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>Year</th>\n",
" <th>level_0</th>\n",
" <th>index</th>\n",
" <th>Finished Transaction</th>\n",
" <th>StockCode</th>\n",
" <th>Description</th>\n",
" <th>Quantity</th>\n",
" <th>Finished TransactionDate</th>\n",
" <th>Price</th>\n",
" <th>Customer ID</th>\n",
" <th>Country</th>\n",
" <th>Revenue</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2009</td>\n",
" <td>30761</td>\n",
" <td>30761</td>\n",
" <td>30761</td>\n",
" <td>30761</td>\n",
" <td>30761</td>\n",
" <td>30761</td>\n",
" <td>30761</td>\n",
" <td>30761</td>\n",
" <td>30761</td>\n",
" <td>30761</td>\n",
" <td>30761</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2010</td>\n",
" <td>403094</td>\n",
" <td>403094</td>\n",
" <td>403094</td>\n",
" <td>403094</td>\n",
" <td>403094</td>\n",
" <td>403094</td>\n",
" <td>403094</td>\n",
" <td>403094</td>\n",
" <td>403094</td>\n",
" <td>403094</td>\n",
" <td>403094</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2011</td>\n",
" <td>371765</td>\n",
" <td>371765</td>\n",
" <td>371765</td>\n",
" <td>371765</td>\n",
" <td>371765</td>\n",
" <td>371765</td>\n",
" <td>371765</td>\n",
" <td>371765</td>\n",
" <td>371765</td>\n",
" <td>371765</td>\n",
" <td>371765</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-00dd1149-e481-41a9-941c-511e811feb0b')\"\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-00dd1149-e481-41a9-941c-511e811feb0b 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-00dd1149-e481-41a9-941c-511e811feb0b');\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
}
],
"source": [
"#transaksi yang berhasil \n",
"\n",
"total_finished = finished.groupby('Year').count().reset_index()\n",
"total_finished.columns = total_finished.columns.str.replace('Invoice', 'Finished Transaction')\n",
"total_finished"
]
},
{
"cell_type": "code",
"source": [
"#transaksi yang gagal\n",
"\n",
"total_cancel = cancel.groupby('Year').count().reset_index()\n",
"total_cancel.columns = total_cancel.columns.str.replace('Invoice', 'Cancel Transaction')\n",
"total_cancel"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 143
},
"id": "77pAp6QHh3JZ",
"outputId": "c57eeef5-88e2-4b58-c675-5a59b47254cf"
},
"id": "77pAp6QHh3JZ",
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Year index Cancel Transaction StockCode Description Quantity \\\n",
"0 2009 1015 1015 1015 1015 1015 \n",
"1 2010 9919 9919 9919 9919 9919 \n",
"2 2011 8560 8560 8560 8560 8560 \n",
"\n",
" Cancel TransactionDate Price Customer ID Country \n",
"0 1015 1015 999 1015 \n",
"1 9919 9919 9530 9919 \n",
"2 8560 8560 8215 8560 "
],
"text/html": [
"\n",
" <div id=\"df-476a7071-5a1f-46a2-8c0c-0f5b94a29ee7\">\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>Year</th>\n",
" <th>index</th>\n",
" <th>Cancel Transaction</th>\n",
" <th>StockCode</th>\n",
" <th>Description</th>\n",
" <th>Quantity</th>\n",
" <th>Cancel TransactionDate</th>\n",
" <th>Price</th>\n",
" <th>Customer ID</th>\n",
" <th>Country</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2009</td>\n",
" <td>1015</td>\n",
" <td>1015</td>\n",
" <td>1015</td>\n",
" <td>1015</td>\n",
" <td>1015</td>\n",
" <td>1015</td>\n",
" <td>1015</td>\n",
" <td>999</td>\n",
" <td>1015</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2010</td>\n",
" <td>9919</td>\n",
" <td>9919</td>\n",
" <td>9919</td>\n",
" <td>9919</td>\n",
" <td>9919</td>\n",
" <td>9919</td>\n",
" <td>9919</td>\n",
" <td>9530</td>\n",
" <td>9919</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2011</td>\n",
" <td>8560</td>\n",
" <td>8560</td>\n",
" <td>8560</td>\n",
" <td>8560</td>\n",
" <td>8560</td>\n",
" <td>8560</td>\n",
" <td>8560</td>\n",
" <td>8215</td>\n",
" <td>8560</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-476a7071-5a1f-46a2-8c0c-0f5b94a29ee7')\"\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-476a7071-5a1f-46a2-8c0c-0f5b94a29ee7 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-476a7071-5a1f-46a2-8c0c-0f5b94a29ee7');\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": 15
}
]
},
{
"cell_type": "code",
"source": [
"finished_ = total_finished[[\"Year\",\"Finished Transaction\"]]\n"
],
"metadata": {
"id": "QEVmvlkainQz"
},
"id": "QEVmvlkainQz",
"execution_count": null,
"outputs": []
},
{
"cell_type": "code",
"source": [
"cancel_ = total_cancel[[\"Year\",\"Cancel Transaction\"]]"
],
"metadata": {
"id": "czvR_zu7mgcF"
},
"id": "czvR_zu7mgcF",
"execution_count": null,
"outputs": []
},
{
"cell_type": "code",
"source": [
"merged_df = pd.merge(finished_,cancel_)\n",
"merged_df"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 143
},
"id": "3Q931Oy8tAjQ",
"outputId": "aa36799d-0141-4ecc-9008-a33dbbd95a99"
},
"id": "3Q931Oy8tAjQ",
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Year Finished Transaction Cancel Transaction\n",
"0 2009 30761 1015\n",
"1 2010 403094 9919\n",
"2 2011 371765 8560"
],
"text/html": [
"\n",
" <div id=\"df-e6010334-db51-4598-add1-f209c58ff18d\">\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>Year</th>\n",
" <th>Finished Transaction</th>\n",
" <th>Cancel Transaction</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2009</td>\n",
" <td>30761</td>\n",
" <td>1015</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2010</td>\n",
" <td>403094</td>\n",
" <td>9919</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2011</td>\n",
" <td>371765</td>\n",
" <td>8560</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e6010334-db51-4598-add1-f209c58ff18d')\"\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-e6010334-db51-4598-add1-f209c58ff18d 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-e6010334-db51-4598-add1-f209c58ff18d');\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": 18
}
]
},
{
"cell_type": "code",
"source": [
"sns.barplot(x=\"Year\", y=\"Finished Transaction\", data=merged_df)"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 297
},
"id": "tL_I2B3MwYLQ",
"outputId": "85b974ad-a3bd-41d9-bdb5-35bbf07f90c0"
},
"id": "tL_I2B3MwYLQ",
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x7f280fd455b0>"
]
},
"metadata": {},
"execution_count": 19
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
],
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAZcAAAEGCAYAAACpXNjrAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAdNUlEQVR4nO3df7RV5X3n8fen4K8kIqi3xAIJpqF1ESdBvVGmZnUZXcELTYOZGIPTFRlLQrsCHdOkHdHpjFbLjLZJ7DgxtGQkQiYjEtMUxmIIQUyaHypXJSgax1uMIwzKraAYHXXA7/yxvzduL+eee4B9zvHe+3mttdfZ+7uf/ezneJAvez/PfrYiAjMzsyr9SrsbYGZmw4+Ti5mZVc7JxczMKufkYmZmlXNyMTOzyo1udwPeLE488cSYPHlyu5thZjak3H///f8cER39404uafLkyXR3d7e7GWZmQ4qkJ2vFfVvMzMwq5+RiZmaVc3IxM7PKObmYmVnlnFzMzKxyTi5mZlY5JxczM6tc05OLpFGSHpR0R26fLOleST2SbpN0ZMaPyu2e3D+5VMcVGX9M0vmleFfGeiQtKsVrnsPMzFqjFVculwGPlravB26IiHcDe4B5GZ8H7Mn4DVkOSVOBOcB7gC7gK5mwRgE3ATOBqcDFWbbeOczMrAWa+oS+pInA7wCLgc9JEnAu8K+zyHLgamAJMDvXAW4HvpzlZwMrI+IV4AlJPcCZWa4nIrbluVYCsyU9WuccZvzva/5Fu5sw7L3jPz7U7iZYmzX7yuWvgX8HvJbbJwDPRcS+3N4OTMj1CcBTALn/+Sz/y3i/YwaK1zvHG0iaL6lbUndvb++hfkczM+unaclF0oeBXRFxf7POcbgiYmlEdEZEZ0fHAfOumZnZIWrmbbGzgY9ImgUcDYwB/gswVtLovLKYCOzI8juAScB2SaOB44BnS/E+5WNqxZ+tcw4zM2uBpl25RMQVETExIiZTdMjfFRG/B2wELsxic4HVub4mt8n9d0VEZHxOjiY7GZgC3AdsAqbkyLAj8xxr8piBzmFmZi3QjudcLqfo3O+h6B+5OeM3Aydk/HPAIoCI2AqsAh4BvgMsiIj9eVWyEFhHMRptVZatdw4zM2uBlrzPJSLuBu7O9W28PtqrXOZl4OMDHL+YYsRZ//haYG2NeM1zmJlZa/gJfTMzq5yTi5mZVc7JxczMKufkYmZmlXNyMTOzyjm5mJlZ5ZxczMysck4uZmZWOScXMzOrXEue0Dczq8LZ//XsdjdhRPjRH/3osOvwlYuZmVXOycXMzCrn5GJmZpVzcjEzs8o5uZiZWeWcXMzMrHJOLmZmVrmmJRdJR0u6T9JPJW2V9OcZv0XSE5I25zIt45J0o6QeSVsknV6qa66kx3OZW4qfIemhPOZGScr48ZLWZ/n1ksY163uamdmBmnnl8gpwbkS8D5gGdEmanvv+NCKm5bI5YzOBKbnMB5ZAkSiAq4CzKF5dfFUpWSwBPl06rivji4ANETEF2JDbZmbWIk1LLlH4RW4ekUvUOWQ2sCKPuwcYK+kk4HxgfUTsjog9wHqKRHUSMCYi7omIAFYAF5TqWp7ry0txMzNrgab2uUgaJWkzsIsiQdybuxbnra8bJB2VsQnAU6XDt2esXnx7jTjA+IjYmetPA+MHaN98Sd2Sunt7ew/tS5qZ2QGamlwiYn9ETAMmAmdKOhW4AjgFeD9wPHB5k9sQDHDFFBFLI6IzIjo7Ojqa2QwzsxGlJaPFIuI5YCPQFRE789bXK8DXKPpRAHYAk0qHTcxYvfjEGnGAZ/K2Gfm5q9pvZGZm9TRztFiHpLG5fgzwIeBnpb/0RdEX8nAesga4JEeNTQeez1tb64AZksZlR/4MYF3u2ytpetZ1CbC6VFffqLK5pbiZmbVAM6fcPwlYLmkURRJbFRF3SLpLUgcgYDPwh1l+LTAL6AFeAi4FiIjdkq4FNmW5ayJid65/BrgFOAa4MxeA64BVkuYBTwIXNe1bmpnZAZqWXCJiC3Bajfi5A5QPYMEA+5YBy2rEu4FTa8SfBc47yCabmVlF/IS+mZlVzsnFzMwq5+RiZmaVc3IxM7PKObmYmVnlnFzMzKxyTi5mZlY5JxczM6uck4uZmVXOycXMzCrn5GJmZpVzcjEzs8o5uZiZWeWcXMzMrHJOLmZmVjknFzMzq5yTi5mZVW7Q5CKpQ9KVkpZKWta3NHDc0ZLuk/RTSVsl/XnGT5Z0r6QeSbdJOjLjR+V2T+6fXKrriow/Jun8UrwrYz2SFpXiNc9hZmat0ciVy2rgOOB7wD+UlsG8ApwbEe8DpgFdkqYD1wM3RMS7gT3AvCw/D9iT8RuyHJKmAnOA9wBdwFckjZI0CrgJmAlMBS7OstQ5h5mZtUAjyeUtEXF5RKyKiG/1LYMdFIVf5OYRuQRwLnB7xpcDF+T67Nwm958nSRlfGRGvRMQTQA9wZi49EbEtIl4FVgKz85iBzmFmZi3QSHK5Q9KsQ6k8rzA2A7uA9cA/Ac9FxL4ssh2YkOsTgKcAcv/zwAnleL9jBoqfUOcc/ds3X1K3pO7e3t5D+YpmZlZDI8nlMooE87KkF3LZ20jlEbE/IqYBEymuNE45jLZWLiKWRkRnRHR2dHS0uzlmZsPG6MEKRMSxh3uSiHhO0kbgXwJjJY3OK4uJwI4stgOYBGyXNJqin+fZUrxP+Zha8WfrnMPMzFqgoaHIkj4i6Qu5fLjBYzokjc31Y4APAY8CG4ELs9hcigEDAGtym9x/V0RExufkaLKTgSnAfcAmYEqODDuSotN/TR4z0DnMzKwFBr1ykXQd8H7gGxm6TNLZEXHFIIeeBCzPUV2/AqyKiDskPQKslPQXwIPAzVn+ZuDrknqA3RTJgojYKmkV8AiwD1gQEfuzbQuBdcAoYFlEbM26Lh/gHGZm1gKDJhdgFjAtIl4DkLSc4i/susklIrYAp9WIb6Pof+kffxn4+AB1LQYW14ivBdY2eg4zM2uNRp/QH1taP64ZDTEzs+GjkSuX/ww8mB3yAn4bWFT/EDMzG8kaGS12q6S7KfpdAC6PiKeb2iozMxvSBrwtJumU/DydonN+ey6/ljEzM7Oa6l25fA6YD3yxxr6+aVzMzMwOMGByiYj5uTozR3L9kqSjm9oqMzMb0hoZLfbjBmNmZmZAnSsXSW+nmPDxGEmnUYwUAxgDvKUFbTMzsyGqXp/L+cC/oZib64u8nlz2Alc2t1lmZjaU1etzWU4xfcvHGnl/i5mZWZ9G+lzO6JuAEkDSuJyzy8zMrKZGksvMiHiubyMi9lDMN2ZmZlZTI8lllKSj+jZy+vyj6pQ3M7MRrpG5xb4BbJD0tdy+lNffdW9mZnaARuYWu17SFuC8DF0bEeua2ywzMxvKGrlyISLuBO5sclvMzGyYGLTPRdJ0SZsk/ULSq5L2S9rbwHGTJG2U9IikrZIuy/jVknZI2pzLrNIxV0jqkfSYpPNL8a6M9UhaVIqfLOnejN+WrzsmX4l8W8bvlTT54P6zmJnZ4WikQ//LwMXA48AxwKeAmxo4bh/w+YiYCkwHFkiamvtuiIhpuawFyH1zgPcAXcBXJI3K1yTfBMwEpgIXl+q5Put6N7AHmJfxecCejN+Q5czMrEUaehNlRPQAoyJif0R8jeIv/8GO2RkRD+T6C8CjFNPJDGQ2sDIiXomIJ4AeilcVnwn0RMS2iHgVWAnMliSKmZlvz+OXAxeU6uobdHA7cF6WNzOzFmgkubyUt5s2S/pLSX/c4HG/lLelTgPuzdBCSVskLZM0LmMTgKdKh23P2EDxE4DnImJfv/gb6sr9z2f5/u2aL6lbUndvb+/BfCUzM6ujkSTxySy3EHgRmAR8rNETSHob8C3gsxGxF1gC/DowDdhJ7ffFtERELI2Izojo7OjoaFczzMyGnUaGIj+Zqy9LuhGYlLfJBiXpCIrE8o2I+Lus75nS/q8Cd+TmDorE1Wdixhgg/iwwVtLovDopl++ra7uk0cBxWd7MzFqgkdFid0saI+l44AHgq5K+1MBxAm4GHo2IL5XiJ5WKfRR4ONfXAHNypNfJwBTgPmATMCVHhh1J0em/JiIC2AhcmMfPBVaX6pqb6xcCd2V5MzNrgUaeczkuIvZK+hSwIiKuyocqB3M2xS21hyRtztiVFKO9plG8KvnnwB8ARMRWSauARyhGmi2IiP0AkhYC64BRwLKI2Jr1XQ6szIk0H6RIZuTn1yX1ALspEpKZmbVII8lldF5tXAT8+0Yrjogf8vo7YMrW1jlmMbC4RnxtreMiYhvFaLL+8ZeBjzfaVjMzq1YjHfrXUFw19ETEJknvonjmxczMrKZGOvS/CXyztL2NgxgtZmZmI8+gyUVSB/BpYHK5fET8fvOaZWZmQ1kjfS6rgX8Evgfsb25zzMxsOGgkubwlIi5vekvMzGzYaKRD/47yzMVmZmaDaSS5XEaRYP6vpL2SXmhkyn0zMxu5GhktdmwrGmJmZsNHQ2+izJmLpwBH98Ui4gfNapSZmQ1tjQxF/hTFrbGJwGaKF3/9hOJdKmZmZgdotM/l/cCTEfFBiveyPNfUVpmZ2ZDWSHJ5OefqQtJREfEz4Deb2ywzMxvKGulz2S5pLPD3wHpJe4AnBznGzMxGsEZGi300V6+WtJHixVvfaWqrzMxsSKubXCSNArZGxCkAEfH9lrTKzMyGtLp9LvmyrsckvaNF7TEzs2FgwCsXSf8q33s/Dtgq6T7gxb79EfGRFrTPzMyGoHpXLn+Wn/8B+DDFS8O+WFrqkjRJ0kZJj0jaKumyjB8vab2kx/NzXMYl6UZJPZK2SDq9VNfcLP+4pLml+BmSHspjbpSkeucwM7PWGHQockR8v9bSQN37gM9HxFSKBy8XSJoKLAI2RMQUYENuA8ykmAVgCjAfWAJFogCuAs6ieKXxVaVksYTiXTN9x3VlfKBzmJlZC9Tr0D9F0paBdkbEe+tVHBE7gZ25/oKkR4EJwGzgnCy2HLgbuDzjKyIigHskjZV0UpZdHxG7ASStB7ok3Q2MiYh7Mr4CuAC4s845zMysBeollyeA363iJJImUzzZfy8wPhMPwNPA+FyfADxVOmx7xurFt9eIU+cc/ds1n+IqiXe8w2MWzMyqUi+5vBoRh/2wpKS3Ad8CPhsRe7NbBICICElxuOeop945ImIpsBSgs7Ozqe0wMxtJ6vW5/OhwK5d0BEVi+UaOPAN4Jm93kZ+7Mr4DmFQ6fGLG6sUn1ojXO4eZmbXAgMklIhYeTsU5cutm4NGI+FJp1xqgb8TXXGB1KX5JjhqbDjyft7bWATMkjcuO/BnAuty3V9L0PNcl/eqqdQ4zM2uBht7ncojOBj4JPCRpc8auBK4DVkmaRzFH2UW5by0wC+gBXgIuBYiI3ZKuBTZluWv6OveBzwC3AMdQdOTfmfGBzmFmZi3QtOQSET8ENMDu82qUD2DBAHUtA5bViHcDp9aIP1vrHGZm1hp1n9Cvd2CpD8XMzOwN6l259A1D/lXgt4C7cvuDwI8BJxczM6tpwOQSEZcCSPouMLXvuZEcfXVLS1pnZmZDUiNvopxUeiAR4BnATxyamdmAGunQ3yBpHXBrbn8C+F7zmmRmZkNdI2+iXCjpo8BvZ2hpRHy7uc0yM7OhrNGhyA8AL0TE9yS9RdKxEfFCMxtmZmZD16B9LpI+DdwO/G2GJgB/38xGmZnZ0NZIh/4Ciqft9wJExOMUw5PNzMxqaiS5vBIRr/ZtSBoNeAZhMzMbUCPJ5fuSrgSOkfQh4JvA/2xus8zMbChrJLksAnqBh4A/oJhg8s+a2SgzMxvaGhmK/Brw1VzMzMwGNWhykXQ2cDXwziwvikmM39XcppmZ2VDVyHMuNwN/DNwP7G9uc8zMbDhoJLk8HxF3Dl7MzMysUO99Lqfn6kZJf0Uxxf4rffsj4oEmt83MzIaoeqPFvpjLWUAn8J9KsS8MVrGkZZJ2SXq4FLta0g5Jm3OZVdp3haQeSY9JOr8U78pYj6RFpfjJku7N+G2Sjsz4Ubndk/snN/ofw8zMqlHvfS4fPMy6bwG+DKzoF78hIt6QnCRNBeYA7wF+DfiepN/I3TcBHwK2A5skrYmIR4Drs66Vkv4GmAcsyc89EfFuSXOy3CcO87uYmdlBaGRuscskjVHhv0l6QNKMwY6LiB8Auxtsx2xgZUS8EhFPAD3Ambn0RMS2nCVgJTBbkoBzKeY8A1gOXFCqa3mu3w6cl+XNzKxFGnmI8vcjYi8wAzgB+CRw3WGcc6GkLXnbbFzGJgBPlcpsz9hA8ROA5yJiX7/4G+rK/c9n+QNImi+pW1J3b2/vYXwlMzMrayS59P2rfxawIiK2lmIHawnw68A0YCdF/03bRMTSiOiMiM6Ojo52NsXMbFhpJLncL+m7FMllnaRjgdcO5WQR8UxE7C899X9m7toBTCoVnZixgeLPAmNzEs1y/A115f7jsryZmbVII8llHsX8Yu+PiJeAI4FLD+Vkkk4qbX4U6BtJtgaYkyO9TgamAPcBm4ApOTLsSIpO/zUREcBG4MI8fi6wulTX3Fy/ELgry5uZWYvUe87llIj4GcUtLIB3HUy/uKRbgXOAEyVtB64CzpE0jWLK/p9TTIRJRGyVtAp4BNgHLIiI/VnPQmAdMApYlrflAC4HVkr6C+BBipkEyM+vS+qhGFAwp+FGm5lZJeo9of85YD61+0WCYrTWgCLi4hrhm2vE+sovBhbXiK+lmIm5f3wbr99WK8dfBj5er21mZtZc9Z5zmZ+fh/u8i5mZjTCNzC2GpN8CJpfLR0T/hyPNzMyAxqbc/zrF8OHNvD4rcnDgk/dmZmZAY1cuncBUj7gyM7NGNTIU+WHg7c1uiJmZDR+NXLmcCDwi6T7eOOX+R5rWKjMzG9IaSS5XN7sRZmY2vAyaXCLi+61oiJmZDR/1ntD/YUR8QNILFKPDfrkLiIgY0/TWmZnZkFTvyuX3ACLi2Ba1xczMhol6o8W+3bci6VstaIuZmQ0T9ZJLeZbKdzW7IWZmNnzUSy4xwLqZmVld9fpc3idpL8UVzDG5Du7QNzOzQdSbFXlUKxtiZmbDRyPTv5iZmR2UpiUXScsk7ZL0cCl2vKT1kh7Pz3EZl6QbJfVI2iLp9NIxc7P845LmluJnSHooj7lR+ZrMgc5hZmat08wrl1uArn6xRcCGiJgCbMhtgJnAlFzmA0ugSBQUr0c+i+Ktk1eVksUS4NOl47oGOYeZmbVI05JLRPyA4h32ZbOB5bm+HLigFF8RhXuAsZJOAs4H1kfE7ojYA6wHunLfmIi4J18FsKJfXbXOYWZmLdLqPpfxEbEz158Gxuf6BOCpUrntGasX314jXu8cB5A0X1K3pO7e3t5D+DpmZlZL2zr084qjqc/PDHaOiFgaEZ0R0dnR0dHMppiZjSitTi7P5C0t8nNXxncAk0rlJmasXnxijXi9c5iZWYu0OrmsAfpGfM0FVpfil+SosenA83lrax0wQ9K47MifAazLfXslTc9RYpf0q6vWOczMrEUaeVnYIZF0K3AOcKKk7RSjvq4DVkmaBzwJXJTF1wKzgB7gJeBSgIjYLelaYFOWuyYi+gYJfIZiRNoxwJ25UOccZmbWIk1LLhFx8QC7zqtRNoAFA9SzDFhWI94NnFoj/mytc5iZWev4CX0zM6uck4uZmVXOycXMzCrn5GJmZpVzcjEzs8o5uZiZWeWcXMzMrHJOLmZmVjknFzMzq5yTi5mZVc7JxczMKufkYmZmlXNyMTOzyjm5mJlZ5ZxczMysck4uZmZWOScXMzOrXFuSi6SfS3pI0mZJ3Rk7XtJ6SY/n57iMS9KNknokbZF0eqmeuVn+cUlzS/Ezsv6ePFat/5ZmZiNXO69cPhgR0yKiM7cXARsiYgqwIbcBZgJTcpkPLIEiGQFXAWcBZwJX9SWkLPPp0nFdzf86ZmbW5810W2w2sDzXlwMXlOIronAPMFbSScD5wPqI2B0Re4D1QFfuGxMR90REACtKdZmZWQu0K7kE8F1J90uan7HxEbEz158Gxuf6BOCp0rHbM1Yvvr1G/ACS5kvqltTd29t7ON/HzMxKRrfpvB+IiB2SfhVYL+ln5Z0REZKi2Y2IiKXAUoDOzs6mn8/MbKRoy5VLROzIz13Atyn6TJ7JW1rk564svgOYVDp8YsbqxSfWiJuZWYu0PLlIequkY/vWgRnAw8AaoG/E11xgda6vAS7JUWPTgefz9tk6YIakcdmRPwNYl/v2Spqeo8QuKdVlZmYt0I7bYuOBb+fo4NHA/4iI70jaBKySNA94Ergoy68FZgE9wEvApQARsVvStcCmLHdNROzO9c8AtwDHAHfmYmZmLdLy5BIR24D31Yg/C5xXIx7AggHqWgYsqxHvBk497MaamdkheTMNRTYzs2HCycXMzCrn5GJmZpVzcjEzs8q16yHKIe2MP13R7iYMe/f/1SXtboKZHQZfuZiZWeWcXMzMrHJOLmZmVjknFzMzq5yTi5mZVc7JxczMKufkYmZmlXNyMTOzyjm5mJlZ5ZxczMysck4uZmZWOScXMzOr3LBNLpK6JD0mqUfSona3x8xsJBmWyUXSKOAmYCYwFbhY0tT2tsrMbOQYlskFOBPoiYhtEfEqsBKY3eY2mZmNGIqIdrehcpIuBLoi4lO5/UngrIhY2K/cfGB+bv4m8FhLG9paJwL/3O5G2CHxbze0Dfff750R0dE/OKJfFhYRS4Gl7W5HK0jqjojOdrfDDp5/u6FtpP5+w/W22A5gUml7YsbMzKwFhmty2QRMkXSypCOBOcCaNrfJzGzEGJa3xSJin6SFwDpgFLAsIra2uVntNiJu/w1T/u2GthH5+w3LDn0zM2uv4XpbzMzM2sjJxczMKufkMkRJmiRpo6RHJG2VdFnGj5e0XtLj+Tku45J0Y06Hs0XS6aW6rpf0cC6faNd3GikO4bc7RdJPJL0i6U/61eVpjlqs4t9vmaRdkh5ux3dpJieXoWsf8PmImApMBxbkFDeLgA0RMQXYkNtQTIUzJZf5wBIASb8DnA5MA84C/kTSmFZ+kRHoYH+73cC/Bb5QrsTTHLVNJb9fugXoanqL28DJZYiKiJ0R8UCuvwA8CkygmOZmeRZbDlyQ67OBFVG4Bxgr6SSKv5R+EBH7IuJFYAvD9A/7m8XB/nYRsSsiNgH/r19VnuaoDSr8/YiIH1Akn2HHyWUYkDQZOA24FxgfETtz19PA+FyfADxVOmx7xn4KdEl6i6QTgQ/yxgdQrYka/O0GMtBvai1ymL/fsDYsn3MZSSS9DfgW8NmI2Cvpl/siIiTVHWseEd+V9H7gx0Av8BNgfxObbOlwfztrL/9+9fnKZQiTdATFH+5vRMTfZfiZvN1Ffu7K+IBT4kTE4oiYFhEfAgT8r1a0fyQ7yN9uIJ7mqE0q+v2GNSeXIUrFP5NuBh6NiC+Vdq0B5ub6XGB1KX5JjhqbDjwfETsljZJ0Qtb5XuC9wHdb8iVGqEP47QbiaY7aoMLfb1jzE/pDlKQPAP8IPAS8luErKe79rgLeATwJXBQRu/N/iC9TdNa/BFwaEd2SjgYeyOP3An8YEZtb901GnkP47d4OdANjsvwvgKl5K2YW8Ne8Ps3R4pZ+mRGo4t/vVuAcimn5nwGuioibW/h1msbJxczMKufbYmZmVjknFzMzq5yTi5mZVc7JxczMKufkYmZmlXNyMWuTfOboh5JmlmIfl/SddrbLrAoeimzWRpJOBb5JMT/VaOBBoCsi/ukQ6hodEfsqbqLZIXFyMWszSX8JvAi8NT/fCZwKHAFcHRGrc4LEr2cZgIUR8WNJ5wDXAnuAUyLiN1rberPanFzM2kzSWylmSXgVuAPYGhH/XdJY4D6Kq5oAXouIlyVNAW6NiM5MLv8AnBoRT7TnG5gdyLMim7VZRLwo6TaKaUEuAn639MbCoymmE/k/wJclTaOYtbp8hXKfE4u92Ti5mL05vJaLgI9FxGPlnZKupph76n0UA3FeLu1+sUVtNGuYR4uZvbmsA/4oJxpF0mkZPw7YGRGvAZ+kmKjS7E3LycXszeVaio78LZK25jbAV4C5kn4KnIKvVuxNzh36ZmZWOV+5mJlZ5ZxczMysck4uZmZWOScXMzOrnJOLmZlVzsnFzMwq5+RiZmaV+/9rkU7ui3Ri/AAAAABJRU5ErkJggg==\n"
},
"metadata": {
"needs_background": "light"
}
}
]
},
{
"cell_type": "code",
"source": [
"sns.barplot(x=\"Year\", y=\"Cancel Transaction\", data=merged_df)"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 297
},
"id": "SH5Mr30K7I5C",
"outputId": "fde98376-f83e-40ce-83c5-aead680638b7"
},
"id": "SH5Mr30K7I5C",
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x7f280fd1cfd0>"
]
},
"metadata": {},
"execution_count": 20
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
],
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAZEAAAEGCAYAAACkQqisAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAWCUlEQVR4nO3df/BddX3n8edLAqIoghApm1BD14hDqVXMAlucHS1bCNoaOlWk40qWpWatKNit3aKzWxwo09J1/dUu7LJCG9QVEd0hU38gG7FoLWAACwKLRBFJGiAafjOigff+cT+BS/b7/ebmfHPvzc33+Zi58z3nc849533nZHhxzvmcz0lVIUlSF88ZdwGSpMlliEiSOjNEJEmdGSKSpM4MEUlSZ/PGXcCo7b///rVo0aJxlyFJE+OGG274cVXNn2rZnAuRRYsWsWbNmnGXIUkTI8nd0y3zcpYkqTNDRJLUmSEiSerMEJEkdTa0EElycZL7k3y3r+3FSa5Kcmf7u29rT5KPJ1mb5OYkh/d9Z3lb/84ky/vaX5PklvadjyfJsH6LJGlqwzwT+Rtg6VZtZwKrq2oxsLrNAxwPLG6fFcAF0Asd4CzgSOAI4KwtwdPWeUff97belyRpyIYWIlV1DbBpq+ZlwMo2vRI4oa/9kuq5FtgnyYHAccBVVbWpqh4ArgKWtmV7V9W11RuG+JK+bUmSRmTU90QOqKoNbfpe4IA2vQC4p2+9da1tpvZ1U7RPKcmKJGuSrNm4cePsfoEk6Wlju7HeziBG8jKTqrqwqpZU1ZL586d86FKS1MGon1i/L8mBVbWhXZK6v7WvBw7qW29ha1sPvG6r9q+39oVTrC8B8KOzf2XcJcwJv/gnt4y7BI3ZqM9EVgFbelgtB67oaz+59dI6CnioXfa6Ejg2yb7thvqxwJVt2cNJjmq9sk7u25YkaUSGdiaS5DP0ziL2T7KOXi+rPwcuS3IqcDdwYlv9S8AbgLXA48ApAFW1Kck5wLfbemdX1Zab9e+i1wPsecCX20eSNEJDC5Gq+t1pFh0zxboFnDbNdi4GLp6ifQ1w2GxqlCTNjk+sS5I6M0QkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiSerMEJEkdWaISJI6M0QkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiSerMEJEkdWaISJI6M0QkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiSerMEJEkdTZv3AVI0taO/sujx13CLu/v3/P3O2Q7nolIkjozRCRJnRkikqTODBFJUmeGiCSpM0NEktSZISJJ6swQkSR1NpYQSfIHSW5N8t0kn0myZ5KDk1yXZG2SzybZo6373Da/ti1f1Led97f2O5IcN47fIklz2chDJMkC4HRgSVUdBuwGnAScB3ykql4GPACc2r5yKvBAa/9IW48kh7bv/TKwFDg/yW6j/C2SNNeN63LWPOB5SeYBzwc2AL8OXN6WrwROaNPL2jxt+TFJ0tovraonquouYC1wxIjqlyQxhhCpqvXAh4Af0QuPh4AbgAeranNbbR2woE0vAO5p393c1t+vv32K7zxLkhVJ1iRZs3Hjxh37gyRpDhvH5ax96Z1FHAz8M2AvepejhqaqLqyqJVW1ZP78+cPclSTNKeO4nPWvgbuqamNV/Rz4AnA0sE+7vAWwEFjfptcDBwG05S8CftLfPsV3JEkjMI4Q+RFwVJLnt3sbxwC3AVcDb27rLAeuaNOr2jxt+deqqlr7Sa331sHAYuD6Ef0GSRJjeJ9IVV2X5HLgRmAzcBNwIfBF4NIkf9raLmpfuQj4ZJK1wCZ6PbKoqluTXEYvgDYDp1XVkyP9MZI0x43lpVRVdRZw1lbNP2CK3lVV9VPgLdNs51zg3B1eoCRpID6xLknqzBCRJHVmiEiSOjNEJEmdGSKSpM4MEUlSZ4aIJKmzgZ4TacO3v7R//aq6ZlhFSZImwzZDJMl5wFvpPRm+5YnwAgwRSZrjBjkTOQE4pKqeGHYxkqTJMsg9kR8Auw+7EEnS5BnkTORx4DtJVgNPn41U1elDq0qSNBEGCZFV7SNJ0rNsM0SqamWSPYCXt6Y72sukJElz3CC9s14HrAR+CAQ4KMlyu/hKkga5nPVfgWOr6g6AJC8HPgO8ZpiFSZJ2foP0ztp9S4AAVNX3sLeWJInBzkTWJPkE8Kk2/zZgzfBKkiRNikFC5PeB04AtXXq/AZw/tIokSRNjkN5ZTwAfbh9Jkp42bYgkuayqTkxyC72xsp6lql451MokSTu9mc5Ezmh/f3MUhUiSJs+0vbOqakObfFdV3d3/Ad41mvIkSTuzQbr4/sYUbcfv6EIkSZNnpnsiv0/vjOOfJ7m5b9ELgW8NuzBJ0s5vpnsi/wv4MvBnwJl97Y9U1aahViVJmggz3RN5qKp+CHwM2NR3P2RzkiNHVaAkaec1yD2RC4BH++YfbW2SpDlukBBJVT39nEhVPcVgT7pLknZxA70eN8npSXZvnzPovTJXkjTHDRIi7wR+DVgPrAOOBFYMsyhJ0mQYZOys+4GTRlCLJGnCbPNMJMmeSU5Lcn6Si7d8ZrPTJPskuTzJ/01ye5J/meTFSa5Kcmf7u29bN0k+nmRtkpuTHN63neVt/TuTLJ9NTZKk7TfI5axPAr8AHAf8HbAQeGSW+/0Y8JWqegXwq8Dt9J5FWV1Vi4HVPPNsyvHA4vZZQesZluTFwFn0Lq8dAZy1JXgkSaMxSIi8rKr+M/BYVa0E3kjvP9ydJHkR8K+AiwCq6mdV9SCwjN673Gl/T2jTy4BLqudaYJ8kB9ILtauqalNVPQBcBSztWpckafsNEiI/b38fTHIY8CLgJbPY58HARuCvk9yU5BNJ9gIO6Bv08V7ggDa9ALin7/vrWtt07ZKkERkkRC5sl4n+E7AKuA34i1nscx5wOHBBVb0aeIxnD6tCey7l/3uHSVdJViRZk2TNxo0bd9RmJWnO22aIVNUnquqBqrqmqn6pql5SVf99FvtcB6yrquva/OX0QuW+dpmK9vf+tnw9cFDf9xe2tunap/oNF1bVkqpaMn/+/FmULknqN0jvrDOS7N16SX0iyY1Jju26w6q6F7gnySGt6Rh6ZzergC09rJYDV7TpVcDJbf9HAQ+1y15XAscm2bedKR3b2iRJIzLI8CX/rqo+luQ4YD/g7fR6bH11Fvt9D/DpJHvQe/r9FHqBdlmSU4G7gRPbul8C3gCsBR5v61JVm5KcA3y7rXe2owtL0mgNEiJpf99Ar5fUrUky0xe2paq+AyyZYtExU6xbwGnTbOdiYFbPrEiSuhvkxvoNSb5KL0SuTPJC4KnhliVJmgSDnImcCrwK+EFVPZ5kP9olJUnS3DbI2FlPJbkPODSJQ8BLkp62zVBIch7wVno9qJ5szQVcM8S6JEkTYJAzixOAQ6rqiWEXI0maLAO9lArYfdiFSJImzyBnIo8D30myGnj6bKSqTh9aVZKkiTBIiKxqH0mSnmWQ3lkrt7WOJGluGqR31mLgz4BDgT23tFfVLw2xLknSBBjkxvpf03ub4Gbg9cAlwKeGWZQkaTIMEiLPq6rVQKrq7qr6IL23G0qS5rhBbqw/keQ5wJ1J3k3vnR0vGG5ZkqRJMMiZyBnA84HTgdcA/4Zn3vshSZrDZjwTSbIb8Naqeh/wKA68KEnqM+OZSFU9Cbx2RLVIkibMtGciSeZV1WbgpiSrgM8Bj21ZXlVfGEF9kqSd2EyXs64HDqf3bMhPgF/vW1aAISJJc9xMIRKAqvI+iCRpSjOFyPwk/2G6hVX14SHUI0maIDOFyG70ngfJiGqRJE2YmUJkQ1WdPbJKJEkTZ6Yuvp6BSJJmNFOIHDOyKiRJE2naEKmqTaMsRJI0eQYZO0uSpCkZIpKkzmYa9uQRek+mwzM32atNV1XtPeTaJEk7uWlDpKpeOMpCJEmTZ6DLWUlem+SUNr1/koOHW5YkaRJsM0SSnAX8MfD+1rQHvmNdksRgZyK/DbyJNgx8Vf0T4KUuSdJAIfKzqiraTfYkew23JEnSpBgkRC5L8j+AfZK8A/g/wP+c7Y6T7JbkpiR/2+YPTnJdkrVJPptkj9b+3Da/ti1f1LeN97f2O5IcN9uaJEnbZ5shUlUfAi4HPg8cAvxJVf3lDtj3GcDtffPnAR+pqpcBDwCntvZTgQda+0faeiQ5FDgJ+GVgKXB+eye8JGlEBrmxfjDwjar6o6p6H/DN/rOBLpIsBN4IfKLNh96bEy9vq6wETmjTy9o8bfkxbf1lwKVV9URV3QWsBY6YTV2SpO0zyOWszwFP9c0/2dpm46PAf+zb7n7Ag+2d7gDrgAVtegFwD0Bb/lBb/+n2Kb7zLElWJFmTZM3GjRtnWbokaYtBQmReVf1sy0yb3qPrDpP8JnB/Vd3QdRvbq6ourKolVbVk/vz5o9qtJO3yBgmRjUnetGUmyTLgx7PY59HAm5L8ELiU3mWsj9G7cb/lCfqFwPo2vR44qO17HvAi4Cf97VN8R5I0AoOEyDuBDyT5UZJ76D14+O+77rCq3l9VC6tqEb0b41+rqrcBVwNvbqstB65o06vaPG3511qX41XASa331sHAYuD6rnVJkrbfTK/HBaCqvg8cleQFbf7RIdXyx8ClSf4UuAm4qLVfBHwyyVpgE73goapuTXIZcBuwGTitqp4cUm2SpClsM0SSPBf4HWARMK/XMQp2xPvXq+rrwNfb9A+YondVVf0UeMs03z8XOHe2dUiSutlmiNC7rPQQcAPwxHDLkSRNkkFCZGFVLR16JZKkiTPIjfVvJfmVoVciSZo4g5yJvBb4t0nuonc5a8ubDV851MokSTu9QULk+KFXIUmaSIN08b0bIMlLgD2HXpEkaWIMMgDjm5LcCdwF/B3wQ+DLQ65LkjQBBrmxfg5wFPC9qjoYOAa4dqhVSZImwiAh8vOq+gnwnCTPqaqrgSVDrkuSNAEGubH+YBvy5Brg00nup71vXZI0tw1yJrIMeBz4A+ArwPeB3xpmUZKkyTBtiCR5WZKjq+qxqnqqqjZX1UrgRmCf0ZUoSdpZzXQm8lHg4SnaH2rLJElz3EwhckBV3bJ1Y2tbNLSKJEkTY6YQmemS1fN2dCGSpMkzU4isSfKOrRuT/B69YeElSXPcTF183wv87yRv45nQWALsAfz2sAuTJO38pg2RqroP+LUkrwcOa81frKqvjaQySdJOb5ABGK8Grh5BLZKkCTPIw4aSJE3JEJEkdWaISJI6M0QkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiSerMEJEkdWaISJI6M0QkSZ0ZIpKkzgwRSVJnIw+RJAcluTrJbUluTXJGa39xkquS3Nn+7tvak+TjSdYmuTnJ4X3bWt7WvzPJ8lH/Fkma68ZxJrIZ+MOqOhQ4CjgtyaHAmcDqqloMrG7zAMcDi9tnBXAB9EIHOAs4EjgCOGtL8EiSRmPkIVJVG6rqxjb9CHA7sABYBqxsq60ETmjTy4BLqudaYJ8kBwLHAVdV1aaqegC4Clg6wp8iSXPeWO+JJFkEvBq4Djigqja0RfcCB7TpBcA9fV9b19qma59qPyuSrEmyZuPGjTusfkma68YWIkleAHweeG9VPdy/rKoKqB21r6q6sKqWVNWS+fPn76jNStKcN5YQSbI7vQD5dFV9oTXf1y5T0f7e39rXAwf1fX1ha5uuXZI0IuPonRXgIuD2qvpw36JVwJYeVsuBK/raT269tI4CHmqXva4Ejk2yb7uhfmxrkySNyLwx7PNo4O3ALUm+09o+APw5cFmSU4G7gRPbsi8BbwDWAo8DpwBU1aYk5wDfbuudXVWbRvMTJEkwhhCpqm8CmWbxMVOsX8Bp02zrYuDiHVedJGl7+MS6JKkzQ0SS1JkhIknqzBCRJHVmiEiSOjNEJEmdGSKSpM4MEUlSZ4aIJKkzQ0SS1JkhIknqzBCRJHVmiEiSOjNEJEmdGSKSpM7G8VKqifGaP7pk3CXs8m74LyePuwRJs+CZiCSpM0NEktSZISJJ6swQkSR1ZohIkjozRCRJnRkikqTODBFJUmeGiCSpM0NEktSZISJJ6swQkSR1ZohIkjozRCRJnRkikqTODBFJUmeGiCSps4kPkSRLk9yRZG2SM8ddjyTNJRMdIkl2A/4bcDxwKPC7SQ4db1WSNHdMdIgARwBrq+oHVfUz4FJg2ZhrkqQ5I1U17ho6S/JmYGlV/V6bfztwZFW9e6v1VgAr2uwhwB0jLXR09gd+PO4i1JnHb7LtysfvpVU1f6oF80ZdyThU1YXAheOuY9iSrKmqJeOuQ914/CbbXD1+k345az1wUN/8wtYmSRqBSQ+RbwOLkxycZA/gJGDVmGuSpDljoi9nVdXmJO8GrgR2Ay6uqlvHXNY47fKX7HZxHr/JNieP30TfWJckjdekX86SJI2RISJJ6swQ2cklOSjJ1UluS3JrkjNa+4uTXJXkzvZ339aeJB9vw8DcnOTwvm2dl+S77fPWcf2muaLDsXtFkn9I8kSS9221LYf3GbEdfPwuTnJ/ku+O47cMkyGy89sM/GFVHQocBZzWhnY5E1hdVYuB1W0eekPALG6fFcAFAEneCBwOvAo4Enhfkr1H+UPmoO09dpuA04EP9W/E4X3GZoccv+ZvgKVDr3gMDJGdXFVtqKob2/QjwO3AAnrDu6xsq60ETmjTy4BLqudaYJ8kB9L7j881VbW5qh4DbmYX/Ue9s9jeY1dV91fVt4Gfb7Uph/cZgx14/Kiqa+iFzC7HEJkgSRYBrwauAw6oqg1t0b3AAW16AXBP39fWtbZ/BJYmeX6S/YHX8+wHNTVEAx676Ux3TDUiszx+u7SJfk5kLknyAuDzwHur6uEkTy+rqkoyY1/tqvpqkn8BfAvYCPwD8OQQS1Yz22On8fL4zcwzkQmQZHd6/4g/XVVfaM33tctUtL/3t/Zph4KpqnOr6lVV9RtAgO+Nov65bDuP3XQc3mdMdtDx26UZIju59P635yLg9qr6cN+iVcDyNr0cuKKv/eTWS+so4KGq2pBktyT7tW2+Engl8NWR/Ig5qsOxm47D+4zBDjx+uzSfWN/JJXkt8A3gFuCp1vwBetdmLwN+EbgbOLGqNrV/+H9F76b548ApVbUmyZ7Aje37DwPvrKrvjO6XzD0djt0vAGuAvdv6jwKHtksobwA+yjPD+5w70h8zB+3g4/cZ4HX0hou/Dzirqi4a4c8ZGkNEktSZl7MkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiDVF7XuebSY7va3tLkq+Msy5pR7GLrzRkSQ4DPkdv7KV5wE3A0qr6fodtzauqzTu4RKkzQ0QagSR/ATwG7NX+vhQ4DNgd+GBVXdEG+ftkWwfg3VX1rSSvA84BHgBeUVUvH2310vQMEWkEkuxFb8SAnwF/C9xaVZ9Ksg9wPb2zlAKeqqqfJlkMfKaqlrQQ+SJwWFXdNZ5fIE3NUXylEaiqx5J8lt5QGCcCv9X39rs96Q2h8U/AXyV5Fb0RlvvPOK43QLQzMkSk0XmqfQL8TlXd0b8wyQfpjav0q/Q6vfy0b/FjI6pR2i72zpJG70rgPW2wTJK8urW/CNhQVU8Bb6c32KK0UzNEpNE7h94N9ZuT3NrmAc4Hlif5R+AVePahCeCNdUlSZ56JSJI6M0QkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiSers/wHtSuakHXdtAQAAAABJRU5ErkJggg==\n"
},
"metadata": {
"needs_background": "light"
}
}
]
},
{
"cell_type": "markdown",
"id": "158f85e3",
"metadata": {
"id": "158f85e3"
},
"source": [
"### Cancellation Rate"
]
},
{
"cell_type": "markdown",
"source": [
"Hitung cancellation rate untuk setiap tahunnya.\n",
"Cancellation rate adalah persentase pelanggan yang melakukan pembatalan order\n",
"yang telah dilakukan. Formulanya adalah jumlah customer yang cancel dibagi jumlah\n",
"seluruh customer kemudian dikali 100%.\n"
],
"metadata": {
"id": "blvo98ct7cAN"
},
"id": "blvo98ct7cAN"
},
{
"cell_type": "code",
"execution_count": null,
"id": "ca8edaa1",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "ca8edaa1",
"outputId": "711be319-2dbc-47d2-fbdd-717f9d2fbb9d"
},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"(Year\n",
" 2009 1015\n",
" Name: Invoice, dtype: int64, Year\n",
" 2010 9919\n",
" Name: Invoice, dtype: int64, Year\n",
" 2011 8560\n",
" Name: Invoice, dtype: int64)"
]
},
"metadata": {},
"execution_count": 45
}
],
"source": [
"#Definisi variabel jumlah costumer yang melakukan pembatalan per tahun --> terdapat beberapa customer dengan ID yang sama melakukan pembatalan sehingga menggunakan fuction nunique()\n",
"cancelID = cancel.groupby(\"Year\").count()\n",
"Cancel_ID_2009 = cancelID['Invoice'].iloc[[0]]\n",
"Cancel_ID_2010 = cancelID['Invoice'].iloc[[1]]\n",
"Cancel_ID_2011 = cancelID['Invoice'].iloc[[2]] \n",
"Cancel_ID_2009, Cancel_ID_2010,Cancel_ID_2011"
]
},
{
"cell_type": "code",
"source": [
"#Definisi variabel semua jumlah costumer yang melakukan transaksi baik yg valid atau batal --> terdapat beberapa customer dengan ID yang sama sehingga menggunakan fuction nunique()\n",
"semuaID = data.groupby(\"Year\").count()\n",
"Semua_ID_2009 = semuaID['Invoice'].iloc[[0]]\n",
"Semua_ID_2010 = semuaID['Invoice'].iloc[[1]]\n",
"Semua_ID_2011 = semuaID['Invoice'].iloc[[2]]\n",
"Semua_ID_2009,Semua_ID_2010,Semua_ID_2011"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "0RwdhCdI96Vl",
"outputId": "5f09d093-6c46-4262-e3a9-d78c767725c2"
},
"id": "0RwdhCdI96Vl",
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"(Year\n",
" 2009 45228\n",
" Name: Invoice, dtype: int64, Year\n",
" 2010 522714\n",
" Name: Invoice, dtype: int64, Year\n",
" 2011 499429\n",
" Name: Invoice, dtype: int64)"
]
},
"metadata": {},
"execution_count": 46
}
]
},
{
"cell_type": "code",
"source": [
"#operasi / perhitungan Cancellation_rate\n",
"Cancellation_rate_2009 = (Cancel_ID_2009/Semua_ID_2009)*100\n",
"Cancellation_rate_2010 = (Cancel_ID_2010/Semua_ID_2010)*100\n",
"Cancellation_rate_2011 = (Cancel_ID_2011/Semua_ID_2011)*100"
],
"metadata": {
"id": "IMEy9As-T0Cd"
},
"id": "IMEy9As-T0Cd",
"execution_count": null,
"outputs": []
},
{
"cell_type": "code",
"source": [
"#menggabungkan 3 variabel Cancellation_rate dalam 1 dataframe\n",
"Cancellation_rate = pd.concat([Cancellation_rate_2009,Cancellation_rate_2010,Cancellation_rate_2011])\n",
"Cancellation_rate = Cancellation_rate.reset_index()\n",
"Cancellation_rate"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 143
},
"id": "RCMpU3kcCY2y",
"outputId": "f715d3eb-02dc-43de-db99-95a55283cf39"
},
"id": "RCMpU3kcCY2y",
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Year Invoice\n",
"0 2009 2.244185\n",
"1 2010 1.897596\n",
"2 2011 1.713957"
],
"text/html": [
"\n",
" <div id=\"df-37a4be81-492e-45e6-833b-303d66a3a8c9\">\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>Year</th>\n",
" <th>Invoice</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2009</td>\n",
" <td>2.244185</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2010</td>\n",
" <td>1.897596</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2011</td>\n",
" <td>1.713957</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-37a4be81-492e-45e6-833b-303d66a3a8c9')\"\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-37a4be81-492e-45e6-833b-303d66a3a8c9 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-37a4be81-492e-45e6-833b-303d66a3a8c9');\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": 48
}
]
},
{
"cell_type": "code",
"source": [
"#Output 4\n",
"#Visualisasi Cancellation_rate pertahun\n",
"ax = sns.barplot(x=\"Year\", y=\"Invoice\", data=Cancellation_rate)\n",
"ax.set(xlabel='Tahun', ylabel='Cancellation Rate (%)')\n",
"plt.show()"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 279
},
"id": "YRt4jN34DaYC",
"outputId": "8990ee88-5791-4207-e613-4749bf031f41"
},
"id": "YRt4jN34DaYC",
"execution_count": null,
"outputs": [
{
"output_type": "display_data",
"data": {
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
],
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEGCAYAAABo25JHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAATP0lEQVR4nO3de7RmBVnH8e/PAYQARZtRidtQki1UJJsUw1WUukIyyLQCScBCqiWKpeWllMRslamhghdMBNTlJbEclVJTBIt0MYPIdRnjZQSaZATlIgrO8PTHu4++Hs6cd8/M2fvlnP39rPWus2/vfp937ZnzO/v27FQVkqThut+0C5AkTZdBIEkDZxBI0sAZBJI0cAaBJA3cDtMuYGstX768Vq5cOe0yJGlRWbt27beqasVc8xZdEKxcuZI1a9ZMuwxJWlSSrN/SPA8NSdLAGQSSNHAGgSQNnEEgSQNnEEjSwBkEkjRwBoEkDZxBIEkDZxBI0sAtujuLt8Yv/Pl50y5hENb+w3HTLkHSdnCPQJIGziCQpIEzCCRp4AwCSRo4g0CSBs4gkKSBMwgkaeAMAkkaOINAkgbOIJCkgTMIJGngDAJJGjiDQJIGziCQpIEzCCRp4AwCSRo4g0CSBs4gkKSB6ywIkuyT5MIk1yS5OskpcyyTJG9Ksi7JFUke21U9kqS5dfnM4k3Ai6rqsiS7A2uTfKqqrhlb5qnAAc3r8cBbm5+SpJ50tkdQVRuq6rJm+HbgWmCvWYsdBZxXI58H9kiyZ1c1SZLurZdzBElWAj8PfGHWrL2A68fGb+DeYUGSk5KsSbJm48aNXZUpSYPUeRAk2Q04H3hhVd22LeuoqrOqalVVrVqxYsXCFihJA9dpECTZkVEIvLeqPjzHIjcC+4yN791MkyT1pMurhgK8E7i2qt6whcVWA8c1Vw8dAtxaVRu6qkmSdG9dXjV0KPBs4MoklzfTXg7sC1BVbwMuAI4A1gF3As/psB5J0hw6C4Kq+k8gE5Yp4Hld1SBJmsw7iyVp4AwCSRo4g0CSBs4gkKSB6/KqIWm7fOO0R0+7hCVv31deOe0SdB/gHoEkDZxBIEkDZxBI0sAZBJI0cAaBJA2cQSBJA2cQSNLAGQSSNHAGgSQNnEEgSQNnEEjSwBkEkjRwBoEkDVyr7qNJ7gc8Bvgp4HvAVVV1U5eFSZL6MW8QJPkZ4CXAk4HrgI3AzsDPJrkTeDtwblXd03WhkqRuTNoj+BvgrcAfNQ+a/6EkDwGeBTwbOLeb8iRJXZs3CKrqmHnm3QScvuAVSVoSDn3zodMuYcn7r+f/14KsZ6tOFid5eJL3JDk/yRMWpAJJ0lRNOkewc1V9f2zSq4G/aIY/ChzcVWGSpH5M2iP4aJLjxsZ/AKwE9gM2d1WUJKk/k4LgcOABSf49yS8DLwZ+HXg6cGzXxUmSujfpZPFm4Iwk7wZeAfwJ8FdV9ZU+ipMkdW/SOYLHA38O3A38LaObyV6T5Ebg1VX1ne5LlCR1adJ9BG8HjgB2A95VVYcCRyf5FeADjA4TSZIWsUlBsInRyeFdGe0VAFBVFwEXdVeWJKkvk4LgWcAfMQqB4yYsK0lahCYFwXVV9aL5FkiS2e0nJEmLx6TLRy9M8vwk+45PTLJTkl9Lci5wfHflSZK6NmmP4HDgD4D3Jdkf+A6j7qPLgE8Cp1fVF7stUZLUpUn3EXwfeAvwliQ7AsuB73nZqCQtHa0eTANQVT8ANnRYiyRpCnxUpSQNXGdBkOTsJDcluWoL8w9LcmuSy5vXK7uqRZK0Za2DIMl+SZ7cDO+SZPcJbzmH0cnm+Xyuqg5uXqe1rUWStHBaBUGS5wIfYtRyAmBv4F/ne09VXQzcsl3VSZI613aP4HnAocBtAFV1HfCQBfj8JyT5UpJ/S/LILS2U5KQka5Ks2bhx4wJ8rCRpRtsguKuqfthrKMkOwPbeTXwZsF9VPQZ4M/PsYVTVWVW1qqpWrVixYjs/VpI0rm0QXJTk5cAuSZ4C/DOjR1Vus6q6raruaIYvAHZMsnx71ilJ2nptg+ClwEbgSkZN6C6oqr/cng9O8rAkaYYf19Ry8/asU5K09dreUPb8qnoj8I6ZCUlOaabNKcn7gMOA5UluAE4FdgSoqrcBzwT+JMkmRg+8OdrmdZLUv7ZBcDww+5f+CXNM+6GqOma+FVbVGcAZLT9fktSRSY+qPIbRMwn2T7J6bNbueGmoJC0Jk/YILmHUX2g58Pqx6bcDV3RVlCSpP5O6j64H1gNP6KccSVLf2t5ZfEiSS5PckeTuJJuT3NZ1cZKk7rW9fPQM4BjgOmAX4ETgzK6KkiT1p3XTuapaByyrqs1V9S4mN5STJC0CbS8fvTPJTsDlSV7L6ASyzzKQpCWg7S/zZzfLngx8F9gH+O2uipIk9adVEFTV+qr6ftMf6FXAq4Gjuy1NktSHeYMgyT5JzkrysSQnJtk1yeuBL7MwbaglSVM26RzBecBFwPmMTg6vAS4HDqqq/+u4NklSDyYFwYOr6q+b4U8k+R3g2Kq6p9uyJEl9mXjVUJIHAWlGbwYeONM+uqrsNyRJi9ykIHggsJYfBQGMniwGoyeU/XQXRUmS+jOp19DKnuqQJE2JN4VJ0sAZBJI0cAaBJA1c215DJFkGPHT8PVX1jS6KkiT1p1UQJHk+o4fPfxOYuYeggIM6qkuS1JO2ewSnAI+oqpu7LEaS1L+25wiuB27tshBJ0nS03SP4KvDZJB8H7pqZWFVv6KQqSVJv2gbBN5rXTs1LkrREtAqC5hkEJNmtGb+jy6IkSf1pdY4gyaOSfBG4Grg6ydokj+y2NElSH9qeLD4L+LOq2q+q9gNeBLyju7IkSX1pGwS7VtWFMyNV9Vlg104qkiT1qvVVQ0leAby7Gf99RlcSSZIWubZ7BH8ArAA+3LxWNNMkSYtc26uGvg28oONaJElTMG8QJDm9ql6Y5KOMegv9mKo6srPKJEm9mLRHMHNO4HVdFyJJmo5Jj6pc2wweXFVvHJ+X5BTgoq4KkyT1o+3J4uPnmHbCAtYhSZqSSecIjgGeBeyfZPXYrN2BW7osTJLUj0nnCC4BNgDLgdePTb8duKKroiRJ/Zl0jmA9sB54wtauOMnZwNOAm6rqUXPMD/BG4AjgTuCEqrpsaz9HkrR92jadOyTJpUnuSHJ3ks1JbpvwtnOAw+eZ/1TggOZ1EvDWNrVIkhZW25PFZwDHANcBuwAnAmfO94aqupj5zyMcBZxXI58H9kiyZ8t6JEkLpG0QUFXrgGVVtbmq3sX8f+23sRejR2DOuKGZJknqUdumc3cm2Qm4PMlrGZ1Abh0i2yvJSYwOH7Hvvvv29bGSNAhtf5k/G1gGnAx8F9gHeMZ2fvaNzXpm7N1Mu5eqOquqVlXVqhUrVmznx0qSxrVtOre+Gfwe8KoF+uzVwMlJ3g88Hri1qjYs0LolSS1NuqHsSuZoNjejqg6a573vAw4Dlie5ATgV2LF539uACxhdOrqO0eWjz9nK2iVJC2DSHsHTtnXFVXXMhPkFPG9b1y9JWhhtbiiTJC1hkw4N3c6PDg2l+VnNcFXVAzqsTZLUg0l7BLv3VYgkaTpa3wuQ5IlJntMML0+yf3dlSZL60rbX0KnAS4CXNZN2At7TVVGSpP603SN4OnAko5vJqKr/ZfRMAknSItc2CO5uLvcsgCS7dleSJKlPbYPgg0nezqhD6HOB/wDe0V1ZkqS+tG0x8bokTwFuAx4BvLKqPtVpZZKkXrQKguYKoc/N/PJPskuSlVX19S6LkyR1r+2hoX8G7hkb39xMkyQtcm2DYIequntmpBneqZuSJEl9ahsEG5McOTOS5CjgW92UJEnqU9snlP0x8N4kZzDqM3Q9cFxnVUmSetP2qqGvAIck2a0Zv6PTqiRJvWl71dD9GT2aciWwQzJqRFpVp3VWmSSpF20PDX0EuBVYC9zVXTmSpL61DYK9q+rwTiuRJE1F26uGLkny6E4rkSRNRds9gicCJyT5GqNDQzNPKNviw+slSYtD2yB4aqdVSJKmpu3lo+sBkjwE2LnTiiRJvWr7hLIjk1wHfA24CPg68G8d1iVJ6knbk8WvBg4B/qeq9geeBHy+s6okSb1pGwQ/qKqbgfsluV9VXQis6rAuSVJP2p4s/k7TXuJiRj2HbqJ5frEkaXFru0dwFHAn8KfAvwNfAX6zq6IkSf2ZNwiSPDzJoVX13aq6p6o2VdW5wGXAHv2UKEnq0qQ9gtMZPad4tlubeZKkRW5SEDy0qq6cPbGZtrKTiiRJvZoUBPMd/tllIQuRJE3HpCBYk+S5sycmOZFRS2pJ0iI36fLRFwL/kuRYfvSLfxWjB9c/vcvCJEn9mDcIquqbwC8l+VXgUc3kj1fVZzqvTJLUi7ZN5y4ELuy4FknSFLS9oUyStEQZBJI0cAaBJA1cp0GQ5PAkX06yLslL55h/QpKNSS5vXid2WY8k6d7adh/dakmWAWcCTwFuAC5Nsrqqrpm16Aeq6uSu6pAkza/LPYLHAeuq6qtVdTfwfkZdTCVJ9yFdBsFewPVj4zc002Z7RpIrknwoyT5zrSjJSUnWJFmzcePGLmqVpMGa9snijwIrq+og4FPAuXMtVFVnVdWqqlq1YsWKXguUpKWuyyC4ERj/C3/vZtoPVdXNVXVXM/pPwC90WI8kaQ5dBsGlwAFJ9k+yE3A0sHp8gSR7jo0eCVzbYT2SpDl0dtVQVW1KcjLwCWAZcHZVXZ3kNGBNVa0GXpDkSGATcAtwQlf1SJLm1lkQAFTVBcAFs6a9cmz4ZcDLuqxBkjS/aZ8sliRNmUEgSQNnEEjSwBkEkjRwBoEkDZxBIEkDZxBI0sAZBJI0cAaBJA2cQSBJA2cQSNLAGQSSNHAGgSQNnEEgSQNnEEjSwBkEkjRwBoEkDZxBIEkDZxBI0sAZBJI0cAaBJA2cQSBJA2cQSNLAGQSSNHAGgSQNnEEgSQNnEEjSwBkEkjRwBoEkDZxBIEkDZxBI0sAZBJI0cAaBJA2cQSBJA2cQSNLAGQSSNHAGgSQNXKdBkOTwJF9Osi7JS+eYf/8kH2jmfyHJyi7rkSTdW2dBkGQZcCbwVOBA4JgkB85a7A+Bb1fVw4F/BP6+q3okSXPrco/gccC6qvpqVd0NvB84atYyRwHnNsMfAp6UJB3WJEmaZYcO170XcP3Y+A3A47e0TFVtSnIr8JPAt8YXSnIScFIzekeSL3dS8X3DcmZ9//u6vO74aZdwX7K4tt+p/t01ZnFtOyAv2Krtt9+WZnQZBAumqs4Czpp2HX1IsqaqVk27Dm0bt9/iNeRt1+WhoRuBfcbG926mzblMkh2ABwI3d1iTJGmWLoPgUuCAJPsn2Qk4Glg9a5nVwMxxhWcCn6mq6rAmSdIsnR0aao75nwx8AlgGnF1VVyc5DVhTVauBdwLvTrIOuIVRWAzdIA6BLWFuv8VrsNsu/gEuScPmncWSNHAGgSQNnEHQsST7JLkwyTVJrk5ySjP9wUk+leS65ueDmulJ8qam7cYVSR47tq6/T3JV8/q9aX2nIdmG7fdzSf47yV1JXjxrXfO2XNHCWuBtd3aSm5JcNY3v0jWDoHubgBdV1YHAIcDzmlYbLwU+XVUHAJ9uxmHUkuOA5nUS8FaAJL8BPBY4mNGNeS9O8oA+v8hAbe32uwV4AfC68ZW0bLmihbUg265xDnB45xVPiUHQsaraUFWXNcO3A9cyuqN6vL3GucBvNcNHAefVyOeBPZLsyeiXx8VVtamqvgtcwRL+h3lfsbXbr6puqqpLgR/MWlWblitaQAu47aiqixkFxZJkEPSo6a7688AXgIdW1YZm1v8BD22G52rNsRfwJeDwJD+RZDnwq/z4DXvqWMvttyVb2q7qwXZuuyVvUbSYWAqS7AacD7ywqm4b761XVZVk3ut4q+qTSX4RuATYCPw3sLnDkjVme7efpsdtN5l7BD1IsiOjf4jvraoPN5O/2Rzyofl5UzN9i605quo1VXVwVT0FCPA/fdQ/dFu5/bakTcsVLbAF2nZLnkHQsaat9juBa6vqDWOzxttrHA98ZGz6cc3VQ4cAt1bVhiTLkvxks86DgIOAT/byJQZsG7bflrRpuaIFtIDbbsnzzuKOJXki8DngSuCeZvLLGR2r/CCwL7Ae+N2quqX5x3sGoxPBdwLPqao1SXYGLmvefxvwx1V1eX/fZJi2Yfs9DFgDPKBZ/g7gwOaQxBHA6fyo5cprev0yA7PA2+59wGGMWlV/Ezi1qt7Z49fplEEgSQPnoSFJGjiDQJIGziCQpIEzCCRp4AwCSRo47yyWZmnu1/h0M/owRndwb2zGH9f0CppZ9hzgY1X1oV6LlBaQQSDNUlU3M+rySpK/Bu6oqrk6UkpLgoeGpBaSPDfJpUm+lOT8JD8xNvuXk1yS5KtJntksf1iSj429/4wkJzTDX0/yqiSXJbkyyc/1+22kH2cQSO18uKp+saoew6id8R+OzdsTeCLwNODvWq7vW1X1WEbPm3jxpIWlLhkEUjuPSvK5JFcCxwKPHJv3r1V1T1VdQ/uWxjMN0NYCKxeuTGnrGQRSO+cAJ1fVo4FXATuPzbtrbHimx/Emfvz/1/jy4+/ZjOfqNGUGgdTO7sCGpq3xsS2WXw8cmOT+SfYAntRpddJ28C8RqZ1XMOpaubH5uft8C1fV9Uk+CFwFfA34YucVStvI7qOSNHAeGpKkgTMIJGngDAJJGjiDQJIGziCQpIEzCCRp4AwCSRq4/wf6T5nF3S++NAAAAABJRU5ErkJggg==\n"
},
"metadata": {
"needs_background": "light"
}
}
]
},
{
"cell_type": "markdown",
"id": "8866bcd4",
"metadata": {
"id": "8866bcd4"
},
"source": [
"### Interpretation"
]
},
{
"cell_type": "code",
"source": [
"from IPython.display import Image, display\n",
"\n",
"display(Image('/content/drive/MyDrive/Dataset/download (1).png'))\n",
"display(Image('/content/drive/MyDrive/Dataset/download (2).png'))\n",
"display(Image('/content/drive/MyDrive/Dataset/download (3).png'))"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 803
},
"id": "NdWIX9lW1fWK",
"outputId": "5cf066ba-9629-4627-c879-a78c257738fc"
},
"id": "NdWIX9lW1fWK",
"execution_count": null,
"outputs": [
{
"output_type": "display_data",
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAZcAAAEGCAYAAACpXNjrAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAdNUlEQVR4nO3df7RV5X3n8fen4K8kIqi3xAIJpqF1ESdBvVGmZnUZXcELTYOZGIPTFRlLQrsCHdOkHdHpjFbLjLZJ7DgxtGQkQiYjEtMUxmIIQUyaHypXJSgax1uMIwzKraAYHXXA7/yxvzduL+eee4B9zvHe+3mttdfZ+7uf/ezneJAvez/PfrYiAjMzsyr9SrsbYGZmw4+Ti5mZVc7JxczMKufkYmZmlXNyMTOzyo1udwPeLE488cSYPHlyu5thZjak3H///f8cER39404uafLkyXR3d7e7GWZmQ4qkJ2vFfVvMzMwq5+RiZmaVc3IxM7PKObmYmVnlnFzMzKxyTi5mZlY5JxczM6tc05OLpFGSHpR0R26fLOleST2SbpN0ZMaPyu2e3D+5VMcVGX9M0vmleFfGeiQtKsVrnsPMzFqjFVculwGPlravB26IiHcDe4B5GZ8H7Mn4DVkOSVOBOcB7gC7gK5mwRgE3ATOBqcDFWbbeOczMrAWa+oS+pInA7wCLgc9JEnAu8K+zyHLgamAJMDvXAW4HvpzlZwMrI+IV4AlJPcCZWa4nIrbluVYCsyU9WuccZvzva/5Fu5sw7L3jPz7U7iZYmzX7yuWvgX8HvJbbJwDPRcS+3N4OTMj1CcBTALn/+Sz/y3i/YwaK1zvHG0iaL6lbUndvb++hfkczM+unaclF0oeBXRFxf7POcbgiYmlEdEZEZ0fHAfOumZnZIWrmbbGzgY9ImgUcDYwB/gswVtLovLKYCOzI8juAScB2SaOB44BnS/E+5WNqxZ+tcw4zM2uBpl25RMQVETExIiZTdMjfFRG/B2wELsxic4HVub4mt8n9d0VEZHxOjiY7GZgC3AdsAqbkyLAj8xxr8piBzmFmZi3QjudcLqfo3O+h6B+5OeM3Aydk/HPAIoCI2AqsAh4BvgMsiIj9eVWyEFhHMRptVZatdw4zM2uBlrzPJSLuBu7O9W28PtqrXOZl4OMDHL+YYsRZ//haYG2NeM1zmJlZa/gJfTMzq5yTi5mZVc7JxczMKufkYmZmlXNyMTOzyjm5mJlZ5ZxczMysck4uZmZWOScXMzOrXEue0Dczq8LZ//XsdjdhRPjRH/3osOvwlYuZmVXOycXMzCrn5GJmZpVzcjEzs8o5uZiZWeWcXMzMrHJOLmZmVrmmJRdJR0u6T9JPJW2V9OcZv0XSE5I25zIt45J0o6QeSVsknV6qa66kx3OZW4qfIemhPOZGScr48ZLWZ/n1ksY163uamdmBmnnl8gpwbkS8D5gGdEmanvv+NCKm5bI5YzOBKbnMB5ZAkSiAq4CzKF5dfFUpWSwBPl06rivji4ANETEF2JDbZmbWIk1LLlH4RW4ekUvUOWQ2sCKPuwcYK+kk4HxgfUTsjog9wHqKRHUSMCYi7omIAFYAF5TqWp7ry0txMzNrgab2uUgaJWkzsIsiQdybuxbnra8bJB2VsQnAU6XDt2esXnx7jTjA+IjYmetPA+MHaN98Sd2Sunt7ew/tS5qZ2QGamlwiYn9ETAMmAmdKOhW4AjgFeD9wPHB5k9sQDHDFFBFLI6IzIjo7Ojqa2QwzsxGlJaPFIuI5YCPQFRE789bXK8DXKPpRAHYAk0qHTcxYvfjEGnGAZ/K2Gfm5q9pvZGZm9TRztFiHpLG5fgzwIeBnpb/0RdEX8nAesga4JEeNTQeez1tb64AZksZlR/4MYF3u2ytpetZ1CbC6VFffqLK5pbiZmbVAM6fcPwlYLmkURRJbFRF3SLpLUgcgYDPwh1l+LTAL6AFeAi4FiIjdkq4FNmW5ayJid65/BrgFOAa4MxeA64BVkuYBTwIXNe1bmpnZAZqWXCJiC3Bajfi5A5QPYMEA+5YBy2rEu4FTa8SfBc47yCabmVlF/IS+mZlVzsnFzMwq5+RiZmaVc3IxM7PKObmYmVnlnFzMzKxyTi5mZlY5JxczM6uck4uZmVXOycXMzCrn5GJmZpVzcjEzs8o5uZiZWeWcXMzMrHJOLmZmVjknFzMzq5yTi5mZVW7Q5CKpQ9KVkpZKWta3NHDc0ZLuk/RTSVsl/XnGT5Z0r6QeSbdJOjLjR+V2T+6fXKrriow/Jun8UrwrYz2SFpXiNc9hZmat0ciVy2rgOOB7wD+UlsG8ApwbEe8DpgFdkqYD1wM3RMS7gT3AvCw/D9iT8RuyHJKmAnOA9wBdwFckjZI0CrgJmAlMBS7OstQ5h5mZtUAjyeUtEXF5RKyKiG/1LYMdFIVf5OYRuQRwLnB7xpcDF+T67Nwm958nSRlfGRGvRMQTQA9wZi49EbEtIl4FVgKz85iBzmFmZi3QSHK5Q9KsQ6k8rzA2A7uA9cA/Ac9FxL4ssh2YkOsTgKcAcv/zwAnleL9jBoqfUOcc/ds3X1K3pO7e3t5D+YpmZlZDI8nlMooE87KkF3LZ20jlEbE/IqYBEymuNE45jLZWLiKWRkRnRHR2dHS0uzlmZsPG6MEKRMSxh3uSiHhO0kbgXwJjJY3OK4uJwI4stgOYBGyXNJqin+fZUrxP+Zha8WfrnMPMzFqgoaHIkj4i6Qu5fLjBYzokjc31Y4APAY8CG4ELs9hcigEDAGtym9x/V0RExufkaLKTgSnAfcAmYEqODDuSotN/TR4z0DnMzKwFBr1ykXQd8H7gGxm6TNLZEXHFIIeeBCzPUV2/AqyKiDskPQKslPQXwIPAzVn+ZuDrknqA3RTJgojYKmkV8AiwD1gQEfuzbQuBdcAoYFlEbM26Lh/gHGZm1gKDJhdgFjAtIl4DkLSc4i/susklIrYAp9WIb6Pof+kffxn4+AB1LQYW14ivBdY2eg4zM2uNRp/QH1taP64ZDTEzs+GjkSuX/ww8mB3yAn4bWFT/EDMzG8kaGS12q6S7KfpdAC6PiKeb2iozMxvSBrwtJumU/DydonN+ey6/ljEzM7Oa6l25fA6YD3yxxr6+aVzMzMwOMGByiYj5uTozR3L9kqSjm9oqMzMb0hoZLfbjBmNmZmZAnSsXSW+nmPDxGEmnUYwUAxgDvKUFbTMzsyGqXp/L+cC/oZib64u8nlz2Alc2t1lmZjaU1etzWU4xfcvHGnl/i5mZWZ9G+lzO6JuAEkDSuJyzy8zMrKZGksvMiHiubyMi9lDMN2ZmZlZTI8lllKSj+jZy+vyj6pQ3M7MRrpG5xb4BbJD0tdy+lNffdW9mZnaARuYWu17SFuC8DF0bEeua2ywzMxvKGrlyISLuBO5sclvMzGyYGLTPRdJ0SZsk/ULSq5L2S9rbwHGTJG2U9IikrZIuy/jVknZI2pzLrNIxV0jqkfSYpPNL8a6M9UhaVIqfLOnejN+WrzsmX4l8W8bvlTT54P6zmJnZ4WikQ//LwMXA48AxwKeAmxo4bh/w+YiYCkwHFkiamvtuiIhpuawFyH1zgPcAXcBXJI3K1yTfBMwEpgIXl+q5Put6N7AHmJfxecCejN+Q5czMrEUaehNlRPQAoyJif0R8jeIv/8GO2RkRD+T6C8CjFNPJDGQ2sDIiXomIJ4AeilcVnwn0RMS2iHgVWAnMliSKmZlvz+OXAxeU6uobdHA7cF6WNzOzFmgkubyUt5s2S/pLSX/c4HG/lLelTgPuzdBCSVskLZM0LmMTgKdKh23P2EDxE4DnImJfv/gb6sr9z2f5/u2aL6lbUndvb+/BfCUzM6ujkSTxySy3EHgRmAR8rNETSHob8C3gsxGxF1gC/DowDdhJ7ffFtERELI2Izojo7OjoaFczzMyGnUaGIj+Zqy9LuhGYlLfJBiXpCIrE8o2I+Lus75nS/q8Cd+TmDorE1Wdixhgg/iwwVtLovDopl++ra7uk0cBxWd7MzFqgkdFid0saI+l44AHgq5K+1MBxAm4GHo2IL5XiJ5WKfRR4ONfXAHNypNfJwBTgPmATMCVHhh1J0em/JiIC2AhcmMfPBVaX6pqb6xcCd2V5MzNrgUaeczkuIvZK+hSwIiKuyocqB3M2xS21hyRtztiVFKO9plG8KvnnwB8ARMRWSauARyhGmi2IiP0AkhYC64BRwLKI2Jr1XQ6szIk0H6RIZuTn1yX1ALspEpKZmbVII8lldF5tXAT8+0Yrjogf8vo7YMrW1jlmMbC4RnxtreMiYhvFaLL+8ZeBjzfaVjMzq1YjHfrXUFw19ETEJknvonjmxczMrKZGOvS/CXyztL2NgxgtZmZmI8+gyUVSB/BpYHK5fET8fvOaZWZmQ1kjfS6rgX8Evgfsb25zzMxsOGgkubwlIi5vekvMzGzYaKRD/47yzMVmZmaDaSS5XEaRYP6vpL2SXmhkyn0zMxu5GhktdmwrGmJmZsNHQ2+izJmLpwBH98Ui4gfNapSZmQ1tjQxF/hTFrbGJwGaKF3/9hOJdKmZmZgdotM/l/cCTEfFBiveyPNfUVpmZ2ZDWSHJ5OefqQtJREfEz4Deb2ywzMxvKGulz2S5pLPD3wHpJe4AnBznGzMxGsEZGi300V6+WtJHixVvfaWqrzMxsSKubXCSNArZGxCkAEfH9lrTKzMyGtLp9LvmyrsckvaNF7TEzs2FgwCsXSf8q33s/Dtgq6T7gxb79EfGRFrTPzMyGoHpXLn+Wn/8B+DDFS8O+WFrqkjRJ0kZJj0jaKumyjB8vab2kx/NzXMYl6UZJPZK2SDq9VNfcLP+4pLml+BmSHspjbpSkeucwM7PWGHQockR8v9bSQN37gM9HxFSKBy8XSJoKLAI2RMQUYENuA8ykmAVgCjAfWAJFogCuAs6ieKXxVaVksYTiXTN9x3VlfKBzmJlZC9Tr0D9F0paBdkbEe+tVHBE7gZ25/oKkR4EJwGzgnCy2HLgbuDzjKyIigHskjZV0UpZdHxG7ASStB7ok3Q2MiYh7Mr4CuAC4s845zMysBeollyeA363iJJImUzzZfy8wPhMPwNPA+FyfADxVOmx7xurFt9eIU+cc/ds1n+IqiXe8w2MWzMyqUi+5vBoRh/2wpKS3Ad8CPhsRe7NbBICICElxuOeop945ImIpsBSgs7Ozqe0wMxtJ6vW5/OhwK5d0BEVi+UaOPAN4Jm93kZ+7Mr4DmFQ6fGLG6sUn1ojXO4eZmbXAgMklIhYeTsU5cutm4NGI+FJp1xqgb8TXXGB1KX5JjhqbDjyft7bWATMkjcuO/BnAuty3V9L0PNcl/eqqdQ4zM2uBht7ncojOBj4JPCRpc8auBK4DVkmaRzFH2UW5by0wC+gBXgIuBYiI3ZKuBTZluWv6OveBzwC3AMdQdOTfmfGBzmFmZi3QtOQSET8ENMDu82qUD2DBAHUtA5bViHcDp9aIP1vrHGZm1hp1n9Cvd2CpD8XMzOwN6l259A1D/lXgt4C7cvuDwI8BJxczM6tpwOQSEZcCSPouMLXvuZEcfXVLS1pnZmZDUiNvopxUeiAR4BnATxyamdmAGunQ3yBpHXBrbn8C+F7zmmRmZkNdI2+iXCjpo8BvZ2hpRHy7uc0yM7OhrNGhyA8AL0TE9yS9RdKxEfFCMxtmZmZD16B9LpI+DdwO/G2GJgB/38xGmZnZ0NZIh/4Ciqft9wJExOMUw5PNzMxqaiS5vBIRr/ZtSBoNeAZhMzMbUCPJ5fuSrgSOkfQh4JvA/2xus8zMbChrJLksAnqBh4A/oJhg8s+a2SgzMxvaGhmK/Brw1VzMzMwGNWhykXQ2cDXwziwvikmM39XcppmZ2VDVyHMuNwN/DNwP7G9uc8zMbDhoJLk8HxF3Dl7MzMysUO99Lqfn6kZJf0Uxxf4rffsj4oEmt83MzIaoeqPFvpjLWUAn8J9KsS8MVrGkZZJ2SXq4FLta0g5Jm3OZVdp3haQeSY9JOr8U78pYj6RFpfjJku7N+G2Sjsz4Ubndk/snN/ofw8zMqlHvfS4fPMy6bwG+DKzoF78hIt6QnCRNBeYA7wF+DfiepN/I3TcBHwK2A5skrYmIR4Drs66Vkv4GmAcsyc89EfFuSXOy3CcO87uYmdlBaGRuscskjVHhv0l6QNKMwY6LiB8Auxtsx2xgZUS8EhFPAD3Ambn0RMS2nCVgJTBbkoBzKeY8A1gOXFCqa3mu3w6cl+XNzKxFGnmI8vcjYi8wAzgB+CRw3WGcc6GkLXnbbFzGJgBPlcpsz9hA8ROA5yJiX7/4G+rK/c9n+QNImi+pW1J3b2/vYXwlMzMrayS59P2rfxawIiK2lmIHawnw68A0YCdF/03bRMTSiOiMiM6Ojo52NsXMbFhpJLncL+m7FMllnaRjgdcO5WQR8UxE7C899X9m7toBTCoVnZixgeLPAmNzEs1y/A115f7jsryZmbVII8llHsX8Yu+PiJeAI4FLD+Vkkk4qbX4U6BtJtgaYkyO9TgamAPcBm4ApOTLsSIpO/zUREcBG4MI8fi6wulTX3Fy/ELgry5uZWYvUe87llIj4GcUtLIB3HUy/uKRbgXOAEyVtB64CzpE0jWLK/p9TTIRJRGyVtAp4BNgHLIiI/VnPQmAdMApYlrflAC4HVkr6C+BBipkEyM+vS+qhGFAwp+FGm5lZJeo9of85YD61+0WCYrTWgCLi4hrhm2vE+sovBhbXiK+lmIm5f3wbr99WK8dfBj5er21mZtZc9Z5zmZ+fh/u8i5mZjTCNzC2GpN8CJpfLR0T/hyPNzMyAxqbc/zrF8OHNvD4rcnDgk/dmZmZAY1cuncBUj7gyM7NGNTIU+WHg7c1uiJmZDR+NXLmcCDwi6T7eOOX+R5rWKjMzG9IaSS5XN7sRZmY2vAyaXCLi+61oiJmZDR/1ntD/YUR8QNILFKPDfrkLiIgY0/TWmZnZkFTvyuX3ACLi2Ba1xczMhol6o8W+3bci6VstaIuZmQ0T9ZJLeZbKdzW7IWZmNnzUSy4xwLqZmVld9fpc3idpL8UVzDG5Du7QNzOzQdSbFXlUKxtiZmbDRyPTv5iZmR2UpiUXScsk7ZL0cCl2vKT1kh7Pz3EZl6QbJfVI2iLp9NIxc7P845LmluJnSHooj7lR+ZrMgc5hZmat08wrl1uArn6xRcCGiJgCbMhtgJnAlFzmA0ugSBQUr0c+i+Ktk1eVksUS4NOl47oGOYeZmbVI05JLRPyA4h32ZbOB5bm+HLigFF8RhXuAsZJOAs4H1kfE7ojYA6wHunLfmIi4J18FsKJfXbXOYWZmLdLqPpfxEbEz158Gxuf6BOCpUrntGasX314jXu8cB5A0X1K3pO7e3t5D+DpmZlZL2zr084qjqc/PDHaOiFgaEZ0R0dnR0dHMppiZjSitTi7P5C0t8nNXxncAk0rlJmasXnxijXi9c5iZWYu0OrmsAfpGfM0FVpfil+SosenA83lrax0wQ9K47MifAazLfXslTc9RYpf0q6vWOczMrEUaeVnYIZF0K3AOcKKk7RSjvq4DVkmaBzwJXJTF1wKzgB7gJeBSgIjYLelaYFOWuyYi+gYJfIZiRNoxwJ25UOccZmbWIk1LLhFx8QC7zqtRNoAFA9SzDFhWI94NnFoj/mytc5iZWev4CX0zM6uck4uZmVXOycXMzCrn5GJmZpVzcjEzs8o5uZiZWeWcXMzMrHJOLmZmVjknFzMzq5yTi5mZVc7JxczMKufkYmZmlXNyMTOzyjm5mJlZ5ZxczMysck4uZmZWOScXMzOrXFuSi6SfS3pI0mZJ3Rk7XtJ6SY/n57iMS9KNknokbZF0eqmeuVn+cUlzS/Ezsv6ePFat/5ZmZiNXO69cPhgR0yKiM7cXARsiYgqwIbcBZgJTcpkPLIEiGQFXAWcBZwJX9SWkLPPp0nFdzf86ZmbW5810W2w2sDzXlwMXlOIronAPMFbSScD5wPqI2B0Re4D1QFfuGxMR90REACtKdZmZWQu0K7kE8F1J90uan7HxEbEz158Gxuf6BOCp0rHbM1Yvvr1G/ACS5kvqltTd29t7ON/HzMxKRrfpvB+IiB2SfhVYL+ln5Z0REZKi2Y2IiKXAUoDOzs6mn8/MbKRoy5VLROzIz13Atyn6TJ7JW1rk564svgOYVDp8YsbqxSfWiJuZWYu0PLlIequkY/vWgRnAw8AaoG/E11xgda6vAS7JUWPTgefz9tk6YIakcdmRPwNYl/v2Spqeo8QuKdVlZmYt0I7bYuOBb+fo4NHA/4iI70jaBKySNA94Ergoy68FZgE9wEvApQARsVvStcCmLHdNROzO9c8AtwDHAHfmYmZmLdLy5BIR24D31Yg/C5xXIx7AggHqWgYsqxHvBk497MaamdkheTMNRTYzs2HCycXMzCrn5GJmZpVzcjEzs8q16yHKIe2MP13R7iYMe/f/1SXtboKZHQZfuZiZWeWcXMzMrHJOLmZmVjknFzMzq5yTi5mZVc7JxczMKufkYmZmlXNyMTOzyjm5mJlZ5ZxczMysck4uZmZWOScXMzOr3LBNLpK6JD0mqUfSona3x8xsJBmWyUXSKOAmYCYwFbhY0tT2tsrMbOQYlskFOBPoiYhtEfEqsBKY3eY2mZmNGIqIdrehcpIuBLoi4lO5/UngrIhY2K/cfGB+bv4m8FhLG9paJwL/3O5G2CHxbze0Dfff750R0dE/OKJfFhYRS4Gl7W5HK0jqjojOdrfDDp5/u6FtpP5+w/W22A5gUml7YsbMzKwFhmty2QRMkXSypCOBOcCaNrfJzGzEGJa3xSJin6SFwDpgFLAsIra2uVntNiJu/w1T/u2GthH5+w3LDn0zM2uv4XpbzMzM2sjJxczMKufkMkRJmiRpo6RHJG2VdFnGj5e0XtLj+Tku45J0Y06Hs0XS6aW6rpf0cC6faNd3GikO4bc7RdJPJL0i6U/61eVpjlqs4t9vmaRdkh5ux3dpJieXoWsf8PmImApMBxbkFDeLgA0RMQXYkNtQTIUzJZf5wBIASb8DnA5MA84C/kTSmFZ+kRHoYH+73cC/Bb5QrsTTHLVNJb9fugXoanqL28DJZYiKiJ0R8UCuvwA8CkygmOZmeRZbDlyQ67OBFVG4Bxgr6SSKv5R+EBH7IuJFYAvD9A/7m8XB/nYRsSsiNgH/r19VnuaoDSr8/YiIH1Akn2HHyWUYkDQZOA24FxgfETtz19PA+FyfADxVOmx7xn4KdEl6i6QTgQ/yxgdQrYka/O0GMtBvai1ymL/fsDYsn3MZSSS9DfgW8NmI2Cvpl/siIiTVHWseEd+V9H7gx0Av8BNgfxObbOlwfztrL/9+9fnKZQiTdATFH+5vRMTfZfiZvN1Ffu7K+IBT4kTE4oiYFhEfAgT8r1a0fyQ7yN9uIJ7mqE0q+v2GNSeXIUrFP5NuBh6NiC+Vdq0B5ub6XGB1KX5JjhqbDjwfETsljZJ0Qtb5XuC9wHdb8iVGqEP47QbiaY7aoMLfb1jzE/pDlKQPAP8IPAS8luErKe79rgLeATwJXBQRu/N/iC9TdNa/BFwaEd2SjgYeyOP3An8YEZtb901GnkP47d4OdANjsvwvgKl5K2YW8Ne8Ps3R4pZ+mRGo4t/vVuAcimn5nwGuioibW/h1msbJxczMKufbYmZmVjknFzMzq5yTi5mZVc7JxczMKufkYmZmlXNyMWuTfOboh5JmlmIfl/SddrbLrAoeimzWRpJOBb5JMT/VaOBBoCsi/ukQ6hodEfsqbqLZIXFyMWszSX8JvAi8NT/fCZwKHAFcHRGrc4LEr2cZgIUR8WNJ5wDXAnuAUyLiN1rberPanFzM2kzSWylmSXgVuAPYGhH/XdJY4D6Kq5oAXouIlyVNAW6NiM5MLv8AnBoRT7TnG5gdyLMim7VZRLwo6TaKaUEuAn639MbCoymmE/k/wJclTaOYtbp8hXKfE4u92Ti5mL05vJaLgI9FxGPlnZKupph76n0UA3FeLu1+sUVtNGuYR4uZvbmsA/4oJxpF0mkZPw7YGRGvAZ+kmKjS7E3LycXszeVaio78LZK25jbAV4C5kn4KnIKvVuxNzh36ZmZWOV+5mJlZ5ZxczMysck4uZmZWOScXMzOrnJOLmZlVzsnFzMwq5+RiZmaV+/9rkU7ui3Ri/AAAAABJRU5ErkJggg==\n",
"text/plain": [
"<IPython.core.display.Image object>"
]
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAZEAAAEGCAYAAACkQqisAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAWCUlEQVR4nO3df/BddX3n8edLAqIoghApm1BD14hDqVXMAlucHS1bCNoaOlWk40qWpWatKNit3aKzWxwo09J1/dUu7LJCG9QVEd0hU38gG7FoLWAACwKLRBFJGiAafjOigff+cT+BS/b7/ebmfHPvzc33+Zi58z3nc849533nZHhxzvmcz0lVIUlSF88ZdwGSpMlliEiSOjNEJEmdGSKSpM4MEUlSZ/PGXcCo7b///rVo0aJxlyFJE+OGG274cVXNn2rZnAuRRYsWsWbNmnGXIUkTI8nd0y3zcpYkqTNDRJLUmSEiSerMEJEkdTa0EElycZL7k3y3r+3FSa5Kcmf7u29rT5KPJ1mb5OYkh/d9Z3lb/84ky/vaX5PklvadjyfJsH6LJGlqwzwT+Rtg6VZtZwKrq2oxsLrNAxwPLG6fFcAF0Asd4CzgSOAI4KwtwdPWeUff97belyRpyIYWIlV1DbBpq+ZlwMo2vRI4oa/9kuq5FtgnyYHAccBVVbWpqh4ArgKWtmV7V9W11RuG+JK+bUmSRmTU90QOqKoNbfpe4IA2vQC4p2+9da1tpvZ1U7RPKcmKJGuSrNm4cePsfoEk6Wlju7HeziBG8jKTqrqwqpZU1ZL586d86FKS1MGon1i/L8mBVbWhXZK6v7WvBw7qW29ha1sPvG6r9q+39oVTrC8B8KOzf2XcJcwJv/gnt4y7BI3ZqM9EVgFbelgtB67oaz+59dI6CnioXfa6Ejg2yb7thvqxwJVt2cNJjmq9sk7u25YkaUSGdiaS5DP0ziL2T7KOXi+rPwcuS3IqcDdwYlv9S8AbgLXA48ApAFW1Kck5wLfbemdX1Zab9e+i1wPsecCX20eSNEJDC5Gq+t1pFh0zxboFnDbNdi4GLp6ifQ1w2GxqlCTNjk+sS5I6M0QkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiSerMEJEkdWaISJI6M0QkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiSerMEJEkdWaISJI6M0QkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiSerMEJEkdTZv3AVI0taO/sujx13CLu/v3/P3O2Q7nolIkjozRCRJnRkikqTODBFJUmeGiCSpM0NEktSZISJJ6swQkSR1NpYQSfIHSW5N8t0kn0myZ5KDk1yXZG2SzybZo6373Da/ti1f1Led97f2O5IcN47fIklz2chDJMkC4HRgSVUdBuwGnAScB3ykql4GPACc2r5yKvBAa/9IW48kh7bv/TKwFDg/yW6j/C2SNNeN63LWPOB5SeYBzwc2AL8OXN6WrwROaNPL2jxt+TFJ0tovraonquouYC1wxIjqlyQxhhCpqvXAh4Af0QuPh4AbgAeranNbbR2woE0vAO5p393c1t+vv32K7zxLkhVJ1iRZs3Hjxh37gyRpDhvH5ax96Z1FHAz8M2AvepejhqaqLqyqJVW1ZP78+cPclSTNKeO4nPWvgbuqamNV/Rz4AnA0sE+7vAWwEFjfptcDBwG05S8CftLfPsV3JEkjMI4Q+RFwVJLnt3sbxwC3AVcDb27rLAeuaNOr2jxt+deqqlr7Sa331sHAYuD6Ef0GSRJjeJ9IVV2X5HLgRmAzcBNwIfBF4NIkf9raLmpfuQj4ZJK1wCZ6PbKoqluTXEYvgDYDp1XVkyP9MZI0x43lpVRVdRZw1lbNP2CK3lVV9VPgLdNs51zg3B1eoCRpID6xLknqzBCRJHVmiEiSOjNEJEmdGSKSpM4MEUlSZ4aIJKmzgZ4TacO3v7R//aq6ZlhFSZImwzZDJMl5wFvpPRm+5YnwAgwRSZrjBjkTOQE4pKqeGHYxkqTJMsg9kR8Auw+7EEnS5BnkTORx4DtJVgNPn41U1elDq0qSNBEGCZFV7SNJ0rNsM0SqamWSPYCXt6Y72sukJElz3CC9s14HrAR+CAQ4KMlyu/hKkga5nPVfgWOr6g6AJC8HPgO8ZpiFSZJ2foP0ztp9S4AAVNX3sLeWJInBzkTWJPkE8Kk2/zZgzfBKkiRNikFC5PeB04AtXXq/AZw/tIokSRNjkN5ZTwAfbh9Jkp42bYgkuayqTkxyC72xsp6lql451MokSTu9mc5Ezmh/f3MUhUiSJs+0vbOqakObfFdV3d3/Ad41mvIkSTuzQbr4/sYUbcfv6EIkSZNnpnsiv0/vjOOfJ7m5b9ELgW8NuzBJ0s5vpnsi/wv4MvBnwJl97Y9U1aahViVJmggz3RN5qKp+CHwM2NR3P2RzkiNHVaAkaec1yD2RC4BH++YfbW2SpDlukBBJVT39nEhVPcVgT7pLknZxA70eN8npSXZvnzPovTJXkjTHDRIi7wR+DVgPrAOOBFYMsyhJ0mQYZOys+4GTRlCLJGnCbPNMJMmeSU5Lcn6Si7d8ZrPTJPskuTzJ/01ye5J/meTFSa5Kcmf7u29bN0k+nmRtkpuTHN63neVt/TuTLJ9NTZKk7TfI5axPAr8AHAf8HbAQeGSW+/0Y8JWqegXwq8Dt9J5FWV1Vi4HVPPNsyvHA4vZZQesZluTFwFn0Lq8dAZy1JXgkSaMxSIi8rKr+M/BYVa0E3kjvP9ydJHkR8K+AiwCq6mdV9SCwjN673Gl/T2jTy4BLqudaYJ8kB9ILtauqalNVPQBcBSztWpckafsNEiI/b38fTHIY8CLgJbPY58HARuCvk9yU5BNJ9gIO6Bv08V7ggDa9ALin7/vrWtt07ZKkERkkRC5sl4n+E7AKuA34i1nscx5wOHBBVb0aeIxnD6tCey7l/3uHSVdJViRZk2TNxo0bd9RmJWnO22aIVNUnquqBqrqmqn6pql5SVf99FvtcB6yrquva/OX0QuW+dpmK9vf+tnw9cFDf9xe2tunap/oNF1bVkqpaMn/+/FmULknqN0jvrDOS7N16SX0iyY1Jju26w6q6F7gnySGt6Rh6ZzergC09rJYDV7TpVcDJbf9HAQ+1y15XAscm2bedKR3b2iRJIzLI8CX/rqo+luQ4YD/g7fR6bH11Fvt9D/DpJHvQe/r9FHqBdlmSU4G7gRPbul8C3gCsBR5v61JVm5KcA3y7rXe2owtL0mgNEiJpf99Ar5fUrUky0xe2paq+AyyZYtExU6xbwGnTbOdiYFbPrEiSuhvkxvoNSb5KL0SuTPJC4KnhliVJmgSDnImcCrwK+EFVPZ5kP9olJUnS3DbI2FlPJbkPODSJQ8BLkp62zVBIch7wVno9qJ5szQVcM8S6JEkTYJAzixOAQ6rqiWEXI0maLAO9lArYfdiFSJImzyBnIo8D30myGnj6bKSqTh9aVZKkiTBIiKxqH0mSnmWQ3lkrt7WOJGluGqR31mLgz4BDgT23tFfVLw2xLknSBBjkxvpf03ub4Gbg9cAlwKeGWZQkaTIMEiLPq6rVQKrq7qr6IL23G0qS5rhBbqw/keQ5wJ1J3k3vnR0vGG5ZkqRJMMiZyBnA84HTgdcA/4Zn3vshSZrDZjwTSbIb8Naqeh/wKA68KEnqM+OZSFU9Cbx2RLVIkibMtGciSeZV1WbgpiSrgM8Bj21ZXlVfGEF9kqSd2EyXs64HDqf3bMhPgF/vW1aAISJJc9xMIRKAqvI+iCRpSjOFyPwk/2G6hVX14SHUI0maIDOFyG70ngfJiGqRJE2YmUJkQ1WdPbJKJEkTZ6Yuvp6BSJJmNFOIHDOyKiRJE2naEKmqTaMsRJI0eQYZO0uSpCkZIpKkzmYa9uQRek+mwzM32atNV1XtPeTaJEk7uWlDpKpeOMpCJEmTZ6DLWUlem+SUNr1/koOHW5YkaRJsM0SSnAX8MfD+1rQHvmNdksRgZyK/DbyJNgx8Vf0T4KUuSdJAIfKzqiraTfYkew23JEnSpBgkRC5L8j+AfZK8A/g/wP+c7Y6T7JbkpiR/2+YPTnJdkrVJPptkj9b+3Da/ti1f1LeN97f2O5IcN9uaJEnbZ5shUlUfAi4HPg8cAvxJVf3lDtj3GcDtffPnAR+pqpcBDwCntvZTgQda+0faeiQ5FDgJ+GVgKXB+eye8JGlEBrmxfjDwjar6o6p6H/DN/rOBLpIsBN4IfKLNh96bEy9vq6wETmjTy9o8bfkxbf1lwKVV9URV3QWsBY6YTV2SpO0zyOWszwFP9c0/2dpm46PAf+zb7n7Ag+2d7gDrgAVtegFwD0Bb/lBb/+n2Kb7zLElWJFmTZM3GjRtnWbokaYtBQmReVf1sy0yb3qPrDpP8JnB/Vd3QdRvbq6ourKolVbVk/vz5o9qtJO3yBgmRjUnetGUmyTLgx7PY59HAm5L8ELiU3mWsj9G7cb/lCfqFwPo2vR44qO17HvAi4Cf97VN8R5I0AoOEyDuBDyT5UZJ76D14+O+77rCq3l9VC6tqEb0b41+rqrcBVwNvbqstB65o06vaPG3511qX41XASa331sHAYuD6rnVJkrbfTK/HBaCqvg8cleQFbf7RIdXyx8ClSf4UuAm4qLVfBHwyyVpgE73goapuTXIZcBuwGTitqp4cUm2SpClsM0SSPBf4HWARMK/XMQp2xPvXq+rrwNfb9A+YondVVf0UeMs03z8XOHe2dUiSutlmiNC7rPQQcAPwxHDLkSRNkkFCZGFVLR16JZKkiTPIjfVvJfmVoVciSZo4g5yJvBb4t0nuonc5a8ubDV851MokSTu9QULk+KFXIUmaSIN08b0bIMlLgD2HXpEkaWIMMgDjm5LcCdwF/B3wQ+DLQ65LkjQBBrmxfg5wFPC9qjoYOAa4dqhVSZImwiAh8vOq+gnwnCTPqaqrgSVDrkuSNAEGubH+YBvy5Brg00nup71vXZI0tw1yJrIMeBz4A+ArwPeB3xpmUZKkyTBtiCR5WZKjq+qxqnqqqjZX1UrgRmCf0ZUoSdpZzXQm8lHg4SnaH2rLJElz3EwhckBV3bJ1Y2tbNLSKJEkTY6YQmemS1fN2dCGSpMkzU4isSfKOrRuT/B69YeElSXPcTF183wv87yRv45nQWALsAfz2sAuTJO38pg2RqroP+LUkrwcOa81frKqvjaQySdJOb5ABGK8Grh5BLZKkCTPIw4aSJE3JEJEkdWaISJI6M0QkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiSerMEJEkdWaISJI6M0QkSZ0ZIpKkzgwRSVJnIw+RJAcluTrJbUluTXJGa39xkquS3Nn+7tvak+TjSdYmuTnJ4X3bWt7WvzPJ8lH/Fkma68ZxJrIZ+MOqOhQ4CjgtyaHAmcDqqloMrG7zAMcDi9tnBXAB9EIHOAs4EjgCOGtL8EiSRmPkIVJVG6rqxjb9CHA7sABYBqxsq60ETmjTy4BLqudaYJ8kBwLHAVdV1aaqegC4Clg6wp8iSXPeWO+JJFkEvBq4Djigqja0RfcCB7TpBcA9fV9b19qma59qPyuSrEmyZuPGjTusfkma68YWIkleAHweeG9VPdy/rKoKqB21r6q6sKqWVNWS+fPn76jNStKcN5YQSbI7vQD5dFV9oTXf1y5T0f7e39rXAwf1fX1ha5uuXZI0IuPonRXgIuD2qvpw36JVwJYeVsuBK/raT269tI4CHmqXva4Ejk2yb7uhfmxrkySNyLwx7PNo4O3ALUm+09o+APw5cFmSU4G7gRPbsi8BbwDWAo8DpwBU1aYk5wDfbuudXVWbRvMTJEkwhhCpqm8CmWbxMVOsX8Bp02zrYuDiHVedJGl7+MS6JKkzQ0SS1JkhIknqzBCRJHVmiEiSOjNEJEmdGSKSpM4MEUlSZ4aIJKkzQ0SS1JkhIknqzBCRJHVmiEiSOjNEJEmdGSKSpM7G8VKqifGaP7pk3CXs8m74LyePuwRJs+CZiCSpM0NEktSZISJJ6swQkSR1ZohIkjozRCRJnRkikqTODBFJUmeGiCSpM0NEktSZISJJ6swQkSR1ZohIkjozRCRJnRkikqTODBFJUmeGiCSps4kPkSRLk9yRZG2SM8ddjyTNJRMdIkl2A/4bcDxwKPC7SQ4db1WSNHdMdIgARwBrq+oHVfUz4FJg2ZhrkqQ5I1U17ho6S/JmYGlV/V6bfztwZFW9e6v1VgAr2uwhwB0jLXR09gd+PO4i1JnHb7LtysfvpVU1f6oF80ZdyThU1YXAheOuY9iSrKmqJeOuQ914/CbbXD1+k345az1wUN/8wtYmSRqBSQ+RbwOLkxycZA/gJGDVmGuSpDljoi9nVdXmJO8GrgR2Ay6uqlvHXNY47fKX7HZxHr/JNieP30TfWJckjdekX86SJI2RISJJ6swQ2cklOSjJ1UluS3JrkjNa+4uTXJXkzvZ339aeJB9vw8DcnOTwvm2dl+S77fPWcf2muaLDsXtFkn9I8kSS9221LYf3GbEdfPwuTnJ/ku+O47cMkyGy89sM/GFVHQocBZzWhnY5E1hdVYuB1W0eekPALG6fFcAFAEneCBwOvAo4Enhfkr1H+UPmoO09dpuA04EP9W/E4X3GZoccv+ZvgKVDr3gMDJGdXFVtqKob2/QjwO3AAnrDu6xsq60ETmjTy4BLqudaYJ8kB9L7j881VbW5qh4DbmYX/Ue9s9jeY1dV91fVt4Gfb7Uph/cZgx14/Kiqa+iFzC7HEJkgSRYBrwauAw6oqg1t0b3AAW16AXBP39fWtbZ/BJYmeX6S/YHX8+wHNTVEAx676Ux3TDUiszx+u7SJfk5kLknyAuDzwHur6uEkTy+rqkoyY1/tqvpqkn8BfAvYCPwD8OQQS1Yz22On8fL4zcwzkQmQZHd6/4g/XVVfaM33tctUtL/3t/Zph4KpqnOr6lVV9RtAgO+Nov65bDuP3XQc3mdMdtDx26UZIju59P635yLg9qr6cN+iVcDyNr0cuKKv/eTWS+so4KGq2pBktyT7tW2+Engl8NWR/Ig5qsOxm47D+4zBDjx+uzSfWN/JJXkt8A3gFuCp1vwBetdmLwN+EbgbOLGqNrV/+H9F76b548ApVbUmyZ7Aje37DwPvrKrvjO6XzD0djt0vAGuAvdv6jwKHtksobwA+yjPD+5w70h8zB+3g4/cZ4HX0hou/Dzirqi4a4c8ZGkNEktSZl7MkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiDVF7XuebSY7va3tLkq+Msy5pR7GLrzRkSQ4DPkdv7KV5wE3A0qr6fodtzauqzTu4RKkzQ0QagSR/ATwG7NX+vhQ4DNgd+GBVXdEG+ftkWwfg3VX1rSSvA84BHgBeUVUvH2310vQMEWkEkuxFb8SAnwF/C9xaVZ9Ksg9wPb2zlAKeqqqfJlkMfKaqlrQQ+SJwWFXdNZ5fIE3NUXylEaiqx5J8lt5QGCcCv9X39rs96Q2h8U/AXyV5Fb0RlvvPOK43QLQzMkSk0XmqfQL8TlXd0b8wyQfpjav0q/Q6vfy0b/FjI6pR2i72zpJG70rgPW2wTJK8urW/CNhQVU8Bb6c32KK0UzNEpNE7h94N9ZuT3NrmAc4Hlif5R+AVePahCeCNdUlSZ56JSJI6M0QkSZ0ZIpKkzgwRSVJnhogkqTNDRJLUmSEiSers/wHtSuakHXdtAQAAAABJRU5ErkJggg==\n",
"text/plain": [
"<IPython.core.display.Image object>"
]
},
"metadata": {}
},
{
"output_type": "display_data",
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEGCAYAAABo25JHAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAVKUlEQVR4nO3dfbRldX3f8ffHAYQAQuJMlPI0pJKkiIhkQobiSkkMKyN1QW2wBamAUSdxiUKLadRWiBi7aqqG6vg0FgSMy6hAdTRYpUqAhEi5g8DwUMJEHYESuIDyLDjw7R9njx4ud+7Zc+fuc7mz36+1zrr74bf3/p61Z+7n7qffTlUhSeqv58x3AZKk+WUQSFLPGQSS1HMGgST1nEEgST233XwXsKUWL15cS5cune8yJGlBWbt27b1VtWS6eQsuCJYuXcrExMR8lyFJC0qSDZub56khSeo5g0CSes4gkKSeMwgkqecMAknqOYNAknrOIJCknjMIJKnnDAJJ6rkF92Txlvi1P7pgvkvohbX/7cT5LkHSVvCIQJJ6ziCQpJ4zCCSp5wwCSeo5g0CSeq6zIEiyY5L/k+T6JDclec80bZ6b5PNJ1ie5OsnSruqRJE2vyyOCx4HfrqqXAgcDK5Isn9LmDcAPq+pFwJ8D7++wHknSNDoLghp4uBndvvnUlGbHAOc3wxcCr0iSrmqSJD1Tp9cIkixKch1wD3BpVV09pcmewO0AVbUReAB4/jTrWZlkIsnE5ORklyVLUu90GgRV9WRVHQzsBRya5MBZrmd1VS2rqmVLlkz77mVJ0iyN5a6hqvoRcBmwYsqsO4G9AZJsB+wG3DeOmiRJA13eNbQkye7N8E7AkcD/ndJsDXBSM3ws8K2qmnodQZLUoS47ndsDOD/JIgaB84Wq+mqSs4CJqloDnAN8Jsl64H7guA7rkSRNo7MgqKobgJdNM/2MoeEfA6/pqgZJ0mg+WSxJPWcQSFLPGQSS1HMGgST1nEEgST1nEEhSzxkEktRzBoEk9ZxBIEk9ZxBIUs8ZBJLUcwaBJPWcQSBJPWcQSFLPGQSS1HMGgST1nEEgST1nEEhSzxkEktRzBoEk9ZxBIEk9ZxBIUs8ZBJLUcwaBJPVcZ0GQZO8klyW5OclNSU6dps0RSR5Icl3zOaOreiRJ09uuw3VvBE6vqmuT7AqsTXJpVd08pd2VVfWqDuuQJM2gsyOCqrqrqq5thh8CbgH27Gp7kqTZGcs1giRLgZcBV08z+7Ak1yf5WpIXb2b5lUkmkkxMTk52WKkk9U/nQZBkF+Ai4LSqenDK7GuBfavqpcBHgC9Nt46qWl1Vy6pq2ZIlS7otWJJ6ptMgSLI9gxD4bFVdPHV+VT1YVQ83w5cA2ydZ3GVNkqSn6/KuoQDnALdU1Yc20+aFTTuSHNrUc19XNUmSnqnVXUNJngO8FPgnwGPAjVV1z4jFDgdeB6xLcl0z7V3APgBV9QngWODNSTY26z2uqmqLv4UkadZmDIIk/xT4Y+B3gNuASWBH4JeTPAp8Eji/qp6aumxV/Q2QmdZfVauAVbMrXZI0F0YdEfwp8HHgD6b+pZ7kF4HXMvir//xuypMkdW3GIKiq42eYdw9w9pxXJEkaqy26WJzkRUn+IslFSQ7rqihJ0viMukawY1X9eGjSe4H/2Ax/BTi4q8IkSeMx6ojgK0lOHBr/CbAU2Bd4squiJEnjMyoIVgDPS/K/kvwm8Hbgd4FXAyd0XZwkqXujLhY/CaxK8hng3cCbgf9cVf8wjuIkSd0bdY3gN4A/Ap4A/guDh77el+RO4L1V9aPuS1Rf/eCsl8x3Cdu8fc5YN98l6Flg1HMEnwSOAnYBPl1VhwPHJfkXwOcZnCaSJC1go4JgI4OLwzszOCoAoKouBy7vrixJ0riMCoLXAn/AIAROHNFWkrQAjQqC26rq9JkaJIkdxUnSwjXq9tHLkrw1yT7DE5PskOS3k5wPnNRdeZKkro06IlgB/D7wuST7AT9i0PvoIuAbwNlV9Z1uS5QkdWnUcwQ/Bj4GfKx529hi4DFvG5WkbUerF9MAVNVPgLs6rEWSNA9aB4EkbYnDP3L4fJewzfvbt/7tnKyn05fXS5Ke/VoHQZJ9k/xOM7xTkl27K0uSNC6tgiDJm4ALGXQ5AbAX8KWuipIkjU/bI4K3AIcDDwJU1W3AL3ZVlCRpfNoGweNV9dO+hpJsB/g0sSRtA9oGweVJ3gXslORI4IsMXlUpSVrg2gbBO4BJYB2DTuguqar/1FlVkqSxaRsEb62qT1XVa6rq2Kr6VJJTZ1ogyd5JLktyc5KbpmufgQ8nWZ/khiSHzOpbSJJmrW0QTNex3MkjltkInF5VBwDLgbckOWBKm1cC+zeflcDHW9YjSZojo15VeTyDdxLsl2TN0KxdgftnWraq7qLpkqKqHkpyC7AncPNQs2OAC5purL+dZPckezTLSpLGYFQXE1cx+GW+GPjg0PSHgBvabiTJUuBlwNVTZu0J3D40fkcz7WlBkGQlgyMG9tnnaT1iS5K20qjeRzcAG4DDZruBJLsAFwGnVdWDs1lHVa0GVgMsW7bM21YlaQ61fbJ4eZJrkjyc5IkkTyYZ+Uu96br6IuCzVXXxNE3uBPYeGt+rmSZJGpO2F4tXAccDtwE7AW8EPjrTAkkCnAPcUlUf2kyzNcCJzd1Dy4EHvD4gSeO1Je8jWJ9kUVU9CXw6yXeAd86wyOHA64B1Sa5rpr0L2KdZ3yeAS4CjgPXAo8Drt/wrSJK2RtsgeDTJDsB1Sf6MwcXcGY8mqupvgIxoUwz6MZIkzZO2p4Ze17Q9BXiEwXn9f91VUZKk8WkVBFW1oap+XFUPVtV7gPcCx3VbmiRpHGYMgqabiNVJvprkjUl2TvJB4FbshlqStgmjrhFcAFzO4BbQFcAEcB1wUFX9Y8e1SZLGYFQQ/EJV/Ukz/PUkrwFOqKqnui1LkjQuI+8aSvLz/Ozun/uA3ZpnBKiqGfsbkiQ9+40Kgt2AtTz9NtBrm58F/FIXRUmSxmdUX0NLx1SHJGmetH2OQJK0jTIIJKnnDAJJ6rnWnc4lWQS8YHiZqvpBF0VJksanVRAkeStwJnA3sOkZggIO6qguSdKYtD0iOBX4laq6r8tiJEnj1/Yawe3AA10WIkmaH22PCL4L/HWSvwIe3zRxhjePSZIWiLZB8IPms0PzkSRtI1oFQfMOApLs0ow/3GVRkqTxaXWNIMmBzTuKbwJuSrI2yYu7LU2SNA5tLxavBv5DVe1bVfsCpwOf6q4sSdK4tA2Cnavqsk0jVfXXwM6dVCRJGqvWdw0leTfwmWb83zG4k0iStMC1PSL4fWAJcHHzWdJMkyQtcG3vGvoh8LaOa5EkzYMZgyDJ2VV1WpKvMOhb6Gmq6ugZlj0XeBVwT1UdOM38I4AvA99rJl1cVWdtQe2SpDkw6ohg0zWBD8xi3ecBq4ALZmhzZVW9ahbrliTNkVGvqlzbDB5cVf99eF6SU4HLZ1j2iiRLt7ZASVK32l4sPmmaaSfPwfYPS3J9kq/N9IBakpVJJpJMTE5OzsFmJUmbjLpGcDzwWmC/JGuGZu0K3L+V274W2LeqHk5yFPAlYP/pGlbVagYPtbFs2bJnXKuQJM3eqGsEVwF3AYuBDw5Nfwi4YWs2XFUPDg1fkuRjSRZX1b1bs15J0pYZdY1gA7ABOGyuN5zkhcDdVVVJDmVwmsoX30jSmLV9VeVy4CPAP2PQDfUi4JGqet4My3wOOAJYnOQOBq+63B6gqj4BHAu8OclG4DHguKrytI8kjVnbLiZWAccBXwSWAScCvzzTAlV1/Ij5q5r1SpLmUdu7hqiq9cCiqnqyqj4NrOiuLEnSuLQ9Ing0yQ7AdUn+jMEF5NYhIkl69mr7y/x1DK4LnAI8AuwN/F5XRUmSxqdtp3MbmsHHgPd0V44kadxGPVC2jmk6m9ukqg6a84okSWM16ojADuEkaRvX5oEySdI2bNSpoYf42amhND+rGa6ZHiiTJC0Mo44Idh1XIZKk+dH6WYAkL0/y+mZ4cZL9uitLkjQurYIgyZnAHwPvbCbtAPxFV0VJksan7RHBq4GjGTxMRlX9PwbvJJAkLXBtg+CJpmfQAkiyc3clSZLGqW0QfCHJJ4Hdk7wJ+N/Ap7orS5I0Lm27mPhAkiOBB4FfAc6oqks7rUySNBZtX0yzH3Dlpl/+SXZKsrSqvt9lcZKk7rU9NfRF4Kmh8SebaZKkBa5tEGxXVU9sGmmGd+imJEnSOLUNgskkR28aSXIMcG83JUmSxqntG8r+EPhsklUM+hm6ncF7iyVJC1zbu4b+AVieZJdm/OFOq5IkjU3bu4aey+DVlEuB7ZJBR6RVdVZnlUmSxqLtqaEvAw8Aa4HHuytHkjRubYNgr6pa0WklkqR50fauoauSvGRLVpzk3CT3JLlxM/OT5MNJ1ie5IckhW7J+SdLcaBsELwfWJrm1+aW9LskNI5Y5D5jpKOKVwP7NZyXw8Za1SJLmUNtTQ6/c0hVX1RVJls7Q5BjggqZX028n2T3JHlV115ZuS5I0e62OCKpqQ/Mi+8cYdEX90y6pt8KeDJ5H2OSOZtozJFmZZCLJxOTk5FZuVpI0rO0byo5OchvwPeBy4PvA1zqs62mqanVVLauqZUuWLBnXZiWpF9peI3gvsBz4+6raD3gF8O2t3PadwN5D43s10yRJY9Q2CH5SVfcBz0nynKq6DFi2ldteA5zY3D20HHjA6wOSNH5tLxb/qOle4goGfQ7dQ/P+4s1J8jngCGBxkjuAM4HtAarqE8AlwFHAeuBR4PWz+QKSpK3TNgiOYXCh+N8DJwC7ATN2L1FVx4+YX8BbWm5fktSRGU8NJXlRksOr6pGqeqqqNlbV+cC1wO7jKVGS1KVR1wjOZvCe4qkeaOZJkha4UUHwgqpaN3ViM21pJxVJksZqVBDMdPpnp7ksRJI0P0YFwUSSN02dmOSNDLqkliQtcKPuGjoN+J9JTuBnv/iXMXhx/au7LEySNB4zBkFV3Q388yS/BRzYTP6rqvpW55VJksai7TuLLwMu67gWSdI8aNvFhCRpG2UQSFLPGQSS1HMGgST1nEEgST1nEEhSzxkEktRzBoEk9ZxBIEk9ZxBIUs8ZBJLUcwaBJPWcQSBJPWcQSFLPGQSS1HMGgST1XKdBkGRFkluTrE/yjmnmn5xkMsl1zeeNXdYjSXqmVm8om40ki4CPAkcCdwDXJFlTVTdPafr5qjqlqzokSTPr8ojgUGB9VX23qp4A/hI4psPtSZJmocsg2BO4fWj8jmbaVL+X5IYkFybZe7oVJVmZZCLJxOTkZBe1SlJvzffF4q8AS6vqIOBS4PzpGlXV6qpaVlXLlixZMtYCJWlb12UQ3AkM/4W/VzPtp6rqvqp6vBn9H8CvdViPJGkaXQbBNcD+SfZLsgNwHLBmuEGSPYZGjwZu6bAeSdI0OrtrqKo2JjkF+DqwCDi3qm5KchYwUVVrgLclORrYCNwPnNxVPZKk6XUWBABVdQlwyZRpZwwNvxN4Z5c1SJJmNt8XiyVJ88wgkKSeMwgkqecMAknqOYNAknrOIJCknjMIJKnnDAJJ6jmDQJJ6ziCQpJ4zCCSp5wwCSeo5g0CSes4gkKSeMwgkqecMAknqOYNAknrOIJCknjMIJKnnDAJJ6jmDQJJ6ziCQpJ4zCCSp5wwCSeq5ToMgyYoktyZZn+Qd08x/bpLPN/OvTrK0y3okSc/UWRAkWQR8FHglcABwfJIDpjR7A/DDqnoR8OfA+7uqR5I0vS6PCA4F1lfVd6vqCeAvgWOmtDkGOL8ZvhB4RZJ0WJMkaYrtOlz3nsDtQ+N3AL+xuTZVtTHJA8DzgXuHGyVZCaxsRh9OcmsnFT87LGbK93+2ywdOmu8Snk0W1v4707+7hiysfQfkbVu0//bd3Iwug2DOVNVqYPV81zEOSSaqatl816HZcf8tXH3ed12eGroT2HtofK9m2rRtkmwH7Abc12FNkqQpugyCa4D9k+yXZAfgOGDNlDZrgE3nFY4FvlVV1WFNkqQpOjs11JzzPwX4OrAIOLeqbkpyFjBRVWuAc4DPJFkP3M8gLPquF6fAtmHuv4Wrt/su/gEuSf3mk8WS1HMGgST1nEHQsSR7J7ksyc1JbkpyajP9F5JcmuS25ufPN9OT5MNNtxs3JDlkaF3vT3Jj8/m38/Wd+mQW++9Xk/xdkseTvH3KumbsckVza4733blJ7kly43x8l64ZBN3bCJxeVQcAy4G3NF1tvAP4ZlXtD3yzGYdBlxz7N5+VwMcBkvxL4BDgYAYP5r09yfPG+UV6akv33/3A24APDK+kZZcrmltzsu8a5wErOq94nhgEHauqu6rq2mb4IeAWBk9UD3evcT7wr5rhY4ALauDbwO5J9mDwy+OKqtpYVY8AN7AN/8N8ttjS/VdV91TVNcBPpqyqTZcrmkNzuO+oqisYBMU2ySAYo6Z31ZcBVwMvqKq7mln/CLygGZ6ua449geuBFUl+Lsli4Ld4+gN76ljL/bc5m9uvGoOt3HfbvAXRxcS2IMkuwEXAaVX14HDfelVVSWa8j7eqvpHk14GrgEng74AnOyxZQ7Z2/2n+uO9G84hgDJJsz+Af4mer6uJm8t3NKR+an/c00zfbNUdVva+qDq6qI4EAfz+O+vtuC/ff5rTpckVzbI723TbPIOhY0632OcAtVfWhoVnD3WucBHx5aPqJzd1Dy4EHququJIuSPL9Z50HAQcA3xvIlemwW+29z2nS5ojk0h/tum+eTxR1L8nLgSmAd8FQz+V0MzlV+AdgH2AD8m6q6v/nHu4rBheBHgddX1USSHYFrm+UfBP6wqq4b3zfpp1nsvxcCE8DzmvYPAwc0pySOAs7mZ12uvG+sX6Zn5njffQ44gkFX1XcDZ1bVOWP8Op0yCCSp5zw1JEk9ZxBIUs8ZBJLUcwaBJPWcQSBJPeeTxdIUzfMa32xGX8jgCe7JZvzQpq+gTW3PA75aVReOtUhpDhkE0hRVdR+DXl5J8ifAw1U1XY+U0jbBU0NSC0nelOSaJNcnuSjJzw3N/s0kVyX5bpJjm/ZHJPnq0PKrkpzcDH8/yXuSXJtkXZJfHe+3kZ7OIJDaubiqfr2qXsqgO+M3DM3bA3g58Crgv7Zc371VdQiD9028fVRjqUsGgdTOgUmuTLIOOAF48dC8L1XVU1V1M+27NN7UAdpaYOnclSltOYNAauc84JSqegnwHmDHoXmPDw1v6uN4I0///zXcfniZJ/FaneaZQSC1sytwV9Ot8Qkt2m8ADkjy3CS7A6/otDppK/iXiNTOuxn0WjnZ/Nx1psZVdXuSLwA3At8DvtN5hdIs2fuoJPWcp4YkqecMAknqOYNAknrOIJCknjMIJKnnDAJJ6jmDQJJ67v8Ddtdg7zroCXkAAAAASUVORK5CYII=\n",
"text/plain": [
"<IPython.core.display.Image object>"
]
},
"metadata": {}
}
]
},
{
"cell_type": "markdown",
"id": "09c84168",
"metadata": {
"id": "09c84168"
},
"source": [
"Pada tahun 2009 Finished Transaction &\tCancel Transaction berada di angka terendah yaitu 30761\t& 1015, namun Cancellation Rate per tahun 2009 berada diangka tertinggi yakni\t2.24%. Cancellation Rate per tahun sangat dipengaruhi oleh banyaknya customer yang melakukan pembatalan transaksi berbanding dengan total seluruh customer per tahunnya.\n",
"\n",
"Baca juga [Kompetisi SEO pada Bulan April-Mei 2023](https://www.eighttails.xyz/2023/03/20-kompetisi-seo-pada-bulan-april-mei-2023.html)\n",
"\n",
"Sedangkan untuk Finished Transaction &\tCancel Transaction tertinggi berada pada tahun 2010 dengan jumlah 403094 &\t9919. Cancellation Rate per tahun berada pada peringkat kedua antara tahun 2009 dan 2011 dengan jumlah sebesar 1.89%. Hal ini menunjukan bahwa tren dari Cancellation Rate menurun per tahunnya.\n",
"\n",
"Untuk tahun 2011 Finished Transaction &\tCancel Transactionnya berada pada peringkat kedua antara tahun 2009 dan 2010 dengan jumlah 371765 &\t8560. Sedangkan untuk Cancellation Rate tahun 2011 merupakan Cancellation Rate terendah dengan jumlah 1.71%.\n",
"\n",
"Performa penjualan ritel online dalam kurun waktu 3 tahun terakhir, untuk Finished Transaction mengalami kenaikan cukup tajam pada tahun 2010, namun mengalami penurunan kembali pada tahun 2011 walau tak terlalu tajam. Sedangkan untuk Cancel Transaction juga mengalami lonjakan yang cukup tajam pada tahun 2010, walaupun kembali turun sedikit pada tahun 2011. Cancellation Rate per tahun mengalami tren penurunan dari tahun 2009 sampai 2011 dimana hal ini merupakan hal yang baik bagi perusahaan. Namun dilain sisi Finished Transaction pada tahun 2011 mengalami tren menurun.\n",
"\n",
"Dalam hal ini diperlukan kajian lebih detail tentang Cancel Transaction dan mencari akar permasalahan dari penyebab konsumen membatalkan transaksinya. Kemudian mengkaji ulang dan meningkatkan lagi penjualan ritel online, karena pada tahun 2011 mengalami penurunan untuk total tranksaksinya.\n",
"\n",
"kritik saran bisa langsung ke [eighttail](https://www.eighttails.xyz/).\n"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3 (ipykernel)",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.9.6"
},
"colab": {
"provenance": [],
"include_colab_link": true
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment