Description:
apandasexmindexaggregate 0.10
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]
License
For personal and professional use. You cannot resell or redistribute these repositories in their original state.
Customer Reviews
There are no reviews.
