{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "taruma-hidrokit-viz-table",
"version": "0.3.2",
"provenance": [],
"collapsed_sections": []
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "_CtZpmBbCbAg",
"colab_type": "text"
},
"source": [
"# Tutorial `hidrokit.viz.table`\n",
"\n",
"- **Kategori**: _data visualization_\n",
"- __Tujuan__: Menampilkan dataset melalui bentuk tabel\n",
"- __Dokumentasi__: [readthedocs](https://hidrokit.readthedocs.io/en/stable/viz.html#module-viz.table)\n",
"\n",
"## Informasi notebook\n",
"\n",
"- __notebook name__: `taruma_hidrokit_viz_table`\n",
"- __notebook version/date__: `1.0.1`/`20190713`\n",
"- __notebook server__: Google Colab\n",
"- __hidrokit version__: `0.2.0`\n",
"- **python version**: `3.7`"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "BPm5qNh_DQjj",
"colab_type": "text"
},
"source": [
"## Instalasi hidrokit"
]
},
{
"cell_type": "code",
"metadata": {
"id": "aeLepUrl_nxm",
"colab_type": "code",
"outputId": "64dbd4d3-4858-47d7-ca05-951d060e78c1",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 255
}
},
"source": [
"### Instalasi melalui PyPI\n",
"!pip install hidrokit\n",
"\n",
"### Instalasi melalui Github\n",
"# !pip install git+https://github.com/taruma/hidrokit.git\n",
"\n",
"### Instalasi melalui Github (Latest)\n",
"# !pip install git+https://github.com/taruma/hidrokit.git@latest"
],
"execution_count": 0,
"outputs": [
{
"output_type": "stream",
"text": [
"Collecting hidrokit\n",
" Downloading https://files.pythonhosted.org/packages/43/9d/343d2a413a07463a21dd13369e31d664d6733bbfd46276abef5d804c83d1/hidrokit-0.2.0-py2.py3-none-any.whl\n",
"Requirement already satisfied: matplotlib in /usr/local/lib/python3.6/dist-packages (from hidrokit) (3.0.3)\n",
"Requirement already satisfied: numpy in /usr/local/lib/python3.6/dist-packages (from hidrokit) (1.16.4)\n",
"Requirement already satisfied: pandas in /usr/local/lib/python3.6/dist-packages (from hidrokit) (0.24.2)\n",
"Requirement already satisfied: python-dateutil>=2.1 in /usr/local/lib/python3.6/dist-packages (from matplotlib->hidrokit) (2.5.3)\n",
"Requirement already satisfied: kiwisolver>=1.0.1 in /usr/local/lib/python3.6/dist-packages (from matplotlib->hidrokit) (1.1.0)\n",
"Requirement already satisfied: pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.1 in /usr/local/lib/python3.6/dist-packages (from matplotlib->hidrokit) (2.4.0)\n",
"Requirement already satisfied: cycler>=0.10 in /usr/local/lib/python3.6/dist-packages (from matplotlib->hidrokit) (0.10.0)\n",
"Requirement already satisfied: pytz>=2011k in /usr/local/lib/python3.6/dist-packages (from pandas->hidrokit) (2018.9)\n",
"Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.6/dist-packages (from python-dateutil>=2.1->matplotlib->hidrokit) (1.12.0)\n",
"Requirement already satisfied: setuptools in /usr/local/lib/python3.6/dist-packages (from kiwisolver>=1.0.1->matplotlib->hidrokit) (41.0.1)\n",
"Installing collected packages: hidrokit\n",
"Successfully installed hidrokit-0.2.0\n"
],
"name": "stdout"
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "APb9vC-zDaV4",
"colab_type": "text"
},
"source": [
"## Import Library"
]
},
{
"cell_type": "code",
"metadata": {
"id": "Gx6h8iSxDfQY",
"colab_type": "code",
"colab": {}
},
"source": [
"import numpy as np\n",
"import pandas as pd"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "markdown",
"metadata": {
"id": "Kny2T1itDlz6",
"colab_type": "text"
},
"source": [
"## Dataset"
]
},
{
"cell_type": "code",
"metadata": {
"id": "xdDdm1pbD-AO",
"colab_type": "code",
"outputId": "9921a41d-670d-4297-c332-dc16dcae1fda",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 357
}
},
"source": [
"# Ambil dataset dari data test hidrokit\n",
"!wget -O dataset.csv \"https://github.com/taruma/hidrokit/blob/master/tests/data/one_year_three_columns.csv?raw=true\""
],
"execution_count": 0,
"outputs": [
{
"output_type": "stream",
"text": [
"--2019-07-12 03:02:01-- https://github.com/taruma/hidrokit/blob/master/tests/data/one_year_three_columns.csv?raw=true\n",
"Resolving github.com (github.com)... 192.30.253.112\n",
"Connecting to github.com (github.com)|192.30.253.112|:443... connected.\n",
"HTTP request sent, awaiting response... 302 Found\n",
"Location: https://github.com/taruma/hidrokit/raw/master/tests/data/one_year_three_columns.csv [following]\n",
"--2019-07-12 03:02:01-- https://github.com/taruma/hidrokit/raw/master/tests/data/one_year_three_columns.csv\n",
"Reusing existing connection to github.com:443.\n",
"HTTP request sent, awaiting response... 302 Found\n",
"Location: https://raw.githubusercontent.com/taruma/hidrokit/master/tests/data/one_year_three_columns.csv [following]\n",
"--2019-07-12 03:02:01-- https://raw.githubusercontent.com/taruma/hidrokit/master/tests/data/one_year_three_columns.csv\n",
"Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.0.133, 151.101.64.133, 151.101.128.133, ...\n",
"Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.0.133|:443... connected.\n",
"HTTP request sent, awaiting response... 200 OK\n",
"Length: 7242 (7.1K) [text/plain]\n",
"Saving to: ‘dataset.csv’\n",
"\n",
"dataset.csv 100%[===================>] 7.07K --.-KB/s in 0s \n",
"\n",
"2019-07-12 03:02:01 (90.8 MB/s) - ‘dataset.csv’ saved [7242/7242]\n",
"\n"
],
"name": "stdout"
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "nJdvdBzjEH96",
"colab_type": "code",
"outputId": "e6071183-855a-4123-dc44-5615796198c5",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 359
}
},
"source": [
"# Baca dataset\n",
"dataset = pd.read_csv('dataset.csv', index_col=0, parse_dates=True)\n",
"dataset.head(10)"
],
"execution_count": 0,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" sta_a | \n",
" sta_b | \n",
" sta_c | \n",
"
\n",
" \n",
" \n",
" \n",
" 2000-01-01 | \n",
" 7 | \n",
" 79 | \n",
" 19 | \n",
"
\n",
" \n",
" 2000-01-02 | \n",
" 17 | \n",
" 79 | \n",
" 65 | \n",
"
\n",
" \n",
" 2000-01-03 | \n",
" 79 | \n",
" 51 | \n",
" 25 | \n",
"
\n",
" \n",
" 2000-01-04 | \n",
" 48 | \n",
" 75 | \n",
" 31 | \n",
"
\n",
" \n",
" 2000-01-05 | \n",
" 81 | \n",
" 33 | \n",
" 80 | \n",
"
\n",
" \n",
" 2000-01-06 | \n",
" 26 | \n",
" 3 | \n",
" 96 | \n",
"
\n",
" \n",
" 2000-01-07 | \n",
" 78 | \n",
" 75 | \n",
" 26 | \n",
"
\n",
" \n",
" 2000-01-08 | \n",
" 71 | \n",
" 95 | \n",
" 65 | \n",
"
\n",
" \n",
" 2000-01-09 | \n",
" 48 | \n",
" 71 | \n",
" 22 | \n",
"
\n",
" \n",
" 2000-01-10 | \n",
" 32 | \n",
" 89 | \n",
" 88 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" sta_a sta_b sta_c\n",
"2000-01-01 7 79 19\n",
"2000-01-02 17 79 65\n",
"2000-01-03 79 51 25\n",
"2000-01-04 48 75 31\n",
"2000-01-05 81 33 80\n",
"2000-01-06 26 3 96\n",
"2000-01-07 78 75 26\n",
"2000-01-08 71 95 65\n",
"2000-01-09 48 71 22\n",
"2000-01-10 32 89 88"
]
},
"metadata": {
"tags": []
},
"execution_count": 4
}
]
},
{
"cell_type": "code",
"metadata": {
"id": "XDVLNazbGfHC",
"colab_type": "code",
"outputId": "6bad6d9f-6934-4883-c16d-6d9a6efe7687",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 153
}
},
"source": [
"# Info dataset\n",
"dataset.info()"
],
"execution_count": 0,
"outputs": [
{
"output_type": "stream",
"text": [
"\n",
"DatetimeIndex: 366 entries, 2000-01-01 to 2000-12-31\n",
"Data columns (total 3 columns):\n",
"sta_a 366 non-null int64\n",
"sta_b 366 non-null int64\n",
"sta_c 366 non-null int64\n",
"dtypes: int64(3)\n",
"memory usage: 11.4 KB\n"
],
"name": "stdout"
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "KysAN-JKFs_c",
"colab_type": "text"
},
"source": [
"# Fungsi `table.pivot()`\n",
"\n",
"- __Tujuan__: Menampilkan dataset dalam bentuk pivot/ringkasan\n",
"- __Sintaks__: `viz.table.pivot(dataframe, column=None, lang=None)`\n",
"- __Return__: `DataFrame`\n",
"- __Dokumentasi__: [readthedocs](https://hidrokit.readthedocs.io/en/stable/viz.html#viz.table.pivot)"
]
},
{
"cell_type": "code",
"metadata": {
"id": "62fs0DjLHJP_",
"colab_type": "code",
"colab": {}
},
"source": [
"from hidrokit.viz import table"
],
"execution_count": 0,
"outputs": []
},
{
"cell_type": "markdown",
"metadata": {
"id": "cxGt4n98GVQE",
"colab_type": "text"
},
"source": [
"## Argument: None\n",
"\n",
"Jika tidak ada kolom yang dipilih, maka akan dipilih kolom pertama (`sta_a`)."
]
},
{
"cell_type": "code",
"metadata": {
"id": "6Aq3kFPRGStF",
"colab_type": "code",
"outputId": "1125b183-b82d-444b-e0f7-1d3fbf4ec44c",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 1000
}
},
"source": [
"table.pivot(dataset)"
],
"execution_count": 0,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" month | \n",
" 1 | \n",
" 2 | \n",
" 3 | \n",
" 4 | \n",
" 5 | \n",
" 6 | \n",
" 7 | \n",
" 8 | \n",
" 9 | \n",
" 10 | \n",
" 11 | \n",
" 12 | \n",
"
\n",
" \n",
" day | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" 1 | \n",
" 7.0 | \n",
" 49.0 | \n",
" 55.0 | \n",
" 82.0 | \n",
" 18.0 | \n",
" 61.0 | \n",
" 54.0 | \n",
" 5.0 | \n",
" 14.0 | \n",
" 27.0 | \n",
" 59.0 | \n",
" 28.0 | \n",
"
\n",
" \n",
" 2 | \n",
" 17.0 | \n",
" 76.0 | \n",
" 6.0 | \n",
" 94.0 | \n",
" 86.0 | \n",
" 92.0 | \n",
" 27.0 | \n",
" 19.0 | \n",
" 77.0 | \n",
" 70.0 | \n",
" 65.0 | \n",
" 95.0 | \n",
"
\n",
" \n",
" 3 | \n",
" 79.0 | \n",
" 17.0 | \n",
" 95.0 | \n",
" 3.0 | \n",
" 79.0 | \n",
" 69.0 | \n",
" 68.0 | \n",
" 41.0 | \n",
" 48.0 | \n",
" 83.0 | \n",
" 88.0 | \n",
" 86.0 | \n",
"
\n",
" \n",
" 4 | \n",
" 48.0 | \n",
" 43.0 | \n",
" 67.0 | \n",
" 34.0 | \n",
" 41.0 | \n",
" 24.0 | \n",
" 58.0 | \n",
" 25.0 | \n",
" 94.0 | \n",
" 96.0 | \n",
" 31.0 | \n",
" 12.0 | \n",
"
\n",
" \n",
" 5 | \n",
" 81.0 | \n",
" 38.0 | \n",
" 41.0 | \n",
" 62.0 | \n",
" 5.0 | \n",
" 70.0 | \n",
" 67.0 | \n",
" 27.0 | \n",
" 61.0 | \n",
" 5.0 | \n",
" 96.0 | \n",
" 84.0 | \n",
"
\n",
" \n",
" 6 | \n",
" 26.0 | \n",
" 25.0 | \n",
" 16.0 | \n",
" 20.0 | \n",
" 19.0 | \n",
" 53.0 | \n",
" 60.0 | \n",
" 40.0 | \n",
" 1.0 | \n",
" 75.0 | \n",
" 62.0 | \n",
" 43.0 | \n",
"
\n",
" \n",
" 7 | \n",
" 78.0 | \n",
" 91.0 | \n",
" 88.0 | \n",
" 31.0 | \n",
" 66.0 | \n",
" 27.0 | \n",
" 35.0 | \n",
" 98.0 | \n",
" 64.0 | \n",
" 31.0 | \n",
" 10.0 | \n",
" 13.0 | \n",
"
\n",
" \n",
" 8 | \n",
" 71.0 | \n",
" 58.0 | \n",
" 46.0 | \n",
" 85.0 | \n",
" 20.0 | \n",
" 42.0 | \n",
" 39.0 | \n",
" 22.0 | \n",
" 64.0 | \n",
" 10.0 | \n",
" 46.0 | \n",
" 23.0 | \n",
"
\n",
" \n",
" 9 | \n",
" 48.0 | \n",
" 8.0 | \n",
" 7.0 | \n",
" 54.0 | \n",
" 26.0 | \n",
" 38.0 | \n",
" 67.0 | \n",
" 6.0 | \n",
" 11.0 | \n",
" 9.0 | \n",
" 82.0 | \n",
" 9.0 | \n",
"
\n",
" \n",
" 10 | \n",
" 32.0 | \n",
" 58.0 | \n",
" 73.0 | \n",
" 61.0 | \n",
" 91.0 | \n",
" 86.0 | \n",
" 18.0 | \n",
" 22.0 | \n",
" 12.0 | \n",
" 98.0 | \n",
" 40.0 | \n",
" 94.0 | \n",
"
\n",
" \n",
" 11 | \n",
" 66.0 | \n",
" 94.0 | \n",
" 62.0 | \n",
" 80.0 | \n",
" 99.0 | \n",
" 7.0 | \n",
" 12.0 | \n",
" 36.0 | \n",
" 24.0 | \n",
" 62.0 | \n",
" 54.0 | \n",
" 44.0 | \n",
"
\n",
" \n",
" 12 | \n",
" 93.0 | \n",
" 62.0 | \n",
" 18.0 | \n",
" 37.0 | \n",
" 94.0 | \n",
" 47.0 | \n",
" 41.0 | \n",
" 38.0 | \n",
" 3.0 | \n",
" 0.0 | \n",
" 59.0 | \n",
" 43.0 | \n",
"
\n",
" \n",
" 13 | \n",
" 94.0 | \n",
" 64.0 | \n",
" 37.0 | \n",
" 60.0 | \n",
" 80.0 | \n",
" 91.0 | \n",
" 29.0 | \n",
" 39.0 | \n",
" 61.0 | \n",
" 93.0 | \n",
" 64.0 | \n",
" 12.0 | \n",
"
\n",
" \n",
" 14 | \n",
" 98.0 | \n",
" 80.0 | \n",
" 80.0 | \n",
" 89.0 | \n",
" 90.0 | \n",
" 58.0 | \n",
" 58.0 | \n",
" 93.0 | \n",
" 10.0 | \n",
" 17.0 | \n",
" 35.0 | \n",
" 96.0 | \n",
"
\n",
" \n",
" 15 | \n",
" 40.0 | \n",
" 85.0 | \n",
" 97.0 | \n",
" 12.0 | \n",
" 1.0 | \n",
" 48.0 | \n",
" 76.0 | \n",
" 75.0 | \n",
" 7.0 | \n",
" 9.0 | \n",
" 42.0 | \n",
" 74.0 | \n",
"
\n",
" \n",
" 16 | \n",
" 46.0 | \n",
" 1.0 | \n",
" 0.0 | \n",
" 86.0 | \n",
" 18.0 | \n",
" 96.0 | \n",
" 70.0 | \n",
" 3.0 | \n",
" 28.0 | \n",
" 11.0 | \n",
" 93.0 | \n",
" 31.0 | \n",
"
\n",
" \n",
" 17 | \n",
" 34.0 | \n",
" 21.0 | \n",
" 73.0 | \n",
" 58.0 | \n",
" 26.0 | \n",
" 97.0 | \n",
" 3.0 | \n",
" 24.0 | \n",
" 96.0 | \n",
" 23.0 | \n",
" 35.0 | \n",
" 22.0 | \n",
"
\n",
" \n",
" 18 | \n",
" 21.0 | \n",
" 36.0 | \n",
" 22.0 | \n",
" 5.0 | \n",
" 60.0 | \n",
" 84.0 | \n",
" 75.0 | \n",
" 29.0 | \n",
" 39.0 | \n",
" 76.0 | \n",
" 47.0 | \n",
" 33.0 | \n",
"
\n",
" \n",
" 19 | \n",
" 61.0 | \n",
" 40.0 | \n",
" 60.0 | \n",
" 28.0 | \n",
" 65.0 | \n",
" 20.0 | \n",
" 68.0 | \n",
" 18.0 | \n",
" 50.0 | \n",
" 12.0 | \n",
" 37.0 | \n",
" 5.0 | \n",
"
\n",
" \n",
" 20 | \n",
" 62.0 | \n",
" 6.0 | \n",
" 47.0 | \n",
" 91.0 | \n",
" 28.0 | \n",
" 60.0 | \n",
" 25.0 | \n",
" 51.0 | \n",
" 63.0 | \n",
" 34.0 | \n",
" 70.0 | \n",
" 88.0 | \n",
"
\n",
" \n",
" 21 | \n",
" 25.0 | \n",
" 73.0 | \n",
" 11.0 | \n",
" 66.0 | \n",
" 50.0 | \n",
" 33.0 | \n",
" 18.0 | \n",
" 74.0 | \n",
" 67.0 | \n",
" 63.0 | \n",
" 45.0 | \n",
" 2.0 | \n",
"
\n",
" \n",
" 22 | \n",
" 98.0 | \n",
" 18.0 | \n",
" 87.0 | \n",
" 22.0 | \n",
" 86.0 | \n",
" 24.0 | \n",
" 45.0 | \n",
" 93.0 | \n",
" 19.0 | \n",
" 38.0 | \n",
" 67.0 | \n",
" 80.0 | \n",
"
\n",
" \n",
" 23 | \n",
" 51.0 | \n",
" 25.0 | \n",
" 12.0 | \n",
" 68.0 | \n",
" 31.0 | \n",
" 49.0 | \n",
" 43.0 | \n",
" 32.0 | \n",
" 67.0 | \n",
" 75.0 | \n",
" 49.0 | \n",
" 57.0 | \n",
"
\n",
" \n",
" 24 | \n",
" 83.0 | \n",
" 58.0 | \n",
" 30.0 | \n",
" 20.0 | \n",
" 81.0 | \n",
" 85.0 | \n",
" 10.0 | \n",
" 95.0 | \n",
" 94.0 | \n",
" 72.0 | \n",
" 80.0 | \n",
" 58.0 | \n",
"
\n",
" \n",
" 25 | \n",
" 73.0 | \n",
" 47.0 | \n",
" 74.0 | \n",
" 72.0 | \n",
" 1.0 | \n",
" 44.0 | \n",
" 72.0 | \n",
" 54.0 | \n",
" 61.0 | \n",
" 91.0 | \n",
" 21.0 | \n",
" 2.0 | \n",
"
\n",
" \n",
" 26 | \n",
" 54.0 | \n",
" 87.0 | \n",
" 13.0 | \n",
" 25.0 | \n",
" 72.0 | \n",
" 30.0 | \n",
" 19.0 | \n",
" 11.0 | \n",
" 63.0 | \n",
" 33.0 | \n",
" 70.0 | \n",
" 84.0 | \n",
"
\n",
" \n",
" 27 | \n",
" 90.0 | \n",
" 38.0 | \n",
" 10.0 | \n",
" 72.0 | \n",
" 60.0 | \n",
" 49.0 | \n",
" 1.0 | \n",
" 65.0 | \n",
" 72.0 | \n",
" 76.0 | \n",
" 83.0 | \n",
" 0.0 | \n",
"
\n",
" \n",
" 28 | \n",
" 61.0 | \n",
" 81.0 | \n",
" 99.0 | \n",
" 19.0 | \n",
" 11.0 | \n",
" 44.0 | \n",
" 82.0 | \n",
" 41.0 | \n",
" 50.0 | \n",
" 93.0 | \n",
" 12.0 | \n",
" 65.0 | \n",
"
\n",
" \n",
" 29 | \n",
" 6.0 | \n",
" 69.0 | \n",
" 92.0 | \n",
" 26.0 | \n",
" 3.0 | \n",
" 99.0 | \n",
" 40.0 | \n",
" 71.0 | \n",
" 85.0 | \n",
" 75.0 | \n",
" 31.0 | \n",
" 35.0 | \n",
"
\n",
" \n",
" 30 | \n",
" 64.0 | \n",
" NaN | \n",
" 26.0 | \n",
" 35.0 | \n",
" 92.0 | \n",
" 55.0 | \n",
" 65.0 | \n",
" 33.0 | \n",
" 84.0 | \n",
" 40.0 | \n",
" 82.0 | \n",
" 24.0 | \n",
"
\n",
" \n",
" 31 | \n",
" 72.0 | \n",
" NaN | \n",
" 37.0 | \n",
" NaN | \n",
" 22.0 | \n",
" NaN | \n",
" 86.0 | \n",
" 24.0 | \n",
" NaN | \n",
" 31.0 | \n",
" NaN | \n",
" 95.0 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
"month 1 2 3 4 5 6 7 8 9 10 11 12\n",
"day \n",
"1 7.0 49.0 55.0 82.0 18.0 61.0 54.0 5.0 14.0 27.0 59.0 28.0\n",
"2 17.0 76.0 6.0 94.0 86.0 92.0 27.0 19.0 77.0 70.0 65.0 95.0\n",
"3 79.0 17.0 95.0 3.0 79.0 69.0 68.0 41.0 48.0 83.0 88.0 86.0\n",
"4 48.0 43.0 67.0 34.0 41.0 24.0 58.0 25.0 94.0 96.0 31.0 12.0\n",
"5 81.0 38.0 41.0 62.0 5.0 70.0 67.0 27.0 61.0 5.0 96.0 84.0\n",
"6 26.0 25.0 16.0 20.0 19.0 53.0 60.0 40.0 1.0 75.0 62.0 43.0\n",
"7 78.0 91.0 88.0 31.0 66.0 27.0 35.0 98.0 64.0 31.0 10.0 13.0\n",
"8 71.0 58.0 46.0 85.0 20.0 42.0 39.0 22.0 64.0 10.0 46.0 23.0\n",
"9 48.0 8.0 7.0 54.0 26.0 38.0 67.0 6.0 11.0 9.0 82.0 9.0\n",
"10 32.0 58.0 73.0 61.0 91.0 86.0 18.0 22.0 12.0 98.0 40.0 94.0\n",
"11 66.0 94.0 62.0 80.0 99.0 7.0 12.0 36.0 24.0 62.0 54.0 44.0\n",
"12 93.0 62.0 18.0 37.0 94.0 47.0 41.0 38.0 3.0 0.0 59.0 43.0\n",
"13 94.0 64.0 37.0 60.0 80.0 91.0 29.0 39.0 61.0 93.0 64.0 12.0\n",
"14 98.0 80.0 80.0 89.0 90.0 58.0 58.0 93.0 10.0 17.0 35.0 96.0\n",
"15 40.0 85.0 97.0 12.0 1.0 48.0 76.0 75.0 7.0 9.0 42.0 74.0\n",
"16 46.0 1.0 0.0 86.0 18.0 96.0 70.0 3.0 28.0 11.0 93.0 31.0\n",
"17 34.0 21.0 73.0 58.0 26.0 97.0 3.0 24.0 96.0 23.0 35.0 22.0\n",
"18 21.0 36.0 22.0 5.0 60.0 84.0 75.0 29.0 39.0 76.0 47.0 33.0\n",
"19 61.0 40.0 60.0 28.0 65.0 20.0 68.0 18.0 50.0 12.0 37.0 5.0\n",
"20 62.0 6.0 47.0 91.0 28.0 60.0 25.0 51.0 63.0 34.0 70.0 88.0\n",
"21 25.0 73.0 11.0 66.0 50.0 33.0 18.0 74.0 67.0 63.0 45.0 2.0\n",
"22 98.0 18.0 87.0 22.0 86.0 24.0 45.0 93.0 19.0 38.0 67.0 80.0\n",
"23 51.0 25.0 12.0 68.0 31.0 49.0 43.0 32.0 67.0 75.0 49.0 57.0\n",
"24 83.0 58.0 30.0 20.0 81.0 85.0 10.0 95.0 94.0 72.0 80.0 58.0\n",
"25 73.0 47.0 74.0 72.0 1.0 44.0 72.0 54.0 61.0 91.0 21.0 2.0\n",
"26 54.0 87.0 13.0 25.0 72.0 30.0 19.0 11.0 63.0 33.0 70.0 84.0\n",
"27 90.0 38.0 10.0 72.0 60.0 49.0 1.0 65.0 72.0 76.0 83.0 0.0\n",
"28 61.0 81.0 99.0 19.0 11.0 44.0 82.0 41.0 50.0 93.0 12.0 65.0\n",
"29 6.0 69.0 92.0 26.0 3.0 99.0 40.0 71.0 85.0 75.0 31.0 35.0\n",
"30 64.0 NaN 26.0 35.0 92.0 55.0 65.0 33.0 84.0 40.0 82.0 24.0\n",
"31 72.0 NaN 37.0 NaN 22.0 NaN 86.0 24.0 NaN 31.0 NaN 95.0"
]
},
"metadata": {
"tags": []
},
"execution_count": 7
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "xKE9vz5cGwvP",
"colab_type": "text"
},
"source": [
"## Argument: `column=`\n",
"\n",
"Memilih kolom tertentu."
]
},
{
"cell_type": "code",
"metadata": {
"id": "6NuLODmOHGHn",
"colab_type": "code",
"outputId": "613037ea-ee4f-4461-b400-ae4a1de80ca9",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 1000
}
},
"source": [
"# Memilih stasiun b\n",
"table.pivot(dataset, column='sta_b')"
],
"execution_count": 0,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" month | \n",
" 1 | \n",
" 2 | \n",
" 3 | \n",
" 4 | \n",
" 5 | \n",
" 6 | \n",
" 7 | \n",
" 8 | \n",
" 9 | \n",
" 10 | \n",
" 11 | \n",
" 12 | \n",
"
\n",
" \n",
" day | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" 1 | \n",
" 79.0 | \n",
" 14.0 | \n",
" 47.0 | \n",
" 11.0 | \n",
" 38.0 | \n",
" 24.0 | \n",
" 91.0 | \n",
" 74.0 | \n",
" 11.0 | \n",
" 67.0 | \n",
" 67.0 | \n",
" 5.0 | \n",
"
\n",
" \n",
" 2 | \n",
" 79.0 | \n",
" 21.0 | \n",
" 4.0 | \n",
" 28.0 | \n",
" 35.0 | \n",
" 95.0 | \n",
" 64.0 | \n",
" 34.0 | \n",
" 76.0 | \n",
" 28.0 | \n",
" 68.0 | \n",
" 26.0 | \n",
"
\n",
" \n",
" 3 | \n",
" 51.0 | \n",
" 65.0 | \n",
" 35.0 | \n",
" 90.0 | \n",
" 86.0 | \n",
" 29.0 | \n",
" 97.0 | \n",
" 0.0 | \n",
" 61.0 | \n",
" 0.0 | \n",
" 59.0 | \n",
" 27.0 | \n",
"
\n",
" \n",
" 4 | \n",
" 75.0 | \n",
" 47.0 | \n",
" 74.0 | \n",
" 62.0 | \n",
" 75.0 | \n",
" 32.0 | \n",
" 47.0 | \n",
" 96.0 | \n",
" 77.0 | \n",
" 57.0 | \n",
" 4.0 | \n",
" 58.0 | \n",
"
\n",
" \n",
" 5 | \n",
" 33.0 | \n",
" 48.0 | \n",
" 90.0 | \n",
" 23.0 | \n",
" 11.0 | \n",
" 75.0 | \n",
" 69.0 | \n",
" 1.0 | \n",
" 31.0 | \n",
" 84.0 | \n",
" 86.0 | \n",
" 57.0 | \n",
"
\n",
" \n",
" 6 | \n",
" 3.0 | \n",
" 63.0 | \n",
" 50.0 | \n",
" 6.0 | \n",
" 71.0 | \n",
" 29.0 | \n",
" 73.0 | \n",
" 73.0 | \n",
" 43.0 | \n",
" 45.0 | \n",
" 65.0 | \n",
" 69.0 | \n",
"
\n",
" \n",
" 7 | \n",
" 75.0 | \n",
" 85.0 | \n",
" 6.0 | \n",
" 42.0 | \n",
" 68.0 | \n",
" 51.0 | \n",
" 38.0 | \n",
" 57.0 | \n",
" 79.0 | \n",
" 9.0 | \n",
" 88.0 | \n",
" 76.0 | \n",
"
\n",
" \n",
" 8 | \n",
" 95.0 | \n",
" 81.0 | \n",
" 83.0 | \n",
" 30.0 | \n",
" 25.0 | \n",
" 21.0 | \n",
" 68.0 | \n",
" 90.0 | \n",
" 99.0 | \n",
" 1.0 | \n",
" 23.0 | \n",
" 63.0 | \n",
"
\n",
" \n",
" 9 | \n",
" 71.0 | \n",
" 48.0 | \n",
" 28.0 | \n",
" 13.0 | \n",
" 44.0 | \n",
" 76.0 | \n",
" 51.0 | \n",
" 58.0 | \n",
" 95.0 | \n",
" 18.0 | \n",
" 31.0 | \n",
" 50.0 | \n",
"
\n",
" \n",
" 10 | \n",
" 89.0 | \n",
" 23.0 | \n",
" 32.0 | \n",
" 47.0 | \n",
" 61.0 | \n",
" 66.0 | \n",
" 37.0 | \n",
" 34.0 | \n",
" 10.0 | \n",
" 67.0 | \n",
" 1.0 | \n",
" 94.0 | \n",
"
\n",
" \n",
" 11 | \n",
" 63.0 | \n",
" 90.0 | \n",
" 28.0 | \n",
" 73.0 | \n",
" 58.0 | \n",
" 47.0 | \n",
" 3.0 | \n",
" 93.0 | \n",
" 38.0 | \n",
" 32.0 | \n",
" 79.0 | \n",
" 90.0 | \n",
"
\n",
" \n",
" 12 | \n",
" 41.0 | \n",
" 58.0 | \n",
" 13.0 | \n",
" 58.0 | \n",
" 66.0 | \n",
" 3.0 | \n",
" 54.0 | \n",
" 8.0 | \n",
" 45.0 | \n",
" 46.0 | \n",
" 75.0 | \n",
" 12.0 | \n",
"
\n",
" \n",
" 13 | \n",
" 0.0 | \n",
" 3.0 | \n",
" 29.0 | \n",
" 44.0 | \n",
" 99.0 | \n",
" 67.0 | \n",
" 34.0 | \n",
" 84.0 | \n",
" 88.0 | \n",
" 8.0 | \n",
" 50.0 | \n",
" 60.0 | \n",
"
\n",
" \n",
" 14 | \n",
" 15.0 | \n",
" 31.0 | \n",
" 5.0 | \n",
" 95.0 | \n",
" 24.0 | \n",
" 83.0 | \n",
" 86.0 | \n",
" 78.0 | \n",
" 99.0 | \n",
" 34.0 | \n",
" 83.0 | \n",
" 75.0 | \n",
"
\n",
" \n",
" 15 | \n",
" 73.0 | \n",
" 44.0 | \n",
" 4.0 | \n",
" 22.0 | \n",
" 45.0 | \n",
" 51.0 | \n",
" 3.0 | \n",
" 27.0 | \n",
" 34.0 | \n",
" 41.0 | \n",
" 22.0 | \n",
" 53.0 | \n",
"
\n",
" \n",
" 16 | \n",
" 22.0 | \n",
" 39.0 | \n",
" 23.0 | \n",
" 51.0 | \n",
" 74.0 | \n",
" 75.0 | \n",
" 83.0 | \n",
" 63.0 | \n",
" 56.0 | \n",
" 62.0 | \n",
" 14.0 | \n",
" 54.0 | \n",
"
\n",
" \n",
" 17 | \n",
" 33.0 | \n",
" 70.0 | \n",
" 52.0 | \n",
" 16.0 | \n",
" 52.0 | \n",
" 71.0 | \n",
" 16.0 | \n",
" 71.0 | \n",
" 91.0 | \n",
" 20.0 | \n",
" 35.0 | \n",
" 17.0 | \n",
"
\n",
" \n",
" 18 | \n",
" 38.0 | \n",
" 90.0 | \n",
" 93.0 | \n",
" 16.0 | \n",
" 87.0 | \n",
" 95.0 | \n",
" 72.0 | \n",
" 85.0 | \n",
" 80.0 | \n",
" 1.0 | \n",
" 68.0 | \n",
" 56.0 | \n",
"
\n",
" \n",
" 19 | \n",
" 50.0 | \n",
" 69.0 | \n",
" 73.0 | \n",
" 13.0 | \n",
" 95.0 | \n",
" 44.0 | \n",
" 46.0 | \n",
" 77.0 | \n",
" 75.0 | \n",
" 42.0 | \n",
" 52.0 | \n",
" 67.0 | \n",
"
\n",
" \n",
" 20 | \n",
" 45.0 | \n",
" 66.0 | \n",
" 3.0 | \n",
" 93.0 | \n",
" 67.0 | \n",
" 67.0 | \n",
" 17.0 | \n",
" 47.0 | \n",
" 34.0 | \n",
" 46.0 | \n",
" 42.0 | \n",
" 17.0 | \n",
"
\n",
" \n",
" 21 | \n",
" 40.0 | \n",
" 73.0 | \n",
" 77.0 | \n",
" 28.0 | \n",
" 57.0 | \n",
" 78.0 | \n",
" 27.0 | \n",
" 65.0 | \n",
" 50.0 | \n",
" 99.0 | \n",
" 56.0 | \n",
" 0.0 | \n",
"
\n",
" \n",
" 22 | \n",
" 76.0 | \n",
" 29.0 | \n",
" 50.0 | \n",
" 32.0 | \n",
" 8.0 | \n",
" 64.0 | \n",
" 63.0 | \n",
" 67.0 | \n",
" 73.0 | \n",
" 21.0 | \n",
" 77.0 | \n",
" 32.0 | \n",
"
\n",
" \n",
" 23 | \n",
" 7.0 | \n",
" 9.0 | \n",
" 15.0 | \n",
" 41.0 | \n",
" 69.0 | \n",
" 51.0 | \n",
" 41.0 | \n",
" 96.0 | \n",
" 0.0 | \n",
" 1.0 | \n",
" 81.0 | \n",
" 80.0 | \n",
"
\n",
" \n",
" 24 | \n",
" 12.0 | \n",
" 72.0 | \n",
" 17.0 | \n",
" 39.0 | \n",
" 64.0 | \n",
" 60.0 | \n",
" 99.0 | \n",
" 14.0 | \n",
" 10.0 | \n",
" 23.0 | \n",
" 2.0 | \n",
" 88.0 | \n",
"
\n",
" \n",
" 25 | \n",
" 55.0 | \n",
" 97.0 | \n",
" 25.0 | \n",
" 70.0 | \n",
" 42.0 | \n",
" 64.0 | \n",
" 65.0 | \n",
" 25.0 | \n",
" 62.0 | \n",
" 89.0 | \n",
" 3.0 | \n",
" 93.0 | \n",
"
\n",
" \n",
" 26 | \n",
" 40.0 | \n",
" 22.0 | \n",
" 72.0 | \n",
" 88.0 | \n",
" 32.0 | \n",
" 68.0 | \n",
" 81.0 | \n",
" 59.0 | \n",
" 86.0 | \n",
" 30.0 | \n",
" 57.0 | \n",
" 76.0 | \n",
"
\n",
" \n",
" 27 | \n",
" 40.0 | \n",
" 71.0 | \n",
" 45.0 | \n",
" 14.0 | \n",
" 65.0 | \n",
" 82.0 | \n",
" 7.0 | \n",
" 1.0 | \n",
" 11.0 | \n",
" 49.0 | \n",
" 16.0 | \n",
" 62.0 | \n",
"
\n",
" \n",
" 28 | \n",
" 32.0 | \n",
" 98.0 | \n",
" 75.0 | \n",
" 44.0 | \n",
" 61.0 | \n",
" 13.0 | \n",
" 95.0 | \n",
" 44.0 | \n",
" 74.0 | \n",
" 5.0 | \n",
" 47.0 | \n",
" 17.0 | \n",
"
\n",
" \n",
" 29 | \n",
" 75.0 | \n",
" 79.0 | \n",
" 5.0 | \n",
" 19.0 | \n",
" 72.0 | \n",
" 5.0 | \n",
" 34.0 | \n",
" 13.0 | \n",
" 1.0 | \n",
" 6.0 | \n",
" 7.0 | \n",
" 96.0 | \n",
"
\n",
" \n",
" 30 | \n",
" 51.0 | \n",
" NaN | \n",
" 67.0 | \n",
" 74.0 | \n",
" 54.0 | \n",
" 58.0 | \n",
" 42.0 | \n",
" 75.0 | \n",
" 58.0 | \n",
" 13.0 | \n",
" 84.0 | \n",
" 17.0 | \n",
"
\n",
" \n",
" 31 | \n",
" 75.0 | \n",
" NaN | \n",
" 50.0 | \n",
" NaN | \n",
" 77.0 | \n",
" NaN | \n",
" 1.0 | \n",
" 14.0 | \n",
" NaN | \n",
" 25.0 | \n",
" NaN | \n",
" 31.0 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
"month 1 2 3 4 5 6 7 8 9 10 11 12\n",
"day \n",
"1 79.0 14.0 47.0 11.0 38.0 24.0 91.0 74.0 11.0 67.0 67.0 5.0\n",
"2 79.0 21.0 4.0 28.0 35.0 95.0 64.0 34.0 76.0 28.0 68.0 26.0\n",
"3 51.0 65.0 35.0 90.0 86.0 29.0 97.0 0.0 61.0 0.0 59.0 27.0\n",
"4 75.0 47.0 74.0 62.0 75.0 32.0 47.0 96.0 77.0 57.0 4.0 58.0\n",
"5 33.0 48.0 90.0 23.0 11.0 75.0 69.0 1.0 31.0 84.0 86.0 57.0\n",
"6 3.0 63.0 50.0 6.0 71.0 29.0 73.0 73.0 43.0 45.0 65.0 69.0\n",
"7 75.0 85.0 6.0 42.0 68.0 51.0 38.0 57.0 79.0 9.0 88.0 76.0\n",
"8 95.0 81.0 83.0 30.0 25.0 21.0 68.0 90.0 99.0 1.0 23.0 63.0\n",
"9 71.0 48.0 28.0 13.0 44.0 76.0 51.0 58.0 95.0 18.0 31.0 50.0\n",
"10 89.0 23.0 32.0 47.0 61.0 66.0 37.0 34.0 10.0 67.0 1.0 94.0\n",
"11 63.0 90.0 28.0 73.0 58.0 47.0 3.0 93.0 38.0 32.0 79.0 90.0\n",
"12 41.0 58.0 13.0 58.0 66.0 3.0 54.0 8.0 45.0 46.0 75.0 12.0\n",
"13 0.0 3.0 29.0 44.0 99.0 67.0 34.0 84.0 88.0 8.0 50.0 60.0\n",
"14 15.0 31.0 5.0 95.0 24.0 83.0 86.0 78.0 99.0 34.0 83.0 75.0\n",
"15 73.0 44.0 4.0 22.0 45.0 51.0 3.0 27.0 34.0 41.0 22.0 53.0\n",
"16 22.0 39.0 23.0 51.0 74.0 75.0 83.0 63.0 56.0 62.0 14.0 54.0\n",
"17 33.0 70.0 52.0 16.0 52.0 71.0 16.0 71.0 91.0 20.0 35.0 17.0\n",
"18 38.0 90.0 93.0 16.0 87.0 95.0 72.0 85.0 80.0 1.0 68.0 56.0\n",
"19 50.0 69.0 73.0 13.0 95.0 44.0 46.0 77.0 75.0 42.0 52.0 67.0\n",
"20 45.0 66.0 3.0 93.0 67.0 67.0 17.0 47.0 34.0 46.0 42.0 17.0\n",
"21 40.0 73.0 77.0 28.0 57.0 78.0 27.0 65.0 50.0 99.0 56.0 0.0\n",
"22 76.0 29.0 50.0 32.0 8.0 64.0 63.0 67.0 73.0 21.0 77.0 32.0\n",
"23 7.0 9.0 15.0 41.0 69.0 51.0 41.0 96.0 0.0 1.0 81.0 80.0\n",
"24 12.0 72.0 17.0 39.0 64.0 60.0 99.0 14.0 10.0 23.0 2.0 88.0\n",
"25 55.0 97.0 25.0 70.0 42.0 64.0 65.0 25.0 62.0 89.0 3.0 93.0\n",
"26 40.0 22.0 72.0 88.0 32.0 68.0 81.0 59.0 86.0 30.0 57.0 76.0\n",
"27 40.0 71.0 45.0 14.0 65.0 82.0 7.0 1.0 11.0 49.0 16.0 62.0\n",
"28 32.0 98.0 75.0 44.0 61.0 13.0 95.0 44.0 74.0 5.0 47.0 17.0\n",
"29 75.0 79.0 5.0 19.0 72.0 5.0 34.0 13.0 1.0 6.0 7.0 96.0\n",
"30 51.0 NaN 67.0 74.0 54.0 58.0 42.0 75.0 58.0 13.0 84.0 17.0\n",
"31 75.0 NaN 50.0 NaN 77.0 NaN 1.0 14.0 NaN 25.0 NaN 31.0"
]
},
"metadata": {
"tags": []
},
"execution_count": 8
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "NPpymS8fHgwd",
"colab_type": "text"
},
"source": [
"## Argument: `lang=`\n",
"\n",
"Memberi nama bulan pada kolom. Ada dua pilihan yaitu kode bahasa indonesia `id` dan bahasa inggris `en`."
]
},
{
"cell_type": "code",
"metadata": {
"id": "_WQ2sW7dHo_K",
"colab_type": "code",
"outputId": "59a11246-aaec-4c79-d3f4-2b6a2ded8e26",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 1000
}
},
"source": [
"# Menampilkan data stasiun c dengan nama bulan \n",
"table.pivot(dataset, column='sta_c', lang='en')"
],
"execution_count": 0,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" month | \n",
" Jan | \n",
" Feb | \n",
" Mar | \n",
" Apr | \n",
" May | \n",
" Jun | \n",
" Jul | \n",
" Aug | \n",
" Sep | \n",
" Oct | \n",
" Nov | \n",
" Dec | \n",
"
\n",
" \n",
" day | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" 1 | \n",
" 19.0 | \n",
" 8.0 | \n",
" 8.0 | \n",
" 75.0 | \n",
" 56.0 | \n",
" 34.0 | \n",
" 66.0 | \n",
" 18.0 | \n",
" 41.0 | \n",
" 41.0 | \n",
" 83.0 | \n",
" 10.0 | \n",
"
\n",
" \n",
" 2 | \n",
" 65.0 | \n",
" 36.0 | \n",
" 42.0 | \n",
" 96.0 | \n",
" 28.0 | \n",
" 40.0 | \n",
" 54.0 | \n",
" 53.0 | \n",
" 75.0 | \n",
" 31.0 | \n",
" 46.0 | \n",
" 59.0 | \n",
"
\n",
" \n",
" 3 | \n",
" 25.0 | \n",
" 10.0 | \n",
" 57.0 | \n",
" 67.0 | \n",
" 22.0 | \n",
" 41.0 | \n",
" 76.0 | \n",
" 59.0 | \n",
" 89.0 | \n",
" 44.0 | \n",
" 16.0 | \n",
" 75.0 | \n",
"
\n",
" \n",
" 4 | \n",
" 31.0 | \n",
" 54.0 | \n",
" 81.0 | \n",
" 0.0 | \n",
" 42.0 | \n",
" 69.0 | \n",
" 5.0 | \n",
" 27.0 | \n",
" 21.0 | \n",
" 4.0 | \n",
" 61.0 | \n",
" 17.0 | \n",
"
\n",
" \n",
" 5 | \n",
" 80.0 | \n",
" 60.0 | \n",
" 51.0 | \n",
" 96.0 | \n",
" 84.0 | \n",
" 77.0 | \n",
" 74.0 | \n",
" 35.0 | \n",
" 43.0 | \n",
" 46.0 | \n",
" 26.0 | \n",
" 55.0 | \n",
"
\n",
" \n",
" 6 | \n",
" 96.0 | \n",
" 21.0 | \n",
" 57.0 | \n",
" 97.0 | \n",
" 23.0 | \n",
" 98.0 | \n",
" 29.0 | \n",
" 23.0 | \n",
" 77.0 | \n",
" 52.0 | \n",
" 15.0 | \n",
" 42.0 | \n",
"
\n",
" \n",
" 7 | \n",
" 26.0 | \n",
" 57.0 | \n",
" 49.0 | \n",
" 46.0 | \n",
" 65.0 | \n",
" 35.0 | \n",
" 31.0 | \n",
" 43.0 | \n",
" 22.0 | \n",
" 18.0 | \n",
" 16.0 | \n",
" 4.0 | \n",
"
\n",
" \n",
" 8 | \n",
" 65.0 | \n",
" 93.0 | \n",
" 98.0 | \n",
" 11.0 | \n",
" 74.0 | \n",
" 89.0 | \n",
" 71.0 | \n",
" 68.0 | \n",
" 76.0 | \n",
" 32.0 | \n",
" 13.0 | \n",
" 20.0 | \n",
"
\n",
" \n",
" 9 | \n",
" 22.0 | \n",
" 96.0 | \n",
" 22.0 | \n",
" 15.0 | \n",
" 95.0 | \n",
" 83.0 | \n",
" 16.0 | \n",
" 83.0 | \n",
" 54.0 | \n",
" 61.0 | \n",
" 68.0 | \n",
" 65.0 | \n",
"
\n",
" \n",
" 10 | \n",
" 88.0 | \n",
" 68.0 | \n",
" 60.0 | \n",
" 75.0 | \n",
" 45.0 | \n",
" 31.0 | \n",
" 17.0 | \n",
" 1.0 | \n",
" 68.0 | \n",
" 86.0 | \n",
" 26.0 | \n",
" 48.0 | \n",
"
\n",
" \n",
" 11 | \n",
" 55.0 | \n",
" 52.0 | \n",
" 87.0 | \n",
" 65.0 | \n",
" 67.0 | \n",
" 90.0 | \n",
" 20.0 | \n",
" 93.0 | \n",
" 72.0 | \n",
" 54.0 | \n",
" 36.0 | \n",
" 84.0 | \n",
"
\n",
" \n",
" 12 | \n",
" 80.0 | \n",
" 44.0 | \n",
" 77.0 | \n",
" 98.0 | \n",
" 82.0 | \n",
" 36.0 | \n",
" 59.0 | \n",
" 66.0 | \n",
" 72.0 | \n",
" 55.0 | \n",
" 23.0 | \n",
" 38.0 | \n",
"
\n",
" \n",
" 13 | \n",
" 68.0 | \n",
" 36.0 | \n",
" 67.0 | \n",
" 61.0 | \n",
" 89.0 | \n",
" 22.0 | \n",
" 39.0 | \n",
" 42.0 | \n",
" 10.0 | \n",
" 86.0 | \n",
" 11.0 | \n",
" 39.0 | \n",
"
\n",
" \n",
" 14 | \n",
" 90.0 | \n",
" 79.0 | \n",
" 30.0 | \n",
" 86.0 | \n",
" 29.0 | \n",
" 61.0 | \n",
" 43.0 | \n",
" 58.0 | \n",
" 63.0 | \n",
" 0.0 | \n",
" 72.0 | \n",
" 97.0 | \n",
"
\n",
" \n",
" 15 | \n",
" 73.0 | \n",
" 10.0 | \n",
" 1.0 | \n",
" 79.0 | \n",
" 86.0 | \n",
" 92.0 | \n",
" 25.0 | \n",
" 35.0 | \n",
" 97.0 | \n",
" 47.0 | \n",
" 26.0 | \n",
" 40.0 | \n",
"
\n",
" \n",
" 16 | \n",
" 12.0 | \n",
" 47.0 | \n",
" 0.0 | \n",
" 92.0 | \n",
" 94.0 | \n",
" 3.0 | \n",
" 89.0 | \n",
" 81.0 | \n",
" 58.0 | \n",
" 67.0 | \n",
" 65.0 | \n",
" 57.0 | \n",
"
\n",
" \n",
" 17 | \n",
" 72.0 | \n",
" 63.0 | \n",
" 31.0 | \n",
" 85.0 | \n",
" 65.0 | \n",
" 43.0 | \n",
" 86.0 | \n",
" 72.0 | \n",
" 38.0 | \n",
" 44.0 | \n",
" 73.0 | \n",
" 30.0 | \n",
"
\n",
" \n",
" 18 | \n",
" 37.0 | \n",
" 13.0 | \n",
" 40.0 | \n",
" 67.0 | \n",
" 29.0 | \n",
" 67.0 | \n",
" 2.0 | \n",
" 24.0 | \n",
" 50.0 | \n",
" 53.0 | \n",
" 84.0 | \n",
" 9.0 | \n",
"
\n",
" \n",
" 19 | \n",
" 45.0 | \n",
" 20.0 | \n",
" 52.0 | \n",
" 31.0 | \n",
" 89.0 | \n",
" 41.0 | \n",
" 29.0 | \n",
" 28.0 | \n",
" 47.0 | \n",
" 16.0 | \n",
" 49.0 | \n",
" 82.0 | \n",
"
\n",
" \n",
" 20 | \n",
" 92.0 | \n",
" 2.0 | \n",
" 51.0 | \n",
" 33.0 | \n",
" 63.0 | \n",
" 20.0 | \n",
" 89.0 | \n",
" 36.0 | \n",
" 75.0 | \n",
" 29.0 | \n",
" 50.0 | \n",
" 41.0 | \n",
"
\n",
" \n",
" 21 | \n",
" 4.0 | \n",
" 49.0 | \n",
" 26.0 | \n",
" 98.0 | \n",
" 41.0 | \n",
" 65.0 | \n",
" 77.0 | \n",
" 19.0 | \n",
" 15.0 | \n",
" 49.0 | \n",
" 22.0 | \n",
" 52.0 | \n",
"
\n",
" \n",
" 22 | \n",
" 12.0 | \n",
" 49.0 | \n",
" 33.0 | \n",
" 60.0 | \n",
" 8.0 | \n",
" 59.0 | \n",
" 17.0 | \n",
" 36.0 | \n",
" 41.0 | \n",
" 19.0 | \n",
" 93.0 | \n",
" 81.0 | \n",
"
\n",
" \n",
" 23 | \n",
" 45.0 | \n",
" 35.0 | \n",
" 38.0 | \n",
" 54.0 | \n",
" 19.0 | \n",
" 37.0 | \n",
" 1.0 | \n",
" 33.0 | \n",
" 39.0 | \n",
" 74.0 | \n",
" 41.0 | \n",
" 0.0 | \n",
"
\n",
" \n",
" 24 | \n",
" 92.0 | \n",
" 70.0 | \n",
" 55.0 | \n",
" 53.0 | \n",
" 46.0 | \n",
" 90.0 | \n",
" 50.0 | \n",
" 15.0 | \n",
" 56.0 | \n",
" 95.0 | \n",
" 47.0 | \n",
" 66.0 | \n",
"
\n",
" \n",
" 25 | \n",
" 27.0 | \n",
" 35.0 | \n",
" 14.0 | \n",
" 88.0 | \n",
" 62.0 | \n",
" 33.0 | \n",
" 74.0 | \n",
" 2.0 | \n",
" 44.0 | \n",
" 54.0 | \n",
" 87.0 | \n",
" 4.0 | \n",
"
\n",
" \n",
" 26 | \n",
" 45.0 | \n",
" 21.0 | \n",
" 10.0 | \n",
" 50.0 | \n",
" 22.0 | \n",
" 96.0 | \n",
" 55.0 | \n",
" 94.0 | \n",
" 44.0 | \n",
" 49.0 | \n",
" 64.0 | \n",
" 48.0 | \n",
"
\n",
" \n",
" 27 | \n",
" 13.0 | \n",
" 42.0 | \n",
" 62.0 | \n",
" 77.0 | \n",
" 52.0 | \n",
" 43.0 | \n",
" 97.0 | \n",
" 85.0 | \n",
" 88.0 | \n",
" 80.0 | \n",
" 25.0 | \n",
" 70.0 | \n",
"
\n",
" \n",
" 28 | \n",
" 84.0 | \n",
" 34.0 | \n",
" 19.0 | \n",
" 72.0 | \n",
" 35.0 | \n",
" 77.0 | \n",
" 88.0 | \n",
" 89.0 | \n",
" 16.0 | \n",
" 46.0 | \n",
" 82.0 | \n",
" 56.0 | \n",
"
\n",
" \n",
" 29 | \n",
" 8.0 | \n",
" 96.0 | \n",
" 73.0 | \n",
" 25.0 | \n",
" 27.0 | \n",
" 41.0 | \n",
" 83.0 | \n",
" 32.0 | \n",
" 51.0 | \n",
" 30.0 | \n",
" 1.0 | \n",
" 4.0 | \n",
"
\n",
" \n",
" 30 | \n",
" 45.0 | \n",
" NaN | \n",
" 97.0 | \n",
" 92.0 | \n",
" 39.0 | \n",
" 0.0 | \n",
" 69.0 | \n",
" 80.0 | \n",
" 18.0 | \n",
" 26.0 | \n",
" 44.0 | \n",
" 55.0 | \n",
"
\n",
" \n",
" 31 | \n",
" 76.0 | \n",
" NaN | \n",
" 7.0 | \n",
" NaN | \n",
" 69.0 | \n",
" NaN | \n",
" 65.0 | \n",
" 26.0 | \n",
" NaN | \n",
" 77.0 | \n",
" NaN | \n",
" 39.0 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
"month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec\n",
"day \n",
"1 19.0 8.0 8.0 75.0 56.0 34.0 66.0 18.0 41.0 41.0 83.0 10.0\n",
"2 65.0 36.0 42.0 96.0 28.0 40.0 54.0 53.0 75.0 31.0 46.0 59.0\n",
"3 25.0 10.0 57.0 67.0 22.0 41.0 76.0 59.0 89.0 44.0 16.0 75.0\n",
"4 31.0 54.0 81.0 0.0 42.0 69.0 5.0 27.0 21.0 4.0 61.0 17.0\n",
"5 80.0 60.0 51.0 96.0 84.0 77.0 74.0 35.0 43.0 46.0 26.0 55.0\n",
"6 96.0 21.0 57.0 97.0 23.0 98.0 29.0 23.0 77.0 52.0 15.0 42.0\n",
"7 26.0 57.0 49.0 46.0 65.0 35.0 31.0 43.0 22.0 18.0 16.0 4.0\n",
"8 65.0 93.0 98.0 11.0 74.0 89.0 71.0 68.0 76.0 32.0 13.0 20.0\n",
"9 22.0 96.0 22.0 15.0 95.0 83.0 16.0 83.0 54.0 61.0 68.0 65.0\n",
"10 88.0 68.0 60.0 75.0 45.0 31.0 17.0 1.0 68.0 86.0 26.0 48.0\n",
"11 55.0 52.0 87.0 65.0 67.0 90.0 20.0 93.0 72.0 54.0 36.0 84.0\n",
"12 80.0 44.0 77.0 98.0 82.0 36.0 59.0 66.0 72.0 55.0 23.0 38.0\n",
"13 68.0 36.0 67.0 61.0 89.0 22.0 39.0 42.0 10.0 86.0 11.0 39.0\n",
"14 90.0 79.0 30.0 86.0 29.0 61.0 43.0 58.0 63.0 0.0 72.0 97.0\n",
"15 73.0 10.0 1.0 79.0 86.0 92.0 25.0 35.0 97.0 47.0 26.0 40.0\n",
"16 12.0 47.0 0.0 92.0 94.0 3.0 89.0 81.0 58.0 67.0 65.0 57.0\n",
"17 72.0 63.0 31.0 85.0 65.0 43.0 86.0 72.0 38.0 44.0 73.0 30.0\n",
"18 37.0 13.0 40.0 67.0 29.0 67.0 2.0 24.0 50.0 53.0 84.0 9.0\n",
"19 45.0 20.0 52.0 31.0 89.0 41.0 29.0 28.0 47.0 16.0 49.0 82.0\n",
"20 92.0 2.0 51.0 33.0 63.0 20.0 89.0 36.0 75.0 29.0 50.0 41.0\n",
"21 4.0 49.0 26.0 98.0 41.0 65.0 77.0 19.0 15.0 49.0 22.0 52.0\n",
"22 12.0 49.0 33.0 60.0 8.0 59.0 17.0 36.0 41.0 19.0 93.0 81.0\n",
"23 45.0 35.0 38.0 54.0 19.0 37.0 1.0 33.0 39.0 74.0 41.0 0.0\n",
"24 92.0 70.0 55.0 53.0 46.0 90.0 50.0 15.0 56.0 95.0 47.0 66.0\n",
"25 27.0 35.0 14.0 88.0 62.0 33.0 74.0 2.0 44.0 54.0 87.0 4.0\n",
"26 45.0 21.0 10.0 50.0 22.0 96.0 55.0 94.0 44.0 49.0 64.0 48.0\n",
"27 13.0 42.0 62.0 77.0 52.0 43.0 97.0 85.0 88.0 80.0 25.0 70.0\n",
"28 84.0 34.0 19.0 72.0 35.0 77.0 88.0 89.0 16.0 46.0 82.0 56.0\n",
"29 8.0 96.0 73.0 25.0 27.0 41.0 83.0 32.0 51.0 30.0 1.0 4.0\n",
"30 45.0 NaN 97.0 92.0 39.0 0.0 69.0 80.0 18.0 26.0 44.0 55.0\n",
"31 76.0 NaN 7.0 NaN 69.0 NaN 65.0 26.0 NaN 77.0 NaN 39.0"
]
},
"metadata": {
"tags": []
},
"execution_count": 9
}
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "yHQFwa_nCE9p",
"colab_type": "text"
},
"source": [
"# Changelog\n",
"\n",
"```\n",
"- 20190713 - 1.0.1 - Update information\n",
"- 20190712 - 1.0.0 - Initial\n",
"```"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "gSU3NrNrCKoi",
"colab_type": "text"
},
"source": [
"#### Copyright © 2019 [Taruma Sakti Megariansyah](https://taruma.github.io)\n",
"\n",
"Source code in this notebook is licensed under a [MIT License](https://opensource.org/licenses/MIT). Data in this notebook is licensed under a [Creative Common Attribution 4.0 International](https://choosealicense.com/licenses/cc-by-4.0/). "
]
}
]
}