pandas combine two strings ignore nan values

by

Call fillna and pass an empty str as the fill value and then sum with param axis=1:

In [3]:
df = pd.DataFrame({'a':['asd',np.NaN,'asdsa'], 'b':['asdas','asdas',np.NaN]})
df

Out[3]:
       a      b
0    asd  asdas
1    NaN  asdas
2  asdsa    NaN

In [7]:
df['a+b'] = df.fillna('').sum(axis=1)
df

Out[7]:
       a      b       a+b
0    asd  asdas  asdasdas
1    NaN  asdas     asdas
2  asdsa    NaN     asdsa

More Related Contents:

  1. Filter pandas DataFrame by substring criteria
  2. How to change the datetime format in Pandas
  3. How to test if a string contains one of the substrings in a list, in pandas?
  4. Pandas filtering for multiple substrings in series
  5. Create Pandas DataFrame from a string
  6. Remove unwanted parts from strings in a column
  7. Find column whose name contains a specific string
  8. add a string prefix to each value in a string column using Pandas
  9. pandas dataframe str.contains() AND operation
  10. Pandas DataFrame stored list as string: How to convert back to list
  11. Pandas Extract Number from String
  12. Add Leading Zeros to Strings in Pandas Dataframe
  13. Pandas column access w/column names containing spaces
  14. How to remove square bracket from pandas dataframe
  15. Remove non-ASCII characters from pandas column
  16. NLTK-based text processing with pandas
  17. Count number of words per row
  18. Converting a column within pandas dataframe from int to string
  19. removing newlines from messy strings in pandas dataframe cells?
  20. Print very long string completely in pandas dataframe
  21. Convert a columns of string to list in pandas
  22. Capitalize first letter of each word in a dataframe column
  23. pandas: replace string with another string
  24. Pandas read_csv dtype leading zeros
  25. FutureWarning: The default value of regex will change from True to False in a future version
  26. Column of lists, convert list to string as a new column
  27. How to use str.contains() with multiple expressions in pandas dataframes
  28. Filtering pandas dataframe rows by contains str
  29. Copy text between parentheses in pandas DataFrame column into another column
  30. pandas – convert string into list of strings [duplicate]

Leave a Comment