def get_drug_info(df):
    """ Get max phase per drug"""

    result = df \
        .groupby('drug_id').agg(
        max_phase=('phase', 'max')
        ) \
        .reset_index()

    # Rename drug_id to id
    result.rename(columns={'drug_id': 'id'} , inplace= True)
    return result