{ "cells": [ { "cell_type": "markdown", "id": "cooperative-notification", "metadata": { "papermill": { "duration": 0.071871, "end_time": "2021-07-20T13:15:55.071212", "exception": false, "start_time": "2021-07-20T13:15:54.999341", "status": "completed" }, "tags": [] }, "source": [ "# **Location of the stress factor in potential evapo-transpiration models**" ] }, { "cell_type": "markdown", "id": "confident-account", "metadata": { "papermill": { "duration": 0.060225, "end_time": "2021-07-20T13:15:55.195448", "exception": false, "start_time": "2021-07-20T13:15:55.135223", "status": "completed" }, "slideshow": { "slide_type": "slide" }, "tags": [] }, "source": [ "# Part I - Methodology \n", "\n", "## Motivation \n", "\n", "### Theoretical background\n", "\n", "This notebook focuses mainly on the physical meaning of the stress factor whenn put in front of the potential evapo-transpiration model. Thus it will mainly investigate the *constant surface conductance model* which is expressed as: \n", "\n", "\\begin{align}\n", " E_{a, cst} = f_{PAR}.S(\\theta).E_{p,PM}(\\textbf{X})\n", "\\end{align}\n", "\n", "For more details about the formulation of the model and the associated potential evapo-transpiration model, see *location_stress_factor.ipynb* notebook. \n", "\n", "In the literature, the stress factor put in front of the potential evapo-transpiration model is often interpretated as the shrinkage in the leaf area cover over time. In this notebook we investigate the information contained within the stress factor and the meaning of the stress factor in order to better interprete this coefficient\n", "\n", "### Modelling experiements\n", "\n", "Two main experiments are carried out to infer the hypothesis : \n", "1. The stress factor is reconstructed out of the observations and compared to our artificial stress factor\n", "2. The model is computed with and without the fPAR coefficient to infer the information contained in this time serie\n", "\n", "🚧 All the newly constructed models in this notebook are not multiply by the fPAR factor (classical Penman-Monteith model, varying surface conductance and constant surface conductance models) 🚧" ] }, { "cell_type": "markdown", "id": "received-recognition", "metadata": { "papermill": { "duration": 0.060889, "end_time": "2021-07-20T13:15:55.329816", "exception": false, "start_time": "2021-07-20T13:15:55.268927", "status": "completed" }, "tags": [] }, "source": [ "# Part II - Functions set up" ] }, { "cell_type": "markdown", "id": "indonesian-garden", "metadata": { "papermill": { "duration": 0.061149, "end_time": "2021-07-20T13:15:55.456208", "exception": false, "start_time": "2021-07-20T13:15:55.395059", "status": "completed" }, "tags": [] }, "source": [ "## Importing relevant packages" ] }, { "cell_type": "code", "execution_count": 1, "id": "frequent-logistics", "metadata": { "execution": { "iopub.execute_input": "2021-07-20T13:15:55.586604Z", "iopub.status.busy": "2021-07-20T13:15:55.581057Z", "iopub.status.idle": "2021-07-20T13:16:00.258883Z", "shell.execute_reply": "2021-07-20T13:16:00.259874Z" }, "papermill": { "duration": 4.743091, "end_time": "2021-07-20T13:16:00.260468", "exception": false, "start_time": "2021-07-20T13:15:55.517377", "status": "completed" }, "tags": [] }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "WARNING (aesara.link.c.cmodule): install mkl with `conda install mkl-service`: No module named 'mkl'\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "WARNING (aesara.tensor.blas): Using NumPy C-API based implementation for BLAS functions.\n" ] } ], "source": [ "# data manipulation and plotting\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "from matplotlib._layoutgrid import plot_children\n", "from matplotlib.patches import Polygon\n", "from collections import OrderedDict\n", "from IPython.display import display\n", "import os # to look into the other folders of the project\n", "import importlib.util # to open the .py files written somewhere else\n", "#sns.set_theme(style=\"whitegrid\")\n", "\n", "# Sympy and sympbolic mathematics\n", "from sympy import (asin, cos, diff, Eq, exp, init_printing, log, pi, sin, \n", " solve, sqrt, Symbol, symbols, tan, Abs)\n", "from sympy.physics.units import convert_to\n", "init_printing() \n", "from sympy.printing import StrPrinter\n", "from sympy import Piecewise\n", "StrPrinter._print_Quantity = lambda self, expr: str(expr.abbrev) # displays short units (m instead of meter)\n", "from sympy.printing.aesaracode import aesara_function\n", "from sympy.physics.units import * # Import all units and dimensions from sympy\n", "from sympy.physics.units.systems.si import dimsys_SI, SI\n", "\n", "# for ESSM, environmental science for symbolic math, see https://github.com/environmentalscience/essm\n", "from essm.variables._core import BaseVariable, Variable\n", "from essm.equations import Equation\n", "from essm.variables.units import derive_unit, SI, Quantity\n", "from essm.variables.utils import (extract_variables, generate_metadata_table, markdown, \n", " replace_defaults, replace_variables, subs_eq)\n", "from essm.variables.units import (SI_BASE_DIMENSIONS, SI_EXTENDED_DIMENSIONS, SI_EXTENDED_UNITS,\n", " derive_unit, derive_baseunit, derive_base_dimension)\n", "\n", "# For netCDF\n", "import netCDF4\n", "import numpy as np\n", "import xarray as xr\n", "import warnings\n", "from netCDF4 import Dataset\n", "\n", "# For regressions\n", "from sklearn.linear_model import LinearRegression\n", "\n", "# Deactivate unncessary warning messages related to a bug in Numpy\n", "warnings.simplefilter(action='ignore', category=FutureWarning)\n", "\n", "# for calibration\n", "from scipy import optimize\n", "\n", "from random import random" ] }, { "cell_type": "markdown", "id": "elegant-timeline", "metadata": { "papermill": { "duration": 0.064897, "end_time": "2021-07-20T13:16:00.401230", "exception": false, "start_time": "2021-07-20T13:16:00.336333", "status": "completed" }, "tags": [] }, "source": [ "## Path of the different files (pre-defined python functions, sympy equations, sympy variables)" ] }, { "cell_type": "code", "execution_count": 2, "id": "indonesian-parker", "metadata": { "execution": { "iopub.execute_input": "2021-07-20T13:16:00.547540Z", "iopub.status.busy": "2021-07-20T13:16:00.545995Z", "iopub.status.idle": "2021-07-20T13:16:00.550599Z", "shell.execute_reply": "2021-07-20T13:16:00.549023Z" }, "papermill": { "duration": 0.08518, "end_time": "2021-07-20T13:16:00.550946", "exception": false, "start_time": "2021-07-20T13:16:00.465766", "status": "completed" }, "tags": [ "parameters" ] }, "outputs": [], "source": [ "path_variable = '../../theory/pyFile_storage/theory_variable.py'\n", "path_equation = '../../theory/pyFile_storage/theory_equation.py' \n", "path_analysis_functions = '../../theory/pyFile_storage/analysis_functions.py'\n", "path_data = '../../../data/eddycovdata/'\n", "dates_fPAR = '../../../data/fpar_howard_spring/dates_v5'\n", "\n", "stress_factor_reconstruct = \"stress_factor_reconstruct.png\"\n", "constant_VS_fPAR = \"constant_VS_fPAR.png\"\n", "complete_VS_incomplete = \"complete_VS_incomplete.png\"" ] }, { "cell_type": "code", "execution_count": 3, "id": "descending-rendering", "metadata": { "execution": { "iopub.execute_input": "2021-07-20T13:16:00.708377Z", "iopub.status.busy": "2021-07-20T13:16:00.707555Z", "iopub.status.idle": "2021-07-20T13:16:00.710880Z", "shell.execute_reply": "2021-07-20T13:16:00.711652Z" }, "papermill": { "duration": 0.096747, "end_time": "2021-07-20T13:16:00.711948", "exception": false, "start_time": "2021-07-20T13:16:00.615201", "status": "completed" }, "tags": [ "injected-parameters" ] }, "outputs": [], "source": [ "# Parameters\n", "path_variable = \"notebooks/theory/pyFile_storage/theory_variable.py\"\n", "path_equation = \"notebooks/theory/pyFile_storage/theory_equation.py\"\n", "path_analysis_functions = \"notebooks/theory/pyFile_storage/analysis_functions.py\"\n", "path_data = \"data/eddycovdata/\"\n", "dates_fPAR = \"data/fpar_howard_spring/dates_v5\"\n", "stress_factor_reconstruct = (\n", " \"notebooks/Finished_project/meaning_stress_factor/stress_factor_reconstruct.png\"\n", ")\n", "constant_VS_fPAR = (\n", " \"notebooks/Finished_project/meaning_stress_factor/constant_VS_fPAR.png\"\n", ")\n", "complete_VS_incomplete = (\n", " \"notebooks/Finished_project/meaning_stress_factor/complete_VS_incomplete.png\"\n", ")\n" ] }, { "cell_type": "markdown", "id": "considered-texas", "metadata": { "papermill": { "duration": 0.060885, "end_time": "2021-07-20T13:16:00.845097", "exception": false, "start_time": "2021-07-20T13:16:00.784212", "status": "completed" }, "tags": [] }, "source": [ "## Importing the sympy variables and equations defined in the theory.ipynb notebook" ] }, { "cell_type": "code", "execution_count": 4, "id": "clear-bibliography", "metadata": { "execution": { "iopub.execute_input": "2021-07-20T13:16:01.004589Z", "iopub.status.busy": "2021-07-20T13:16:01.003422Z", "iopub.status.idle": "2021-07-20T13:16:02.594279Z", "shell.execute_reply": "2021-07-20T13:16:02.592960Z" }, "papermill": { "duration": 1.668234, "end_time": "2021-07-20T13:16:02.594545", "exception": false, "start_time": "2021-07-20T13:16:00.926311", "status": "completed" }, "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "theta_sat\n", "theta_res\n", "alpha\n", "n\n", "m\n", "S_mvg\n", "theta\n", "h\n", "S\n", "theta_4\n", "theta_3\n", "theta_2\n", "theta_1\n", "L\n", "Mw\n", "Pv\n", "Pvs\n", "R\n", "T\n", "c1\n", "T0\n", "Delta\n", "E\n", "G\n", "H\n", "Rn\n", "LE\n", "gamma\n", "alpha_PT\n", "c_p\n", "w\n", "kappa\n", "z\n", "u_star\n", "VH\n", "d\n", "z_om\n", "z_oh\n", "r_a\n", "g_a\n", "r_s\n", "g_s\n", "c1_e\n", "c2_e\n", "e\n", "T_min\n", "T_max\n", "RH_max\n", "RH_min\n", "e_a\n", "e_s\n", "iv_T\n", "T_kv\n", "P\n", "rho_a\n", "VPD\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "eq_m_n\n", "eq_MVG_neg_case\n", "eq_MVG\n", "eq_sat_degree\n", "eq_MVG_h\n", "eq_h_FC\n", "eq_theta_4_3\n", "eq_theta_2_1\n", "eq_water_stress_simple\n", "eq_Pvs_T\n", "eq_Delta\n", "eq_PT\n", "eq_PM\n", "eq_PM_VPD\n", "eq_PM_g\n", "eq_PM_inv\n" ] } ], "source": [ "for code in [path_variable,path_equation]:\n", " name_code = code[-20:-3]\n", " spec = importlib.util.spec_from_file_location(name_code, code)\n", " mod = importlib.util.module_from_spec(spec)\n", " spec.loader.exec_module(mod)\n", " names = getattr(mod, '__all__', [n for n in dir(mod) if not n.startswith('_')])\n", " glob = globals()\n", " for name in names:\n", " print(name)\n", " glob[name] = getattr(mod, name)" ] }, { "cell_type": "markdown", "id": "extreme-amendment", "metadata": { "papermill": { "duration": 0.073848, "end_time": "2021-07-20T13:16:02.735363", "exception": false, "start_time": "2021-07-20T13:16:02.661515", "status": "completed" }, "tags": [] }, "source": [ "## Importing the performance assessment functions defined in the analysis_function.py file" ] }, { "cell_type": "code", "execution_count": 5, "id": "mounted-exception", "metadata": { "execution": { "iopub.execute_input": "2021-07-20T13:16:02.876405Z", "iopub.status.busy": "2021-07-20T13:16:02.875613Z", "iopub.status.idle": "2021-07-20T13:16:02.890627Z", "shell.execute_reply": "2021-07-20T13:16:02.889703Z" }, "papermill": { "duration": 0.092114, "end_time": "2021-07-20T13:16:02.890861", "exception": false, "start_time": "2021-07-20T13:16:02.798747", "status": "completed" }, "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "AIC\n", "AME\n", "BIC\n", "CD\n", "CP\n", "IoA\n", "KGE\n", "MAE\n", "MARE\n", "ME\n", "MRE\n", "MSRE\n", "MdAPE\n", "NR4MS4E\n", "NRMSE\n", "NS\n", "NSC\n", "PDIFF\n", "PEP\n", "R4MS4E\n", "RAE\n", "RMSE\n", "RMedSE\n", "RVE\n", "bias\n", "np\n", "nt\n" ] } ], "source": [ "for code in [path_analysis_functions]:\n", " name_code = code[-20:-3]\n", " spec = importlib.util.spec_from_file_location(name_code, code)\n", " mod = importlib.util.module_from_spec(spec)\n", " spec.loader.exec_module(mod)\n", " names = getattr(mod, '__all__', [n for n in dir(mod) if not n.startswith('_')])\n", " glob = globals()\n", " for name in names:\n", " print(name)\n", " glob[name] = getattr(mod, name)" ] }, { "cell_type": "markdown", "id": "american-soundtrack", "metadata": { "papermill": { "duration": 0.067871, "end_time": "2021-07-20T13:16:03.025469", "exception": false, "start_time": "2021-07-20T13:16:02.957598", "status": "completed" }, "tags": [] }, "source": [ "## Data import, preprocess and shape for the computations" ] }, { "cell_type": "markdown", "id": "unauthorized-bullet", "metadata": { "papermill": { "duration": 0.063491, "end_time": "2021-07-20T13:16:03.155717", "exception": false, "start_time": "2021-07-20T13:16:03.092226", "status": "completed" }, "tags": [] }, "source": [ "### Get the different files where data are stored\n", "\n", "Eddy-covariance data from the OzFlux network are stored in **.nc** files (NetCDF4 files) which is roughly a panda data frame with meta-data (see https://www.unidata.ucar.edu/software/netcdf/ for more details about NetCDF4 file format). fPAR data are stored in **.txt** files" ] }, { "cell_type": "code", "execution_count": 6, "id": "bigger-establishment", "metadata": { "execution": { "iopub.execute_input": "2021-07-20T13:16:03.294721Z", "iopub.status.busy": "2021-07-20T13:16:03.293304Z", "iopub.status.idle": "2021-07-20T13:16:03.298410Z", "shell.execute_reply": "2021-07-20T13:16:03.297251Z" }, "papermill": { "duration": 0.076458, "end_time": "2021-07-20T13:16:03.298633", "exception": false, "start_time": "2021-07-20T13:16:03.222175", "status": "completed" }, "tags": [] }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "['data/eddycovdata/fpar_adelaide_v5.txt', 'data/eddycovdata/fpar_daly_v5.txt', 'data/eddycovdata/fpar_dry_v5.txt', 'data/eddycovdata/fpar_howard_v5.txt', 'data/eddycovdata/fpar_sturt_v5.txt']\n", "['data/eddycovdata/AdelaideRiver_L4.nc', 'data/eddycovdata/DalyUncleared_L4.nc', 'data/eddycovdata/DryRiver_L4.nc', 'data/eddycovdata/HowardSprings_L4.nc', 'data/eddycovdata/SturtPlains_L4.nc']\n" ] } ], "source": [ "fPAR_files = []\n", "eddy_files = []\n", "\n", "for file in os.listdir(path_data):\n", " if file.endswith(\".txt\"):\n", " fPAR_files.append(os.path.join(path_data, file))\n", " elif file.endswith(\".nc\"):\n", " eddy_files.append(os.path.join(path_data, file))\n", " \n", "fPAR_files.sort()\n", "print(fPAR_files)\n", "eddy_files.sort()\n", "print(eddy_files)" ] }, { "cell_type": "markdown", "id": "behavioral-secret", "metadata": { "papermill": { "duration": 0.068208, "end_time": "2021-07-20T13:16:03.433215", "exception": false, "start_time": "2021-07-20T13:16:03.365007", "status": "completed" }, "tags": [] }, "source": [ "### Define and test a function that process the fPAR data\n", "In the **.txt** files, only one value per month is given for the fPAR. The following function takes one .txt file containing data about the fPAR coefficients, and the related dates, stored in the a seperate file. The fPAR data (date and coefficients) are cleaned (good string formatting), mapped together and averaged to output one value per month (the fPAR measurement period doesn't spans the measurement period of the eddy covariance data)" ] }, { "cell_type": "code", "execution_count": 7, "id": "extra-medicare", "metadata": { "execution": { "iopub.execute_input": "2021-07-20T13:16:03.580701Z", "iopub.status.busy": "2021-07-20T13:16:03.573567Z", "iopub.status.idle": "2021-07-20T13:16:03.585661Z", "shell.execute_reply": "2021-07-20T13:16:03.584558Z" }, "papermill": { "duration": 0.089601, "end_time": "2021-07-20T13:16:03.586041", "exception": false, "start_time": "2021-07-20T13:16:03.496440", "status": "completed" }, "tags": [] }, "outputs": [], "source": [ "def fPAR_data_process(fPAR_file,dates_fPAR):\n", " \n", " fparv5_dates = np.genfromtxt(dates_fPAR, dtype='str', delimiter=',')\n", " fparv5_dates = pd.to_datetime(fparv5_dates[:,1], format=\"%Y%m\")\n", " dates_pd = pd.date_range(fparv5_dates[0], fparv5_dates[-1], freq='MS')\n", "\n", " fparv5_howard = np.loadtxt(fPAR_file,delimiter=',', usecols=3 )\n", " fparv5_howard[fparv5_howard == -999] = np.nan\n", " fparv5_howard_pd = pd.Series(fparv5_howard, index = fparv5_dates)\n", " fparv5_howard_pd = fparv5_howard_pd.resample('MS').max()\n", "\n", " # convert fparv5_howard_pd to dataframe\n", " fPAR_pd = pd.DataFrame(fparv5_howard_pd)\n", " fPAR_pd = fPAR_pd.rename(columns={0:\"fPAR\"})\n", " fPAR_pd.index = fPAR_pd.index.rename(\"time\")\n", "\n", " # convert fPAR_pd to xarray to aggregate the data\n", " fPAR_xr = fPAR_pd.to_xarray()\n", " fPAR_agg = fPAR_xr.fPAR.groupby('time.month').max()\n", "\n", " # convert back to dataframe\n", " fPAR_pd = fPAR_agg.to_dataframe()\n", " Month = np.arange(1,13)\n", " Month_df = pd.DataFrame(Month)\n", " Month_df.index = fPAR_pd.index\n", " Month_df = Month_df.rename(columns={0:\"Month\"})\n", "\n", " fPAR_mon = pd.concat([fPAR_pd,Month_df], axis = 1)\n", " \n", " return(fPAR_mon)" ] }, { "cell_type": "code", "execution_count": 8, "id": "funky-speaking", "metadata": { "execution": { "iopub.execute_input": "2021-07-20T13:16:03.767261Z", "iopub.status.busy": "2021-07-20T13:16:03.758518Z", "iopub.status.idle": "2021-07-20T13:16:03.811022Z", "shell.execute_reply": "2021-07-20T13:16:03.810270Z" }, "papermill": { "duration": 0.15361, "end_time": "2021-07-20T13:16:03.811272", "exception": false, "start_time": "2021-07-20T13:16:03.657662", "status": "completed" }, "tags": [] }, "outputs": [ { "data": { "text/html": [ "
\n", " | fPAR | \n", "Month | \n", "
---|---|---|
month | \n", "\n", " | \n", " |
1 | \n", "0.78 | \n", "1 | \n", "
2 | \n", "0.84 | \n", "2 | \n", "
3 | \n", "0.79 | \n", "3 | \n", "
4 | \n", "0.84 | \n", "4 | \n", "
5 | \n", "0.71 | \n", "5 | \n", "
6 | \n", "0.75 | \n", "6 | \n", "
7 | \n", "0.60 | \n", "7 | \n", "
8 | \n", "0.54 | \n", "8 | \n", "
9 | \n", "0.52 | \n", "9 | \n", "
10 | \n", "0.67 | \n", "10 | \n", "
11 | \n", "0.73 | \n", "11 | \n", "
12 | \n", "0.78 | \n", "12 | \n", "
\n", " | latitude | \n", "longitude | \n", "time | \n", "Fe | \n", "Fn | \n", "Fg | \n", "Ws | \n", "Sws | \n", "Ta | \n", "ustar | \n", "... | \n", "Fn_QCFlag | \n", "Fg_QCFlag | \n", "Ws_QCFlag | \n", "Sws_QCFlag | \n", "Ta_QCFlag | \n", "ustar_QCFlag | \n", "RH_QCFlag | \n", "VPD_QCFlag | \n", "fPAR | \n", "error | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
time | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2016-01-01 | \n", "-12.4952 | \n", "131.15005 | \n", "2016-01-01 | \n", "0.000070 | \n", "206.663669 | \n", "3.010310 | \n", "2.561668 | \n", "0.157900 | \n", "302.140316 | \n", "0.642854 | \n", "... | \n", "0.000000 | \n", "1.041667 | \n", "0.000000 | \n", "0.00 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.78 | \n", "0.000033 | \n", "
2016-01-02 | \n", "-12.4952 | \n", "131.15005 | \n", "2016-01-02 | \n", "0.000061 | \n", "190.624095 | \n", "3.332525 | \n", "2.881215 | \n", "0.150468 | \n", "302.581487 | \n", "0.770923 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.00 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.0 | \n", "0.78 | \n", "0.000034 | \n", "
2016-01-03 | \n", "-12.4952 | \n", "131.15005 | \n", "2016-01-03 | \n", "0.000077 | \n", "193.395385 | \n", "8.767265 | \n", "2.199078 | \n", "0.155324 | \n", "302.239956 | \n", "0.652901 | \n", "... | \n", "7.500000 | \n", "166.250000 | \n", "153.750000 | \n", "157.50 | \n", "153.750000 | \n", "0.750000 | \n", "153.750000 | \n", "0.0 | \n", "0.78 | \n", "0.000032 | \n", "
2016-01-04 | \n", "-12.4952 | \n", "131.15005 | \n", "2016-01-04 | \n", "0.000101 | \n", "213.666286 | \n", "6.134695 | \n", "2.158660 | \n", "0.154047 | \n", "302.167654 | \n", "0.644330 | \n", "... | \n", "10.416667 | \n", "227.500000 | \n", "213.541667 | \n", "218.75 | \n", "213.541667 | \n", "1.041667 | \n", "213.541667 | \n", "0.0 | \n", "0.78 | \n", "0.000032 | \n", "
2016-01-05 | \n", "-12.4952 | \n", "131.15005 | \n", "2016-01-05 | \n", "0.000102 | \n", "215.143544 | \n", "8.402115 | \n", "2.109156 | \n", "0.148717 | \n", "302.745469 | \n", "0.634869 | \n", "... | \n", "10.416667 | \n", "227.500000 | \n", "213.541667 | \n", "218.75 | \n", "213.541667 | \n", "1.041667 | \n", "213.541667 | \n", "0.0 | \n", "0.78 | \n", "0.000030 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2016-12-27 | \n", "-12.4952 | \n", "131.15005 | \n", "2016-12-27 | \n", "0.000036 | \n", "78.264130 | \n", "-2.143734 | \n", "0.935192 | \n", "0.193120 | \n", "299.873800 | \n", "0.300746 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "162.291667 | \n", "0.00 | \n", "0.000000 | \n", "0.791667 | \n", "0.000000 | \n", "0.0 | \n", "0.78 | \n", "0.000058 | \n", "
2016-12-28 | \n", "-12.4952 | \n", "131.15005 | \n", "2016-12-28 | \n", "0.000027 | \n", "63.387278 | \n", "-5.455608 | \n", "1.407992 | \n", "0.207409 | \n", "299.701627 | \n", "0.324596 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "187.916667 | \n", "0.00 | \n", "0.000000 | \n", "0.916667 | \n", "0.000000 | \n", "0.0 | \n", "0.78 | \n", "0.000060 | \n", "
2016-12-29 | \n", "-12.4952 | \n", "131.15005 | \n", "2016-12-29 | \n", "0.000066 | \n", "152.046311 | \n", "4.866939 | \n", "1.614556 | \n", "0.195984 | \n", "301.062104 | \n", "0.540755 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "153.750000 | \n", "0.00 | \n", "0.000000 | \n", "0.750000 | \n", "0.000000 | \n", "0.0 | \n", "0.78 | \n", "0.000057 | \n", "
2016-12-30 | \n", "-12.4952 | \n", "131.15005 | \n", "2016-12-30 | \n", "0.000018 | \n", "34.171569 | \n", "-6.993181 | \n", "1.818007 | \n", "0.195555 | \n", "300.033565 | \n", "0.383059 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "77.916667 | \n", "0.00 | \n", "0.000000 | \n", "0.416667 | \n", "0.000000 | \n", "0.0 | \n", "0.78 | \n", "0.000050 | \n", "
2016-12-31 | \n", "-12.4952 | \n", "131.15005 | \n", "2016-12-31 | \n", "0.000060 | \n", "148.405680 | \n", "4.302383 | \n", "2.431514 | \n", "0.196216 | \n", "302.251514 | \n", "0.693060 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "6.250000 | \n", "0.00 | \n", "0.000000 | \n", "0.250000 | \n", "0.000000 | \n", "0.0 | \n", "0.78 | \n", "0.000053 | \n", "
366 rows × 24 columns
\n", "