find_average_participants.py
f3a3b0f515a6master

find_average_participants.py
View Options

			""" Finds the average numbers of participants for COP meetings and for SB meetings
			Could be improved by using the metadata file.
			"""

			import pandas as pd
			import os

			complete_data = pd.read_csv("../results/complete_dataset.csv",
			encoding="utf-8-sig")

			# COPs
			sum = 0
			for i in range(1, 26):
			data = pd.read_csv("../results/participants-csv/participants_cop" + str(i) + ".csv",
			encoding="utf-8-sig")

			sum += len(data)

			data = pd.read_csv("../results/participants-csv/participants_cop6b.csv",
			encoding="utf-8-sig")
			sum += len(data)

			print(f"COPs have in average {sum/26} participants")


			# SB
			sum = 0
			count = 0
			for i in range(1, 51):
			path = "../results/participants-csv/participants_sb" + str(i) + ".csv"
			if os.path.isfile(path):
			count += 1
			data = pd.read_csv(path, encoding="utf-8-sig")
			sum += len(data)

			print(f"SBs have in average {sum/count} participants")