import_apsim_db

Imports data from SQLite databases (*.db) applied by APSIM
Next Generation. It reads one file at a time.

A compilation of more than 80 functions designed to quantitatively and visually evaluate prediction performance of regression (continuous variables) and classification (categorical variables) of point-forecast models (e.g. APSIM, DSSAT, DNDC, supervised Machine Learning). For regression, it includes functions to generate plots (scatter, tiles, density, & Bland-Altman plot), and to estimate error metrics (e.g. MBE, MAE, RMSE), error decomposition (e.g. lack of accuracy-precision), model efficiency (e.g. NSE, E1, KGE), indices of agreement (e.g. d, RAC), goodness of fit (e.g. r, R2), adjusted correlation coefficients (e.g. CCC, dcorr), symmetric regression coefficients (intercept, slope), and mean absolute scaled error (MASE) for time series predictions. For classification (binomial and multinomial), it offers functions to generate and plot confusion matrices, and to estimate performance metrics such as accuracy, precision, recall, specificity, F-score, Cohen's Kappa, G-mean, and many more. For more details visit the vignettes <https://adriancorrendo.github.io/metrica/>.

Adrian A. Correndo

metrica

Prediction Performance Metrics

Luiz H. Moro Rosso

Rai Schwalbert

Carlos Hernandez

Leonardo M. Bastos

Luciana Nieto

Dean Holzworth

Ignacio A. Ciampitti

import_apsim_db function

<dl><dt>filename</dt>
<dd>file name including the file extension ("*.db"), as a string ("").</dd>
<dt>folder</dt>
<dd>source folder/directory containing the file, as a string ("").</dd>
<dt>value</dt>
<dd>either &#8216;report&#8217;, &#8216;all&#8217; (list) or user-defined for a specific report.</dd>
<dt>simplify</dt>
<dd>if TRUE will attempt to simplify multiple reports into a single data.frame.
If FALSE it will return a list. Default: TRUE.</dd></dl>

Arguments

Import SQLite databases generated by APSIM NextGen — import_apsim_db

<dl>

<dt>filename</dt>
<dd>file name including the file extension ("*.db"), as a string ("").</dd>


<dt>folder</dt>
<dd>source folder/directory containing the file, as a string ("").</dd>


<dt>value</dt>
<dd>either &#8216;report&#8217;, &#8216;all&#8217; (list) or user-defined for a specific report.</dd>


<dt>simplify</dt>
<dd>if TRUE will attempt to simplify multiple reports into a single data.frame.
If FALSE it will return a list. Default: TRUE.</dd>

</dl>

import_apsim_db: Import SQLite databases generated by APSIM NextGen

Description

Usage

Value

Arguments

References

Examples