通过填充使Dataframe列的长度达到一定的字数

Question

我的数据帧看起来像

Abc                       XYZ 
0  Hello      How are you doing today
1   Good                    This is a
2    Bye                      See you
3  Books     Read chapter 1 to 5 only

max_words=6，filler_word='end'。在XYZ列中，我想填充它，这样所有行的长度都是max_words。

期望输出

Abc                       XYZ
0  Hello               How are you end end end
1   Good               This is a end end end
2    Bye               See you end end end end
3  Books               Read chapter 1 to 5 only

第3行没有填充，因为它的长度已经是6。

Answer 1

IIUC，试试这个：

df['XYZ'] = df['XYZ'].str.split(expand=True)
.fillna('end')
.apply(lambda x: x.str.cat(sep=' '), axis=1)
print(df)

输出：

Abc                          XYZ
0  Hello  How are you doing today end
1   Good        This is a end end end
2    Bye      See you end end end end
3  Books     Read chapter 1 to 5 only