ed04f04e014da8ea597ff00b3f3f15c7e6d6fefe,src/pudl/transform/eia861.py,,sales,#Any#,653

Before Change

    logger.info("Tidying the EIA 861 Sales table.")
    // Clean up values just enough to use primary key columns as a multi-index:
    logger.debug("Cleaning up EIA861 Sales index columns so we can tidy data.")
    clean_sales = (
        tfr_dfs["sales_eia861"].copy()
        .assign(balancing_authority_code_eia=lambda x: x.balancing_authority_code_eia.fillna("UNK"))
        .dropna(subset=["utility_id_eia"])
        .query("utility_id_eia not in (88888, 99999)")
        .astype({"utility_id_eia": pd.Int64Dtype()})
        .set_index(idx_cols)
    )
    // Split the table into index, data, and "denormalized" columns for processing:
    // Separate customer classes and reported data into a hierarchical index
    logger.debug("Stacking EIA861 Sales data columns by customer class.")
    data_cols = _filter_customer_cols(clean_sales, CUSTOMER_CLASSES)

After Change

    ]

    // Pre-tidy clean specific to sales table
    raw_sales = (
        tfr_dfs["sales_eia861"].copy()
        .query("utility_id_eia not in (88888, 99999)")
    )

    //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    // Tidy Data:
    //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Instances