pudl.transform.rus7#
Transform the RUS7 tables.
Attributes#
Functions#
Transform the meeting and board (aka governance) table. |
|
Transform the balance sheet assets table. |
|
Transform the balance sheet liabilities table. |
|
|
Transform the borrowers table. |
Transform the employee statistics table. |
|
Transform the energy efficiency table. |
|
Early transform an internal power_requirements table. |
|
Transform the power requirements of electric sales table. |
|
|
Transform the power requirements of electric customers table. |
|
Transform the power requirements table. |
|
Transform the investments table. |
|
Transform the core_rus7__yearly_investments table. |
|
Transform the patronage capital table. |
Transform the statement of operations table. |
|
|
Transform the owed by consumer table. |
Transform the service_interruptions table. |
|
Transform the transmission_and_distribution table. |
|
|
Transform the long term leases table. |
|
Transform the raw_rus7__loans and raw_rus7__loan_guarantees tables. |
Transform the raw_rus7__external_financial_risk_ratio table. |
|
|
Transform the raw_rus7__energy_purchased table. |
Transform the materials and supplies table. |
|
Transform the utility plant changes table. |
|
|
Harvesting IDs & consistent static attributes for RUS7 entity. |
Module Contents#
- pudl.transform.rus7._core_rus7__yearly_meeting_and_board(raw_rus7__meeting_and_board)[source]#
Transform the meeting and board (aka governance) table.
- pudl.transform.rus7._core_rus7__yearly_balance_sheet_assets(raw_rus7__balance_sheet)[source]#
Transform the balance sheet assets table.
- pudl.transform.rus7._core_rus7__yearly_balance_sheet_liabilities(raw_rus7__balance_sheet)[source]#
Transform the balance sheet liabilities table.
- pudl.transform.rus7._core_rus7__scd_borrowers(raw_rus7__borrowers)[source]#
Transform the borrowers table.
- pudl.transform.rus7._core_rus7__yearly_employee_statistics(raw_rus7__employee_statistics)[source]#
Transform the employee statistics table.
- pudl.transform.rus7._core_rus7__yearly_energy_efficiency(raw_rus7__energy_efficiency)[source]#
Transform the energy efficiency table.
- pudl.transform.rus7._core_rus7__power_requirements(raw_rus7__power_requirements)[source]#
Early transform an internal power_requirements table.
This main input gets used serval times in several downstream
core_rus7__yearly_power_requirements*assets. The raw asset needs some cleaning and dropping of duplicate records so we do it once.
- pudl.transform.rus7._core_rus7__yearly_power_requirements_electric_sales(_core_rus7__power_requirements: pandas.DataFrame) pandas.DataFrame[source]#
Transform the power requirements of electric sales table.
The resulting table is a portion of the power_requirements tables, which pertains to the sales and revenue of electricity.
- pudl.transform.rus7._core_rus7__yearly_power_requirements_electric_customers(_core_rus7__power_requirements: pandas.DataFrame) pandas.DataFrame[source]#
Transform the power requirements of electric customers table.
The resulting table is a portion of the power_requirements tables, which pertains to the number of customers in different customer classes.
- pudl.transform.rus7._core_rus7__yearly_power_requirements(_core_rus7__power_requirements: pandas.DataFrame) pandas.DataFrame[source]#
Transform the power requirements table.
The resulting table is a portion of the power_requirements tables, which pertains to the revenue from several portions of the borrower’s business as well as several types of electricity generated, purchased or used.
- pudl.transform.rus7._core_rus7__yearly_investments(raw_rus7__investments: pandas.DataFrame) pandas.DataFrame[source]#
Transform the investments table.
- pudl.transform.rus7._core_rus7__yearly_long_term_debt(raw_rus7__long_term_debt: pandas.DataFrame) pandas.DataFrame[source]#
Transform the core_rus7__yearly_investments table.
- pudl.transform.rus7._core_rus7__yearly_patronage_capital(raw_rus7__patronage_capital: pandas.DataFrame) pandas.DataFrame[source]#
Transform the patronage capital table.
- pudl.transform.rus7._core_rus7__yearly_statement_of_operations(raw_rus7__statement_of_operations: pandas.DataFrame) pandas.DataFrame[source]#
Transform the statement of operations table.
- pudl.transform.rus7._core_rus7__consumer_debt(raw_rus7__owed_by_customers: pandas.DataFrame)[source]#
Transform the owed by consumer table.
This transform splits the owed_by_consumers table into one table describing general consumer debts and one table describing the status of energy efficiency and conservation loan program debts.
- pudl.transform.rus7._core_rus7__yearly_service_interruptions(raw_rus7__service_interruptions: pandas.DataFrame) pandas.DataFrame[source]#
Transform the service_interruptions table.
- pudl.transform.rus7._core_rus7__transmission_and_distribution(raw_rus7__transmission_and_distribution: pandas.DataFrame)[source]#
Transform the transmission_and_distribution table.
- pudl.transform.rus7._core_rus7__yearly_long_term_leases(raw_rus7__long_term_leases: pandas.DataFrame) pandas.DataFrame[source]#
Transform the long term leases table.
- pudl.transform.rus7._core_rus7__yearly_loans(raw_rus7__loan_guarantees: pandas.DataFrame, raw_rus7__loans: pandas.DataFrame) pandas.DataFrame[source]#
Transform the raw_rus7__loans and raw_rus7__loan_guarantees tables.
- pudl.transform.rus7._core_rus7__yearly_external_financial_risk_ratio(raw_rus7__external_financial_risk_ratio: pandas.DataFrame) pandas.DataFrame[source]#
Transform the raw_rus7__external_financial_risk_ratio table.
- pudl.transform.rus7._core_rus7__yearly_energy_purchased(raw_rus7__energy_purchased: pandas.DataFrame) pandas.DataFrame[source]#
Transform the raw_rus7__energy_purchased table.
- pudl.transform.rus7._core_rus7__yearly_materials_and_supplies(raw_rus7__materials_and_supplies: pandas.DataFrame) pandas.DataFrame[source]#
Transform the materials and supplies table.
- pudl.transform.rus7._core_rus7__yearly_utility_plant_changes(raw_rus7__utility_plant_changes: pandas.DataFrame)[source]#
Transform the utility plant changes table.