Aggregates multiple columns of a DataFrame
Project description
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]
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file a_pandas_ex_mindex_aggregate-0.10.tar.gz.
File metadata
- Download URL: a_pandas_ex_mindex_aggregate-0.10.tar.gz
- Upload date:
- Size: 4.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.1 CPython/3.9.13
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 0a75d6c27364caed51a2157eed53a9873c034f1a545cc68ac608131301164fe3 |
|
| MD5 | 52cecdc4d8e154c8b14b05ac2e47d51e |
|
| BLAKE2b-256 | a1707da0e84bc1f1dff77963ef5ab671904b55ac36c67a71e333330ade0020f5 |
File details
Details for the file a_pandas_ex_mindex_aggregate-0.10-py3-none-any.whl.
File metadata
- Download URL: a_pandas_ex_mindex_aggregate-0.10-py3-none-any.whl
- Upload date:
- Size: 5.9 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.1 CPython/3.9.13
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 42c3bd70ac9a34287eed615e3c24cb2855b69dd72a663ced3bd3b247054c3bd7 |
|
| MD5 | 2aa45e84c1dfc1406a276be1c3fe40ed |
|
| BLAKE2b-256 | 731d39061a90bdcbf47d16e8e8f1780670f549ec01f9d98e60e0743ae3531a0f |
