find_number_of_participants_per_party.py
d59172c8e7a5master

find_number_of_participants_per_party.py
View Options

			import pandas as pd

			filename = "../results/participants-csv/participants_cop25.csv"

			participants = pd.read_csv(filename, encoding="utf-8-sig")

			grouped = participants.groupby("affiliation")

			country_and_nb_part = pd.DataFrame(columns={"country", "nb of participants"})

			for affiliation, people in grouped:
			df = pd.DataFrame(people)
			if df["affiliation_category"].iloc[0] == "parties":
			print(f"{affiliation} : {len(people)}")
			country_and_nb_part = country_and_nb_part.append({
			"country": affiliation,
			"nb of participants": len(people)
			}, ignore_index=True)

			country_and_nb_part.to_csv("cop25_per_party.csv", encoding="utf-8-sig", mode="w", index=False)