More than 3 years have passed since last update.

pandas DataFrameで最大最小値の行名,列名を取得(argmax/argmin)

Python
pandas

Last updated at 2021-12-12Posted at 2021-12-12

こんな感じでとれます

import pandas as pd
import numpy as np

def argmaxdf(table):
    argmax=lambda A: np.unravel_index(np.array(A).argmax(), np.array(A).shape)
    row, col = argmax(table.values)
    row, col = table.index[row], table.columns[col]
    return row, col

table = pd.DataFrame(pd.DataFrame(np.random.rand(5,8),
                                  index=list("abcde"),
                                  columns=list("fghijklm")))

display(table,
        argmaxdf(table)
       )

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up