将Pandas系列转换为字符串数组

Question

我有一个熊猫数据帧：

ind  
0   ['C']
1   ['C']
2   ['C']
3   ['C']
4   ['E']
5   ['E']

我想把它转换成一个字符串：CCCCEE

Answer 1

您可以使用str

df['ind'].str[0].sum()
Out[197]: 'CCCCEE'

Answer 2

您可以这样做：

chain=""
for index, row in df.iterrows():
    chain=chain+row['column']
return chain

如果在迭代数据帧时遇到问题，可以检查How to iterate over rows in a DataFrame in Pandas?

Answer 3

使用^{}：

from itertools import chain

df = pd.DataFrame({'ind': [['C'], ['C'], ['C'], ['C'], ['E'], ['E']]})

res = ''.join(chain.from_iterable(df['ind']))

print(res)

CCCCEE