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]

Project details

These details have not been verified by PyPI

Project links

Homepage

GitHub Statistics

View statistics for this project via Libraries.io, or by using our public dataset on Google BigQuery

Release history Release notifications | RSS feed

This version

0.10

Dec 21, 2022

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

a_pandas_ex_mindex_aggregate-0.10.tar.gz (4.1 kB view hashes)

Uploaded Dec 21, 2022 Source

Built Distribution

a_pandas_ex_mindex_aggregate-0.10-py3-none-any.whl (5.9 kB view hashes)

Uploaded Dec 21, 2022 Python 3

Hashes for a_pandas_ex_mindex_aggregate-0.10.tar.gz

Hashes for a_pandas_ex_mindex_aggregate-0.10.tar.gz
Algorithm	Hash digest
SHA256	`0a75d6c27364caed51a2157eed53a9873c034f1a545cc68ac608131301164fe3`
MD5	`52cecdc4d8e154c8b14b05ac2e47d51e`
BLAKE2b-256	`a1707da0e84bc1f1dff77963ef5ab671904b55ac36c67a71e333330ade0020f5`

Hashes for a_pandas_ex_mindex_aggregate-0.10-py3-none-any.whl

Hashes for a_pandas_ex_mindex_aggregate-0.10-py3-none-any.whl
Algorithm	Hash digest
SHA256	`42c3bd70ac9a34287eed615e3c24cb2855b69dd72a663ced3bd3b247054c3bd7`
MD5	`2aa45e84c1dfc1406a276be1c3fe40ed`
BLAKE2b-256	`731d39061a90bdcbf47d16e8e8f1780670f549ec01f9d98e60e0743ae3531a0f`