我的示例df有四列包含NaN
值。目标是将所有行拼接在一起,同时排除掉NaN
值。
import pandas as pd
import numpy as np
df = pd.DataFrame({'keywords_0':["a", np.nan, "c"],
'keywords_1':["d", "e", np.nan],
'keywords_2':[np.nan, np.nan, "b"],
'keywords_3':["f", np.nan, "g"]})
keywords_0 keywords_1 keywords_2 keywords_3
0 a d NaN f
1 NaN e NaN NaN
2 c NaN b g
希望实现以下目标:
keywords_0 keywords_1 keywords_2 keywords_3 keywords_all
0 a d NaN f a,d,f
1 NaN e NaN NaN e
2 c NaN b g c,b,g
伪代码:
cols = [df.keywords_0, df.keywords_1, df.keywords_2, df.keywords_3]
df["keywords_all"] = df["keywords_all"].apply(lambda cols: ",".join(cols), axis=1)
我知道我可以使用",".join()
来获得精确的结果,但我不确定如何将列名传递到函数中。
['keywords_0', 'keywords_1', 'keywords_2', 'keywords_3']
,对吗? - Rayhane Mama