Merging hosp/labevents with core/patients on subject_id

[tchang1997]

Prerequisites

• Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.mit.edu/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

Hi all,

I'm on MIMICIV-v1.0, trying to link demographic data to lab results.

I was attempting to link the labevents table with lab orders and results to patient demographic data, as stored in the core "patients" table, merging on the subject_id attribute. However, upon closer inspection, the subject_id values in the labevents table do not match up with the subject_id values in the core "patients" table.

I tried switching to hadm_id, but found that the values for that column in the labevents table were all NaNs.

Is there a better way to link demographic information to lab results? Maybe there's an issue with my downloaded version?