擅长:python、mysql、java
<p>您可以创建一个从给定字符串中删除重复项的函数。然后将此函数应用于列标记。你知道吗</p>
<pre><code>def remove_dup(strng):
'''
Input a string and split them
'''
return ', '.join(list(dict.fromkeys(strng.split(', '))))
df['Tags'] = df['Tags'].apply(lambda x: remove_dup(x))
</code></pre>
<p>演示:</p>
<pre><code>import pandas as pd
my_dict = {'Tags':["Museum, Art Museum, Shopping, Museum",'Drink, Drink','Shop','Visit'],'Country':['USA','USA','USA', 'USA']}
df = pd.DataFrame(my_dict)
df['Tags'] = df['Tags'].apply(lambda x: remove_dup(x))
df
</code></pre>
<p>输出:</p>
<pre><code> Tags Country
0 Museum, Art Museum, Shopping USA
1 Drink USA
2 Shop USA
3 Visit USA
</code></pre>