从列中的列表中删除方括号

Question

我的列有数据框中的列表。我只想删除方括号：

| 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'])

不是我想要的输出，以及如何将新列表附加到新列（当然无需方括号）上，任何人都可以提供帮助？

Answer 1

iiuc，尝试以此为字符串存储或列表storge：

# 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]

Answer 2

您可以尝试使用[]字符字符字符，并用repleent（）函数替换 carture function：

for fruit in df['Fruits']:
    df['Fruits'] = df['Fruits'].replace("[", "").replace("]", "")
    print(df['Fruits'])