{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "incorporate-check", "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "from sklearn.metrics import mean_squared_error, r2_score, mean_absolute_error, median_absolute_error, mean_absolute_percentage_error\n", "from math import sqrt" ] }, { "cell_type": "code", "execution_count": 2, "id": "deluxe-consolidation", "metadata": {}, "outputs": [], "source": [ "MNLraw = pd.read_csv('MNL_withPredictions.csv', sep=';')\n", "WMLraw = pd.read_csv('WML_withPredictions.csv', sep=';')\n", "\n", "mode =[0,1,2]\n", "\n", "correl = pd.DataFrame(columns = [\"Mode\", \"Year\", \"Case\", \"MNL\", \"WML\"])" ] }, { "cell_type": "code", "execution_count": 3, "id": "literary-pointer", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | NSTR1 | \n", "V2010 | \n", "V2011 | \n", "V2012 | \n", "V2013 | \n", "V2014 | \n", "V2015 | \n", "V2016 | \n", "V2017 | \n", "V2018 | \n", "... | \n", "VOL19 | \n", "IWT17 | \n", "IWT16 | \n", "IWT19 | \n", "ROAD17 | \n", "ROAD16 | \n", "ROAD19 | \n", "RAIL17 | \n", "RAIL16 | \n", "RAIL19 | \n", "
---|
0 rows × 170 columns
\n", "\n", " | NSTR1 | \n", "V2021 | \n", "ORIGIN | \n", "DESTINATION | \n", "C_IWT_INTER_TRANS | \n", "C_IWT_INTER_HAND | \n", "C_IWT_INTER_TIME | \n", "C_IWT_INTER_REL | \n", "C_IWT_INTER_EXT | \n", "C_IWT_INTER_POCK | \n", "... | \n", "VOL19 | \n", "IWT17 | \n", "IWT16 | \n", "IWT19 | \n", "ROAD17 | \n", "ROAD16 | \n", "ROAD19 | \n", "RAIL17 | \n", "RAIL16 | \n", "RAIL19 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1.0 | \n", "3137.079696 | \n", "2603.0 | \n", "3401.0 | \n", "136.763321 | \n", "97.5 | \n", "35.448467 | \n", "4.600553 | \n", "154.503324 | \n", "234.263321 | \n", "... | \n", "3237.841631 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "3352.761118 | \n", "3413.593663 | \n", "3237.841631 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
1 | \n", "1.0 | \n", "58.623405 | \n", "2603.0 | \n", "3402.0 | \n", "155.033549 | \n", "97.5 | \n", "49.315966 | \n", "4.751758 | \n", "152.255914 | \n", "252.533548 | \n", "... | \n", "2851.751474 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "2890.313711 | \n", "2942.755604 | \n", "2791.245105 | \n", "62.653899 | \n", "63.790692 | \n", "60.506369 | \n", "
2 | \n", "1.0 | \n", "1798.445498 | \n", "2603.0 | \n", "3411.0 | \n", "142.904632 | \n", "97.5 | \n", "54.137438 | \n", "4.846085 | \n", "100.752875 | \n", "240.404632 | \n", "... | \n", "1856.210957 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1922.092749 | \n", "1956.967227 | \n", "1856.210957 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
3 | \n", "1.0 | \n", "1199.256954 | \n", "2603.0 | \n", "3412.0 | \n", "128.715258 | \n", "97.5 | \n", "45.192007 | \n", "4.584792 | \n", "89.003238 | \n", "226.215258 | \n", "... | \n", "2972.567734 | \n", "1281.708619 | \n", "1304.963958 | \n", "1237.776680 | \n", "1796.363337 | \n", "1828.956578 | \n", "1734.791054 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
4 | \n", "1.0 | \n", "2629.690474 | \n", "2603.0 | \n", "3413.0 | \n", "179.551959 | \n", "97.5 | \n", "89.246420 | \n", "5.192508 | \n", "79.876156 | \n", "277.051959 | \n", "... | \n", "2714.155239 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "2810.487724 | \n", "2861.481253 | \n", "2714.155239 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1195 | \n", "9.0 | \n", "453402.873400 | \n", "9433.0 | \n", "9421.0 | \n", "63.281185 | \n", "65.0 | \n", "42.944886 | \n", "6.890148 | \n", "38.051482 | \n", "128.281185 | \n", "... | \n", "823092.349600 | \n", "362898.001600 | \n", "359331.924000 | \n", "370480.433400 | \n", "289267.371200 | \n", "286424.837300 | \n", "295311.356400 | \n", "154081.170400 | \n", "152567.066200 | \n", "157300.559800 | \n", "
1196 | \n", "9.0 | \n", "52272.569540 | \n", "9433.0 | \n", "9422.0 | \n", "68.068997 | \n", "97.5 | \n", "49.479978 | \n", "4.400219 | \n", "24.576481 | \n", "165.568997 | \n", "... | \n", "267137.639180 | \n", "41838.312320 | \n", "41427.181180 | \n", "42712.486740 | \n", "209370.751900 | \n", "207313.335400 | \n", "213745.368100 | \n", "10461.206700 | \n", "10358.407920 | \n", "10679.784340 | \n", "
1197 | \n", "9.0 | \n", "45904.662990 | \n", "9433.0 | \n", "9423.0 | \n", "72.266223 | \n", "97.5 | \n", "37.113933 | \n", "4.266030 | \n", "59.964316 | \n", "169.766223 | \n", "... | \n", "308717.607740 | \n", "36741.519380 | \n", "36380.472730 | \n", "37509.200840 | \n", "265657.724300 | \n", "263047.194600 | \n", "271208.406900 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
1198 | \n", "9.0 | \n", "6507.081029 | \n", "9433.0 | \n", "9424.0 | \n", "81.792488 | \n", "97.5 | \n", "49.400207 | \n", "4.452485 | \n", "54.571858 | \n", "179.292488 | \n", "... | \n", "168764.611305 | \n", "5208.186449 | \n", "5157.007340 | \n", "5317.006886 | \n", "157818.951800 | \n", "156268.117600 | \n", "161116.438900 | \n", "2283.454756 | \n", "2261.016009 | \n", "2331.165519 | \n", "
1199 | \n", "9.0 | \n", "10390.662350 | \n", "9433.0 | \n", "9425.0 | \n", "71.508493 | \n", "65.0 | \n", "41.689381 | \n", "6.918849 | \n", "64.077483 | \n", "136.508493 | \n", "... | \n", "254223.352093 | \n", "8316.556475 | \n", "8234.832446 | \n", "8490.323540 | \n", "237846.609100 | \n", "235509.369800 | \n", "242816.203000 | \n", "2857.128390 | \n", "2829.052342 | \n", "2916.825553 | \n", "
1200 rows × 156 columns
\n", "\n", " | NSTR1 | \n", "V2021 | \n", "ORIGIN | \n", "DESTINATION | \n", "C_IWT_INTER_TRANS | \n", "C_IWT_INTER_HAND | \n", "C_IWT_INTER_TIME | \n", "C_IWT_INTER_REL | \n", "C_IWT_INTER_EXT | \n", "C_IWT_INTER_POCK | \n", "... | \n", "VOL19 | \n", "IWT17 | \n", "IWT16 | \n", "IWT19 | \n", "ROAD17 | \n", "ROAD16 | \n", "ROAD19 | \n", "RAIL17 | \n", "RAIL16 | \n", "RAIL19 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1.0 | \n", "3137.079696 | \n", "2603.0 | \n", "3401.0 | \n", "136.763321 | \n", "97.5 | \n", "35.448467 | \n", "4.600553 | \n", "154.503324 | \n", "234.263321 | \n", "... | \n", "3237.841631 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "3352.761118 | \n", "3413.593663 | \n", "3237.841631 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
1 | \n", "1.0 | \n", "58.623405 | \n", "2603.0 | \n", "3402.0 | \n", "155.033549 | \n", "97.5 | \n", "49.315966 | \n", "4.751758 | \n", "152.255914 | \n", "252.533548 | \n", "... | \n", "2851.751474 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "2890.313711 | \n", "2942.755604 | \n", "2791.245105 | \n", "62.653899 | \n", "63.790692 | \n", "60.506369 | \n", "
2 | \n", "1.0 | \n", "1798.445498 | \n", "2603.0 | \n", "3411.0 | \n", "142.904632 | \n", "97.5 | \n", "54.137438 | \n", "4.846085 | \n", "100.752875 | \n", "240.404632 | \n", "... | \n", "1856.210957 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "1922.092749 | \n", "1956.967227 | \n", "1856.210957 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
3 | \n", "1.0 | \n", "1199.256954 | \n", "2603.0 | \n", "3412.0 | \n", "128.715258 | \n", "97.5 | \n", "45.192007 | \n", "4.584792 | \n", "89.003238 | \n", "226.215258 | \n", "... | \n", "2972.567734 | \n", "1281.708619 | \n", "1304.963958 | \n", "1237.776680 | \n", "1796.363337 | \n", "1828.956578 | \n", "1734.791054 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
4 | \n", "1.0 | \n", "2629.690474 | \n", "2603.0 | \n", "3413.0 | \n", "179.551959 | \n", "97.5 | \n", "89.246420 | \n", "5.192508 | \n", "79.876156 | \n", "277.051959 | \n", "... | \n", "2714.155239 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "2810.487724 | \n", "2861.481253 | \n", "2714.155239 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
1195 | \n", "9.0 | \n", "453402.873400 | \n", "9433.0 | \n", "9421.0 | \n", "63.281185 | \n", "65.0 | \n", "42.944886 | \n", "6.890148 | \n", "38.051482 | \n", "128.281185 | \n", "... | \n", "823092.349600 | \n", "362898.001600 | \n", "359331.924000 | \n", "370480.433400 | \n", "289267.371200 | \n", "286424.837300 | \n", "295311.356400 | \n", "154081.170400 | \n", "152567.066200 | \n", "157300.559800 | \n", "
1196 | \n", "9.0 | \n", "52272.569540 | \n", "9433.0 | \n", "9422.0 | \n", "68.068997 | \n", "97.5 | \n", "49.479978 | \n", "4.400219 | \n", "24.576481 | \n", "165.568997 | \n", "... | \n", "267137.639180 | \n", "41838.312320 | \n", "41427.181180 | \n", "42712.486740 | \n", "209370.751900 | \n", "207313.335400 | \n", "213745.368100 | \n", "10461.206700 | \n", "10358.407920 | \n", "10679.784340 | \n", "
1197 | \n", "9.0 | \n", "45904.662990 | \n", "9433.0 | \n", "9423.0 | \n", "72.266223 | \n", "97.5 | \n", "37.113933 | \n", "4.266030 | \n", "59.964316 | \n", "169.766223 | \n", "... | \n", "308717.607740 | \n", "36741.519380 | \n", "36380.472730 | \n", "37509.200840 | \n", "265657.724300 | \n", "263047.194600 | \n", "271208.406900 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "
1198 | \n", "9.0 | \n", "6507.081029 | \n", "9433.0 | \n", "9424.0 | \n", "81.792488 | \n", "97.5 | \n", "49.400207 | \n", "4.452485 | \n", "54.571858 | \n", "179.292488 | \n", "... | \n", "168764.611305 | \n", "5208.186449 | \n", "5157.007340 | \n", "5317.006886 | \n", "157818.951800 | \n", "156268.117600 | \n", "161116.438900 | \n", "2283.454756 | \n", "2261.016009 | \n", "2331.165519 | \n", "
1199 | \n", "9.0 | \n", "10390.662350 | \n", "9433.0 | \n", "9425.0 | \n", "71.508493 | \n", "65.0 | \n", "41.689381 | \n", "6.918849 | \n", "64.077483 | \n", "136.508493 | \n", "... | \n", "254223.352093 | \n", "8316.556475 | \n", "8234.832446 | \n", "8490.323540 | \n", "237846.609100 | \n", "235509.369800 | \n", "242816.203000 | \n", "2857.128390 | \n", "2829.052342 | \n", "2916.825553 | \n", "
1200 rows × 156 columns
\n", "