Breaking News: Grepper is joining You.com. Read the official announcement!

Remove empty cells and move content to the left Python

Juan Andres Russy Cervera answered on August 9, 2022 Popularity 2/10 Helpfulness 1/10

answer Remove empty cells and move content to the left Python

Remove empty cells and move content to the left Python

Comment

Ok, then I propose to transpose the dataset, process it, and transpose it back.

import pandas as pd
import numpy as np

df = pd.DataFrame(
    {
        "A": ["ABC", "DEF", "XYZ"],
        "B": ["XLS", "XLS", "XLS"],
        "C": ["1231341231", "1231231231", "1231231233"],
        "D": ["123123asdad1923", "1231823asda9123", "2138820394832sd"],
        "E": [np.nan, np.nan, np.nan],
        "F": [np.nan, "askda213", np.nan],
        "I": ["blabla", "blabla", np.nan],
        "K": ["123123asdad1923", "123123asdad1923", "asdasdq2ew12332"],
    }
)

print(df)
# transpose
df_transposed = df.T
# move NaN at end of column
df_transposed = df_transposed.apply(lambda x: pd.Series(x.dropna().values))
# replace Nan by empty strings
df_transposed.replace(np.nan, "", inplace=True)
# transpose back
df = df_transposed.T
print()
print(df)

Popularity 2/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: cells move python

Link to this answer
Share Copy Link