import pandas as pd


def main():
    corpus_df = pd.read_excel("data/migration/corpus_titoli_2013_2021_with_most_recent_years.xlsx")
    ratings = corpus_df.groupby("Testata").first()[["Orientamento politico", "Religiosa?"]]
    ratings.index.rename("provider", inplace=True)
    ratings["political_stance"] = ratings["Orientamento politico"]
    ratings["religious"] = ratings["Religiosa?"] == "religiosa"
    ratings.drop("Orientamento politico", axis=1, inplace=True)
    ratings.drop("Religiosa?", axis=1, inplace=True)

    ratings.to_csv("data/migration/provider_pol_rel_ratings.csv")


if __name__ == "__main__":
    main()