Tool to read model data from a table
Project description
Tool to define random variables in a table. The main purpose is to support the EAM framework.
Free software: Apache Software License 2.0
Installation
pip install eam-data-tools
You can also install the in-development version with:
pip install https://github.com/dschien/eam-data-tools/archive/master.zip
Documentation
Usage
# Example Given an excel file with rows similar to the below
variable |
scenario |
type |
ref value |
param |
initial_value_proportional_variation |
unit |
mean growth |
variability growth |
ref date |
label |
comment |
source |
a |
exp |
10 |
0.4 |
kg |
-0.20 |
0.10 |
01/01/2009 |
test var 1 |
||||
b |
interp |
{“2010-01-01”:1, “2010-03-01”:100 , “2010-12-01”:110} |
linear |
0.4 |
kg |
-0.20 |
0.10 |
01/01/2009 |
test var 1 |
Write code that references these variables and generates random distributions in pandas dataframes with pint-pandas units.:
repository = ParameterRepository() TableParameterLoader(filename='./test_v2.xlsx', excel_handler='xlrd').load_into_repo(sheet_name='Sheet1', repository=repository) p = repository.get_parameter('a') settings = {'sample_size': 3, 'times': pd.date_range('2016-01-01', '2017-01-01', freq='MS'), 'sample_mean_value': False, 'use_time_series': True} val = p(settings) series = val.pint.m
Changelog
0.0.0 (2020-04-04)
First release on PyPI.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for eam_data_tools-1.4.3-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 38733bc7a7a61fa84cecee51a2450f318b75edfcf1ea2bfe959fd3522acdaadc |
|
MD5 | bce2b5b8cdbe1683a5a02a311f6aa4e7 |
|
BLAKE2b-256 | 2243e68bf24c6eecf6aca328f2b627431cd02edf3cf90128d488df23b0654a5d |