Merge multiple column values into one column in python pandas

by

You can call apply pass axis=1 to apply row-wise, then convert the dtype to str and join:

In [153]:
df['ColumnA'] = df[df.columns[1:]].apply(
    lambda x: ','.join(x.dropna().astype(str)),
    axis=1
)
df

Out[153]:
  Column1  Column2  Column3  Column4  Column5  ColumnA
0       a        1        2        3        4  1,2,3,4
1       a        3        4        5      NaN    3,4,5
2       b        6        7        8      NaN    6,7,8
3       c        7        7      NaN      NaN      7,7

Here I call dropna to get rid of the NaN, however we need to cast again to int so we don’t end up with floats as str.

More Related Contents:

  1. Find row where values for column is maximal in a pandas DataFrame
  2. Python pandas insert list into a cell
  3. Pandas dataframe get first row of each group
  4. Pandas DataFrame to List of Dictionaries
  5. Pandas DataFrame stored list as string: How to convert back to list
  6. Pandas expand rows from list data available in column
  7. python pandas flatten a dataframe to a list
  8. “unstack” a pandas column containing lists into multiple rows [duplicate]
  9. Why does df.apply(tuple) work but not df.apply(list)?
  10. Convert list into a pandas dataframe
  11. Convert List to Pandas Dataframe Column
  12. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  13. How to split a dataframe string column into two columns?
  14. Comparing two dataframes and getting the differences [duplicate]
  15. set difference for pandas
  16. Nested dictionary to multiindex dataframe where dictionary keys are column labels
  17. Python pandas: how to specify data types when reading an Excel file?
  18. Pandas filling missing dates and values within group
  19. Use groupby in Pandas to count things in one column in comparison to another
  20. pandas unique values multiple columns
  21. How to find which columns contain any NaN value in Pandas dataframe
  22. Python Pandas Group by date using datetime data
  23. Pandas – dataframe groupby – how to get sum of multiple columns
  24. Mapping ranges of values in pandas dataframe [duplicate]
  25. Convert month int to month name in Pandas
  26. Calculate summary statistics of columns in dataframe
  27. How to use str.contains() with multiple expressions in pandas dataframes
  28. Check if certain value is contained in a dataframe column in pandas [duplicate]
  29. UnicodeDecodeError when reading CSV file in Pandas
  30. how to understand closed and label arguments in pandas resample method?

Leave a Comment