我在資料框中有一列包含串列。我只想洗掉方括號：
| Fruits |
| -------------------------------------|
| [apple, kiwi, pineapple, mango, lime]|
| [strawberry, cherry, kiwi, orange] |
| [...] |
期望的輸出：
| Fruits |
| -----------------------------------|
| apple, kiwi, pineapple, mango, lime|
| strawberry, cherry, kiwi, orange |
| ... |
我試過這個
for fruit in df['Fruits']:
df['Fruits'] = (','.join(word))
print(df['Fruits'])
輸出不是我想要的，我怎樣才能將新串列附加到新列（當然不需要方括號）任何人都可以提供幫助？
uj5u.com熱心網友回復：
IIUC，試試這個用于字串存盤或串列存盤：
# String object
df_string = pd.DataFrame({'Fruits':['[apple, kiwi, pineapple, mango]',
'[strawberry, cherry, kiwi, orange]']})
df_string['Fruits'].str.replace('\[|\]','', regex=True)
輸出：
0 apple, kiwi, pineapple, mango
1 strawberry, cherry, kiwi, orange
Name: Fruits, dtype: object
或者，
#List object
df_list = pd.DataFrame({'Fruits':[['apple', 'kiwi', 'pineapple', 'mango'],
['strawberry', 'cherry', 'kiwi', 'orange']]})
df_list['Fruits'].agg(', '.join)
輸出：
0 apple, kiwi, pineapple, mango
1 strawberry, cherry, kiwi, orange
Name: Fruits, dtype: object
注意：df_list 和 df_string 字串表示看起來相同。
print(df_list)
Fruits
0 [apple, kiwi, pineapple, mango]
1 [strawberry, cherry, kiwi, orange]
print(df_string)
Fruits
0 [apple, kiwi, pineapple, mango]
1 [strawberry, cherry, kiwi, orange]
uj5u.com熱心網友回復：
您可以嘗試使用以下功能將字符替換為[]字符：emptyreplace()
for fruit in df['Fruits']:
df['Fruits'] = df['Fruits'].replace("[", "").replace("]", "")
print(df['Fruits'])
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/465261.html
上一篇：跨多個列的序列中的行平均值
下一篇：nos均衡塊