// Contains the one-to-one mapping of EIA plants to their operators, but
// we only have the 860 data integrated for 2011 forward right now.
plants_eia860 = pd.read_sql(
"""SELECT * FROM plants_eia860""", pudl_engine)
plants_eia860 = plants_eia860[["year", "plant_id", "operator_id"]]
// For the PUDL Utility & Plant IDs, as well as utility & plant names:
utils_eia = pd.read_sql("""SELECT * FROM utilities_eia""", pudl_engine)
After Change
pt = models.PUDLBase.metadata.tables
// Most of the fields we want come direclty from Fuel Receipts & Costs
frc_tbl = pt["fuel_receipts_costs_eia923"]
frc_select = sa.sql.select([frc_tbl, ])
frc_df = pd.read_sql(frc_select, pudl_engine)
// Need a year column to merge with EIA860 data which is annual.
frc_df["year"] = pd.to_datetime(frc_df["report_date"]).dt.year
