0f92cc61bcaed024402e71ca94cc414228473484,pudl/transform/ferc1.py,,plants_pumped_storage,#Any#Any#,564

Before Change

    // grab table from dictionary of dfs
    ferc1_pumped_storage_df = ferc1_raw_dfs["plants_pumped_storage_ferc1"]

    ferc1_pumped_storage_df.drop(["spplmnt_num", "row_number", "row_seq",
                                  "row_prvlg", "report_prd"],
                                 axis=1, inplace=True)

    // Standardize plant_name capitalization and remove leading/trailing white
    // space -- necesary b/c plant_name is part of many foreign keys.
    ferc1_pumped_storage_df["plant_name"] = \
        ferc1_pumped_storage_df["plant_name"].str.strip()
    ferc1_pumped_storage_df["plant_name"] = \
        ferc1_pumped_storage_df["plant_name"].str.title()

    // Converting kWh to MWh
    ferc1_pumped_storage_df["net_generation_mwh"] = \
        ferc1_pumped_storage_df["net_generation"] / 1000.0
    ferc1_pumped_storage_df.drop("net_generation", axis=1, inplace=True)

    ferc1_pumped_storage_df["energy_used_for_pumping_mwh"] = \
        ferc1_pumped_storage_df["energy_used"] / 1000.0
    ferc1_pumped_storage_df.drop("energy_used", axis=1, inplace=True)

After Change

    
    // grab table from dictionary of dfs
    ferc1_pumped_storage_df = clean_cols(
        ferc1_raw_dfs["plants_pumped_storage_ferc1"])

    // Standardize plant_name capitalization and remove leading/trailing white
    // space -- necesary b/c plant_name is part of many foreign keys.
    ferc1_pumped_storage_df["plant_name"] = \
        ferc1_pumped_storage_df["plant_name"].str.strip()
    ferc1_pumped_storage_df["plant_name"] = \
        ferc1_pumped_storage_df["plant_name"].str.title()

    // Converting kWh to MWh
    ferc1_pumped_storage_df["net_generation_mwh"] = \
        ferc1_pumped_storage_df["net_generation"] / 1000.0
    ferc1_pumped_storage_df.drop("net_generation", axis=1, inplace=True)

    ferc1_pumped_storage_df["energy_used_for_pumping_mwh"] = \
        ferc1_pumped_storage_df["energy_used"] / 1000.0
    ferc1_pumped_storage_df.drop("energy_used", axis=1, inplace=True)

Instances