Combine columns into strings ignoring None

Question

This is the dataframe that i have:

list = [['man walks', 'slowly', 'back'], ['slowly','None', 'None'], ['sunny','sons','None']]
df1 = pd.DataFrame(list)

which results in this dataframe

    0             1      2
0   man walks   slowly  back
1   slowly      None    None
2   sunny       sons    None

How do I add the contents of each row together ONLY IF the value is not equal to None? Desired Result is another column that looks like this:

    Sum
0  man walks slowly back 
1  slowly
2  sunny sons

Thank you so much!

yatu · Accepted Answer · 2020-04-13 11:18:05Z

1

Those None are actually strings in your example. Assuming they are indeed None, you can use stack (which removes missing values by default), groupby and aggregate with join:

df1.stack().groupby(level=0).agg(' '.join)

0    man walks slowly back
1                   slowly
2               sunny sons
dtype: object

answered Apr 13, 2020 at 11:18

yatu

88.7k12 gold badges93 silver badges148 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combine columns into strings ignoring None

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related