a-pandas-ex-obj-into-cell 0.12

Description:

apandasexobjintocell 0.12

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