import csv
import zipfile

with open("C:/Users/Peter Cui/Desktop/STACAN/ALLTABLES.csv", 'r') as CSV_LIST:
    READER = csv.reader(CSV_LIST)
    READ_LIST = list(READER)

COUNTER = 0
while COUNTER < 1:
    LIST_ROWNUM = READ_LIST[COUNTER]
    ENTRY_NUM = LIST_ROWNUM[0]
    print(ENTRY_NUM)
    with zipfile.ZipFile("C:/Users/Peter Cui/Desktop/STACAN/" + ENTRY_NUM + "-eng.zip", 'r') as ZIP_EXTRACT:
    ZIP_EXTRACT.extractall("C:/Users/Peter Cui/Desktop/STACAN/EXTRACTED")
    ZIP_EXTRACT.close()
    COUNTER = COUNTER + 1

for abcd in mylist:
    print(abcd)

with zipfile.ZipFile("C:/Users/Peter Cui/Desktop/STACAN/" + ENTRY_NUM + "-eng.zip", 'r') as ZIP_EXTRACT:
    ZIP_EXTRACT.extractall("C:/Users/Peter Cui/Desktop/STACAN/EXTRACTED")