python为什么说csv文件不存在_如何使用Python检查CSV文件中是否已存在数据

Good day all,

I am trying to write a python script that picks up IP address(es) from a textfile, check if the IP addresses already present in CSV file, if IP address is already present then do nothing (pass), if the IP is not present in the CSV file then append the IP address in the CSV file.

I can add the IP addresses to the CSV file but I am not able to get my head around with how to check if the IP address is already present in the file.

if os.path.isfile('IP_file.txt'):

logfile = open('IP_file.txt', 'r')

csv_file = open('csv_file.csv', 'ab')

for line in logfile:

if line in csv_file: # This is not working

pass

else:

csv_file.write(line)

csv_file.close()

logfile.close()

else:

print('No file with filename ' logfile 'created')

I also tried to use the CSV module but no luck. Any help is much appreciated.

解决方案

CSV is just a text format. Read it line by line, test every line against your IP. Like

ip="192.168.1.1"

for line in csv_file:

if ip in line:

found = True

break

I am a bit concerned against your cycling over file on the disk. Probably it is better to read files into memories (find all IPs in CSV file first and put in a list) and then check against the list instead of opening and iterating over whole CSV file for every line of IP file.