Move non-empty cells to the left in pandas DataFrame

by

First, make function.

        def squeeze_nan(x):
            original_columns = x.index.tolist()

            squeezed = x.dropna()
            squeezed.index = [original_columns[n] for n in range(squeezed.count())]

            return squeezed.reindex(original_columns, fill_value=np.nan)

Second, apply the function.

df.apply(squeeze_nan, axis=1)

You can also try axis=0 and .[::-1] to squeeze nan to any direction.

[EDIT]

@Mxracer888 you want this?

def squeeze_nan(x, hold):
    if x.name not in hold:
        original_columns = x.index.tolist()

        squeezed = x.dropna()
        squeezed.index = [original_columns[n] for n in range(squeezed.count())]

        return squeezed.reindex(original_columns, fill_value=np.nan)
    else:
        return x

df.apply(lambda x: squeeze_nan(x, ['B']), axis=1)

enter image description here

More Related Contents:

  1. How do I select rows from a DataFrame based on column values?
  2. Aggregation in Pandas
  3. Pandas Melt Function
  4. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  5. Python Pandas: Check if string in one column is contained in string of another column in the same row
  6. First non-null value per row from a list of Pandas columns
  7. Pandas: Filtering multiple conditions
  8. Fastest way to populate QTableView from Pandas data frame
  9. Get data from pandas into a SQL server with PYODBC
  10. Pivoting a Pandas Dataframe containing strings – ‘No numeric types to aggregate’ error
  11. how do I calculate a rolling idxmax
  12. binning a dataframe in pandas in Python [duplicate]
  13. What is the difference between pandas agg and apply function?
  14. Pandas sparse dataFrame to sparse matrix, without generating a dense matrix in memory
  15. Dictionary column in pandas dataframe
  16. How do I split a string into several columns in a dataframe with pandas Python?
  17. Convert a columns of string to list in pandas
  18. Loading multiple csv files of a folder into one dataframe
  19. Pandas: combining header rows of a multiIndex DataFrame
  20. pandas groupby and join lists
  21. Selecting pandas column by location
  22. Row-wise average for a subset of columns with missing values
  23. Plot multiple columns of pandas DataFrame using Seaborn
  24. How to solve import error for pandas?
  25. Dynamically filtering a pandas dataframe
  26. Pandas: Creating aggregated column in DataFrame
  27. Pandas combining rows based on dates
  28. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  29. Preserving column order in Python Pandas DataFrame
  30. Convert dates to pd.to_datetime where month could be either a number or month name

Leave a Comment