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
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
Close
Hashes for a_pandas_ex_obj_into_cell-0.10.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 82d466301101931851e801660ee17cf06f5676a05033e67e304eee5b49d441a1 |
|
MD5 | fad1104c706014ffbfad84c544b1b409 |
|
BLAKE2b-256 | 31a48358f1ac704a95088892ee1edd4649916f211492291d22dd101ba7a77839 |
Close
Hashes for a_pandas_ex_obj_into_cell-0.10-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 54a64a2032b3fa5a932d0c3ba7c2275fdd002b9713e0668cd581bfa54be575b8 |
|
MD5 | b2a7cbbb45519eac61e7b1850f8e0028 |
|
BLAKE2b-256 | 91686dd0b4a29bcbe870d4d9f08e484b75792eaccfd60b0d12095755fb688dfc |