{ "cells": [ { "attachments": {}, "cell_type": "markdown", "metadata": {}, "source": [ "# Read EPANET result files generated by MIKE+\n", "\n", "In this notebook we give examples how to read EPANET result files **res** generated by MIKE+. Most of the functionality is the same as reading res1d files, which is described in [res1d.ipynb](res1d.ipynb)." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "from mikeio1d import Res1D\n", "from mikeio1d.query import QueryDataNode, QueryDataReach" ] }, { "attachments": {}, "cell_type": "markdown", "metadata": {}, "source": [ "## EPANET res file" ] }, { "attachments": {}, "cell_type": "markdown", "metadata": {}, "source": [ "Read entire res file into a data frame. Here we use results from a standard **Net1.inp** (EPANET Example Network 1) distributed together with EPANET 2.2 and imported into MIKE+." ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "file_path = \"../tests/testdata/epanet.res\"\n", "res = Res1D(file_path)\n", "df = res.read()" ] }, { "attachments": {}, "cell_type": "markdown", "metadata": {}, "source": [ "Let's peek at the full data frame coming from EPANET result." ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | Demand:10 | \n", "Head:10 | \n", "Pressure:10 | \n", "WaterQuality:10 | \n", "Demand:11 | \n", "Head:11 | \n", "Pressure:11 | \n", "WaterQuality:11 | \n", "Demand:12 | \n", "Head:12 | \n", "... | \n", "ReactorRate:31 | \n", "FrictionFactor:31 | \n", "Flow:9 | \n", "Velocity:9 | \n", "HeadlossPer1000Unit:9 | \n", "AvgWaterQuality:9 | \n", "StatusCode:9 | \n", "Setting:9 | \n", "ReactorRate:9 | \n", "FrictionFactor:9 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-10-13 00:00:00 | \n", "0.0 | \n", "306.125000 | \n", "89.716995 | \n", "0.5 | \n", "9.463531 | \n", "300.298187 | \n", "83.890175 | \n", "0.5 | \n", "9.463531 | \n", "295.677277 | \n", "... | \n", "0.0 | \n", "0.048410 | \n", "117.737534 | \n", "0.0 | \n", "-62.285000 | \n", "0.0 | \n", "3.0 | \n", "1.0 | \n", "0.0 | \n", "0.0 | \n", "
| 2022-10-13 01:00:00 | \n", "0.0 | \n", "306.862823 | \n", "90.454834 | \n", "0.5 | \n", "9.463531 | \n", "301.137360 | \n", "84.729355 | \n", "0.5 | \n", "9.463531 | \n", "296.611542 | \n", "... | \n", "0.0 | \n", "0.048470 | \n", "116.627487 | \n", "0.0 | \n", "-63.022831 | \n", "0.0 | \n", "3.0 | \n", "1.0 | \n", "0.0 | \n", "0.0 | \n", "
| 2022-10-13 02:00:00 | \n", "0.0 | \n", "307.325562 | \n", "90.917557 | \n", "0.5 | \n", "11.356236 | \n", "301.663696 | \n", "85.255707 | \n", "0.5 | \n", "11.356236 | \n", "297.515137 | \n", "... | \n", "0.0 | \n", "0.048168 | \n", "115.925919 | \n", "0.0 | \n", "-63.485558 | \n", "0.0 | \n", "3.0 | \n", "1.0 | \n", "0.0 | \n", "0.0 | \n", "
| 2022-10-13 03:00:00 | \n", "0.0 | \n", "307.824982 | \n", "91.416985 | \n", "0.5 | \n", "11.356236 | \n", "302.231873 | \n", "85.823860 | \n", "0.5 | \n", "11.356236 | \n", "298.146301 | \n", "... | \n", "0.0 | \n", "0.048195 | \n", "115.163910 | \n", "0.0 | \n", "-63.984989 | \n", "0.0 | \n", "3.0 | \n", "1.0 | \n", "0.0 | \n", "0.0 | \n", "
| 2022-10-13 04:00:00 | \n", "0.0 | \n", "308.052460 | \n", "91.644470 | \n", "0.5 | \n", "13.248942 | \n", "302.490662 | \n", "86.082672 | \n", "0.5 | \n", "13.248942 | \n", "298.756622 | \n", "... | \n", "0.0 | \n", "0.047632 | \n", "114.815155 | \n", "0.0 | \n", "-64.212471 | \n", "0.0 | \n", "3.0 | \n", "1.0 | \n", "0.0 | \n", "0.0 | \n", "
5 rows × 148 columns
\n", "| \n", " | Flow:10 | \n", "Pressure:10 | \n", "Pressure:11 | \n", "
|---|---|---|---|
| 2022-10-13 00:00:00 | \n", "117.737534 | \n", "89.716995 | \n", "83.890175 | \n", "
| 2022-10-13 01:00:00 | \n", "116.627487 | \n", "90.454834 | \n", "84.729355 | \n", "
| 2022-10-13 02:00:00 | \n", "115.925919 | \n", "90.917557 | \n", "85.255707 | \n", "
| 2022-10-13 03:00:00 | \n", "115.163910 | \n", "91.416985 | \n", "85.823860 | \n", "
| 2022-10-13 04:00:00 | \n", "114.815155 | \n", "91.644470 | \n", "86.082672 | \n", "
| 2022-10-13 05:00:00 | \n", "114.398529 | \n", "91.915298 | \n", "86.390823 | \n", "
| 2022-10-13 06:00:00 | \n", "114.390770 | \n", "91.920341 | \n", "86.396553 | \n", "
| 2022-10-13 07:00:00 | \n", "114.311264 | \n", "91.971931 | \n", "86.455261 | \n", "
| 2022-10-13 08:00:00 | \n", "113.833015 | \n", "92.281364 | \n", "86.807350 | \n", "
| 2022-10-13 09:00:00 | \n", "113.436226 | \n", "92.537125 | \n", "87.098404 | \n", "
| 2022-10-13 10:00:00 | \n", "112.646294 | \n", "93.043625 | \n", "87.674835 | \n", "
| 2022-10-13 11:00:00 | \n", "111.941292 | \n", "93.492691 | \n", "88.185966 | \n", "
| 2022-10-13 12:00:00 | \n", "110.851845 | \n", "94.181076 | \n", "88.969604 | \n", "
| 2022-10-13 13:00:00 | \n", "-0.000053 | \n", "84.220718 | \n", "84.220718 | \n", "
| 2022-10-13 14:00:00 | \n", "-0.000052 | \n", "83.050537 | \n", "83.050537 | \n", "
| 2022-10-13 15:00:00 | \n", "-0.000051 | \n", "81.976448 | \n", "81.976448 | \n", "
| 2022-10-13 16:00:00 | \n", "-0.000050 | \n", "81.041527 | \n", "81.041527 | \n", "
| 2022-10-13 17:00:00 | \n", "-0.000049 | \n", "80.235962 | \n", "80.235962 | \n", "
| 2022-10-13 18:00:00 | \n", "-0.000048 | \n", "79.534828 | \n", "79.534828 | \n", "
| 2022-10-13 19:00:00 | \n", "-0.000048 | \n", "78.997780 | \n", "78.997780 | \n", "
| 2022-10-13 20:00:00 | \n", "-0.000047 | \n", "78.356293 | \n", "78.356293 | \n", "
| 2022-10-13 21:00:00 | \n", "-0.000046 | \n", "77.550705 | \n", "77.550705 | \n", "
| 2022-10-13 22:00:00 | \n", "-0.000046 | \n", "76.605965 | \n", "76.605965 | \n", "
| 2022-10-13 23:00:00 | \n", "120.466057 | \n", "87.873650 | \n", "81.794281 | \n", "
| 2022-10-14 00:00:00 | \n", "119.382088 | \n", "88.611023 | \n", "82.632576 | \n", "