{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "### Predictions with the trained RF-models\n", "\n", "Linn Alexandra Emhjellen, 2021.\n" ] }, { "cell_type": "code", "execution_count": 25, "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import os\n", "import matplotlib.pyplot as plt\n", "import joblib" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [], "source": [ "from sklearn.preprocessing import StandardScaler\n", "from sklearn import datasets, linear_model\n", "from sklearn.ensemble import RandomForestClassifier,RandomForestRegressor\n", "from sklearn.metrics import recall_score,roc_curve,auc\n", "from sklearn.model_selection import cross_val_score\n", "from sklearn.model_selection import cross_val_predict\n", "from sklearn import metrics" ] }, { "cell_type": "code", "execution_count": 27, "metadata": {}, "outputs": [], "source": [ "# vestland dataset\n", "#df_database = pd.read_excel(\"ML_Vestland_database2.xlsx\")\n", "#df_database = pd.read_excel('ML_Lærdal_Aurland_database.xlsx')\n", "#df_database = pd.read_excel('ML_test_area_database.xlsx')\n", "#df_database = pd.read_excel('ML_Lærdal_Gård_Bø_database.xlsx')\n", "\n", "\n", "#df_database = pd.read_csv('ML_Lærdal_Aurland_close_10_m_database.csv')\n", "\n", "df_database = pd.read_csv(\"ML_Vestland_West_10_m_database.csv\")\n", "df_database = df_database.dropna()" ] }, { "cell_type": "code", "execution_count": 28, "metadata": {}, "outputs": [], "source": [ "# load models\n", "\n", "RF_p1_model = joblib.load(\"../RF/lr_p1_Emhjellen2.joblib\")\n", "RF_p2_model = joblib.load(\"../RF/lr_p2_Emhjellen2.joblib\")\n", "RF_p3_model = joblib.load(\"../RF/lr_p3_Emhjellen2.joblib\")\n", "RF_p4_model = joblib.load(\"../RF/lr_p4_Emhjellen2.joblib\")\n", "RF_p5_model = joblib.load(\"../RF/lr_p5_Emhjellen2.joblib\")\n", "RF_p6_model = joblib.load(\"../RF/lr_p6_Emhjellen2.joblib\")\n", "RF_p7_model = joblib.load(\"../RF/lr_p7_Emhjellen2.joblib\")\n", "RF_p8_model = joblib.load(\"../RF/lr_p8_Emhjellen2.joblib\")\n", "\n" ] }, { "cell_type": "code", "execution_count": 30, "metadata": {}, "outputs": [], "source": [ "#missing_bedrocks = ['Arkose', 'Greenstone', 'Metagreywacke', 'Tonalite', 'Peridotite', 'Meta-arkose', 'Dioritic gneis', 'Pyroclastic rock', 'Quartz diorite', 'Sedimentary breccia', 'Andesite', 'Pyroksenite', 'Charnockite', 'Shale', 'Mica schist', 'Intermediate volcanic rock', 'Trondhjemite', 'Amphibole schist', 'Serpentinite', 'Mangerite', 'Felsic volcanic rock', 'Greywacke', 'Pegmatite/aplite', 'Tuffite', 'Mafic dyke (Diabase, Dolerite)', 'Eclogite', 'Mafic volcanic rock', 'Calcareous mica schist', 'Diorite', 'Garnet mica schist', 'Limestone', 'Basalt', 'Graphitic schist', 'Norite', 'Konglomerate', 'Sandstone', 'Volcanic breccia', 'Quartz dioritic gneiss', 'Dacite', 'Calcite marble', 'Calc-silicate rock', 'Syenite', 'Greenschist', 'Siltstone']\n", "\n", "#missing_bedrocks = ['Intermediate volcanic rock', 'Orthopyroxene gneiss', 'Metagabbro', 'Mangerite', 'Peridotite', 'Banded gneiss', 'Metagreywacke', 'Greywacke', 'Amphibolite', 'Syenite', 'Cataclasite', 'Limestone', 'Monzonitic gneiss', 'Rhyolite', 'Felsic volcanic rock', 'Andesite', 'Phyllite', 'Basalt', 'Mafic volcanic rock', 'Volcanic breccia', 'Tuffite', 'Amphibole schist', 'Mica gneiss', 'Shale', 'Meta-arkose', 'Quartz dioritic gneiss', 'Augengneiss', 'Diorite', 'Eclogite', 'Metasandstone', 'Tonalite', 'Mica schist', 'Serpentinite', 'Greenschist', 'Calcareous phyllite', 'Konglomerate', 'Siltstone', 'Quartz diorite', 'Calcareous mica schist', 'Dioritic gneis', 'Norite', 'Mafic dyke (Diabase, Dolerite)', 'Amphibole gneiss', 'Quartz schist', 'Granodioritic gneiss', 'Sedimentary breccia', 'Dacite', 'Sandstone', 'Pyroksenite', 'Garnet mica schist', 'Pyroclastic rock', 'Anorthosite', 'Pegmatite/aplite', 'Quartzite', 'Mylonite/Phyllonite', 'Calcite marble', 'Granodiorite', 'Graphitic schist', 'Calc-silicate rock', 'Gabbro', 'Arkose', 'Greenstone', 'Migmatite', 'Trondhjemite']\n", "\n", "#missing_bedrocks = ['Gabbro', 'Amphibole schist', 'Mylonite/Phyllonite', 'Amphibolite', 'Basalt', 'Greenschist', 'Mangerite', 'Intermediate volcanic rock', 'Volcanic breccia', 'Anorthosite', 'Tuffite', 'Granodioritic gneiss', 'Banded gneiss', 'Syenite', 'Dacite', 'Felsic volcanic rock', 'Metagreywacke', 'Augengneiss', 'Peridotite', 'Cataclasite', 'Konglomerate', 'Orthopyroxene gneiss', 'Pyroclastic rock', 'Metagabbro', 'Andesite', 'Greywacke', 'Shale', 'Calcareous phyllite', 'Mica schist', 'Graphitic schist', 'Calcareous mica schist', 'Norite', 'Calc-silicate rock', 'Diorite', 'Migmatite', 'Monzonitic gneiss', 'Arkose', 'Pyroksenite', 'Dioritic gneis', 'Siltstone', 'Quartzite', 'Phyllite', 'Meta-arkose', 'Serpentinite', 'Quartz dioritic gneiss', 'Garnet mica schist', 'Mafic volcanic rock', 'Quartz schist', 'Tonalite', 'Trondhjemite', 'Calcite marble', 'Quartz diorite', 'Amphibole gneiss', 'Granodiorite', 'Metasandstone', 'Rhyolite', 'Sedimentary breccia', 'Sandstone', 'Mica gneiss', 'Greenstone', 'Eclogite', 'Pegmatite/aplite', 'Limestone', 'Mafic dyke (Diabase, Dolerite)']\n", "\n", "\n", "#missing_bedrocks = ['Graphitic schist', 'Cataclasite', 'Dioritic gneis', 'Trondhjemite', 'Norite', 'Sedimentary breccia', 'Andesite', 'Mafic dyke (Diabase, Dolerite)', 'Gabbro', 'Quartz diorite', 'Greenstone', 'Dacite', 'Calc-silicate rock', 'Mangerite', 'Metasandstone', 'Quartz schist', 'Phyllite', 'Tonalite', 'Calcareous mica schist', 'Granite', 'Eclogite', 'Pegmatite/aplite', 'Pyroclastic rock', 'Mica gneiss', 'Mafic volcanic rock', 'Konglomerate', 'Intermediate volcanic rock', 'Migmatite', 'Calcareous phyllite', 'Quartzite', 'Diorite', 'Arkose', 'Volcanic breccia', 'Sandstone', 'Garnet mica schist', 'Siltstone', 'Calcite marble', 'Shale', 'Mylonite/Phyllonite', 'Granodioritic gneiss', 'Amphibole gneiss', 'Orthopyroxene gneiss', 'Syenite', 'Rhyolite', 'Banded gneiss', 'Quartz dioritic gneiss', 'Limestone', 'Metagreywacke', 'Basalt', 'Mica schist', 'Metagabbro', 'Granodiorite', 'Felsic volcanic rock', 'Tuffite', 'Meta-arkose', 'Greywacke', 'Peridotite', 'Pyroksenite', 'Augengneiss', 'Serpentinite', 'Greenschist', 'Amphibole schist', 'Amphibolite', 'Monzonitic gneiss']\n", "\n", "#missing_bedrocks = ['Granodiorite', 'Dioritic gneis', 'Gabbro', 'Monzodiorite', 'Quartz diorite', 'Tuffite', 'Norite', 'Felsic volcanic rock', 'Basalt', 'Shale', 'Andesite', 'Greenschist', 'Syenite', 'Calcareous phyllite', 'Meta-arkose', 'Arkose', 'Amphibole gneiss', 'Granite', 'Graphitic schist', 'Mafic dyke (Diabase, Dolerite)', 'Amphibole schist', 'Peridotite', 'Monzonitic gneiss', 'Garnet mica schist', 'Greenstone', 'Trondhjemite', 'Charnockite', 'Rhyolite', 'Siltstone', 'Metasandstone', 'Calcareous mica schist', 'Pegmatite/aplite', 'Volcanic breccia', 'Metagabbro', 'Granodioritic gneiss', 'Metagreywacke', 'Pyroclastic rock', 'Mica gneiss', 'Diorite', 'Calc-silicate rock', 'Augengneiss', 'Quartzite', 'Calcite marble', 'Mafic volcanic rock', 'Cataclasite', 'Migmatite', 'Pyroksenite', 'Intermediate volcanic rock', 'Tonalite', 'Mangerite', 'Greywacke', 'Sedimentary breccia', 'Anorthosite', 'Eclogite', 'Monzonite', 'Mylonite/Phyllonite', 'Serpentinite', 'Phyllite', 'Quartz dioritic gneiss', 'Orthopyroxene gneiss', 'Limestone']\n", "\n", "missing_bedrocks = ['Basalt', 'Syenite', 'Monzonitic gneiss', 'Garnet mica schist', 'Dioritic gneis', 'Quartzite', 'Monzonite', 'Pyroclastic rock', 'Calcite marble', 'Sedimentary breccia', 'Norite', 'Orthopyroxene gneiss', 'Meta-arkose', 'Quartz dioritic gneiss', 'Peridotite', 'Mica gneiss', 'Anorthosite', 'Shale', 'Mylonite/Phyllonite', 'Monzodiorite', 'Quartz diorite', 'Metagabbro', 'Andesite', 'Tonalite', 'Amphibole schist', 'Pegmatite/aplite', 'Metasandstone', 'Metagreywacke', 'Granodiorite', 'Limestone', 'Rhyolite', 'Granodioritic gneiss', 'Greenstone', 'Augengneiss', 'Siltstone', 'Calcareous mica schist', 'Gabbro', 'Mangerite', 'Trondhjemite', 'Volcanic breccia', 'Serpentinite', 'Phyllite', 'Eclogite', 'Calc-silicate rock', 'Graphitic schist', 'Pyroksenite', 'Calcareous phyllite', 'Granite', 'Greenschist', 'Mafic volcanic rock', 'Mafic dyke (Diabase, Dolerite)', 'Felsic volcanic rock', 'Diorite', 'Greywacke', 'Arkose', 'Charnockite', 'Intermediate volcanic rock', 'Tuffite', 'Cataclasite', 'Amphibole gneiss', 'Migmatite']" ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [], "source": [ "#df = pd.DataFrame(data, columns = ['Arkose', 'Greenstone', 'Metagreywacke', 'Tonalite', 'Peridotite', 'Meta-arkose', 'Dioritic gneis', 'Pyroclastic rock', 'Quartz diorite', 'Sedimentary breccia', 'Andesite', 'Pyroksenite', 'Charnockite', 'Shale', 'Mica schist', 'Intermediate volcanic rock', 'Trondhjemite', 'Amphibole schist', 'Serpentinite', 'Mangerite', 'Felsic volcanic rock', 'Greywacke', 'Pegmatite/aplite', 'Tuffite', 'Mafic dyke (Diabase, Dolerite)', 'Eclogite', 'Mafic volcanic rock', 'Calcareous mica schist', 'Diorite', 'Garnet mica schist', 'Limestone', 'Basalt', 'Graphitic schist', 'Norite', 'Konglomerate', 'Sandstone', 'Volcanic breccia', 'Quartz dioritic gneiss', 'Dacite', 'Calcite marble', 'Calc-silicate rock', 'Syenite', 'Greenschist', 'Siltstone'])" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ " , , , , , , , , 'Konglomerate', 'Sandstone', 'Volcanic breccia', 'Quartz dioritic gneiss', 'Dacite', 'Calcite marble', 'Calc-silicate rock', 'Syenite', 'Greenschist', 'Siltstone'] " ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Basalt\n", "Syenite\n", "Monzonitic gneiss\n", "Garnet mica schist\n", "Dioritic gneis\n", "Quartzite\n", "Monzonite\n", "Pyroclastic rock\n", "Calcite marble\n", "Sedimentary breccia\n", "Norite\n", "Orthopyroxene gneiss\n", "Meta-arkose\n", "Quartz dioritic gneiss\n", "Peridotite\n", "Mica gneiss\n", "Anorthosite\n", "Shale\n", "Mylonite/Phyllonite\n", "Monzodiorite\n", "Quartz diorite\n", "Metagabbro\n", "Andesite\n", "Tonalite\n", "Amphibole schist\n", "Pegmatite/aplite\n", "Metasandstone\n", "Metagreywacke\n", "Granodiorite\n", "Limestone\n", "Rhyolite\n", "Granodioritic gneiss\n", "Greenstone\n", "Augengneiss\n", "Siltstone\n", "Calcareous mica schist\n", "Gabbro\n", "Mangerite\n", "Trondhjemite\n", "Volcanic breccia\n", "Serpentinite\n", "Phyllite\n", "Eclogite\n", "Calc-silicate rock\n", "Graphitic schist\n", "Pyroksenite\n", "Calcareous phyllite\n", "Granite\n", "Greenschist\n", "Mafic volcanic rock\n", "Mafic dyke (Diabase, Dolerite)\n", "Felsic volcanic rock\n", "Diorite\n", "Greywacke\n", "Arkose\n", "Charnockite\n", "Intermediate volcanic rock\n", "Tuffite\n", "Cataclasite\n", "Amphibole gneiss\n", "Migmatite\n" ] } ], "source": [ "for i in missing_bedrocks:\n", " print(i)\n", " df_database[i] = 0" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "df_database['Arkose'] = 0\n", "df_database['Greenstone'] = 0 \n", "df_database['Metagreywacke'] = 0\n", "df_database['Tonalite'] = 0\n", "df_database['Peridotite'] = 0\n", "df_database['Meta-arkose'] = 0\n", "df_database['Dioritic gneis'] = 0\n", "df_database['Pyroclastic rock'] = 0\n", "df_database['Quartz diorite'] = 0\n", "df_database['Sedimentary breccia'] = 0\n", "df_database['Andesite'] = 0\n", "df_database['Pyroksenite'] = 0\n", "df_database['Charnockite'] = 0\n", "df_database['Shale'] = 0\n", "df_database['Mica schist'] = 0\n", "df_database['Intermediate volcanic rock'] = 0\n", "df_database['Trondhjemite'] = 0\n", "df_database['Amphibole schist'] = 0\n", "df_database['Serpentinite'] = 0\n", "df_database['Mangerite'] = 0\n", "df_database['Felsic volcanic rock'] = 0\n", "df_database['Greywacke'] = 0\n", "df_database['Pegmatite/aplite'] = 0\n", "df_database['Tuffite'] = 0\n", "df_database['Mafic dyke (Diabase, Dolerite)'] = 0\n", "df_database['Mafic volcanic rock'] = 0\n", "df_database['Calcareous mica schist'] = 0\n", "df_database['Diorite'] = 0\n", "df_database['Garnet mica schist'] = 0\n", "df_database['Limestone'] = 0\n", "df_database['Basalt'] = 0\n", "df_database['Graphitic schist'] = 0\n", "df_database['Norite'] = 0\n" ] }, { "cell_type": "code", "execution_count": 33, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Unnamed: 0 | \n", "POINT_X | \n", "POINT_Y | \n", "Elevation | \n", "Slope | \n", "Aspect | \n", "Profile_curv | \n", "Plan_curv | \n", "Flow_dir | \n", "Flow_acc | \n", "... | \n", "Felsic volcanic rock | \n", "Diorite | \n", "Greywacke | \n", "Arkose | \n", "Charnockite | \n", "Intermediate volcanic rock | \n", "Tuffite | \n", "Cataclasite | \n", "Amphibole gneiss | \n", "Migmatite | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "-12021.556 | \n", "6.727549e+06 | \n", "212.356674 | \n", "21.265505 | \n", "261.564423 | \n", "-0.928917 | \n", "2.169502 | \n", "16.0 | \n", "0.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
1 | \n", "1 | \n", "-12011.556 | \n", "6.727549e+06 | \n", "215.332855 | \n", "17.124088 | \n", "237.247726 | \n", "-0.104549 | \n", "1.050633 | \n", "8.0 | \n", "21.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
2 | \n", "2 | \n", "-12001.556 | \n", "6.727549e+06 | \n", "217.093842 | \n", "16.037911 | \n", "231.804871 | \n", "0.052524 | \n", "-0.751706 | \n", "8.0 | \n", "2.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
3 | \n", "3 | \n", "-11991.556 | \n", "6.727549e+06 | \n", "219.437729 | \n", "20.578068 | \n", "248.741119 | \n", "2.373503 | \n", "-2.114137 | \n", "8.0 | \n", "5.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
4 | \n", "4 | \n", "-11981.556 | \n", "6.727549e+06 | \n", "224.555237 | \n", "22.921480 | \n", "254.060852 | \n", "-2.083771 | \n", "1.692047 | \n", "16.0 | \n", "0.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
492376 | \n", "492376 | \n", "-1531.556 | \n", "6.733009e+06 | \n", "568.710083 | \n", "15.073245 | \n", "209.229599 | \n", "-1.011383 | \n", "-0.712067 | \n", "8.0 | \n", "2.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
492377 | \n", "492377 | \n", "-1521.556 | \n", "6.733009e+06 | \n", "570.214661 | \n", "16.294689 | \n", "214.092499 | \n", "0.111530 | \n", "0.670673 | \n", "8.0 | \n", "0.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
492378 | \n", "492378 | \n", "-1511.556 | \n", "6.733009e+06 | \n", "571.424316 | \n", "17.588123 | \n", "207.157410 | \n", "1.255567 | \n", "-0.346728 | \n", "8.0 | \n", "2.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
492379 | \n", "492379 | \n", "-1501.556 | \n", "6.733009e+06 | \n", "573.165405 | \n", "17.707794 | \n", "209.771149 | \n", "-0.668694 | \n", "-0.523064 | \n", "4.0 | \n", "3.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
492380 | \n", "492380 | \n", "-1491.556 | \n", "6.733009e+06 | \n", "575.253174 | \n", "15.909173 | \n", "222.063995 | \n", "-1.713338 | \n", "-0.033589 | \n", "8.0 | \n", "9.0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
492381 rows × 102 columns
\n", "\n", " | POINT_X | \n", "POINT_Y | \n", "
---|---|---|
0 | \n", "-12021.556 | \n", "6.727549e+06 | \n", "
1 | \n", "-12011.556 | \n", "6.727549e+06 | \n", "
2 | \n", "-12001.556 | \n", "6.727549e+06 | \n", "
3 | \n", "-11991.556 | \n", "6.727549e+06 | \n", "
4 | \n", "-11981.556 | \n", "6.727549e+06 | \n", "
... | \n", "... | \n", "... | \n", "
492376 | \n", "-1531.556 | \n", "6.733009e+06 | \n", "
492377 | \n", "-1521.556 | \n", "6.733009e+06 | \n", "
492378 | \n", "-1511.556 | \n", "6.733009e+06 | \n", "
492379 | \n", "-1501.556 | \n", "6.733009e+06 | \n", "
492380 | \n", "-1491.556 | \n", "6.733009e+06 | \n", "
492381 rows × 2 columns
\n", "\n", " | POINT_X | \n", "POINT_Y | \n", "lr_Vestland_pred_p1 | \n", "lr_Vestland_prob_p1 | \n", "
---|---|---|---|---|
0 | \n", "-12021.556 | \n", "6.727549e+06 | \n", "0 | \n", "0.084519 | \n", "
1 | \n", "-12011.556 | \n", "6.727549e+06 | \n", "0 | \n", "0.022840 | \n", "
2 | \n", "-12001.556 | \n", "6.727549e+06 | \n", "0 | \n", "0.016041 | \n", "
3 | \n", "-11991.556 | \n", "6.727549e+06 | \n", "0 | \n", "0.068466 | \n", "
4 | \n", "-11981.556 | \n", "6.727549e+06 | \n", "0 | \n", "0.137857 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
492376 | \n", "-1531.556 | \n", "6.733009e+06 | \n", "0 | \n", "0.011700 | \n", "
492377 | \n", "-1521.556 | \n", "6.733009e+06 | \n", "0 | \n", "0.017442 | \n", "
492378 | \n", "-1511.556 | \n", "6.733009e+06 | \n", "0 | \n", "0.026539 | \n", "
492379 | \n", "-1501.556 | \n", "6.733009e+06 | \n", "0 | \n", "0.027584 | \n", "
492380 | \n", "-1491.556 | \n", "6.733009e+06 | \n", "0 | \n", "0.015381 | \n", "
492381 rows × 4 columns
\n", "\n", " | POINT_X | \n", "POINT_Y | \n", "lr_Vestland_pred_p1 | \n", "lr_Vestland_prob_p1 | \n", "lr_Vestland_pred_p2 | \n", "lr_Vestland_prob_p2 | \n", "lr_Vestland_pred_p3 | \n", "lr_Vestland_prob_p3 | \n", "lr_Vestland_pred_p4 | \n", "lr_Vestland_prob_p4 | \n", "lr_Vestland_pred_p5 | \n", "lr_Vestland_prob_p5 | \n", "lr_Vestland_pred_p6 | \n", "lr_Vestland_prob_p6 | \n", "lr_Vestland_pred_p7 | \n", "lr_Vestland_prob_p7 | \n", "lr_Vestland_pred_p8 | \n", "lr_Vestland_prob_p8 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "-12021.556 | \n", "6.727549e+06 | \n", "0 | \n", "0.084519 | \n", "0 | \n", "0.083872 | \n", "0 | \n", "0.148711 | \n", "0 | \n", "0.081987 | \n", "0 | \n", "0.083440 | \n", "0 | \n", "0.078193 | \n", "1 | \n", "0.557111 | \n", "0 | \n", "3.665532e-02 | \n", "
1 | \n", "-12011.556 | \n", "6.727549e+06 | \n", "0 | \n", "0.022840 | \n", "0 | \n", "0.023353 | \n", "0 | \n", "0.041710 | \n", "0 | \n", "0.022847 | \n", "0 | \n", "0.023612 | \n", "0 | \n", "0.022302 | \n", "1 | \n", "0.503459 | \n", "0 | \n", "8.876416e-03 | \n", "
2 | \n", "-12001.556 | \n", "6.727549e+06 | \n", "0 | \n", "0.016041 | \n", "0 | \n", "0.016510 | \n", "0 | \n", "0.029325 | \n", "0 | \n", "0.017018 | \n", "0 | \n", "0.017525 | \n", "0 | \n", "0.016782 | \n", "1 | \n", "0.502885 | \n", "0 | \n", "6.343416e-03 | \n", "
3 | \n", "-11991.556 | \n", "6.727549e+06 | \n", "0 | \n", "0.068466 | \n", "0 | \n", "0.067573 | \n", "0 | \n", "0.121762 | \n", "0 | \n", "0.078212 | \n", "0 | \n", "0.080957 | \n", "0 | \n", "0.075440 | \n", "1 | \n", "0.567381 | \n", "0 | \n", "2.926984e-02 | \n", "
4 | \n", "-11981.556 | \n", "6.727549e+06 | \n", "0 | \n", "0.137857 | \n", "0 | \n", "0.132834 | \n", "0 | \n", "0.233611 | \n", "0 | \n", "0.123330 | \n", "0 | \n", "0.124980 | \n", "0 | \n", "0.121433 | \n", "1 | \n", "0.508827 | \n", "0 | \n", "5.738864e-02 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
492376 | \n", "-1531.556 | \n", "6.733009e+06 | \n", "0 | \n", "0.011700 | \n", "0 | \n", "0.006835 | \n", "0 | \n", "0.021376 | \n", "0 | \n", "0.000009 | \n", "0 | \n", "0.000009 | \n", "0 | \n", "0.007022 | \n", "0 | \n", "0.002326 | \n", "0 | \n", "3.901299e-07 | \n", "
492377 | \n", "-1521.556 | \n", "6.733009e+06 | \n", "0 | \n", "0.017442 | \n", "0 | \n", "0.010082 | \n", "0 | \n", "0.031884 | \n", "0 | \n", "0.000012 | \n", "0 | \n", "0.000012 | \n", "0 | \n", "0.009418 | \n", "0 | \n", "0.002032 | \n", "0 | \n", "5.146157e-07 | \n", "
492378 | \n", "-1511.556 | \n", "6.733009e+06 | \n", "0 | \n", "0.026539 | \n", "0 | \n", "0.015201 | \n", "0 | \n", "0.048411 | \n", "0 | \n", "0.000018 | \n", "0 | \n", "0.000018 | \n", "0 | \n", "0.014977 | \n", "0 | \n", "0.002052 | \n", "0 | \n", "7.660662e-07 | \n", "
492379 | \n", "-1501.556 | \n", "6.733009e+06 | \n", "0 | \n", "0.027584 | \n", "0 | \n", "0.015746 | \n", "0 | \n", "0.050298 | \n", "0 | \n", "0.000019 | \n", "0 | \n", "0.000020 | \n", "0 | \n", "0.016388 | \n", "0 | \n", "0.002194 | \n", "0 | \n", "7.805199e-07 | \n", "
492380 | \n", "-1491.556 | \n", "6.733009e+06 | \n", "0 | \n", "0.015381 | \n", "0 | \n", "0.008839 | \n", "0 | \n", "0.028118 | \n", "0 | \n", "0.000011 | \n", "0 | \n", "0.000011 | \n", "0 | \n", "0.009590 | \n", "0 | \n", "0.002369 | \n", "0 | \n", "4.310515e-07 | \n", "
492381 rows × 18 columns
\n", "