technical_drawings_extraction/csv_to_pandadf.py

import pandas
import csv
import re
#data_df = pandas.read_csv("values.csv", sep=",")
#print(data_df.head(3))

#data = data_df[["X1","Y1","X2","Y2"]]
#print(data)

text = []
with open('text_merged.csv', 'r') as csvFile:
    reader = csv.reader(csvFile, delimiter=",")
    for row in reader:
        text.append(row[2])
csvFile.close()
###extract ISOs
matches = []
regex = r"(ISO\s\d\d\d\d?\W?\d?\W?\d?\W?\d?)"
for line in text:
    match = re.findall(regex, line)
    if match:
        matches.append(match)

print(matches)