pudl.load

Routines for loading PUDL data into various storage formats.

Module Contents

Functions

dfs_to_sqlite(dfs: Dict[str, pandas.DataFrame], engine: sqlalchemy.engine.Engine, check_foreign_keys: bool = True, check_types: bool = True, check_values: bool = True) → None

Load a dictionary of dataframes into the PUDL SQLite DB.

Attributes

logger

MINIMUM_SQLITE_VERSION

pudl.load.logger[source]
pudl.load.MINIMUM_SQLITE_VERSION = 3.32.0[source]
pudl.load.dfs_to_sqlite(dfs: Dict[str, pandas.DataFrame], engine: sqlalchemy.engine.Engine, check_foreign_keys: bool = True, check_types: bool = True, check_values: bool = True) None[source]

Load a dictionary of dataframes into the PUDL SQLite DB.

Parameters
  • dfs – Dictionary mapping table names to dataframes.

  • engine – PUDL DB connection engine.

  • check_foreign_keys – if True, enforce foreign key constraints.

  • check_types – if True, enforce column data types.

  • check_values – if True, enforce value constraints.