# build_input¶

Module to create Input space and its child spaces from input data.

This module contains a function build_input(), which creates “Input” space and its subspaces by reading input data into them from an Excel file.

By default, build_input() reads data from input.xlsm in the same folder as this module, and the structure of Input space is illustrated by the diagram below.

Below are descriptions of Input spaces and its subspaces.

Input

The parent module of all other input spaces.

Some tables in input.xlsm are imported as cells directly under this space.

PolicyData

The sample policy data read from PolicyData tab in input.xlsm. Records and fields of PolicyData represents policies and policy attributes respectively. Each record of PolicyData is accessible as a dynamic space under PolicyData space indexed by Policy column in the input table. Each field of a record is accessible as a scalar cells in the dynamic space corresponding to the record.

For example:

>>> model.Input.PolicyData[3].PolicyTerm()


gives the value of the policy term of the policy record 3.

MortalityTables

The sample mortality tables read from Mortality tab. For Each mortality table, a dynamic space is created indexed by TableID, and MortalityTable cells indexed by Sex and Age is created in that space.

The script below will return the mortality rate of Male, Age 41 from the mortality table 3:

>>> model.Input.MortalityTables[3].MortalityTable('M', 41)

ProductSpec

The sample product spec table read from ProductSpec tab. ProductSpec dynamic subspaces holds parameters to specify products as cells. The dynamic subspaces are indexed by Product, PolType and Gen, and each of the subspace has scalar cells defined by the columns of ProductSpec tab other than the index columns.

Empty cells in the index columns are imported as None. Cells.match method treats None as the wildcard when finding the closest matching indexes for the given arguments.

Assumption

The sample assumption table read from Assumption tab.

The Assumption space has dynamic subspaces indexed by Product, PolType and Gen, each of which has scalar cells defined by the columns of Assumption tab other than the index columns.

Empty cells in the index columns are imported as None. Cells.match method treats None as the wildcard when finding the closest matching indexes for the given arguments.

AssumptionTables

The sample assumption table read from AssumptionTables tab. The tab holds assumptions by policy duration, such as mortality factors and lapse assumptions.

Each assumption in the table is imported as a cells in the AssumptionTables space.

Scenarios
The sample scenario table read from Scenarios tab. TODO

Functions

 build_input(model[, input_file]) Create “Input” space and its sub spaces by reading data from an Excel file into it.
solvency2.build_input.build_input(model, input_file='input.xlsx')[source]

Create “Input” space and its sub spaces by reading data from an Excel file into it.

This function creates a space named “Input” under model, reads tables from input_file into cells and subspaces under the “Input” space.

By default, this function assumes reading data from input.xlsm located in the same folder as this module.

Parameters: model – Model object in which ‘Input’ space is created. input_file (str) – Path to the Excel input file.