iode.Equations.to_frame
- Equations.to_frame() DataFrame[source]
Create a pandas DataFrame from the current Equations database. The index of the returned DataFrame is build from the Equations names.
See also
Equations.from_seriesEquations.from_frame
Examples
>>> from iode import SAMPLE_DATA_DIR, equations >>> import pandas as pd >>> equations.load(f"{SAMPLE_DATA_DIR}/fun.eqs") Loading .../fun.eqs 274 objects loaded >>> len(equations) 274
>>> # Export the IODE Equations database as a pandas DataFrame >>> df = equations.to_frame() >>> len(df) 274
>>> df.index.to_list() ['ACAF', 'ACAG', 'AOUC', ..., 'YSSG', 'ZF', 'ZJ', 'ZZF_'] >>> equations["ACAF"] Equation(endogenous = 'ACAF', lec = '(ACAF/VAF[-1]) :=acaf1+acaf2*GOSF[-1]+\nacaf4*(TIME=1995)', method = 'LSQ', from_period = '1980Y1', to_period = '1996Y1', block = 'ACAF', tests = {corr = 1, dw = 2.32935, fstat = 32.2732, loglik = 83.8075, meany = 0.00818467, r2 = 0.821761, r2adj = 0.796299, ssres = 5.19945e-05, stderr = 0.00192715, stderrp = 23.5458, stdev = 0.0042699}, date = '12-06-1998') >>> df.loc["ACAF"] lec (ACAF/VAF[-1]) :=acaf1+acaf2*GOSF[-1]+\nacaf4*... method LSQ sample 1980Y1:1996Y1 comment instruments block ACAF corr 1.0 stdev 0.00427 meany 0.008185 ssres 0.000052 stderr 0.001927 stderrp 23.545813 fstat 32.273193 r2 0.821761 r2adj 0.796299 dw 2.329346 loglik 83.807526 date 12-06-1998 Name: ACAF, dtype: object >>> equations["YDH_"] Equation(endogenous = 'YDH_', lec = 'grt YDH_ :=grt((WBU_+YN+GOSH_+IDH)-(SSF+SSH+DTH)+(SBH+OCUH))', method = 'LSQ', comment = ' ', block = 'YDH_') >>> df.loc["YDH_"] lec grt YDH_ :=grt((WBU_+YN+GOSH_+IDH)-(SSF+SSH+DT... method LSQ sample None comment instruments block YDH_ corr 0.0 stdev 0.0 meany 0.0 ssres 0.0 stderr 0.0 stderrp 0.0 fstat 0.0 r2 0.0 r2adj 0.0 dw 0.0 loglik 0.0 date Name: YDH_, dtype: object
>>> # Export a subset of the IODE Equations database as a pandas DataFrame >>> df = equations["A*;*_"].to_frame() >>> len(df) 29
>>> df.index.to_list() ['ACAF', 'ACAG', 'AOUC', ..., 'WNF_', 'YDH_', 'ZZF_'] >>> equations["ACAF"] Equation(endogenous = 'ACAF', lec = '(ACAF/VAF[-1]) :=acaf1+acaf2*GOSF[-1]+\nacaf4*(TIME=1995)', method = 'LSQ', from_period = '1980Y1', to_period = '1996Y1', block = 'ACAF', tests = {corr = 1, dw = 2.32935, fstat = 32.2732, loglik = 83.8075, meany = 0.00818467, r2 = 0.821761, r2adj = 0.796299, ssres = 5.19945e-05, stderr = 0.00192715, stderrp = 23.5458, stdev = 0.0042699}, date = '12-06-1998') >>> df.loc["ACAF"] lec (ACAF/VAF[-1]) :=acaf1+acaf2*GOSF[-1]+\nacaf4*... method LSQ sample 1980Y1:1996Y1 comment instruments block ACAF corr 1.0 stdev 0.00427 meany 0.008185 ssres 0.000052 stderr 0.001927 stderrp 23.545813 fstat 32.273193 r2 0.821761 r2adj 0.796299 dw 2.329346 loglik 83.807526 date 12-06-1998 Name: ACAF, dtype: object >>> equations["YDH_"] Equation(endogenous = 'YDH_', lec = 'grt YDH_ :=grt((WBU_+YN+GOSH_+IDH)-(SSF+SSH+DTH)+(SBH+OCUH))', method = 'LSQ', comment = ' ', block = 'YDH_') >>> df.loc["YDH_"] lec grt YDH_ :=grt((WBU_+YN+GOSH_+IDH)-(SSF+SSH+DT... method LSQ sample None comment instruments block YDH_ corr 0.0 stdev 0.0 meany 0.0 ssres 0.0 stderr 0.0 stderrp 0.0 fstat 0.0 r2 0.0 r2adj 0.0 dw 0.0 loglik 0.0 date Name: YDH_, dtype: object