search

batmanlab / BatmanLabWiki

Documents and Wiki of the lab
Apache License 2.0
3 stars 0 forks source link

Access to SAM_ELT schema in Neptune for EMR data #64

Open shyamvis opened 6 years ago

gatechke commented 6 years ago

@shyamvis I just got the connection to Neptune. I am able to access to SAM_ELT now.

shyamvis commented 6 years ago

Great. Look at the dx table and create a histogram of number of patients per IC9/ICD10 code.

Shyam

On Wed, Sep 19, 2018 at 9:13 AM Ke Yu notifications@github.com wrote:

@shyamvis https://github.com/shyamvis I just got the connection to Neptune. I am able to access to SAM_ELT now.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/kayhan-batmanghelich/BatmanLab/issues/64#issuecomment-422798352, or mute the thread https://github.com/notifications/unsubscribe-auth/AIR8_-dkqBXTXdyFLQXkHY-51-R7UITTks5uckMMgaJpZM4Wh4IP .

gatechke commented 6 years ago

 Top 10 ICD9 codes by #patients (DX_PERSON_CNT is the #patients, DX_PERSON_PROP is the proportion of total patients)

image

Top 10 ICD10 codes by #patients (same column format) image

Observation - the rank of top 10 codes are different between ICD9 and ICD10

gatechke commented 6 years ago

Histogram - use log scale because the distributions have very long tail

ICD9 image

ICD10 image

gatechke commented 6 years ago

There are also some records with unknown ICD type

image

shyamvis commented 6 years ago

Great. I will ask Patrick to investigate the unknown coding system data. We are supposed to get it down to a smaller number.