nrel_p3.analysis.Analysis

class Analysis(pt_estimate, wd_report)

Bases: object

Analyze pricing tool estimate versus worday report.

Parameters:

• pt_estimate (nrel_p3.pricing_tool.Estimate) – Initialized pricing tool Estimate object.

• wd_report (nrel_p3.workday_report.Report) – Initialized workday report object

Methods

get_spend_table([filters])	Get a timeseries spend table for the whole project, one charge code, or by person
get_worker_spend([filters])	Get a timeseries spend table with worker breakdowns.

get_spend_table(filters=None)

Get a timeseries spend table for the whole project, one charge code, or by person

Parameters:

filters (dict | None) – Set of filters where keys are columns in the pt_estimate and wd_report data and values are one or more items to sub select in the column. For example, filters={'charge_code': '12765.07.01.01', 'eid': '19864'} will return data for a single charge code for a single person.

Returns:

df (pd.DataFrame) – Timeseries cost table with columns: ‘Year-Month’, ‘planned_cost’, ‘planned_cost_cumulative’, ‘actual_cost’, ‘actual_cost_cumulative’

get_worker_spend(filters=None)

Get a timeseries spend table with worker breakdowns.

Parameters:

filters (dict | None) – Set of filters where keys are columns in the pt_estimate and wd_report data and values are one or more items to sub select in the column. For example, filters={'charge_code': '12765.07.01.01'} will return data for a single charge code

Returns:

df (pd.DataFrame) – Timeseries cost table with columns: ‘Year-Month’, ‘planned_cost’, ‘planned_cost_cumulative’, ‘actual_cost’, ‘actual_cost_cumulative’, ‘eid’, ‘worker’