Python - Agrupar tabla

df = pd.DataFrame({'A': ["aa", "bb", "aa", "cc", "bb","cc"],'B': ["casa", "libro", "arbol", "lapiz","goma","gato"],'C': [12, 2, 7, 3, 6,9]}, columns=['A', 'B', 'C'])

df.groupby(["A"])['C'].max()

import pandas as pd

df = pd.DataFrame({'A': ["aa", "bb", "aa", "cc", "bb","cc"],

                   'B': ["casa", "libro", "arbol", "lapiz","goma","gato"],

                   'C': [12, 2, 7, 3, 6,9]},

                  columns=['A', 'B', 'C'])

df.groupby(['A', 'B']).agg(minimum_C = pd.NamedAgg(column='C', aggfunc='max'))

aa arbol 7

   casa 12

bb goma 6

 libro 2

cc gato 9

 lapiz  3

import pandas as pd

df = pd.DataFrame({'A': ["aa", "bb", "aa", "cc", "bb","cc"],

                   'B': ["casa", "libro", "arbol", "lapiz","goma","gato"],

                   'C': [12, 2, 7, 3, 6,9]},

                  columns=['A', 'B', 'C'])

def myMax(data):

    if (data[0][1] > data[2][1]):

        return data[0]

    else:

        return data[2]

df['result'] = list(zip(df.B, df.C))

df = df.groupby(['A']).agg(result = pd.NamedAgg('result', myMax))

df['result'] = df['result'].apply(lambda row: row[0])

df

df['result'] = df[['B', 'C']].apply(tuple, axis=1)

df = df.groupby('A').agg(result = pd.NamedAgg('result', lambda data: data.apply(lambda row: row[0])[data.apply(lambda row: row[1]).idxmax()]))

df.apply(lambda row: (row[0], (row[1], row[2])), 1, result_type='expand').groupby(0).agg(result = (1, lambda data: data.apply(lambda row: row[0])[data.apply(lambda row: row[1]).idxmax()]))

import pandas as pd

df = pd.DataFrame({'A': ["aa", "bb", "aa", "cc", "bb","cc"],

                   'B': ["casa", "libro", "arbol", "lapiz","goma","gato"],

                   'C': [12, 2, 7, 3, 6,9]},

                  columns=['A', 'B', 'C'])

df.iloc[df.groupby('A').agg(result = ('C', lambda data: data.idxmax())).result][['A', 'B']]