data = FileAttachment("supplementary_dataset2.xlsx")
.xlsx()
.then((xl) => xl.sheet("all_samples", { headers: true }))
.then(
(data) => (
data.forEach((d) => {
d.status = d.samplecollection === "obb_negatives" ? "N" : "P";
d.status_result = 1 + +(d.status === "P");
d.diasorin_result =
d.diasorin_result[0] === "<"
? +d.diasorin_result.slice(1).trim()
: d.diasorin_result;
d.siemens_result =
d.siemens_result[0] === "<"
? +d.siemens_result.slice(1).trim()
: d.siemens_result;
d.random_result = random();
}),
data
)
)