Untitled

import pandas as pd

old_data_path = "path_to_old_data.csv"
new_data_path = "path_to_new_data.csv"
output_path = "combined_table_data.csv"

old_data = pd.read_csv(old_data_path)
new_data = pd.read_csv(new_data_path)

combined_data = pd.merge(
    old_data, 
    new_data, 
    on="TABLE_NAME", 
    how="outer", 
    suffixes=("_OLD", "_NEW")
)

combined_data.to_csv(output_path, index=False)

print(f"Combined data saved to: {output_path}")