OA2LY3TCTCUBN67P57P5NNM2INIMEZ56H76UFLFM43SK5PHWCICAC
VEUFJ7P7X3G7OBHNDQ3AQU2EYW7UX4EY5E7FW22C7GXTYXRIWJOAC
RHWQQAAHNHFO3FLCGVB3SIDKNOUFJGZTDNN57IQVBMXXCWX74MKAC
TIA2DAOS3IGVDSDQCCDB6UOHWNDBX2YWUPSYWUOX5V3JJVZ7JJWQC
UFNUN5UYHRWFTKE7M2VJJMWSNPCLJZH4NJ3FNDLF2OW2T33OJOQAC
KLANR23QTUGFNUP7WVIF77WYTUF24EU6U2SNSLTTDKFX2X3H5ZSAC
UHOVWI5235P26UNRND24XOYPI3FXSCBBM5TQ4S2RLR7V73HBIBLAC
CXW37WKZDOFBTPGZQGQVWDWGA7YWGGJ47SSD4KYEXD6MPERELGGAC
def getExome(root, dna, p):
# Merge exome and sample
e = readExome(root)
d = dna.set_index("sampleID").join(e.set_index("specimenID"),
how="inner",
lsuffix="dna", rsuffix="exome")
d2 = d.set_index('patientIDdna').join(p.set_index("patientID"),
how="inner")
# Reorder columns
d2 = cleanExome(d2)
d2.to_excel(root / "exome dijons.xlsx")
def getPanel(root, dna, p):
# Merge exome and sample
e = readExome(root)
d = dna.set_index("sampleID").join(e.set_index("specimenID"),
how="inner",
lsuffix="dna", rsuffix="exome")
d2 = d.set_index('patientIDdna').join(p.set_index("patientID"),
how="inner")
# Reorder columns
d2 = cleanExome(d2)
d2.to_excel(root / "exome dijons.xlsx")
# Merge exome and sample
d = dna.set_index("sampleID").join(e.set_index("specimenID"),
how="inner",
lsuffix="dna", rsuffix="exome")
d2 = d.set_index('patientIDdna').join(p.set_index("patientID"),
how="inner")
# Reorder columns
d2 = cleanExome(d2)
d2.to_excel(root / "exome dijons.xlsx")
# getExome(root, dna, p)
getPanel(root, dna, p)