In [ ]:

    

from __future__ import division
import pymongo, pandas, random


    

In [ ]:

    

connection = pymongo.MongoClient('localhost', 27017)
communities = connection.database_names()

for db in ["gender", "admin", "local", "visualizations", "results"]:
    if db in communities:communities.remove(db)


    

In [ ]:

    

for community in communities:
    community_db = connection[community]['statistics']
    
    cursor = community_db.find({'contributions_total': {'$gt':0}, 'gender': {'$ne': "Unknown"}},
                       {u'_id': False, u'gender':True,
                       'questions_total':True,'answers_total':True,'comments_total':True,'contributions_total':True,
                       'accepted_rate':True,'mean_utility':True,'questions_avg':True,
                       'lifetime':True,'activity_freq':True,})
    
    df =  pandas.DataFrame(list(cursor))

    df.to_csv("/Users/milena/Desktop/results/"+community+".csv")