Aggregates multiple columns of a DataFrame

pip install a-pandas-ex-mindex-aggregate

from a_pandas_ex_mindex_aggregate import pd_add_mindex_aggregate
import pandas as pd
pd_add_mindex_aggregate()
df = pd.read_csv("https://github.com/pandas-dev/pandas/raw/main/doc/data/titanic.csv")

     PassengerId  Survived  Pclass  ...     Fare Cabin  Embarked
0              1         0       3  ...   7.2500   NaN         S
1              2         1       1  ...  71.2833   C85         C
2              3         1       3  ...   7.9250   NaN         S
3              4         1       1  ...  53.1000  C123         S
4              5         0       3  ...   8.0500   NaN         S
..           ...       ...     ...  ...      ...   ...       ...
886          887         0       2  ...  13.0000   NaN         S
887          888         1       1  ...  30.0000   B42         S
888          889         0       3  ...  23.4500   NaN         S
889          890         1       1  ...  30.0000  C148         C
890          891         0       3  ...   7.7500   NaN         Q
[891 rows x 12 columns]


df.d_multiindex_aggregate(['Fare', 'Age'])

              PassengerId Survived  ...          Cabin Embarked
Fare     Age                        ...                        
0.0000   19.0       [303]      [0]  ...          [nan]      [S]
         25.0       [272]      [1]  ...          [nan]      [S]
         36.0       [180]      [0]  ...          [nan]      [S]
         38.0       [823]      [0]  ...          [nan]      [S]
         39.0       [807]      [0]  ...          [A36]      [S]
                   ...      ...  ...            ...      ...
263.0000 23.0        [89]      [1]  ...  [C23 C25 C27]      [S]
         24.0       [342]      [1]  ...  [C23 C25 C27]      [S]
         64.0       [439]      [0]  ...  [C23 C25 C27]      [S]
512.3292 35.0  [259, 738]   [1, 1]  ...    [nan, B101]   [C, C]
         36.0       [680]      [1]  ...  [B51 B53 B55]      [C]
[815 rows x 10 columns]