python-3.x - 如何在 Pandas 的字符串列中的一行中获取多个句子

Question

我有以下数据框。我需要删除两个句子之间的空格，并将其合二为一。

输入 ：

id  text
1   compliant solve.
    today  query clear
2   branch visit on date-16/02/2018
    contact person
    xyz -101010101
3   visit on date-16/06/2018
    contact person-ddd -66666
4   visit on date-14-02-2018
    contact person
    ak -80000003

使用 to_dict 从数据帧输出：

140: 'visit on date-16/02/2018\ncontect person\xyz-567890',
141: 'visit on date-08/02/2018\ncontect person \nabc - 908789\nabcd
142: 'visit on date-08/03/2018\ncontect person\npqrspqrs pqrssssp -8909787901',
143: 'visit on date-08/05/2018\ncontect person-jagggan aaaa 897654321',
144: 'visit on date-09/02/2018\ncontect person\nqqqqqqqqqe-9087654321',
145: 'abcdefgh\n business sourcing\n35000 sourced',

来自 df 的输出：

369: 'abcdefgh. \n\ndiscussion on xyz', 370: 'new byusiness', 371: 'new 
busnes', 372: 'ghi call', 373: 'new business\npolicy deliver\npaopo refund'

输出 ：

id  text
1   compliant solve. today  query clear
2   branch visit on date-16/02/2018 contact person xyz -101010101
3   visit on date-16/06/2018 contact person-ddd -66666
4   visit on date-14-02-2018 contact person ak -80000003

标签： python-3.xpandasdataframe

Answer 1

尝试这个：

df.text = df.text.str.replace('\n', ' ')