擅长:python、mysql、java
<p>我认为您可以通过比较两个列表来尝试:</p>
<pre><code>serverName_list=df['Server Name'].unique().tolist()
</code></pre>
<p>如果“服务器名称”列的所有元素都具有相同的格式,则应使用以下内容清理数据,例如:</p>
<pre><code>serverName_clean_list=[]
for element in serverName_list:
serverName_clean_list.append(element.split(".")[0])
</code></pre>
<p>根据<a href="https://stackoverflow.com/questions/41125909/python-find-elements-in-one-list-that-are-not-in-the-other#comment102211219_41125909">Python find elements in one list that are not in the other</a></p>
<pre><code>import numpy as np
main_list = np.setdiff1d(serverName_clean_list, search_list).tolist()
# yields the elements in `list_2` that are NOT in `list_1`
</code></pre>