find_biggest_delegations.py
f3a3b0f515a6master

find_biggest_delegations.py
View Options

			import sys
			import os
			import pandas as pd

			""" Finds the top ten biggest party delegation and top ten biggest NGO
			delegation of a meeting (of which the label is given as an argument).
			"""

			args = sys.argv
			if len(args) != 2:
			sys.exit("Please provide one argument that contains the label \
			of the meeting to proceed")

			label = args[1]

			datafile_name = "../results/participants-csv/participants_" + label + ".csv"
			# generate the data if not yet available
			if not os.path.isfile(datafile_name):
			sys.exit("There is no datafile for this meeting. Please check if given \
			label is a valid label")

			data = pd.read_csv(datafile_name, encoding="utf-8-sig")
			data_by_affiliation = data.groupby("affiliation")

			parties = []
			NGOs = []
			for affiliation, delegates in data_by_affiliation:
			df = pd.DataFrame(delegates)
			if df["affiliation_category"].iloc[0] == "parties":
			parties.append((affiliation, len(delegates)))
			if df["affiliation_category"].iloc[0] == "non-governmental organizations":
			NGOs.append((affiliation, len(delegates)))

			parties.sort(reverse=True, key=(lambda x: x[1]))
			NGOs.sort(reverse=True, key=(lambda x: x[1]))

			print("Biggest delegations of " + label)
			print("Parties")
			print(parties[:10])
			print("NGO's")
			print(NGOs[:10])