def _load(self):
"""Load the two tables (labevents and d_patients) separately.
Since labevents is a very large table we select a subset of it before loading."""
bun_labevents = load_table(labevents_schema, "itemid=51006") #"itemid=50177")
patients = load_table(patients_schema)
return {'labevents': bun_labevents, 'patients': patients}
def _load(self):
"""Load the two tables (admissions and d_patients) separately,
since both are relatively small and can be efficiently joined in memory."""
admissions = load_table(admissions_schema)
patients = load_table(patients_schema)
return {'admissions': admissions, 'patients': patients}
def _load(self):
"""Load the two tables (admissions and d_patients) separately,
since both are relatively small and can be efficiently joined in memory."""
admissions = load_table(admissions_schema)
d_patients = load_table(d_patients_schema)
return {'admissions': admissions, 'd_patients': d_patients}
def _load(self):
if self.subject_ids is not None:
condition = 'subject_id IN ( {} )'.format(', '.join(map(str, self.subject_ids)))
else:
condition = None
icustay_detail = load_table(icustay_detail_schema, condition + ' AND subject_icustay_seq = 1')
chartevents = load_table(chartevents_schema, condition)
labevents = load_table(labevents_schema, condition)
ioevents = load_table(ioevents_schema, condition)
return {
'chartevents': chartevents,
'labevents': labevents,
'ioevents': ioevents,
'icustay_detail': icustay_detail
}
def _load(self):
if self.subject_ids is not None:
condition = "subject_id IN ( {} )".format(", ".join(map(str, self.subject_ids)))
else:
condition = None
icustay_detail = load_table(icustay_detail_schema, condition + " AND subject_icustay_seq = 1")
chartevents = load_table(chartevents_schema, condition)
labevents = load_table(labevents_schema, condition)
ioevents = load_table(ioevents_schema, condition)
return {
"chartevents": chartevents,
"labevents": labevents,
"ioevents": ioevents,
"icustay_detail": icustay_detail,
}
def _load(self):
if self.subject_ids is not None:
condition = 'subject_id IN ( {} )'.format(', '.join(
map(str, self.subject_ids)))
else:
condition = None
icustay_detail = load_table(icustay_detail_schema,
condition + ' AND subject_icustay_seq = 1')
chartevents = load_table(chartevents_schema, condition)
labevents = load_table(labevents_schema, condition)
ioevents = load_table(ioevents_schema, condition)
return {
'chartevents': chartevents,
'labevents': labevents,
'ioevents': ioevents,
'icustay_detail': icustay_detail
}