{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Advanced Tutorial\n", "### Follow along\n", "\n", "Code for all the examples is located in your `PYTHONPATH/Lib/site-packages/eonr/examples` folder. With that said, you should be able to make use of `EONR` by following and executing the commands in this tutorial using either the sample data provided or substituting in your own data.\n", "\n", "*You will find the following code included in the* `advanced_tutorial.py` *or* `advanced_tutorial.ipynb` *(for* [Jupyter notebooks](https://jupyter.org/)*) files in your* `PYTHONPATH/Lib/site-packages/eonr/examples` *folder - feel free to load that into your Python IDE to follow along.*\n", "\n", "- - -\n", "### Calculate `EONR` for several economic scenarios \n", "In this tutorial, we will run `EONR.calculate_eonr()` in a loop, adjusting the economic scenario prior to each run." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "- - -\n", "### Load modules\n", "Load `pandas` and `EONR`:" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "EONR version: 0.2.0\n" ] } ], "source": [ "import os\n", "import pandas as pd\n", "import eonr\n", "print('EONR version: {0}'.format(eonr.__version__))" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "- - -\n", "### Load the data\n", "`EONR` uses Pandas dataframes to access and manipulate the experimental data." ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | year | \n", "location | \n", "plot | \n", "trt | \n", "rep | \n", "time_n | \n", "rate_n_applied_kgha | \n", "yld_grain_dry_kgha | \n", "nup_total_kgha | \n", "soil_plus_fert_n_kgha | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2012 | \n", "Minnesota | \n", "101 | \n", "8 | \n", "1 | \n", "Pre | \n", "235.3785 | \n", "12410.916200 | \n", "198.759898 | \n", "284.69590 | \n", "
1 | \n", "2012 | \n", "Minnesota | \n", "102 | \n", "3 | \n", "1 | \n", "Pre | \n", "67.2510 | \n", "10627.946000 | \n", "147.971755 | \n", "116.56840 | \n", "
2 | \n", "2012 | \n", "Minnesota | \n", "103 | \n", "1 | \n", "1 | \n", "Pre | \n", "0.0000 | \n", "7428.081218 | \n", "98.769392 | \n", "38.10890 | \n", "
3 | \n", "2012 | \n", "Minnesota | \n", "104 | \n", "2 | \n", "1 | \n", "Pre | \n", "33.6255 | \n", "9202.953180 | \n", "111.440210 | \n", "71.73440 | \n", "
4 | \n", "2012 | \n", "Minnesota | \n", "105 | \n", "4 | \n", "2 | \n", "Pre | \n", "100.8765 | \n", "10841.127180 | \n", "142.663887 | \n", "154.67730 | \n", "
5 | \n", "2012 | \n", "Minnesota | \n", "106 | \n", "7 | \n", "2 | \n", "Pre | \n", "201.7530 | \n", "10646.649330 | \n", "178.802092 | \n", "255.55380 | \n", "
6 | \n", "2012 | \n", "Minnesota | \n", "107 | \n", "6 | \n", "2 | \n", "Pre | \n", "168.1275 | \n", "12367.436000 | \n", "186.053531 | \n", "201.75300 | \n", "
7 | \n", "2012 | \n", "Minnesota | \n", "108 | \n", "5 | \n", "2 | \n", "Pre | \n", "134.5020 | \n", "13366.361700 | \n", "196.737290 | \n", "168.12750 | \n", "
8 | \n", "2012 | \n", "Minnesota | \n", "201 | \n", "7 | \n", "1 | \n", "Pre | \n", "201.7530 | \n", "14232.053480 | \n", "228.775204 | \n", "251.07040 | \n", "
9 | \n", "2012 | \n", "Minnesota | \n", "202 | \n", "5 | \n", "1 | \n", "Pre | \n", "134.5020 | \n", "14384.824980 | \n", "226.006218 | \n", "183.81940 | \n", "
10 | \n", "2012 | \n", "Minnesota | \n", "203 | \n", "6 | \n", "1 | \n", "Pre | \n", "168.1275 | \n", "13592.219290 | \n", "182.423028 | \n", "206.23640 | \n", "
11 | \n", "2012 | \n", "Minnesota | \n", "204 | \n", "4 | \n", "1 | \n", "Pre | \n", "100.8765 | \n", "14091.078390 | \n", "187.745096 | \n", "138.98540 | \n", "
12 | \n", "2012 | \n", "Minnesota | \n", "205 | \n", "3 | \n", "2 | \n", "Pre | \n", "67.2510 | \n", "10739.981390 | \n", "133.470950 | \n", "121.05180 | \n", "
13 | \n", "2012 | \n", "Minnesota | \n", "206 | \n", "1 | \n", "2 | \n", "Pre | \n", "0.0000 | \n", "8375.090921 | \n", "109.460245 | \n", "53.80080 | \n", "
14 | \n", "2012 | \n", "Minnesota | \n", "207 | \n", "8 | \n", "2 | \n", "Pre | \n", "235.3785 | \n", "13797.485850 | \n", "195.932161 | \n", "269.00400 | \n", "
15 | \n", "2012 | \n", "Minnesota | \n", "208 | \n", "2 | \n", "2 | \n", "Pre | \n", "33.6255 | \n", "9713.487469 | \n", "113.903035 | \n", "67.25100 | \n", "
16 | \n", "2012 | \n", "Minnesota | \n", "301 | \n", "3 | \n", "3 | \n", "Pre | \n", "67.2510 | \n", "12579.012170 | \n", "180.812783 | \n", "106.48075 | \n", "
17 | \n", "2012 | \n", "Minnesota | \n", "302 | \n", "7 | \n", "3 | \n", "Pre | \n", "201.7530 | \n", "13604.571780 | \n", "208.724988 | \n", "240.98275 | \n", "
18 | \n", "2012 | \n", "Minnesota | \n", "303 | \n", "2 | \n", "3 | \n", "Pre | \n", "33.6255 | \n", "10185.959390 | \n", "121.505528 | \n", "68.37185 | \n", "
19 | \n", "2012 | \n", "Minnesota | \n", "304 | \n", "6 | \n", "3 | \n", "Pre | \n", "168.1275 | \n", "14305.321460 | \n", "204.391319 | \n", "202.87385 | \n", "
20 | \n", "2012 | \n", "Minnesota | \n", "305 | \n", "8 | \n", "4 | \n", "Pre | \n", "235.3785 | \n", "13929.592020 | \n", "186.775288 | \n", "267.88315 | \n", "
21 | \n", "2012 | \n", "Minnesota | \n", "306 | \n", "4 | \n", "4 | \n", "Pre | \n", "100.8765 | \n", "10975.799250 | \n", "147.057081 | \n", "133.38115 | \n", "
22 | \n", "2012 | \n", "Minnesota | \n", "307 | \n", "5 | \n", "4 | \n", "Pre | \n", "134.5020 | \n", "11338.070290 | \n", "148.348790 | \n", "162.52325 | \n", "
23 | \n", "2012 | \n", "Minnesota | \n", "308 | \n", "1 | \n", "4 | \n", "Pre | \n", "0.0000 | \n", "5821.373521 | \n", "68.791363 | \n", "28.02125 | \n", "
24 | \n", "2012 | \n", "Minnesota | \n", "401 | \n", "5 | \n", "3 | \n", "Pre | \n", "134.5020 | \n", "13755.002370 | \n", "198.844611 | \n", "173.73175 | \n", "
25 | \n", "2012 | \n", "Minnesota | \n", "402 | \n", "1 | \n", "3 | \n", "Pre | \n", "0.0000 | \n", "9077.628329 | \n", "122.207140 | \n", "39.22975 | \n", "
26 | \n", "2012 | \n", "Minnesota | \n", "403 | \n", "4 | \n", "3 | \n", "Pre | \n", "100.8765 | \n", "13760.323240 | \n", "181.734857 | \n", "135.62285 | \n", "
27 | \n", "2012 | \n", "Minnesota | \n", "404 | \n", "8 | \n", "3 | \n", "Pre | \n", "235.3785 | \n", "14896.886860 | \n", "227.454749 | \n", "270.12485 | \n", "
28 | \n", "2012 | \n", "Minnesota | \n", "405 | \n", "2 | \n", "4 | \n", "Pre | \n", "33.6255 | \n", "10551.466010 | \n", "144.282839 | \n", "66.13015 | \n", "
29 | \n", "2012 | \n", "Minnesota | \n", "406 | \n", "6 | \n", "4 | \n", "Pre | \n", "168.1275 | \n", "15621.406530 | \n", "227.056199 | \n", "200.63215 | \n", "
30 | \n", "2012 | \n", "Minnesota | \n", "407 | \n", "3 | \n", "4 | \n", "Pre | \n", "67.2510 | \n", "10950.450720 | \n", "146.628851 | \n", "95.27225 | \n", "
31 | \n", "2012 | \n", "Minnesota | \n", "408 | \n", "7 | \n", "4 | \n", "Pre | \n", "201.7530 | \n", "13838.222530 | \n", "210.340625 | \n", "229.77425 | \n", "
\n", " | price_grain | \n", "cost_n_fert | \n", "cost_n_social | \n", "costs_fixed | \n", "price_ratio | \n", "unit_price_grain | \n", "unit_cost_n | \n", "location | \n", "year | \n", "time_n | \n", "... | \n", "mrtn | \n", "grtn_r2_adj | \n", "grtn_rmse | \n", "grtn_max_y | \n", "grtn_crit_x | \n", "grtn_y_int | \n", "scn_lin_r2 | \n", "scn_lin_rmse | \n", "scn_exp_r2 | \n", "scn_exp_rmse | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1.000 | \n", "0 | \n", "0.00 | \n", "0 | \n", "0.000000 | \n", "$ per ha | \n", "$ per kg | \n", "Minnesota | \n", "2012 | \n", "Pre | \n", "... | \n", "13579.232456 | \n", "0.728926 | \n", "1154.305686 | \n", "13579.232456 | \n", "177.437339 | \n", "7735.725352 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
1 | \n", "1.000 | \n", "0 | \n", "0.00 | \n", "0 | \n", "0.000000 | \n", "$ per ha | \n", "$ per kg | \n", "Minnesota | \n", "2012 | \n", "Pre | \n", "... | \n", "13579.232456 | \n", "0.728926 | \n", "1154.305686 | \n", "13579.232456 | \n", "177.437339 | \n", "7735.725352 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
2 | \n", "0.157 | \n", "0.44 | \n", "0.00 | \n", "12 | \n", "2.802548 | \n", "$ per ha | \n", "$ per kg | \n", "Minnesota | \n", "2012 | \n", "Pre | \n", "... | \n", "2043.528038 | \n", "0.728926 | \n", "181.225993 | \n", "2131.939496 | \n", "177.437340 | \n", "1214.508882 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
3 | \n", "0.157 | \n", "1.32 | \n", "0.00 | \n", "12 | \n", "8.407643 | \n", "$ per ha | \n", "$ per kg | \n", "Minnesota | \n", "2012 | \n", "Pre | \n", "... | \n", "1900.670950 | \n", "0.728926 | \n", "181.225993 | \n", "2131.939496 | \n", "177.437340 | \n", "1214.508882 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
4 | \n", "0.157 | \n", "2.2 | \n", "0.00 | \n", "12 | \n", "14.012739 | \n", "$ per ha | \n", "$ per kg | \n", "Minnesota | \n", "2012 | \n", "Pre | \n", "... | \n", "1771.101634 | \n", "0.728926 | \n", "181.225993 | \n", "2131.939496 | \n", "177.437340 | \n", "1214.508882 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
5 | \n", "0.157 | \n", "0.88 | \n", "0.44 | \n", "12 | \n", "8.407643 | \n", "$ per ha | \n", "$ per kg | \n", "Minnesota | \n", "2012 | \n", "Pre | \n", "... | \n", "749.347111 | \n", "0.728926 | \n", "181.225993 | \n", "917.433580 | \n", "177.439985 | \n", "0.002964 | \n", "0.777106 | \n", "55.7255 | \n", "0.836099 | \n", "8.44737 | \n", "
6 | \n", "0.157 | \n", "0.88 | \n", "1.32 | \n", "12 | \n", "14.012739 | \n", "$ per ha | \n", "$ per kg | \n", "Minnesota | \n", "2012 | \n", "Pre | \n", "... | \n", "737.042610 | \n", "0.728926 | \n", "181.225993 | \n", "917.433580 | \n", "177.439985 | \n", "0.002964 | \n", "0.777106 | \n", "167.176 | \n", "0.836099 | \n", "25.3421 | \n", "
7 | \n", "0.157 | \n", "0.88 | \n", "2.20 | \n", "12 | \n", "19.617834 | \n", "$ per ha | \n", "$ per kg | \n", "Minnesota | \n", "2012 | \n", "Pre | \n", "... | \n", "725.792236 | \n", "0.728926 | \n", "181.225993 | \n", "917.433580 | \n", "177.439985 | \n", "0.002964 | \n", "0.777106 | \n", "278.627 | \n", "0.836099 | \n", "42.2368 | \n", "
8 | \n", "0.157 | \n", "0.88 | \n", "4.40 | \n", "12 | \n", "33.630573 | \n", "$ per ha | \n", "$ per kg | \n", "Minnesota | \n", "2012 | \n", "Pre | \n", "... | \n", "701.669696 | \n", "0.728926 | \n", "181.225993 | \n", "917.433580 | \n", "177.439985 | \n", "0.002964 | \n", "0.777106 | \n", "557.255 | \n", "0.836099 | \n", "84.4737 | \n", "
9 rows × 33 columns
\n", "