Skip to main content

Puts objects into cells / columns of a Pandas Dataframe

Project description

Puts objects into cells / columns of a Pandas Dataframe

pip install a-pandas-ex-obj-into-cell
Not best (Pandas) practice, but sometimes very useful :)
from a_pandas_ex_obj_into_cell import pd_add_obj_into_cells

import pandas as pd



pd_add_obj_into_cells()

df = pd.read_csv(

    "https://raw.githubusercontent.com/pandas-dev/pandas/main/doc/data/titanic.csv"

)



d1 = df.d_one_object_to_several_cells(

    column="test1",

    value=({1: ("xx", 331, 11)}),

    indexlist=[1, 2, 3, 7],

    ffill=True,

    bfill=True,

)



print(d1)

d2 = df.d_list_items_to_cells(

    column="test2",

    values=[

        [

            1,

            32,

            4,

        ],

        {33: "dfd", 0: [3, 2]},

        4,

        (5, 34),

    ],

    indexlist=[1, 4, 6, 9],

    ffill=False,

    bfill=False,

)

print(d2)





'''     

PassengerId  Survived  Pclass  ... Cabin Embarked                 test1

0              1         0       3  ...   NaN        S  {1: ('xx', 331, 11)}

1              2         1       1  ...   C85        C  {1: ('xx', 331, 11)}

2              3         1       3  ...   NaN        S  {1: ('xx', 331, 11)}

3              4         1       1  ...  C123        S  {1: ('xx', 331, 11)}

4              5         0       3  ...   NaN        S  {1: ('xx', 331, 11)}

..           ...       ...     ...  ...   ...      ...                   ...

886          887         0       2  ...   NaN        S  {1: ('xx', 331, 11)}

887          888         1       1  ...   B42        S  {1: ('xx', 331, 11)}

888          889         0       3  ...   NaN        S  {1: ('xx', 331, 11)}

889          890         1       1  ...  C148        C  {1: ('xx', 331, 11)}

890          891         0       3  ...   NaN        Q  {1: ('xx', 331, 11)}

[891 rows x 13 columns]

     PassengerId  Survived  Pclass  ... Cabin Embarked                   test2

0              1         0       3  ...   NaN        S                    <NA>

1              2         1       1  ...   C85        C              [1, 32, 4]

2              3         1       3  ...   NaN        S                    <NA>

3              4         1       1  ...  C123        S                    <NA>

4              5         0       3  ...   NaN        S  {33: 'dfd', 0: [3, 2]}

..           ...       ...     ...  ...   ...      ...                     ...

886          887         0       2  ...   NaN        S                     NaN

887          888         1       1  ...   B42        S                     NaN

888          889         0       3  ...   NaN        S                     NaN

889          890         1       1  ...  C148        C                     NaN

890          891         0       3  ...   NaN        Q                     NaN

[891 rows x 13 columns]'''

Project details


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_obj_into_cell-0.12.tar.gz (4.4 kB view hashes)

Uploaded Source

Built Distribution

a_pandas_ex_obj_into_cell-0.12-py3-none-any.whl (6.2 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page