Python 如何重命名pivot_table中的aggfunc

发布于08月14日

我得到了DataFrame:

df = pd.pivot_table(df, values=['Values'],
                                 index=['Division', 'Perfomer'],
                                 columns=['Completed on time'], aggfunc=[np.sum, len], margins=True, fill_value=0)

如何重命名aggfunc:np.sum-&gt；‘Sum of Labor Cost’；len-&gt；‘Number of Taskes’？

推荐答案

希望下面的代码能有所帮助.

import pandas as pd
import numpy as np

# Sample data for illustration
data = {
    'Division': ['A', 'A', 'B', 'B'],
    'Perfomer': ['X', 'Y', 'X', 'Y'],
    'Completed on time': ['Yes', 'No', 'Yes', 'No'],
    'Values': [10, 20, 30, 40]
}

df = pd.DataFrame(data)

df_pivot = pd.pivot_table(df, values=['Values'],
                          index=['Division', 'Perfomer'],
                          columns=['Completed on time'],
                          aggfunc=[np.sum, len],
                          margins=True,
                          fill_value=0)

# Rename columns
df_pivot.columns = df_pivot.columns.set_levels(['Sum of labor costs', 'Number of tasks'], level=0)
df_pivot.reset_index(inplace=True)  # Flatten the index for better visualization
print(df_pivot)