{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "name": "taruma-hidrokit-prep-excel", "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.prep.excel`\n", "\n", "- **Kategori**: _data preparation_\n", "- __Tujuan__: Memperoleh dataframe dari _excel file_.\n", "- __Dokumentasi__: [readthedocs](https://github.com/taruma/hidrokit-nb/blob/master/notebook/taruma_hidrokit_prep_timeseries.ipynb)\n", "\n", "## Informasi notebook\n", "\n", "- __notebook name__: `taruma_hidrokit_prep_excel`\n", "- __notebook version/date__: `1.0.2`/`20190713`\n", "- __notebook server__: Google Colab\n", "- __hidrokit version__: `0.2.0`\n", "- **python version**: `3.7`\n", "\n", "\n", "## CATATAN\n", "\n", "Modul `.prep.excel` masih dalam tahap pengembangan sehingga fungsi yang akan ditampilkan pada tutorial ini adalah _private function_ yang ditandai dengan diawali `_` pada setiap fungsinya. Fungsi tersebut seharusnya tidak digunakan oleh _users_ dan hanya bertugas sebagai fungsi di balik layar. Notebook ini hanya melengkapi tutorial hidrokit. \n", "\n", "**Disarankan tidak menggunakan _private function_, karena _private function_ akan mengalami perubahan signifikan selama pengembangan.**" ] }, { "cell_type": "markdown", "metadata": { "id": "BPm5qNh_DQjj", "colab_type": "text" }, "source": [ "## Instalasi hidrokit" ] }, { "cell_type": "code", "metadata": { "id": "aeLepUrl_nxm", "colab_type": "code", "outputId": "ae81bd4d-3d0a-45f5-9d96-654e073c32d5", "colab": { "base_uri": "https://localhost:8080/", "height": 289 } }, "source": [ "### Instalasi melalui PyPI\n", "!pip install hidrokit[excel] # Digunakan [excel] karena membutuhkan paket xlrd\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": [ "Requirement already satisfied: hidrokit[excel] in /usr/local/lib/python3.6/dist-packages (0.2.0)\n", "Requirement already satisfied: matplotlib in /usr/local/lib/python3.6/dist-packages (from hidrokit[excel]) (3.0.3)\n", "Requirement already satisfied: pandas in /usr/local/lib/python3.6/dist-packages (from hidrokit[excel]) (0.24.2)\n", "Requirement already satisfied: numpy in /usr/local/lib/python3.6/dist-packages (from hidrokit[excel]) (1.16.4)\n", "Requirement already satisfied: openpyxl; extra == \"excel\" in /usr/local/lib/python3.6/dist-packages (from hidrokit[excel]) (2.5.9)\n", "Requirement already satisfied: xlwt; extra == \"excel\" in /usr/local/lib/python3.6/dist-packages (from hidrokit[excel]) (1.3.0)\n", "Requirement already satisfied: xlrd; extra == \"excel\" in /usr/local/lib/python3.6/dist-packages (from hidrokit[excel]) (1.1.0)\n", "Requirement already satisfied: cycler>=0.10 in /usr/local/lib/python3.6/dist-packages (from matplotlib->hidrokit[excel]) (0.10.0)\n", "Requirement already satisfied: kiwisolver>=1.0.1 in /usr/local/lib/python3.6/dist-packages (from matplotlib->hidrokit[excel]) (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[excel]) (2.4.0)\n", "Requirement already satisfied: python-dateutil>=2.1 in /usr/local/lib/python3.6/dist-packages (from matplotlib->hidrokit[excel]) (2.5.3)\n", "Requirement already satisfied: pytz>=2011k in /usr/local/lib/python3.6/dist-packages (from pandas->hidrokit[excel]) (2018.9)\n", "Requirement already satisfied: jdcal in /usr/local/lib/python3.6/dist-packages (from openpyxl; extra == \"excel\"->hidrokit[excel]) (1.4.1)\n", "Requirement already satisfied: et-xmlfile in /usr/local/lib/python3.6/dist-packages (from openpyxl; extra == \"excel\"->hidrokit[excel]) (1.0.1)\n", "Requirement already satisfied: six in /usr/local/lib/python3.6/dist-packages (from cycler>=0.10->matplotlib->hidrokit[excel]) (1.12.0)\n", "Requirement already satisfied: setuptools in /usr/local/lib/python3.6/dist-packages (from kiwisolver>=1.0.1->matplotlib->hidrokit[excel]) (41.0.1)\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\n" ], "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": "6345ad62-30d9-4975-e3e4-75c0891b8346", "colab": { "base_uri": "https://localhost:8080/", "height": 357 } }, "source": [ "# Ambil dataset dari data test hidrokit\n", "!wget -O '2006 data hujan stasiun A.xls' \"https://github.com/taruma/hidrokit/blob/master/tests/data/excel/2006%20HUJAN%20DISNEY%20LAND.xls?raw=true\"" ], "execution_count": 0, "outputs": [ { "output_type": "stream", "text": [ "--2019-07-13 02:17:07-- https://github.com/taruma/hidrokit/blob/master/tests/data/excel/2006%20HUJAN%20DISNEY%20LAND.xls?raw=true\n", "Resolving github.com (github.com)... 140.82.114.3\n", "Connecting to github.com (github.com)|140.82.114.3|:443... connected.\n", "HTTP request sent, awaiting response... 302 Found\n", "Location: https://github.com/taruma/hidrokit/raw/master/tests/data/excel/2006%20HUJAN%20DISNEY%20LAND.xls [following]\n", "--2019-07-13 02:17:08-- https://github.com/taruma/hidrokit/raw/master/tests/data/excel/2006%20HUJAN%20DISNEY%20LAND.xls\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/excel/2006%20HUJAN%20DISNEY%20LAND.xls [following]\n", "--2019-07-13 02:17:08-- https://raw.githubusercontent.com/taruma/hidrokit/master/tests/data/excel/2006%20HUJAN%20DISNEY%20LAND.xls\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: 36864 (36K) [application/octet-stream]\n", "Saving to: ‘2006 data hujan stasiun A.xls’\n", "\n", "\r 2006 data 0%[ ] 0 --.-KB/s \r2006 data hujan sta 100%[===================>] 36.00K --.-KB/s in 0.01s \n", "\n", "2019-07-13 02:17:08 (2.72 MB/s) - ‘2006 data hujan stasiun A.xls’ saved [36864/36864]\n", "\n" ], "name": "stdout" } ] }, { "cell_type": "code", "metadata": { "id": "kpXizaAl73Eq", "colab_type": "code", "outputId": "d7de6e80-c7fc-4556-b621-2e1643eb8013", "colab": { "base_uri": "https://localhost:8080/", "height": 1000 } }, "source": [ "# Menampilkan file excel dalam bentuk dataframe\n", "filepath = '2006 data hujan stasiun A.xls'\n", "year = 2006\n", "pd.read_excel(filepath)" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Unnamed: 0Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13
0NaNDATA CURAH HUJAN BIASA DALAM MILIMETERNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2NaNNO. POS HUJANNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
3NaNNAMA POS HUJANNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
4NaNNO. KADASTERNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
5NaNDAERAH ALIRAN SUNGAINaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
6NaNLOKASI GEOGRAFINaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
7NaNKECAMATANNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
8NaNDESANaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
9NaNTINGGI DARI PERMUKAAN LAUT (m)NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
10NaNSATUAN WILAYAH SUNGAINaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
11NaNSUNGAINaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
12NaNDIBANGUN OLEHNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
13NaNTAHUN PENDIRIANNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
14NaNTAHUN DATANaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
15NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
16NaNTgl.BulanNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
17NaNNaNJanFebMarAprMeiJuniJuliAgtSeptOktNovDes
18NaN1-28.328.38.4-------159
19NaN29.816.2---29-0.7--63.452.5
20NaN3-9.316.513.9-----0.3-11.6
21NaN466.3-11.3--13.2-----12.3
22NaN52.7--------0.6--
23NaN6-11.8--------27.50.6
24NaN7-15.2---------4.3
25NaN831.4-32.8--12.8-----0.8
26NaN9------88.5---38.6-
27NaN10--17.20.792.6----11.6--
28NaN110.9--13.3-------46
29NaN12-48.2----------
30NaN1316.327.8-36.7--43.5----0.6
31NaN1428.231.6-20.2-----23.2-18.3
32NaN1536.3-36.215.3----0.7---
33NaN16-11.318.7--------15.2
34NaN170.7---13.2----16.5--
35NaN18------37.813.2----
36NaN19--21.8---------
37NaN20---0.6-------0.8
38NaN2135.321.7---31.5------
39NaN22-17.37.392--16.4---13.8-
40NaN2318.9-14.613.5-62.5--0.9-26.714.5
41NaN2440.3---------15.3-
42NaN25-28.331.3-33.8-11.811.3-42.9-105.5
43NaN26-15.520.711.651.5-----11.6-
44NaN27---------21.4-0.6
45NaN28-0.7---0.8----14.879
46NaN29--11.817.3--24.8-9.245.927.3-
47NaN300.6-15.3-------6.50.3
48NaN31------57.3----44
49NaNJumlah287.7283.2283.8243.5191.1149.8280.125.210.8162.4245.5565.9
50NaNRerata22.130820.228620.271420.291747.77524.966740.01438.43.620.324.5531.4389
51NaNMax66.348.236.29292.662.588.513.29.245.963.4159
52NaNMin0.60.77.30.613.20.811.80.70.70.36.50.3
53NaNKeterangan : 0.0 = Tidak ada hujanNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "
" ], "text/plain": [ " Unnamed: 0 Unnamed: 1 ... Unnamed: 12 Unnamed: 13\n", "0 NaN DATA CURAH HUJAN BIASA DALAM MILIMETER ... NaN NaN\n", "1 NaN NaN ... NaN NaN\n", "2 NaN NO. POS HUJAN ... NaN NaN\n", "3 NaN NAMA POS HUJAN ... NaN NaN\n", "4 NaN NO. KADASTER ... NaN NaN\n", "5 NaN DAERAH ALIRAN SUNGAI ... NaN NaN\n", "6 NaN LOKASI GEOGRAFI ... NaN NaN\n", "7 NaN KECAMATAN ... NaN NaN\n", "8 NaN DESA ... NaN NaN\n", "9 NaN TINGGI DARI PERMUKAAN LAUT (m) ... NaN NaN\n", "10 NaN SATUAN WILAYAH SUNGAI ... NaN NaN\n", "11 NaN SUNGAI ... NaN NaN\n", "12 NaN DIBANGUN OLEH ... NaN NaN\n", "13 NaN TAHUN PENDIRIAN ... NaN NaN\n", "14 NaN TAHUN DATA ... NaN NaN\n", "15 NaN NaN ... NaN NaN\n", "16 NaN Tgl. ... NaN NaN\n", "17 NaN NaN ... Nov Des\n", "18 NaN 1 ... - 159\n", "19 NaN 2 ... 63.4 52.5\n", "20 NaN 3 ... - 11.6\n", "21 NaN 4 ... - 12.3\n", "22 NaN 5 ... - -\n", "23 NaN 6 ... 27.5 0.6\n", "24 NaN 7 ... - 4.3\n", "25 NaN 8 ... - 0.8\n", "26 NaN 9 ... 38.6 -\n", "27 NaN 10 ... - -\n", "28 NaN 11 ... - 46\n", "29 NaN 12 ... - -\n", "30 NaN 13 ... - 0.6\n", "31 NaN 14 ... - 18.3\n", "32 NaN 15 ... - -\n", "33 NaN 16 ... - 15.2\n", "34 NaN 17 ... - -\n", "35 NaN 18 ... - -\n", "36 NaN 19 ... - -\n", "37 NaN 20 ... - 0.8\n", "38 NaN 21 ... - -\n", "39 NaN 22 ... 13.8 -\n", "40 NaN 23 ... 26.7 14.5\n", "41 NaN 24 ... 15.3 -\n", "42 NaN 25 ... - 105.5\n", "43 NaN 26 ... 11.6 -\n", "44 NaN 27 ... - 0.6\n", "45 NaN 28 ... 14.8 79\n", "46 NaN 29 ... 27.3 -\n", "47 NaN 30 ... 6.5 0.3\n", "48 NaN 31 ... - 44\n", "49 NaN Jumlah ... 245.5 565.9\n", "50 NaN Rerata ... 24.55 31.4389\n", "51 NaN Max ... 63.4 159\n", "52 NaN Min ... 6.5 0.3\n", "53 NaN Keterangan : 0.0 = Tidak ada hujan ... NaN NaN\n", "\n", "[54 rows x 14 columns]" ] }, "metadata": { "tags": [] }, "execution_count": 17 } ] }, { "cell_type": "markdown", "metadata": { "id": "KysAN-JKFs_c", "colab_type": "text" }, "source": [ "# Fungsi _private_ `prep.excel()`\n", "\n", "- __Tujuan__: Memperoleh data dari _excel file_.\n", "- __Dokumentasi__: [readthedocs](https://hidrokit.readthedocs.io/en/stable/prep.html#module-prep.excel)" ] }, { "cell_type": "code", "metadata": { "id": "62fs0DjLHJP_", "colab_type": "code", "colab": {} }, "source": [ "from hidrokit.prep import excel" ], "execution_count": 0, "outputs": [] }, { "cell_type": "markdown", "metadata": { "id": "8lEqsohWGz4q", "colab_type": "text" }, "source": [ "## `_file_single_pivot()`\n", "\n", "Memperoleh tabel pivot dari _excel file_" ] }, { "cell_type": "code", "metadata": { "id": "XxQkbXJ0HAUC", "colab_type": "code", "outputId": "dee32d43-5bcd-4ea7-9fe2-18b874fc41a5", "colab": { "base_uri": "https://localhost:8080/", "height": 1000 } }, "source": [ "tabel_pivot = excel._file_single_pivot(filepath)\n", "tabel_pivot" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
2345678910111213
19-28.328.38.4-------159
209.816.2---29-0.7--63.452.5
21-9.316.513.9-----0.3-11.6
2266.3-11.3--13.2-----12.3
232.7--------0.6--
24-11.8--------27.50.6
25-15.2---------4.3
2631.4-32.8--12.8-----0.8
27------88.5---38.6-
28--17.20.792.6----11.6--
290.9--13.3-------46
30-48.2----------
3116.327.8-36.7--43.5----0.6
3228.231.6-20.2-----23.2-18.3
3336.3-36.215.3----0.7---
34-11.318.7--------15.2
350.7---13.2----16.5--
36------37.813.2----
37--21.8---------
38---0.6-------0.8
3935.321.7---31.5------
40-17.37.392--16.4---13.8-
4118.9-14.613.5-62.5--0.9-26.714.5
4240.3---------15.3-
43-28.331.3-33.8-11.811.3-42.9-105.5
44-15.520.711.651.5-----11.6-
45---------21.4-0.6
46-0.7---0.8----14.879
47--11.817.3--24.8-9.245.927.3-
480.6-15.3-------6.50.3
49------57.3----44
\n", "
" ], "text/plain": [ " 2 3 4 5 6 7 8 9 10 11 12 13\n", "19 - 28.3 28.3 8.4 - - - - - - - 159\n", "20 9.8 16.2 - - - 29 - 0.7 - - 63.4 52.5\n", "21 - 9.3 16.5 13.9 - - - - - 0.3 - 11.6\n", "22 66.3 - 11.3 - - 13.2 - - - - - 12.3\n", "23 2.7 - - - - - - - - 0.6 - -\n", "24 - 11.8 - - - - - - - - 27.5 0.6\n", "25 - 15.2 - - - - - - - - - 4.3\n", "26 31.4 - 32.8 - - 12.8 - - - - - 0.8\n", "27 - - - - - - 88.5 - - - 38.6 -\n", "28 - - 17.2 0.7 92.6 - - - - 11.6 - -\n", "29 0.9 - - 13.3 - - - - - - - 46\n", "30 - 48.2 - - - - - - - - - -\n", "31 16.3 27.8 - 36.7 - - 43.5 - - - - 0.6\n", "32 28.2 31.6 - 20.2 - - - - - 23.2 - 18.3\n", "33 36.3 - 36.2 15.3 - - - - 0.7 - - -\n", "34 - 11.3 18.7 - - - - - - - - 15.2\n", "35 0.7 - - - 13.2 - - - - 16.5 - -\n", "36 - - - - - - 37.8 13.2 - - - -\n", "37 - - 21.8 - - - - - - - - -\n", "38 - - - 0.6 - - - - - - - 0.8\n", "39 35.3 21.7 - - - 31.5 - - - - - -\n", "40 - 17.3 7.3 92 - - 16.4 - - - 13.8 -\n", "41 18.9 - 14.6 13.5 - 62.5 - - 0.9 - 26.7 14.5\n", "42 40.3 - - - - - - - - - 15.3 -\n", "43 - 28.3 31.3 - 33.8 - 11.8 11.3 - 42.9 - 105.5\n", "44 - 15.5 20.7 11.6 51.5 - - - - - 11.6 -\n", "45 - - - - - - - - - 21.4 - 0.6\n", "46 - 0.7 - - - 0.8 - - - - 14.8 79\n", "47 - - 11.8 17.3 - - 24.8 - 9.2 45.9 27.3 -\n", "48 0.6 - 15.3 - - - - - - - 6.5 0.3\n", "49 - - - - - - 57.3 - - - - 44" ] }, "metadata": { "tags": [] }, "execution_count": 19 } ] }, { "cell_type": "markdown", "metadata": { "id": "oxsxCiZlFTh2", "colab_type": "text" }, "source": [ "## `_dataframe_table()`\n", "\n", "Mengubah tabel pivot ke dataframe kolom tunggal." ] }, { "cell_type": "code", "metadata": { "id": "s7QYL3IGFb3S", "colab_type": "code", "outputId": "b1d7f72a-bd6a-4d5e-824f-a77dc3adffb1", "colab": { "base_uri": "https://localhost:8080/", "height": 1000 } }, "source": [ "tabel_tunggal = excel._dataframe_table(tabel_pivot, year, name='sta_a')\n", "tabel_tunggal" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
sta_a
2006-01-01-
2006-01-029.8
2006-01-03-
2006-01-0466.3
2006-01-052.7
2006-01-06-
2006-01-07-
2006-01-0831.4
2006-01-09-
2006-01-10-
2006-01-110.9
2006-01-12-
2006-01-1316.3
2006-01-1428.2
2006-01-1536.3
2006-01-16-
2006-01-170.7
2006-01-18-
2006-01-19-
2006-01-20-
2006-01-2135.3
2006-01-22-
2006-01-2318.9
2006-01-2440.3
2006-01-25-
2006-01-26-
2006-01-27-
2006-01-28-
2006-01-29-
2006-01-300.6
......
2006-12-0252.5
2006-12-0311.6
2006-12-0412.3
2006-12-05-
2006-12-060.6
2006-12-074.3
2006-12-080.8
2006-12-09-
2006-12-10-
2006-12-1146
2006-12-12-
2006-12-130.6
2006-12-1418.3
2006-12-15-
2006-12-1615.2
2006-12-17-
2006-12-18-
2006-12-19-
2006-12-200.8
2006-12-21-
2006-12-22-
2006-12-2314.5
2006-12-24-
2006-12-25105.5
2006-12-26-
2006-12-270.6
2006-12-2879
2006-12-29-
2006-12-300.3
2006-12-3144
\n", "

365 rows × 1 columns

\n", "
" ], "text/plain": [ " sta_a\n", "2006-01-01 -\n", "2006-01-02 9.8\n", "2006-01-03 -\n", "2006-01-04 66.3\n", "2006-01-05 2.7\n", "2006-01-06 -\n", "2006-01-07 -\n", "2006-01-08 31.4\n", "2006-01-09 -\n", "2006-01-10 -\n", "2006-01-11 0.9\n", "2006-01-12 -\n", "2006-01-13 16.3\n", "2006-01-14 28.2\n", "2006-01-15 36.3\n", "2006-01-16 -\n", "2006-01-17 0.7\n", "2006-01-18 -\n", "2006-01-19 -\n", "2006-01-20 -\n", "2006-01-21 35.3\n", "2006-01-22 -\n", "2006-01-23 18.9\n", "2006-01-24 40.3\n", "2006-01-25 -\n", "2006-01-26 -\n", "2006-01-27 -\n", "2006-01-28 -\n", "2006-01-29 -\n", "2006-01-30 0.6\n", "... ...\n", "2006-12-02 52.5\n", "2006-12-03 11.6\n", "2006-12-04 12.3\n", "2006-12-05 -\n", "2006-12-06 0.6\n", "2006-12-07 4.3\n", "2006-12-08 0.8\n", "2006-12-09 -\n", "2006-12-10 -\n", "2006-12-11 46\n", "2006-12-12 -\n", "2006-12-13 0.6\n", "2006-12-14 18.3\n", "2006-12-15 -\n", "2006-12-16 15.2\n", "2006-12-17 -\n", "2006-12-18 -\n", "2006-12-19 -\n", "2006-12-20 0.8\n", "2006-12-21 -\n", "2006-12-22 -\n", "2006-12-23 14.5\n", "2006-12-24 -\n", "2006-12-25 105.5\n", "2006-12-26 -\n", "2006-12-27 0.6\n", "2006-12-28 79\n", "2006-12-29 -\n", "2006-12-30 0.3\n", "2006-12-31 44\n", "\n", "[365 rows x 1 columns]" ] }, "metadata": { "tags": [] }, "execution_count": 20 } ] }, { "cell_type": "markdown", "metadata": { "id": "yHQFwa_nCE9p", "colab_type": "text" }, "source": [ "# Changelog\n", "\n", "```\n", "- 20190713 - 1.0.2 - Informasi notebook\n", "- 20190713 - 1.0.1 - Fix typo\n", "- 20190713 - 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/). " ] } ] }