我正在创建一个python脚本,检查CSV文件中的列中是否存在值,而另一个列中是否没有值。目前,我已经按预期使用了这个功能,脚本从CSV文件中的列返回唯一值。下一步是让脚本返回该唯一值的整行。因此,例如,如果CSV文件的第15行中存在ID为“A53456”的用户,我希望脚本能够打印出整个第15行。你知道怎么实施吗?谢谢。在import pandas as pd
#create dataframes
dataframe_server_permissions = pd.read_csv("\server_permissions.csv")
dataframe_database_permissions = pd.read_csv("\database_permissions.csv")
#create list from column values
database_permissions_list=dataframe_database_permissions['Rights'].tolist()
server_permissions_list=dataframe_server_permissions['Permissions'].tolist()
#remove the duplicate values from the list
server_permissions_list_duplicates_removed = list(set(server_permissions_list))
database_permissions_list_duplicates_removed = list(set(database_permissions_list))
#identify permissions that exist in one file but not the other
set1 = set(database_permissions_list_duplicates_removed)
set2 = set(server_permissions_list_duplicates_removed)
permissions_in_server_but_not_database = list(sorted(set2 - set1))
print(permissions_in_server_but_not_database)
#output the values from the comparison
number_of_records_from_permissions_in_server_but_not_database = len(permissions_in_server_but_not_database)
print(number_of_records_from_permissions_in_server_but_not_database)
i = 0
while i < number_of_records_from_permissions_in_server_but_not_database:
print(permissions_in_server_but_not_database[i])
i += 1