f"Column {col} not found in dataframe for association harvesting."
"All columns must be present in all dataframes."
)
return pd.concat([df[cols] for df in dfs]).dropna().drop_duplicates()
def normalize_balancing_authority(tfr_dfs):
After Change
assn = pd.DataFrame()
for df in dfs:
if set(df.columns).issuperset(set(cols)):
assn = assn.append(df[cols])
assn = assn.dropna().drop_duplicates()
if assn.empty:
raise ValueError(
"These dataframes contain no associations for the columns: "