def submitted_projects(raw_df):
    """
    Return all submitted projects.
    """
    df = raw_df.astype({'PRONAC': str, 'CgcCpf': str})
    submitted_projects = df.groupby('CgcCpf')[
        'PRONAC'
    ].agg(['unique', 'nunique'])

    submitted_projects.columns = ['pronac_list', 'num_pronacs']

    return submitted_projects
def submitted_projects ( raw_df ) : df = raw_df . astype ( { 'PRONAC' : str , 'CgcCpf' : str } ) submitted_projects = df . groupby ( 'CgcCpf' ) [ 'PRONAC' ] . agg ( [ 'unique' , 'nunique' ] ) submitted_projects . columns = [ 'pronac_list' , 'num_pronacs' ] return submitted_projects
Return all submitted projects.