我正在创建一个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
Original: https://blog.csdn.net/weixin_32503491/article/details/113975688
Author: 地摊大叔
Title: python如何打印id_找到唯一值的行ID并打印整行(Python/Pandas)
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/679963/
转载文章受原作者版权保护。转载请注明原作者出处!