I am trying to figure out how to write the logic on how to find and append the remaining numbers from two list.
I have a CSV with data in the format like this
jeffrey,192.168.1.1,example1.com,30220,internet serverice provider 1
mike,192.168.1.2,example2.com,30220,internet service provider 1
frank,192.168.1.3,example3.com,30220,internet service provider 1
lucy,192.168.1.4,example4.com,14619,internet service provider 2
louisa,192.168.1.5,example5.com,14619,internet service provider 2
emily,192.168.1.6,example6.com,3357,internet service provider 3
john,192.168.1.7,example7.com,210,internet service provider 4
My list is as follows
list_1 = ['3357', '210']
list_2 = ['14619']
list_3 = [] # List I want that remaining numbers to be in
I am assuming using a if statement is the correct way to go about it.
Something like
import csv
document = file.csv
with open ('test_file', 'w') as output:
with document as file:
output_data = csv.writer(output, delimiter = ',')
reader = csv.reader(file)
list_1 = ['3357', '210']
list_2 = ['14619']
list_3 = [] # List I want that remaining numbers to be in for row in reader:
if row[3] not in list_1 and list_2:
list_3.append(row[3])
print(list_3)
My code above doesnt get the results I would like which would be
jeffrey,192.168.1.1,example1.com,30220,internet serverice provider 1
mike,192.168.1.2,example2.com,30220,internet service provider 1
frank,192.168.1.3,example3.com,30220,internet service provider 1
Any Help is greatly appreciated.
Aucun commentaire:
Enregistrer un commentaire