search

MIT-LCP / eicu-code

Code and website related to the eICU Collaborative Research Database
https://eicu-crd.mit.edu
MIT License
320 stars 219 forks source link

What are the upper values for AST,ALT, and ALP? #155

Closed 161232020 closed 4 years ago

161232020 commented 4 years ago

Hi, When I extracted the data using "pivoted-lab.sql", I found that indicators such as AST, ALT, ALP had a lot of abnormally high values, which had caused me a lot of trouble.I want to know the reliable upper limit of the laboratory indicator instrument used in these hospitals, or can you give me a range. Thanks a lot

161232020 commented 4 years ago

Besides, how to find the outliers for height and weight?

jraffa commented 4 years ago

Unfortunately we don't have the lab reference or any other ranges, as these may vary from hospital to hospital. This applies to the labs and height/weight.

I'm afraid you will have to have a look at the data a little more closely and see if alternative analysis methods (e.g., bin the data, use rank based methods (e.g., medians) can be used.

In my experience most of what people think are spurious or erroneous data are in fact legitimate.

jraffa commented 4 years ago

I will add that height and weight can be found in many places within the eICU-CRD tables, so don't restrict yourself to the patient table when encountering some weird or ambiguous data.