Analyse Person-level Metrics in Python

Here is a cleaned-up example on how to load in a csv file and to run the above person-averaging function: 

import pandas as pd

# path to person query
sq_data = pd.read_csv('../data/demo spq.csv')

# function for person-averaging
def analyse_metric(data, metric, hrvar):
    data = data.groupby(['PersonId',hrvar])
    data = data[metric].mean()
    data = data.reset_index()
    data = data.groupby(hrvar)
    output = data[metric].mean()
    return output

# run function
analyse_metric(data = sq_data, metric = "Collaboration_hours", hrvar = "Organization")