pandaps：在从第一列拆分每一行的同时创建另一列

Question

目标从第一列创建第二列

column1, column2
Hello World, #HelloWord
US Election, #USElection

我有一个只有一列的简单文件

^{pr2}$

我写了以下函数

>>> def newColumn(row):
...     r = "#" + "".join(row.split(" "))
...     return r

然后，我使用pandas创建了第二个专栏

df['column2'] = df.apply (lambda row: newColumn(row),axis=1)

但我最终得出以下错误：

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Users/anuradha_uduwage/anaconda2/lib/python2.7/site-packages/pandas/core/frame.py", line 3972, in apply
    return self._apply_standard(f, axis, reduce=reduce)
  File "/Users/anuradha_uduwage/anaconda2/lib/python2.7/site-packages/pandas/core/frame.py", line 4064, in _apply_standard
    results[i] = func(v)
  File "<stdin>", line 1, in <lambda>
  File "<stdin>", line 2, in newColumn
  File "/Users/anuradha_uduwage/anaconda2/lib/python2.7/site-packages/pandas/core/generic.py", line 2360, in __getattr__
    (type(self).__name__, name))
AttributeError: ("'Series' object has no attribute 'split'", u'occurred at index 0')

因此，我将拆分改为：

r = "".join(row.str.split(" "))

但这没用

Answer 1

尝试列表压缩：

df = pandas.DataFrame({'columnOne': ['Hello World', 'US Election', 'Movie Night']})

df['column2'] = ['#' + item.replace(' ', '') for item in df.columnOne]

In [2]: df