AmsterdamUMC / AmsterdamUMCdb

AmsterdamUMCdb - Freely Accessible ICU database. Please access our Open Access manuscript at https://doi.org/10.1097/CCM.0000000000004916
https://amsterdammedicaldatascience.nl/
MIT License
154 stars 43 forks source link

ITEM dictionary required #4

Closed peiyaoli closed 3 years ago

peiyaoli commented 4 years ago

Hi, I would suggest to build a dictionary of items for numericitems like MIMIC does. In current settings, it takes a long time to search and locate correct labtest items.

patrickthoral commented 4 years ago

That's an excellent suggestion. Do you think we should add this as separate csv files (e.g. numerics) in the dataset or just create a view or table after the indexing?

peiyaoli commented 4 years ago

I think both ways are fine. Maybe materialized view would be better.

patrickthoral commented 3 years ago

The amsterdamumcdb package now contains some utility functions used in the Notebooks, including with work-in-progress tranlations for commonly used items. The package can be installed from the Python Package Index respository (PiPy) by running:

pip install amsterdamumcdb.

So I'm closing this issue.