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)