将多行合并为一行一列的Python

Question

我需要将数据帧的所有行合并为一列中的一行。例如：

data = ('Hello', 'are you having','', 
        'a nice day today? I am very', 
        'delighted to have snail as','',
        'my','','entree for dinner tonight.')

data = pd.DataFrame(list(data))

退货：

^{pr2}$

现在，我将尝试将所有行合并为一列：

data = data.rename(columns={0: 'value'})
data = data.groupby('value').apply(' '.join).reset_index()

这将为每一行创建一个字符串为“value”的附加列。任何帮助都将不胜感激。在

Answer 1

希望这就是你想要的。在

import pandas as pd
data = ('Hello', 'are you having','', 
        'a nice day today? I am very', 
        'delighted to have snail as','',
        'my','','entree for dinner tonight.')

data = pd.DataFrame(list(data))
data = data.rename(columns={0: 'value'})
data['new'] = data['value'].str.cat(sep=' ')#concatenate all the strings in existing column and create a new one.
print(data)

输出：

^{pr2}$