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]'''