def reparse_chemicals():
outchain = "FILE\tOLDFIELD\tNEWFIELD\tINVNUMBERS->\n"
for line in pull_data("chemicals.csv"):
cnd, moldy, shiny = get_inventory_numbers(line)
outchain += "\t".join([line[0]] + [moldy, shiny] + cnd) + "\n"
with open(project_root + "instruments_parsed.csv", "w") as handle:
handle.write(outchain)
def reparse_chemicals_by_inventory_id():
cids = []
for line in pull_data("vegyszerek.csv"):
if line[1] == "-":
continue
cids.append(tuple(str(d).lower() for d in line[1:3] + [line[5]]))
return sorted(list(set(cids)))
def reparse_instruments():
outchain = "FILE\tINSTRUMENT\tFORMATFIELD\tINVNUMBERS->\n"
for line in pull_data("instrument.csv"):
cnd, frm_field = extract_inventory_numbers(line[1])
outchain += "\t".join(map(str, line[:2] + [frm_field] + cnd)) + "\n"
with open(project_root + "invnumbers.csv", "w") as handle:
handle.write(outchain)
def filter_duplicates():
outchain = "\n".join(
"\t".join(line) for line in
sorted(list(set(tuple(line) for line in pull_data("ChemTable.csv")))))
with open(project_root + "ChemTable_uniq.csv", "w") as handle:
handle.write(outchain)