import pandas


data = pandas.read_excel('two_lists.xlsx')
list1 = data['list1'].dropna().to_list()
list2 = data['list2'].dropna().to_list()

print("\nNot in list 2:")
for item in list2:
    if item not in list1:
        print(item)

print("\nNot in list 1:")
for item in list1:
    if item not in list2:
        print(item)
7410207e3f1d7b3377cd28d14d121282f37abd2a
<mask token>

<mask token>
print('\nNot in list 2:')
for item in list2:
    if item not in list1:
        print(item)
print('\nNot in list 1:')
for item in list1:
    if item not in list2:
        print(item)

<mask token>
data = pandas.read_excel('two_lists.xlsx')
list1 = data['list1'].dropna().to_list()
list2 = data['list2'].dropna().to_list()
print('\nNot in list 2:')
for item in list2:
    if item not in list1:
        print(item)
print('\nNot in list 1:')
for item in list1:
    if item not in list2:
        print(item)

import pandas
data = pandas.read_excel('two_lists.xlsx')
list1 = data['list1'].dropna().to_list()
list2 = data['list2'].dropna().to_list()
print('\nNot in list 2:')
for item in list2:
    if item not in list1:
        print(item)
print('\nNot in list 1:')
for item in list1:
    if item not in list2:
        print(item)

import pandas


data = pandas.read_excel('two_lists.xlsx')
list1 = data['list1'].dropna().to_list()
list2 = data['list2'].dropna().to_list()

print("\nNot in list 2:")
for item in list2:
    if item not in list1:
        print(item)

print("\nNot in list 1:")
for item in list1:
    if item not in list2:
        print(item)