In [29]:

    

import sys
sys.path.insert(0, '/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python')
sys.path.insert(0, '/Library/Python/2.7/site-packages')


    

In [30]:

    

import pandas as pd
import numpy as np
import os


    

In [31]:

    

surveys = os.listdir("experts+friends")


    

In [37]:

    

for each in surveys:
    if each.count("_ideas.csv"):
        continue
        
    df = pd.read_csv("experts+friends/" + each, header=0)
    voters = np.unique(df['Session ID'])
    print(each, "Number of votes: %d" % len(df.index), "Number of unique voters: %d" % len(voters))


    

    




('wikisurvey_eviction_votes.csv', 'Number of votes: 980', 'Number of unique voters: 32')
('wikisurvey_gpa_votes.csv', 'Number of votes: 530', 'Number of unique voters: 24')
('wikisurvey_grit_votes.csv', 'Number of votes: 299', 'Number of unique voters: 9')
('wikisurvey_job_training_votes.csv', 'Number of votes: 33', 'Number of unique voters: 4')
('wikisurvey_layoff_votes.csv', 'Number of votes: 32', 'Number of unique voters: 4')
('wikisurvey_material_hardship_votes.csv', 'Number of votes: 777', 'Number of unique voters: 31')

In [38]:

    

surveys = os.listdir("mturks")


    

In [39]:

    

for each in surveys:
    if each.count("_ideas.csv"):
        continue
        
    df = pd.read_csv("mturks/" + each, header=0)
    voters = np.unique(df['Session ID'])
    print(each, "Number of votes: %d" % len(df.index), "Number of unique voters: %d" % len(voters))


    

    




('wikisurvey_eviction_votes.csv', 'Number of votes: 3741', 'Number of unique voters: 113')
('wikisurvey_gpa_votes.csv', 'Number of votes: 5130', 'Number of unique voters: 137')
('wikisurvey_grit_votes.csv', 'Number of votes: 4419', 'Number of unique voters: 110')
('wikisurvey_job_training_votes.csv', 'Number of votes: 4434', 'Number of unique voters: 129')
('wikisurvey_layoff_votes.csv', 'Number of votes: 3964', 'Number of unique voters: 115')
('wikisurvey_material_hardship_votes.csv', 'Number of votes: 5533', 'Number of unique voters: 127')

In [ ]: